Running Matrix Synapse on SQLite and ran into a heavy performance problem on 1.128.0?
Well I did too and worked around it: https://slatecave.net/blog/synapse-sqlite-fix/
That’s what synapse gets for getting in my way while I’m trying to debug some other issue at 1:00 in the morning. 
Building a Minimalist Family Social Platform with JavaScript and PHP
Explore how to create a lightweight social website for families using modern web technologies. This article delves into the architecture, functionality, and customization options of a minimal social p...
https://news.lavx.hu/article/building-a-minimalist-family-social-platform-with-javascript-and-php
I’m starting to get the hang of Docker. For example, replacing the SQLite database in my self-hosted n8n instance with a PostgreSQL database was a piece of cake, thanks to the great support of Gemini 2.5.
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.
Subway Stories: Building an Visualization w/ Transit Data - Jediah Katz & Marc Zitelli -nyhackr Feb
"Every year, New Yorkers take more than a billion trips on the subway. Using data from the MTA, we mapped out how riders flow between stations at every hour. Each story explores a slice of city life."
Brilliant deep dive into prototyping, building and deploying the New York Subway Stories website.
https://www.youtube.com/live/83s_MWc5Yvs?si=U0uzCw0OSbRgBvxR
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
Anyone know if it’s possible to migrate a #SQLite @forgejo #forgejo database to #PostgreSQL or #MySQL?
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
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
I did not expect my clumsy announcement of #BadgeFed to make waves, and now I have a few followers in the @fediverse
It is only less than a dozen, but still I want to honor the follow LOL, and my database for the poc was a #sqlite. Now I need to download and backup that db, otherwise I will lose the pub/priv keys.
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.
