#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

正確に取れない数字は出さない — 4,000社の財務データで選んだ「諦めて注記する」設計

#Python #SQLite #xbrl #EDINET #データ分析

Imagine running your apps from a SQLite database! Farid Zakaria presents a bold vision for the future of executables with his prototype, SELF.

#database #development #reading-list #sqlite

MT5には経済指標カレンダーを取得する仕組みがあります。
EAからも取得できるのですが、独特なんです・・・💦

MT5の経済指標カレンダーにまつわる、あれやこれやをまとめました。

MT5の経済指標カレンダーを飼いならせ！じゃじゃ馬ならしMT5｜mr.cbr
note.com/mr_cbr/n/nf5...

#FX
#EA
#経済指標
#MT5
#MQL5
#SQLite
#経済指標カレンダー
#経済指標CSV
#経済指標DB

Build a conversational AI with persistent history. 203 lines of Python, OpenAI API plus SQLite, so context survives restarts. Intermediate level. https://www.valtersit.com/python/conversational-ai-with-persistent-history/ #python #ai #sqlite

SQLite inside Docker without a volume is a data deletion machine. Container restart wipes your database. Here is how Docker's ephemeral filesystem works and how to mount https://www.valtersit.com/guides/databases/sqlite-in-docker-containers-a-masterclass-in-data-deletion/

#docker #sqlite #devops

180 lines of Python that scrape job boards with Playwright and store results in SQLite. Intermediate level, runs from the CLI.

https://www.valtersit.com/python/job-board-scraper-and-aggregator/

#python #webscraping #sqlite

業務DBを読み取り専用MCPにしてClaudeから参照する

#Security #MCP #ClaudeCode #SQLite #Python

Reads should not stop writes. Writes should not stop reads.

SQLite Write-Ahead Logging keeps both moving.

One setting. A better fit for busy apps.

#SQLite #DatabaseDevelopment #SoftwareEngineering

Pipelines tolerantes a fallos en Python con SQLite WAL

¿Tu pipeline en Python se cae en el paso 19 de 20? Los pipelines tolerantes a fallos en Python ahora usan checkpoints SQLite para retomar sin perder nada.

#python #sqlite #wpipe #pipelinesdedatos #checkpoints

Quelqu'un connait le principe de #Wordpress avec une base de données #Sqlite ? Il faut un plugin ou il est possible de remplacer #Mysql à l'install ? Je vais tester mais si vous avez déjà la réponse ? Pour des petits sites qui ne bouge pas trop cela me semble une évidence.

upd as I had switched from unity's visualscripting sql lib to #Sqlite .net, I can say that

💥 all issues in repost still apply...
BUT
sqlite net is better because:

✅ never breaks on bulk inserts
✅ fully supports enum properties
✅ NotNull attribute really works

#buildinpublic #sql #orm #database

📌 Avalonia: “301 HTTP-Redirects” per Software fehlerfrei anlegen
#avalonia #csharp #macos #pocketbase #sqlite #windows

Work with #SQLite directly in your #IDE. Open SQLite databases, explore tables, edit data and run #SQL queries alongside your application #code. Compare leading IDEs.

I've just released Extralite 3.1.0: noteflakes.com/articles/202... #ruby #sqlite

When using a prepared SQLite statement, can ? stand in for a table or column name? Join the discussion and compare your understanding with the explanations and tests shared by the community.

https://forum.xojo.com/t/new-user-learning-experimenting-with-sqlite/88851

#SQLite #DatabaseDevelopment

📝 「レガシーコードの落とし穴」が招く16年の潜伏——Tailscaleが暴いたSQLiteバグから学ぶ、長期運用システムのデバッグ戦略

VPN企業Tailscaleが数ヶ月の調査で発見したSQLiteの隠れたバグ。16年間の潜在期間を経て顕在化した理由と、その対応方法から見える、レガシーシステム管理の本質に迫ります。

🔗 https://techscope365.com/2773/

#SQLite #バグ修正 #デタベス #AI #テクノロジー

Okay, I am here to inform you that once again I have infact cooked!

Something that's bugged me for a long time about Bearly Fit and that is the low end Android experience.

Especially on first boot.

#buildinpublic #reactnative #sqlite #claude

Discover why SQLite remains the world’s favorite database, its strengths, weaknesses, and the exciting Rust rewrite project Turso.

#database #reading-list #rust #sqlite