Lmst

I’ve had a fun day converting my #Perl #Dancer2 application to use #SQLite instead of MySQL, which not only suits the size and expected use of the application better, but gave me the opportunity to get rid of MySQLisms. It has become so much easier to work locally with Dancer, allowing a lot of schema and view changes very quickly, so I can see the relationships between A. C. Michael’s paintings much faster. #art #CatalogueRaisonné

A gallery of paintings by A. C. Michael in my new app.

A painting from H. Rider Haggard’s “The Ghost Kings,” by A. C. Michael.

SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog https://links.shikiryu.com/shaare/75fnZQ Ooooh je ne connaissais pas cette gestion du JSON avec sqlite ! Trop bien !
#sqlite #tips

SQLite JSON at Full Index Speed Using Generated Columns

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing

#HackerNews #SQLite #JSON #GeneratedColumns #Indexing #DatabasePerformance

SQLite JSON at full index speed using generated columns

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing

#sqlite

#sqlite vfs with litestream https://fly.io/blog/litestream-vfs/ (I've played in the office with sqlite and #ceph vfs integration which also worked out of the box.

makes me think vfs might be an underappreciated interface.

🌕 Litestream VFS：利用 SQLite 擴展功能直接從物件儲存讀取資料
➤ 跳過下載！Litestream VFS 讓 SQLite 直接查詢雲端備份資料
✤ https://fly.io/blog/litestream-vfs/
這篇文章介紹了 Litestream VFS（虛擬檔案系統），一項創新的功能，讓 SQLite 應用程式可以直接讀取儲存在物件儲存（如 S3）上的資料庫備份，無需下載完整檔案。作者 Ben Johnson 詳細解釋了 Litestream 如何透過 LTX（SQLite 資料傳輸檔案格式）的「壓縮」功能，只讀取必要資料頁的最新版本，大幅提升讀取效率。此外，文章還展示瞭如何利用 VFS 外掛程式，讓 SQLite 能夠進行即時的「點時間回復」（PITR），並直接查詢歷史備份資料，為資料庫管理和查詢帶來了前所未有的彈性和便利性。
+ 太棒了！這解決了我一直以來備份 SQLite 資料庫的痛點。再也不用擔心備份檔案越來越大，而且查詢歷史資料變得如此簡單。
+ Lites
#SQLite #Litestream #VFS #資料庫最佳化 #物件儲存

I'm creating an AI dream diary that uses AI for writing and analyzing dreams. It's the first of my projects to use AI.

#FullStack #Django #SQLite #API #Python #HTML #CSS #JavaScript #AI #Programming

Using pragmas to do sql queries on database state in the past is 🤯

https://fly.io/blog/litestream-vfs/

It is like sql suddenly got git’s -r parameter

#sqlite #litestream

How to Use SQLite Studio: A Complete Guide.

Cómo Usar SQLite Studio: Guía Completa.

👉 https://nubecolectiva.com/blog/como-usar-sqlite-studio-guia-completa/

#programming #coding #programación #code #webdevelopment #devs #softwaredevelopment #sql #sqlite

Drizzle is a pretty cool ORM for SQL-like databases. We use it at @awana.digital for local databases with #sqlite and #nodejs

https://orm.drizzle.team/docs/overview

📣 New release of #DatabaseWorkbench now available!

🖥 Database Workbench is a developer tool for #SQLServer, #Firebird, #Oracle, #SQLite, #MySQL, #MariaDB, #PostgreSQL, #InterBase and #NexusDB.

⬇️ Grab your trial copy now.

https://www.firebirdnews.org/database-workbench-6-9-0-released/

Did the TODO. Now old backups are cleaned up.

https://codeberg.org/brybry/gotosocial-sqlite-backup-to-s3/commit/f3ef0a07bebe8822f5b8284fc0a280aefc79a23d61177e321c6759ef6e6cfd6a

#SQLite #gotosocial #Codeberg

Setup daily backups of my #SQLite for my #gotosocial server. Backups go to S3 at the moment but I’ll add just archiving to a local path or maybe scp to a host? I dunno. Don’t need to make things too complicated.

I put the script on #Codeberg for others to use if they want.

TODO: add cleaning up old backups.

https://codeberg.org/brybry/gotosocial-sqlite-backup-to-s3

la bibliothèque #diskcache est intéressante pour plusieurs raisons (https://github.com/grantjenks/python-diskcache) :
- écrite en pur #Python
- persistance du cache sur disque avec #SQLite
- fonctionnalités avancées, comme locking (cf. https://grantjenks.com/docs/diskcache/api.html#diskcache.Lock)

Et bien d'autres choses.

"n8n 2.0 enhances security, speeds up automation workflows & simplifies production updates"

"n8n2.0 introduces secure-by-default execution, making workflows safer for technical teams relying on this AI-powered automation platform."

https://alternativeto.net/news/2025/12/n8n-2-0-enhances-security-speeds-up-automation-workflows-and-simplifies-production-updates/

#SQLite

BobSQL

Based on tsqlparser, tgpiler, and dxp

https://github.com/ha1tch/tgpiler

https://github.com/ha1tch/tsqlparser

https://github.com/ha1tch/dxp

All the pieces are there, so why not?

#tsql #bobsql #database #db #foss #golang #sql #microsoft #mssql #mssqlserver #sqlite #postgres

Tgpiler is a transpiler based on Tsqlparser

Tgpiler is a T-SQL transpiler that targets the Go programming language.
https://github.com/ha1tch/tgpiler

That means: you write T-SQL stored procedures, Tgpiler transpiles them to Go. Which means that with a little more luck and some astute tweaking, your old logic now scales horizontally for free.

Tgpiler is a transpiler powered by tsqlparser that parses T-SQL stored procedures, interprets T-SQL DML and compiles to Go source code with two execution paths: static and dynamic. The dynamic pathway is a genuine T-SQL runtime that executes most dynamic T-SQL code as part of your Go microservice. Newer versions also support a dual backend: DML or gRPC. The DML backend targets Postgres, Mysql, SQLite, and MSSqlServer. The gRPC backend is based on gRPC protos and using voting heuristics it maps stored procedure code to gRPC execution.

Once the vision is fully realised, it will become not a compiler, not a transpiler, not a migration tool with Go as its target, but a different category of tool for which we don't have a name yet:

Its main use is the migration of vertically scalable business logic to horizontally scalable business logic.

It's licenced under the GPL 3.0 and if you have any cool ideas about what should be done about it, feel free to call me:
h@ual.fi

#golang #tgpiler #tsql #foss #tsqlparser #db #database #mssqlserver #mssql #microsoft #sql #sqlite #postgres

This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).

And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi

https://github.com/ha1tch/tsqlparser

#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres