Redka aims to reimplement the core parts of #Redis with SQL [#sqlite, #postgresql], while remaining compatible with Redis API.
TIL about the sqlean project, which brings #SQLite extensions together, neatly packaged into domain modules, documented, tested, and built for Linux, Windows and macOS. Something like a standard library in Python or Go, only for SQLite.
and a boatload of extensions browsable at https://sqlpkg.org/all/
Yesterday, I set up a personal #forgejo (https://forgejo.org) instance on my VPS. It was refreshingly simple.
I love that the default is #SQLite which is more than enough for a private instance. Forgejo looks good. I'm currently only using it as a backup/mirror of some of my GitHub repos. I sure wish my current ticketing & project planning tool #Linear would support git sites other than GitHub/GitLab…
Hey Fediverse! 
We’ve been quiet… but not idle. Forget waiting for long blog posts, time for micro updates.
Today’s news:
We’ve got a few BadgeFed instances live and federating! 
To make it happen, we did a hardcore backend rewrite to support multiple domains on a single machine. For most, it’s a niche cost-saving move, but it might be useful for others too. Under the hood: each domain runs its own SQLite DB, with backups in place.
But this isn’t just about the tech, the fun part is seeing multiple BadgeFed servers talking to each other (!!). Follow them, check the thread, boost it, and watch for more as they come online!
You can read the article "BadgeFed Update: Multiple Instances Online!" by @mapache here as well.
#badgefed #fediverse #openbadges #update #activitypub #sqlite #federationRemember when I was nerd-sniped and built a viewer for french communes border data?
Well, I rewrote all the data processing in Rust (and SQLite) and made it generic, so now instead of just french communes, there are 400+ categories of places to view. A few examples:
Brazil municipalities
Quarters of Limassol
Provinces in Thailand
Romanian counties (județ)
Updated dj-lite for #Django to 1.0.0! 
- Add kwargs for all default pragmas
- Allow adding additional pragmas if needed
- Substantial updates to the readme
- Add `temp_store=MEMORY` pragma by default (from @oliverandrich)
Default #SQLite pragmas are now:
```
PRAGMA journal_mode=WAL;
PRAGMA synchronous=NORMAL;
PRAGMA temp_store=MEMORY;
PRAGMA mmap_size=134217728;
PRAGMA journal_size_limit=27103364;
PRAGMA cache_size=2000;
```
https://github.com/adamghill/dj-lite
https://pypi.org/project/dj-lite/
rust-query, a library with a better API to query #SQLite databases with #Rust 
https://nlnet.nl/project/rust-query/
While that sounds relatively mundane, it's something I'm excited about because Rust really doesn't have as many options as, say, Python, where I just define a model in the code and it automagically generates tables, migrations, and everything in between. Did I say doesn't have options? Well, that was only until now 
3/n
Alright, folks, who can make a case for using SQLite in production for small hobby sites?
The idea sounds silly to me, but I've been conditioned to consider it solely as a development tool.
Now I wonder: Does this attitude do SQLite dirty?
TIL: if sqlite fails to open the .db-wal or .db-journal file with -ENOSPC, it will return the error Runtime error: unable to open database file (14), and you'll scratch your head for days wondering why it fails despite already having a file descriptor to the database itself.
Nothing a good old PRAGMA journal_mode=memory; can't fix (don't do this at home though, this is for a temporary db file easy to rebuild)
https://forum.grist.libre.sh/t/releases-1-7-x-aout-2025/1639 Nouveautés dans Grist – Version 1.7.0
Il est désormais possible d’ajouter des champs de pièces jointes directement dans les formulaires ! Cela permet aux utilisateurs de joindre facilement des fichiers lors de la saisie de données.
Been trying to keep my #PCEngines #ALIX boards alive, but it looks like #NanoBSD in #FreeBSD doesn't work (compile error in tz!) ... which is a real shame; I want to use these extremely reliable, low-power SBCs as #ZabbixDietPi, etc.
... which is a real shame; I want to use these extremely reliable, low-power SBCs as #Zabbix Proxies (using memory-backed #SQLite for the DB), but this seems to be a realllllllly big lift :(
@dexter is this something #OccamBSD can help me with? No chance of a 14.3 serial-console image out there?
Made a little library to ensure that #SQLite is setup for production use in #Django.
https://pypi.org/project/dj-lite/ https://github.com/adamghill/dj-lite
Based mostly on https://blog.pecar.me/sqlite-django-config from @anze3db.
L'accoppiata più calda è sicuramente "ListView 
LiveBindings": è la combo perfetta in #Delphi per creare liste dati dinamiche, responsive e cross-platform! 
Ecco cosa vedremo:
#LiveBindings: legare le liste ai dati con zero codice (o quasi) Personalizzazione visuale delle liste e dei loro elementi Le basi dell'accesso a DB (es. #SQLite) con #FireDAC
Ci vediamo stasera (martedì 22 luglio) alle ore 21.30 su #Twitch! 
Segui il canale per non perderti la live!
https://twitch.tv/compilaquindiva
Patch of the day
perf: Improve throughput by +1140%, https://github.com/matrix-org/matrix-rust-sdk/pull/5411.
It was fun to track it down.
Here's a challenge for you if you speak C and #PHP fluently. Somehow #SQLite seems to keep materialized CTEs for as long as the process runs which seems like it could break #frankenphp and Co. I'm not sure if my conclusions are correct - I'm pretty confused and would appreciate some insights :) https://github.com/loupe-php/loupe/pull/209 #help #BoostsAreAppreciated
Just got way easier to use #Turso with #Gren thanks to Joey Bright's new package: https://github.com/joeybright/gren-turso
I started to develop an Mojolicious::App for my collection of « Stay Put » screenshots taken from movies. The collection started circa 2010 that keeps growing. Until that day, the collection was a Photo « album » on Facebook, but I am more and more uncomfortable using this platform. More to come.
Colophon for https://beesocial.dev for anyone interested: https://beesocial.dev/colophon.
No vibe coding, just good vibes.
"Introducing a new SQLite driver for #WordPress "
https://make.wordpress.org/playground/2025/06/13/introducing-a-new-sqlite-driver-for-wordpress/
