[Interest] Interest Digest, Vol 133, Issue 11

[Roland Hughes]

On 10/26/22 05:00, Thiago Macieira wrote:
> On Monday, 24 October 2022 10:58:56 PDT Till Oliver Knoll wrote:
>> What is the least complicated way to enable the math functions that come
>> with SQLite, when it is compiled with the -DSQLITE_ENABLE_MATH_FUNCTIONS
>> switch?
> Solution #1: compile Qt with -system-sqlite (and provide said system sqlite).
>
> This applies to ANY use of SQLite, whether you need the math functions or not.

As an add-on, this also requires you to locate and distribute all of the 
system SQLite libraries. Use a FlatPak

https://www.flatpak.org/

or the older AppImage

https://appimage.org/

on Linux when distributing your software. Don't bundle the system 
libraries into your own .deb .rpm .whatever at the system locations. 
When packaging your application in distro specific packages, you need to 
be very specific about required versions of dependencies. This can get 
really hinkey when a user has other applications that need incompatible 
SQLite versions.

https://stackoverflow.com/questions/28413683/backwards-compatibility-with-sqlite-db

A custom plug-in may be more up-front work, but it minimizes 
installation incompatibilities.

Btw, Snapcraft is a dead distribution method.

https://snapcraft.io/

I don't do Windows or Mac development, but you will have similar 
situations building with -system-sqlite and distributing.

-- 
Roland Hughes, President
Logikal Solutions
(630)-205-1593

http://www.theminimumyouneedtoknow.com
http://www.infiniteexposure.net
http://www.johnsmith-book.com
http://www.logikalblog.com
http://www.interestingauthors.com/blog
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.qt-project.org/pipermail/interest/attachments/20221026/6fc8e34d/attachment.htm>