#TIL that you can use #python3 as #sqlite #CLI replacement:

```
python3 -m sqlite3 /path/to/database.db "SELECT name FROM sqlite_scheme WHERE type='table' AND NAME NOT LIKE 'sqlite_%'; "
```

this command will show all tables in the file `/path/to/database.db`

Infinite Recursion Guards

#sql #duckdb #postgresql #sqlite #mysql #mariadb

https://modern-sql.com/caniuse/with_recursive_infinit_loop_guards

Vibing with the Agent Control Protocol

Although most of my actual work happens inside a terminal, I have been wanting an easy way to talk to the newfangled crop of AI agents from my iPhone.(...)

#acp #agents #ai #iphone #mcp #preact #sqlite #sse

https://taoofmac.com/space/notes/2026/02/01/2100?utm_content=atom&utm_source=mastodon&utm_medium=social

Is there a decent, Airtable-like #sqlite frontend for macOS that's #OpenSource / #FreeSoftware?

Nocodb looked promising but doesn't have an OSI-approved license.

https://github.com/nocodb/nocodb/blob/master/LICENSE.md

(legit suggestions only; do not presume to explain #FOSS-related concepts to me)

Tạo dịch vụ lưu trữ avatar Octa - hiệu quả hơn S3! Dùng SQLite để lưu ảnh, tốc độ xử lý 35% nhanh hơn hệ thống tập tin truyền thống. Hỗ trợ tối ưu ảnh, giảm 75% dung lượng và phục vụ tại tốc độ CDN. Dễ thiết lập, backups bằng 1 file .db duy nhất. Thích hợp cho blog cá nhân với server $3-$5 nhờ hiệu năng cao (50ms-800ms cho từng thao tác). Hệ thống khóa linh hoạt cho phép truy cập nhiều dạng URL.
#Octa #SQLite #AvatarStorage #Mastodon #MastodonTips #HiệuSuất #OpenSource #LưuTrữHìnhẢnh #DevTo #N

Is it just me, or this 11 months old AI generated article hallucinated entire benchmark results on a version of SQLite that still to this day has yet to be announced, let alone released?

https://markaicode.com/sqlite-4-production-database-benchmarks-pitfalls/

#sqlite #aislop #ai #slop #database #benchmark

New 𝟭𝟱𝟬 𝗠𝗕 𝗠𝗶𝗻𝗶𝗺𝗮𝗹 𝗙𝗿𝗲𝗲𝗕𝗦𝗗 𝗜𝗻𝘀𝘁𝗮𝗹𝗹𝗮𝘁𝗶𝗼𝗻 [150 MB Minimal FreeBSD Installation] on vermaden.wordpress.com blog.

https://vermaden.wordpress.com/2026/02/01/150-mb-minimal-freebsd-installation/

#verblog #freebsd #beadm #bectl #desktop #laptop #minimal #pkg #server #space #sqlite #storage #zfs

New 𝟭𝟱𝟬 𝗠𝗕 𝗠𝗶𝗻𝗶𝗺𝗮𝗹 𝗙𝗿𝗲𝗲𝗕𝗦𝗗 𝗜𝗻𝘀𝘁𝗮𝗹𝗹𝗮𝘁𝗶𝗼𝗻 [150 MB Minimal FreeBSD Installation] on vermaden.wordpress.com blog.

https://vermaden.wordpress.com/2026/02/01/150-mb-minimal-freebsd-installation/

#verblog #freebsd #beadm #bectl #desktop #laptop #minimal #pkg #server #space #sqlite #storage #zfs

📰 Distributed SQLite: Why LibSQL and Turso are the New Standard in 2026

Think SQLite is just for local apps? Discover how LibSQL and Turso are supercharging the world's most deployed database for a globally distributed,...

#database #sqlite #edge #news

🌍 Also in: 🇪🇸 🇫🇷 🇩🇪 🇧🇷 🇮🇹

🔗 https://dataformathub.com/blog/distributed-sqlite-why-libsql-and-turso-are-the-new-standard-in-2026-4rt?utm_source=mastodon&utm_medium=social&utm_campaign=blog

I need help to win an office debate. can anyone CONFIRM that there exists some toaster model out there that runs SQLite?

#sqlite

Deep dive into Turso, the “SQLite rewrite in Rust”

https://kerkour.com/turso-sqlite

#rust #sqlite

Fly.io giới thiệu tính năng Writable VFS mới trong Litestream, cải thiện quy trình sao lưu và phục hồi CSDL SQLite cho lập trình viên. #Litestream #SQLite #Flyio #Côngnghệ #Pháttriểnphầnmềm

https://www.reddit.com/r/programming/comments/1qqgjr9/litestream_writable_vfs/

#SQLite #Rust
Visiblement quelqu'un a ré-écrit SQLite en Rust : https://github.com/tursodatabase/turso
Je ne sais pas si c'est une bonne idée.🤔
https://kerkour.com/turso-sqlite

EDIT: Oh merde, je n'avais pas fait gaffe au ".claude" 😬 ça a probablement été vibe-codé.

Deep dive into Turso, the "SQLite rewrite in Rust"
https://kerkour.com/turso-sqlite
#ycombinator #performance #programming #rust #sqlite

Deep dive into Turso, the “SQLite rewrite in Rust”

https://kerkour.com/turso-sqlite

#rust #sqlite

Разбираемся в функциональных зависимостях БД

Привет Хабр! Возможно вас, как и меня, первое знакомство с функциональными зависимостями в базах данных повергло в легкий ступор. Длинные определения, которые не давались даже после третьего прочтения, излишняя абстрактность, когда на простые и понятные примеры поскупились, и прочее прелести «научного» подхода к объяснению сложных тем. Пора раз и навсегда разобраться во всем этом. Тем не менее, я постараюсь не упускать детали и, где это уместно, углубиться в тему с головой. Без претензии на академичность, но с претензией на ясность. Начнем.

https://habr.com/ru/companies/selectel/articles/988068/?utm_source=habrahabr&utm_medium=rss&utm_campaign=988068

#sql #sqlite #базы_данных #функциональная_зависимость #selectel

Разбираемся в функциональных зависимостях БД

Привет Хабр! Возможно вас, как и меня, первое знакомство с функциональными зависимостями

https://habr.com/ru/companies/selectel/articles/988068/

#sql #sqlite #базы_данных #функциональная_зависимость #selectel

I'm creating a full-stack Next.js app for Ollama.

#Ollama #FullStack #NextJS #ReactJS #SQLite #Sequelize #API #JSX #NodeJS #CSS #JavaScript #AI #Programming

With Part-DB 2.5 you can now easily switch between database platforms. If your instance has grown too large for #sqlite or wanna use native natural sorting only #postgresql or #mariadb (not MySQL) support, then you can now easily migrate without any data loss.

Under the hood the data is copied on an object level using #doctrine ORM, so this is also easy to maintain and should works even as Part-DB develops further.

#opensource #partdb

@ableijs @bossito @ploum

Can add:
- #Ocaml (and generally ML lineage)
- #Haxe

Though we collect this nice set of EU-centric OS fame, let's give a pause and hat-tip to the excellent overseas #SQLite and #FossilSCM