#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).
SQLite Transactions and Virtual Tables
https://misfra.me/2025/sqlite-transactions-and-virtual-tables/
"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
A hackable AI assistant using a single SQLite table and a handful of cron jobs
#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.
A hackable AI assistant using a single SQLite table and a handful of cron jobs
A hackable AI assistant using a single 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
I... actually managed to do this and it was somewhat messy to get through with it, but I did it. My 'stoppers' initially were simply needing to update some of the #Jellyfin's xml configs for any wrong/old paths/values, and lastly, the #SQLite DBs themselves which had old paths as well - most of which were easy to fix as they're text values, but some were (JSON) blobs, using the same extension on #VSCode, this wasn't that hard to do either by simply exporting the blob, editing the blob's JSON text value, and reimporting the blob to the column.
Now my Jellyfin #LinuxServer.io container sitting in an unprivileged (#Debian #Linux) #LXC container on #Proxmox is set up with hardware transcoding using the #AMD Ryzen 5 5600G onboard iGPU (cos I'm getting impatient in waiting for my #Intel #ArcA380 to arrive). I'll update my #ErsatzTV container to do the same. Everything's perfect now, 'cept, I still wouldn't recommend users to stream Jellyfin on the web or a web-based client using transcoding, cos while the transcoding itself is perfect, Jellyfin seems to have an issue (that I never got on #Plex) whereby the subtitle would desync pretty consistently if not direct playing - with external or embedded subs, regardless. Dk if that can ever be fixed though, considering the issue has been up since 2023 with no fix whatsoever.
There's also a separate issue I'm having where Jellyfin does not seem to support discovering/serving media files that are contained in a symlink directory (even though there were some people on their forums reporting in the past that it should) - I've reported it last week, but it's not going anywhere for now. Regardless though, I'm absolutely loving Jellyfin despite some of its rough edges, and my users are loving it too. I think I've considered myself 'migrated' from Plex to Jellyfin, but I'll still keep Plex around as backup for these 2 cases/issues I've mentioned, for now.
https://github.com/jellyfin/jellyfin-web/issues/4346 https://github.com/jellyfin/jellyfin/issues/13858
RE: https://sakurajima.social/notes/a6j9bhrbtq
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
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/
