Full, working example of using sqlite with the pretty nice, full stack, gren web framework:

https://github.com/blaix/prettynice/tree/main/examples/v3/database

"Take a Vonage Voice API webhook and persist it to #Sqlite"

#Typescript #Prisma #ExpressJS: 2 days, including finding out #Sequelize CLI is broken so shelved for Prisma and some libraries are still stuck in CommonJS vs ESM module export hell.

#Laravel: 35 minutes.

DIY AI Butler Is Simpler and More Useful Than Siri - [Geoffrey Litt] shows that getting an effective digital assistant that’s tailored ... - https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/ #artificialintelligence #digitalassistant #aiassistant #sqlite #diy #llm

It would be nice if Godot had native integration with SQLite, or at least an official plugin. It's a tiny/fast/embedabble database, perfect for games and mobile/desktop apps.

Stevens: a hackable #AI assistant "using a single #SQLite table and a handful of cron jobs"

https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs

#syncthing is working on a v2 release that will switch the internal database to #sqlite. Testers welcome!

https://forum.syncthing.net/t/syncthing-on-sqlite-help-test/23981

Uuuh, Graft looks super interesting for a #SQLite context! Basically, it's replication to object storage on the 4 kB page level, so it maps nicely to SQLite pages (and everything else): https://sqlsync.dev/posts/stop-syncing-everything/

As a stress test I loaded 8M bookmarks into a little SQLite backed bookmark saving/sharing web app I'm building. The slowest part turned out to be the `SELECT count(1) FROM bookmarks` query that's used as part of the pagination UI. Not what I was expecting but known/expected behaviour from what I've read. It takes 400ms on Snapdragon X Elite CPU, which is fine in practice—I'd be surprised if anyone actually stored more than 100k items in it.

Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.

https://www.youtube.com/watch?v=ZnFf4sj8jro

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Running SQLite in Pure Java with Quarkus
https://quarkus.io/blog/sqlite4j-pure-java-sqlite/
#Java #SQLite #Quarkus

GitHub - splitbrain/meh: Meh... another comment system https://github.com/splitbrain/meh #alternative #integration #OpenSource #comments #mastodon #node.js #website #GitHub #sqlite #static #blog #PHP

Leanpub book LAUNCH! Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project by Isaak Tsalicoglou https://youtu.be/LtzBS9hb1Go #books #leanpublishing #selfpublishing #booklaunch #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast

NEW! A Leanpub Frontmatter Podcast Interview with Isaak Tsalicoglou, Author of Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project | Watch here: https://youtu.be/zeUVFt82UG4 #books #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast

I'm a database extremist. I default to #SQLite for pretty much anything.

As an independent software consultant, I need time tracking and CRM like anyone else. Guess what? It's just a single SQLite database file. :D Has worked wonderfully for years using just a database viewer app. (Tableplus, if you're wondering.)

But now, with this wonderful tool from Rune Kaagaard, I can hook up my database to Anthropic's Claude, and get insights into my time spent as well as my connections, just by chatting with Claude Sonnet 3.7.

Wild! :D

https://github.com/runekaagaard/mcp-alchemy

Video: Creating an #SQLite database with tables and foreign key relationships.
https://www.youtube.com/watch?v=w88NySp6Ydk

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Anyone using #litestream for an #sqlite DB

I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.

My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream

#GoToSocial #gts @gotosocial@thefedi.forum

TIL: you can insert and fetch strings that are way longer than 255 characters in a VARCHAR(255) column in #sqlite
There is no constraint

SQLite is a great tool if you want to use SQL queries on large datasets within languages like powershell, and you don't need a cumbersome SQL server.

Quick Clip: using #SQLite with Database Workbench
https://www.youtube.com/watch?v=9kD8JIUf14Q

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench