I am disappointed to find that, with #SQLite, an INSERT statement with both ON CONFLICT DO NOTHING and RETURNING clauses won't return anything if there is a conflict.
I have a table that's basically just for interning frequently-used strings. It has a numeric ID column and a unique text column, and I want to get the ID for a given string, inserting if necessary.
With this RETURNING behavior, that has to be done in two steps, not one. 
#Coding_Fridays is back : K-nn classifier in SQLite
Watch the full video in the Youtube channel central
>> https://www.youtube.com/@apneacoding
This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics.
Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).
#Coding_Fridays is back : K-nn classifier in SQLite
Watch the full video in the Youtube channel central
>> https://www.youtube.com/@apneacoding
This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics.
Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).
"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 https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/ #ArtificialIntelligence #digitalassistant #AIassistant #sqlite #diy #LLM
#grist est un logiciel libre très intéressant utilisé de plus en plus par l'ANCT (Agence Nationale de la cohésion des Territoires) et la DINUM (Direction Interministérielle du Numérique)
Voici une vidéo très intéressante, présentée en particulier par Aude Zuliani, gristeuse professionnelle à l'ANCT (https://forum.grist.libre.sh/u/audezu/summary, https://community.getgrist.com/u/aude/summary)
- https://tube.numerique.gouv.fr/w/b1742f58-b2aa-45e9-8604-fbfa303fe56a
- https://gdevops.frama.io/databases/grist/news/2025/02/13/webinaire-introduction-a-grist/index.html
This is really cool: SQLite File Format Viewer (runs entirely in the #browser)
> This tool helps you explore the #SQLite file format internals according to the official #specification. It's designed for #developers and #database enthusiasts who want to understand the internal structure of SQLite database files.
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.
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.
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
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
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
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.
Which can actually give some performance improvements on postgres.
