Reading first few pages of `SQLite on Rails: The Workbook (beta)` from Stephen Margheim and already learned a lot of things:

- oha benchmarking tool
- RELAX_SSL=true env variable
- Write-Ahead Logging (WAL) mode
- IMMEDIATE TRANSACTION mode
- activerecord-enhancedsqlite3-adapter

今天在研究openai的function calling, 官方的cookbook给了一个神奇的text2sql的例子：
cookbook.openai.com/examples/how_t…

强烈墙裂推荐。
用的sqlite的db是这个sqlitetutorial.net/sqlite-sample-…

这个sqlite的教程网站也强烈推荐。
例如我们后端工程师日常比较熟悉MYSQL以及一些大数据库，sqlite3语法上还是很不同

SQLite: The Database Behind BILLIONS of Devices

If you've ever used a smartphone, browsed the web, or interacted with a digital device, chances are you've relied on SQLite.

SQLite is quietly powering our digital world. First released in 2000, this compact database engine is now

2,300 people on the list for the SQLite course! Y'all are awesome 😮‍💨

#每日推荐 一个数据可视化工具
适用于 SQLite 和 CSV 文件，支持数据导入导出、过滤、排序、格式转换等功能，离线运行在浏览器，完全免费，打开即用。

项目地址：github.com/lana-k/sqlitev…

Redka (Redis re-implemented with SQLite) is now functionally ready for 1.0. It implements strings, lists, sets, hashes, sorted sets, and also key management and transactions.

So now it's time for more testing, documentation, and — most exciting — trying Redka with

cloudflare worker 官方教程：使用 Cloudflare Workers 部署一个有状态 APP，教程包含：
- API、Workers KV、D1、SQLite、Prisma 的使用
- Workers 文档：developers.cloudflare.com/workers
- KV 文档: developers.cloudflare.com/kv
- D1 文档：developers.cloudflare.com/d1

youtube.com/watch?v=QTsaAh…

Yesterday I tweeted DHH and asked if we could talk about SQLite. To my surprise and delight, he said yes!

It's a fun conversation spanning SQLite, Campfire, the one-person framework, Stoicism, and their new ONCE product!

Click on the video to see the full discussion.

Justo lo que estaba buscando, un recurso que muestra cómo usar SQLite en producción: highperformancesqlite.com

Did you know you can use Outerbase SQLite with Astro?

Check out our ✨ new ✨ how-to guide, and you'll be up and running in minutes👇

outerba.se/astro

POV: you are 27 years old and missed the cutoff to be breathlessly analyzed by 40 year old elder millennial spinsters who think you're ngmi because you don't have a useless skill

SQLite 概ね理解した。

Observações finais:

- HTMX em prod
- SQLite em prod
- on-premises em prod

- dev manja menos que devia de infra

the first line of cocaine in the morning is one of my favorite things in life

Salah satu simple hands on project untuk course bunjs, elysiajs, htmx, sqlite.
toolhunt.bexlite.dev

Masih diskon 70%+ sampai tanggal 21.
bexlite.dev/course

u can just do things

THIS IS THE CODE OF ETHICS OF SQLITE
BASED

Our open contribution SQLite fork libSQL just crossed 8,000 stars on GitHub! If you haven't already ⭐️'ed it we'd love your support. Link in bio

I am joining the party with my little plain PHP todo app.
- 67 lines of code
- 0 frameworks
- 0 javascript
- 1 PHP file
- 1 SQLite
- 1 ☕️