v0.8.0

• Compressed database files can be queried over the web directly (docs)
  • Open routines accept http/https URLs (read-only) as well as local filenames
  • Adaptive batching & prefetching to optimize the HTTP request pattern (will be tuned over time)
  • Builds in sqlite_web_vfs extension (also usable standalone)
• Improves the genomicsqlite command-line tool installed with the Python package (docs)
  • Opens local filename or remote URL
  • Removes extraneous messages on entering interactive shell
  • New --compact subcommand to re-compress and defragment a database file, potentially shrinking it further and making it more suitable for web access
• The extension is now compatible with host programs statically linking SQLite3.

---

Start here 👉 👈

Most developers should install a package through pip/conda/maven/cargo, which bundle the same prebuilt library files available below for use with C/C++ and yet-to-be-packaged languages.

• libgenomicsqlite.so for Linux x86-64 (Ivy Bridge), built in CentOS 7
• libgenomicsqlite.dylib for macOS Catalina x86-64

An up-to-date version of SQLite itself (≥3.31.0) is also required, as detailed in the docs. If unable to upgrade the host SQLite, a prebuilt Linux x86-64 libsqlite3.so.0 is available below, for deployment with suitable LD_LIBRARY_PATH.

USE AT YOUR OWN RISK: This project is not associated with the SQLite developers.

---

_{SHA-256 digests:}

610d5de2f12906b098528c391a1af9a9bdb09561f1b6e795a2c739d533fcf5c6  libgenomicsqlite.so
80e22ff126561d379210363c842f95101a1cdd9a94d687a342cabadf0e0add24  libgenomicsqlite.dylib
9d6cd9c6724d276db4d3b1a344d72cd96bfa2bda99e4702033647b6bf481f8b6  genomicsqlite-jdbc-v0.8.0.jar
2dae78da03f2dd1bdeac5089cf4ec976912efab23186e5b6c0c8ce91048d16b9  libsqlite3.so.0