#sqlite win ... corrupted database? Run this and it's back:

sqilte3 correupted.db ".recover" | recovered.db

«Stoolap - High-performance embedded SQL database in Rust»

Have any of you tried it before and what is your experience with it? Can it be used in the same way as SQLite? I ask because the open source project is relatively new, i.e. are there certain arguments to (not) use it productively?

🦀 https://stoolap.io

#rust #sql #database #sqlite #rustlang #opensource #embedded #newproject #db #database #productivity #askfedi

The early Web had a quality that has been lost ever since: it was *simple*

Download #httpd , #netscape write some #html by hand and boom, the concept of a networked digital society is born.

It first started going pear shaped with #LAMP . The complexity of a full blown database was not justified for most use cases. As proven decades later by the popularity of #sqlite and #ssg approaches.

The final blow was when #bigtech got into the act. Immense complexity for the simplest things became a moat

@helge Yep! Now suppose you have yesterday’s 500K #SQLite DB. If you keep a copy around (instead of writing your local change state there), now you can use sqlite3_rsync to download today’s updates quite quickly.

We have this excellent "SQLite As An Application File Format", there should be a follow up "SQLite As A Network Payload Format".
https://sqlite.org/appfileformat.html #SQLite

Renaming a table in SQL
Since I am currently overhauling many websites, I needed in one particular case to rename a table. Never needed this before, I searched and found the following. Bog-standard SQL (which worked for me) RENAME TABLE ohu1y_docman_file_counts TO ohu1y_docman_file_counts_bak; PostgreSQL / SQLite ALTER TABLE ohu1y_docman_file_counts RENAME TO ohu1y_docman_file_counts_bak;
---
https://3xn.nl/projects/2026/02/11/renaming-a-table-in-sql/
---
#mysql #postgresql #rename #sqlite #table

📣 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.upscene.com/database_workbench/

Fossil https://fossil-scm.org is forum, chat, bug tracker, wiki. And a distributed version control.

#FossilSCM #Fossil #SQLite #Discord

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

I still think it’s cool that #python has #sqlite bindings right in the standard library

I haven't had to write a Python app that uses a database in a very long time. I thought things were different now. Better, I would hope. But, seriously? Do I still need to write my own SQL statements? What year is that? 🙄

PS: if someone can suggest a Python library that I can use to manipulate SQLite without writing SQL, I would appreciate it.

#Python #SQLite

📊 EXPLAIN-based index analysis detects full table scans, missing indexes, filesort & temporary tables on #MySQL, #MariaDB & #SQLite
🔄 Duplicate query detection finds identical queries executed multiple times with location tracking

⏱️ Query timing assertions for individual query time & total execution time thresholds
🛡️ Combined assertQueriesAreEfficient() checks N+1, duplicates & missing indexes in one call
📋 Detailed failure messages show actual SQL, bindings & source locations

I'm now able to update the book links in the Publii SQLITE tables from the booklinks table I have created myself.

After 45 years in IT I still love this programming stuff.

#programming #sqlite #publii #Python #noai

Last week I released a project a couple of years in the making which allows the #atari8bit to communicate with a #cubeSQL database. cubeSQL wraps #SQLite as a server. I made an admin program called CubeDot (dBase dot prompt style), a POC todo manager called Fuji Do, and a spoof called Fuji Poo. This allows the Atari to handle over 100,000 records with full featured browsing! You can find out more and download them (with complete manuals) at my website:

https://unfinishedbitness.info/2026/02/01/atari-8-bit-sql/

I waited to post here until I got some screenshots posted.
#fujinet

Ich versuche gerade mit #PHP #Symfony ein Tutorial nachzuvollziehen und beim Punkt Datenbank mit #sqlite komme ich seit Stunden nicht weiter.

Der Befehl
symfony console doctrine:database:create

liefert einen Fehler:
Could not create database /home/user/php/symfony/website/var/products.sqlite for connection named default
Operation "Doctrine\DBAL\Platforms\SQLitePlatform::getCreateDatabaseSQL" is not supported by platform.

If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a #PostgreSQL db or write the email watcher myself to put it into the consume folder.

Батчинг запросов в Prisma: объединяем несколько запросов в один вызов БД

В версии 1.58.0 библиотеки prisma-sql появился метод $batch , который позволяет выполнять несколько Prisma-запросов за один раунд-трип к базе данных.

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

#sql #sqlite #базы_данных #prisma #typescript #nodejs #производительность

Discovering the visionary #moodlebox project made me think that the #moodle project has really missed a trick by not properly supporting #sqlite as a database backend.

It would make tinkering with and hacking on the codebase so much easier, potentially expanding #opensource contributor numbers but also generating possible new use cases.