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

New release of Database Workbench, database GUI tool for #MySQL #MariaDB #SQLServer #oracle #sqlite #PostgreSQL #postgres #interbase #nexusdb

#databasetools #databasedevelopment #DatabaseWorkbench #database

https://www.upscene.com/news/item/20251208

"Mini ODE to SQLite"

table created
deserialized JSON
needs many columns
what if the JSON changes?
more columns needed?

maintenance headache
like sweeping back tide with broom
read SQLite docs
new table definition
single column for JSON

now json_extract
obtains desired value
with only SQL

#SQLite #JSON #haiku #tanka #TIL

BTW: pronouncing SQL as sequel 🙂

I am super excited to announce the immediate release of Loupe 0.13 which I have worked on in the past weeks. Go checkout the improvements, they are massive! :) https://github.com/loupe-php/loupe/releases/tag/0.13.0 #loupe #php #sqlite #search

Rqlite is a feature-rich, rock-solid, fault-tolerant, distributed relational database built on SQLite. It's lightweight, developer-friendly, and exceptionally easy to operate, offering effortless installation and deployment.

https://github.com/rqlite/rqlite

#programming #technology #sqlite

By removing network latency, a major bottleneck for databases like Postgres, SQLite avoids Amdahl's Law. The single writer allows for easy batching, enabling it to handle over 100,000 transactions per second with serializable isolation in benchmarks, outperforming a networked database in this scenario.

https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html

#programming #sqlite #clojure

@fosstastic Looks like the feedback was bad and loud enough that they are working on a migration tool: https://github.com/containers/podman/pull/27660

#podman #sqlite

Dreamed that someone in #gentoo had put out an announcement about @librecast saying that we used mjolnirdb for our test data, which I'd never heard of.

I just had to check. There is no mjolnirdb. I usually use #lmdb (or #sqlite if we need a SQL interface) 😉

Запускаем C++ SQL-движок в браузере: как парсить Excel, CSV и Parquet через WebAssembly (без сервера)

Современный фронтенд давно перестал быть просто "лицом" приложения. Мы переносим в браузер нейросети, обработку видео и криптографию. Но когда дело доходит до банальной аналитики файлов — например, локального парсинга тяжелого Excel или Parquet-файла и выполнения SQL-запросов по ним — мы часто упираемся в ограничения JS-библиотек или вынуждены гонять данные на сервер. Команда r7-consult решила задачу радикально: мы взяли наш C++17 движок excel_loader , скомпилировали его в WebAssembly и получили возможность выполнять полноценный SQL по локальным файлам прямо в браузере. В этой статье разберем архитектуру решения wasm-sqlite-database , посмотрим, как C++ код дружит с JS, и покажем, как превратить браузер в локальный ETL-инструмент.

https://habr.com/ru/articles/972646/

#sqlite #wasm

In today's episode of "Tech Buzzword Bingo," folks are shocked to discover that #SQLite, the database equivalent of a Nokia 3310, can do 100,000 #transactions per second WITHOUT MVCC or a real server. 🤯 Apparently, using a MacBook Pro with a chip named after a fruit is the secret sauce! 🍏💻
https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html #TechBuzzwordBingo #MacBookPro #DatabasePerformance #FruitChip #HackerNews #ngated