Posts tagged: sqlite

!https://pype.dev/using-litestream-to-restore-my-database-for-easy-development/#Update

!https://x.com/MeetGor21/status/1967818642768470447

!https://simonwillison.net/2024/Oct/4/sqlite-rsync/

!https://simonwillison.net/2024/Jul/23/sqlite-jiff/

!https://stackoverflow.com/questions/82875/how-can-i-list-the-tables-in-a-sqlite-database-file-that-was-opened-with-a...

!https://stackoverflow.com/questions/8988915/sqlite-count-slow-on-big-tables

!https://kerkour.com/sqlite-for-servers

!None

!https://changelog.com/podcast/433

!https://www.youtube.com/watch?v=yTicYJDT1zE&t=2s

!https://github.com/benbjohnson/litestream

!https://litestream.io/blog/why-i-built-litestream/

!https://fly.io/blog/all-in-on-sqlite-litestream/

!https://fly.io/blog/litefs-cloud/

!https://www.sqlite.org/fts5.html

!https://sqlite-utils.datasette.io/en/stable/python-api.html#full-text-search

!https://github.com/simonw/datasette-render-markdown

!https://docs.datasette.io/en/latest/full_search.html#enabling-full-text-search-for-a-sqlite-table

!https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database

!https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data