Ever wonder why your SQLite WAL file won't shrink

#Sqlite #Wal #Database #Performance

https://mustafaerbay.com.tr/en/blog/tutorials/wal-checkpoint-15-bin-cerceve-saydi-hicbirini-tasimadi/

15 bin çerçeve saydı, ama WAL dosyası yerinde sayıyor. SQLite savaşında checkpoint ateş etmiyor, dosya küçülmüyor. Üç sütun, bir karar; hangisine odaklanırsan…

#Sqlite #Wal #Veritabani #Performans

https://mustafaerbay.com.tr/blog/tutorials/wal-checkpoint-15-bin-cerceve-saydi-hicbirini-tasimadi/

Old code dies young as SQLite 3.54 drops Windows XP support for faster performance. #SQLite sugataai.com/blog/sqlite-...

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

Adding persistence to the Aspire dashboard | by James Newton-King

buff.ly/w9uhNAx

#aspire #cloud #dashboards #cloudnative #telemetry #data #sqlite #dapper

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

🟢 Node.js 26.11 saca la artillería: tiempo de espera nativo, SQLite sin el sufijo ‘Sync’ y Alpine Linux asciende a Tier 2 cibered.com/devops/entor...

#NodeJS #Node2611 #JavaScript #SQLite #AlpineLinux #DevOps #CiberED

Turn 26 · 1 player moved
🏅 @coil.bsky.social +9

18 cells left, 3 spares, 17 flagged.
Reply a coordinate, A1 to K11. Everyone who replies opens one.
30 min.
#Minesweeper #sqlite #braingame #gamedevelopment #opensourcegames #statistics

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

Not every project needs a database server.

SQLite is a full SQL database in one file. When it fits, and when to move on.

https://xt.om/sbfx

#SQLite #Database

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

SupabaseがTursoを取り込む理由は、AIが生む“使い捨てDB”の波にあった
https://papoo.work/doc/7c0b8fdacad57a7c
#supabase #turso #postgres #sqlite #ai

Writing safe hypermedia apps for a resource-constrained world

I've written some tutorials on using htmx to write web applications in Go and Rust, with SQLite and PostgreSQL:

https://benjamingeer.eu/en/post/hypermedia/

#go #golang #rust #rustlang #htmx #hypermedia #sqlite #postgres #postgresql

In www.e-basteln.de/computing/rp..., I came across this neat diagram (pic 1).

I decided to sit down and recreate it with pikchr.org (from the creators of SQlite!). The result is #2. Pretty close!

#pikchr #fossilSCM #sqlite

Well then. #supabase is the only target now for databases now. At least for me. 😅 #turso now part of supabase. So #postgres and #sqlite handled.

#Fauxcarta was about to fill up my 2 tb disk with #wikipedia's giant cache. Also it was duplicating items it really didn't need to. Trying to compact and deduplicate the cache materials into indexable #sqlite databases.

SQLite: cambiar tipo de columna sin perder datos

¿Cambiar tipo de columna en SQLite borra filas sin avisar? Te muestro el rebuild paso a paso para no perder triggers, índices ni datos clave.

#sqlite #basesdedatos #altertable #foreignkeys #sql

#GRDB can turn a #SQLite query into a stream of fresh values by tracking the database region behind the read.

I looked at ValueObservation, DatabaseRegion, transaction events, and concurrent reads.

https://ivantokar.com/posts/grdb-turning-sqlite-queries-into-live-application-state

#SwiftLang