SQLite Disk Page Explorer

1. sqlite-page-explorer

   1 3 616 2.5 Lua

   Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them.

   

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. awesome-cosmopolitan

   2 8 306 2.0

   List of Cosmopolitan Libc related resources and projects

   

   redbean!! redbean is so good

   https://redbean.dev/

   likely a bit outdated but:

   https://github.com/shmup/awesome-cosmopolitan?tab=readme-ov-...

4. sqlite-s3vfs

   3 4 174 1.6 Python

   Python writable virtual filesystem for SQLite on S3

   

   It was for work so I can't share it, but it's read-only and assumes an immutable database which puts it into the realm of a weekend project. I generate the database files in a batch process with regular SQLite, then upload it to S3 and query it using the S3 VFS. If you pull up the S3 API and the SQLite VFS API it's pretty straightforward to see how to glue them together for a simple read-only VFS. I do byte range requests to pull out the pages that SQLite requests, and a readahead cache helps reduce the number of requests.

   There are some open source codebases that do similar things, but take it all the way with write support: https://github.com/uktrade/sqlite-s3vfs

5. go-sqlite3

   4 31 617 9.6 Go

   Go bindings to SQLite using wazero (by ncruces)

   

   The read only bit is definitely a relatively simple afair.

   My Go driver supports it, through a combination of a VFS that can take any io.ReaderAt, and something that implements a io.ReaderAt with http Range requests (possibly with some caching).

   https://github.com/ncruces/go-sqlite3/blob/main/vfs/readervf...

Suggest a related project