SQLite Forum

URL for downloading latest version

URL for downloading latest version

(1) By Mircea Neacsu (neacsum) on 2020-08-14 12:49:39 [link] [source]

First, my apologies if the question has been asked before, but I didn't find the answer.

I use basic functions of SQLITE in my little project and I'd like for my build script to download the latest version of the amalgamation.

I don't care about the version number as I'm using only basic features that are unlikely to be broken by future releases. On the other hand, I'd like to download the latest version just to make sure I keep up to date with latest bug fixes. Also I wouldn't want to manually change my build script to keep track of the latest SQLITE version.

So the question is: is there a fixed URL from where I can download the latest official amalgamation?

Thank you, Mircea

(2) By Stephan Beal (stephan) on 2020-08-14 13:05:54 in reply to 1 [link] [source]

So the question is: is there a fixed URL from where I can download the latest official amalgamation?

To the best of my knowledge there is not: downloading it requires knowing both the version number and the release year.

To second your request, though, i have the same requirement and would also appreciate a link to "the latest" and/or the latest of a given minor version, rather than having to do something like:

# sqlite: Unfortunately, the download path for the sqlite3
# amalgamation build depends on the year, so we need both the version
# and the year here...
ARG sqliteVersion=3320300
ARG sqliteYear=2020
RUN test -d sqlite-amalgamation-${sqliteVersion} || { \
    wget -q https://sqlite.org/${sqliteYear}/sqlite-amalgamation-${sqliteVersion}.zip \
    && unzip sqlite-amalgamation-${sqliteVersion}.zip; \

(3) By Richard Hipp (drh) on 2020-08-14 13:21:13 in reply to 1 [link] [source]

There is no URL for downloading the latest amalgamation. You have to know a specific version number to get a pre-built amalgamation.

But here are URLs for downloading the canonical source code. You'll then have to build your own amalgamation using commands like the following (depending on your OS):

    ./configure && make sqlite3.c
    nmake /f Makefile.msc sqlite3.c

To get a tarball of the latest official release use:

To get a tarball of the latest trunk check-in (for those who like to live more on the edge):

Change "tarball" to "zip" or "sqlar" to get a ZIP Archive or an SQLite archive, respectively, in the links above. See the Fossil documentation for the /tarball, /zip, and /sqlar pages for additional information.

If you do this a lot, please consider cloning the complete SQLite source repository so that you can update to the latest source code version using commands like "fossil up release". Doing so will minimize your bandwidth usage and help reduce the load on the SQLite website server. If you don't want to use Fossil, there is also an official GitHub mirror for the SQLite source repository.

(4) By Ryan Smith (cuz) on 2020-08-14 13:31:08 in reply to 3 [link] [source]

A thought...

This entire message Post above (by Richard) should be a standard page somewhere on the SQLite Site with links from the Downloads page (or even main page if I had the choice) that would hopefully over time become an easy search-engine hit.

I know the individual statements can be found easily, but the whole succinct idea of managing (and especially the bits about saving bandwidth by cloning) seem to not have a single-reference somwhere that hangs together well, like the above.

(5) By Richard Hipp (drh) on 2020-08-14 14:11:09 in reply to 4 [link] [source]

I was thinking the same thing as I was typing in the message, and have plans to try to address that later this morning. :-)

(6) By Mircea Neacsu (neacsum) on 2020-08-14 16:09:01 in reply to 3 [link] [source]

Thanks you so much for the prompt reply.

I still think having a fixed URL aliased to the latest version is more convenient. Building from source requires one to have the whole SQLITE tool-chain. For me, that was one of the advantages of the amalgamation.


(7) By Richard Hipp (drh) on 2020-08-14 17:18:59 in reply to 6 [link] [source]

The "whole SQLite tool-chain" consists of:

  • A C-compiler (gcc, clang, MSVC, etc)
  • make or nmake
  • tclsh

So if you can compile the amalgamation, the only thing extra you need to install in order to build from canonical sources is "tclsh".

(9.1) By Mircea Neacsu (neacsum) on 2020-08-15 02:13:38 edited from 9.0 in reply to 7 [link] [source]


(10) By Mircea Neacsu (neacsum) on 2020-08-15 01:09:04 in reply to 9.0 [link] [source]

Well, one extra tool is still a bit of a hassle.

As is the case with many Unix tools, finding a Windows distribution is not so easy. Following instructions from Tcl Developer Exchange, ActiveTcl wants me to register, Thomas Pershack has any number of packages with funny names (what's "xenial" and "bionic" and tcl87), than there is BWAT, MagicSplat and so on.

I can probably navigate this maze but I don't see how this is simpler than having an URL aliased to the latest version.

Sorry for being stubborn.


PS Sorry for apologizing so much: bad Canadian habit :)

(11) By Keith Medcalf (kmedcalf) on 2020-08-15 03:39:58 in reply to 10 [link] [source]

I am using this version of TCL on Windows 10 64-bit. Seems to work just fine and requires no installation -- just copy and go.

2019-04-22  15:26        24,341,745 tcltk86-8.6.9-0.tcl86.Win10.x86_64.tgz


about 8th from the bottom. Works just fine since only very rudimentary TCL is required. Untgz wherever you please and put the bin directory in the path.

This version of Tclsh works, is tiny, has no dependancies, and is compiled with a real compiler, and does not require you to register anything.

The major plus is that it works the way God intended when she invented computers -- there is no need to run an opaque installer executable -- just copy and go, like in the beginning times before the invasion of the eternal Septemberites with their need for wet-nurses and nannies.

PS: I'm Canadian too ...

(12) By Mircea Neacsu (neacsum) on 2020-08-15 15:21:28 in reply to 11 [link] [source]

Thank you, I'll give it a try.


(8.1) By David Jones (vman59) on 2020-08-14 18:28:04 edited from 8.0 in reply to 1 [source]

I have a script that fetches the /download.html page and extracts the version and hashes from the HTML. It then downloads the files and uses the hashes to verify the downloads completed successfully. A link to an XML file with that information would be nice.