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

> 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; \
    }
```

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

[0]: https://www.sqlite.org/amalgamation.html

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:

  *  <https://sqlite.org/src/tarball/sqlite.tar.gz?r=release>

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

  *  <https://sqlite.org/src/tarball/sqlite.tar.gz?r=trunk>

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][1], [/zip][2], and [/sqlar][3] pages
for additional information.

[1]: https://www.sqlite.org/src/help?cmd=/tarball
[2]: https://www.sqlite.org/src/help?cmd=/zip
[3]: https://www.sqlite.org/src/help?cmd=/sqlar

If you do this a lot, please consider
[cloning the complete SQLite source repository][4]
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][5] for the SQLite source repository.

[4]: https://www.sqlite.org/getthecode.html#clone
[5]: https://github.com/sqlite/sqlite

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.

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

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. 

Mircea

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".

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](https://www.tcl.tk/software/tcltk/bindist.html), __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.

Mircea

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

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
```

<https://bitbucket.org/tombert/tcltk/downloads/>

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 ...

Thank you, I'll give it a try.

Mircea