SQLite Archive Files

An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.

https://www.sqlite.org/sqlar.html

@DevMisc
#database #sqlite #misc

Why Is SQLite Coded in C

https://www.sqlite.org/whyc.html

@DevMisc
#sqlite #c #misc

Using the SQLite-over-HTTP “hack” to make back end-less, offline-friendly apps

https://ansiwave.net/blog/sqlite-over-http.html

@DevMisc
#sqlite #web #misc

Hosting SQLite Databases on GitHub Pages

Compiling SQLite to WASM and fetching read-only data using chunked http requests.

https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages

@DevMisc
#github #sqlite #misc

I found a bug in SQLite

If you didn’t code it in C, it didn’t happen.

https://www.philipotoole.com/how-i-found-a-bug-in-sqlite

@DevMisc
#sqlite #c #misc