update sqlite on ubuntu 18.04 to version 2.30

sqlite3.sh

#!/usr/bin/env bash

# Reference: 
# https://stackoverflow.com/questions/9646353/how-to-find-sqlite-database-file-version

# Go to a known directory so we can cleanup files later
cd ~

# Download
wget https://www.sqlite.org/2019/sqlite-autoconf-3300100.tar.gz
tar -xf sqlite-autoconf-3300100.tar.gz
cd sqlite-autoconf-3300100

# Compile
./configure --prefix=/usr --disable-static CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_SECURE_DELETE=1 -DSQLITE_SOUNDEX"
make

# Quick test:
./sqlite3 --version

# Install in /usr/bin/sqlite3
sudo make install

# Optional cleanup
cd ~
rm -rf sqlite-autoconf-3300100*