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

The #turso implementation of #sqlite keeps getting better. I've built sync engines before. Very much know the complexity enough to choosing NOT do it all myself.
https://turso.tech/blog/local-first-cloud-connected-sqlite-with-turso-embedded-replicas

Performing group_concat queries over distinct values, with a custom delimiter, with SQLite

https://fed.brid.gy/r/https://www.jvt.me/posts/2025/03/25/sqlite-distinct-group-concat/

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

I tend to hop a bit, between #sqlite and #postgres. So much that the nuances of each keeps merging for me.

Interestingly enough, sqlite is the one my brain defaults to. You simply dumb everything way down. Which can actually give some performance improvements on postgres.

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

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

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.

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

Quick Clip: object list filtering in Database Workbench

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

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

It's so nice to be able to do 3 things in the same database at the same time and not worry that one is blocking the other… #postgres #sqlite

Our product manager extraordinaire @jluther has been writing Go and https://templ.guide content for https://apply.coop which tells me we've made the right tech stack choice in order for everyone at @limeleaf to contribute code to it.

He's even been getting his SQLite chops leveled up too.

"ONE OF US! ONE OF US!"

#TIL that multiple processes can access the same #SQLite database at the same time. Only writing is limited to one process.

Just don’t do it on Win 9x, I guess:

“Under Win95/98/ME which lacks support for reader/writer locks, a probabilistic simulation is used instead.”

(https://www.sqlite.org/faq.html)

Decided to do a little #AI #SocialMedia #Experiment.

Introducing SocialMedIA.

#GitHub link:
https://github.com/IAmTheNerdNextDoor/SocialMedIA

A self-hostable "social media" platform that features fake AI users to simulate real social media post conversations. It's not big, but I felt like uploading it anyways. It uses #SQLite 3 to store posts. It also has randomly generated usernames.

You should totally check it out and contribute to it!