News for hackers. Stuff that matters.

A comment on SQLite the only database you will ever need in most cases. Parent comment

Re:SQLite the only database you will ever need in most cases by antimatter15 on Thursday April 15, 2021 @03:26AM (#26817168)
The latest version (3.35.4) adds `ALTER TABLE DROP COLUMN` https://sqlite.org/releaselog/3_35_4.html
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by TicklishTiger on Thursday April 15, 2021 @03:28AM (#26817194)
That is cool.

What is a good way to use 3.35.4 on a system with a Debian version that comes with an older SQLite version?

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by feinte on Thursday April 15, 2021 @03:46AM (#26817341)
Compiling it yourself from source is quite easy, you can find instruction here: https://www.sqlite.org/howtocompile.html

Here is an article from Julia Evans explaining it: https://jvns.ca/blog/2019/10/28/sqlite-is-really-easy-to-com...

Or if you are familiar with Docker, you can use a more recent Debian in a container and install sqlite inside it.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by TicklishTiger on Thursday April 15, 2021 @09:20AM (#26820112)
If you compile it yourself, how do security updates get to your system?

As for a more recent Debian version: The latest stable Debian has sqlite3 3.27.2 in the repos, so that is not an option.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by xorcist on Thursday April 15, 2021 @07:06AM (#26818903)
Since sqlite is local to your application, you can just bundle a newer version.

Speaking generally, if the Debian version is the way to go, the easiest way is often to grab the source package from sid and build it. It's literally just one command. Sometimes new dependencies will cause trouble, in which case some manual tinkering is required.

[ Parent | on HN ]