Everyone wants to run #SQLite on the server.
But now you can run PostgreSQL in the browser!
Try PostgreSQL in #LiveCodes (using pglite from ElectricSQL )
Starter template:
livecodes.io/?template=post… 🚀

P.S. you can also run SQLite in #LiveCodes (starter template in comments 👇)

Mi stack favorito para webs en 2024

Framework → Astro
Estilos → Tailwind
Hosting → Cloudflare
Iconos → Tabler Icons
Dependencias → pnpm
Autenticación → Supabase
Testing → Vitest & Playwright
Base de Datos → Turso (SQLite)

Comparte el tuyo en los comentarios ↓

分享一个 Sqlite 冷知识。SQLite 测试代码和脚本数量是源码的 608 倍，SQLite 核心在默认配置下具有 100% 的分支测试覆盖率。

Rubyists! sqlite3 v2.0.0 has been unleashed!

github.com/sparklemotion/…

This is a major release which ships a native Linux Musl gem, has some shiny new features, some perf improvements, and cleans up a decade of deprecations.

Thanks to everyone who contributed!

#ruby #sqlite

المقال ده جميل جدا، و مقدمه بسيطه لللي معندوش خلفيه عن موضوع ال SQL Query planner في ال Sqlite

sqlite.org/queryplanner.h…

wait this is very stupid. the relationship is like, the opposite of exponential? the scaling laws (as i understand them) seem to indicate for each bump in capabilities has an exponential increase in cost, which is why each training run uses 10x more FLOPs than the last.

The TTFL database, in SQLite format

This is the whole deleted forum from Facebook

cdd.com/TTFL%20DB.db

Sqlite in-memory database using Dapper.

github.com/karenpayneoreg…

A viable Sqlite in production of a Rails application by 🍻Meet Stephen in 🇵🇱Wroclove Th 11.04—Sun 14.04 at #wroclawrb . Looking forward to give a try.

Worth saying clearly and loudly:

v2 of the sqlite-ruby gem provides everything you need for:
1. IMMEDIATE transactions
2. A non-GVL-blocking busy timeout
3. Fair retry mechanism
4. WAL mode

And we’ll be getting Rails using these features by default soon.

Did you know that #Python supports SQLite in the standard library? That's right. You don't need to install anything! 🐍🚀

Let's talk a little about that!

What I'm learning from this tweet is that

• a lot of people are SQLite curious
• a lot of people hate books

Y'all... books are good! They give you a survey of the material and you can dive into details elsewhere.

It solves the 'you don't know what you don't know' problem.

When is it ok to use SQLite in production?

SQLite Has The Greatest Code of Conduct Ever #Linux #YouTube youtu.be/WzCJlHbnzJg

I think more people should learn SQLite.

In the next version of Bun

bun:sqlite supports `using` to automatically close database connections & finalize statements

This post by 🍻Meet Stephen in 🇧🇬Sofia Th 25.04—Sun 28.04 on sqlite performance in Rails apps is just terrific:

fractaledmind.github.io/2024/04/15/sql…

The change to retry timing he mentions is in the new 2.0 release of the sqlite3 gem!

#ruby #rails #sqlite

Wish you could use #Forms with #SQLite and without relying on ODBC or #JDBC ? Wish granted. bit.ly/49Etc6J

👀iLEAPP TSV reports & EZ Tools Timeline Explorer are game changers when analyzing 📸 iOS Photos.sqlite!!