— Change first word “SELECT” to “QLINE-SELECT” SELECT QLINE-SELECT — Axis X: — X – column name, axis: x1, x2, ..xn Value: Number — L – column name, axis: l Value: Text — T – column name, axis: t … Read more
A deep dive into how CRDT-powered local-first apps track, merge, and sync every INSERT, UPDATE, and DELETE inside SQLite. In my previous article, I provided a broad explanation of the algorithms that allow local-first applications to synchronize data correctly using … Read more
Detailed Schema Inspector Manage your database structure with Base’s schema inspector, making understanding your tables effortless. View table schemas, column types, constraints, and relationships at a glance. Understand your table design without digging through SQL.
This is a follow-up post to my PSA: SQLite does not do checksums and PSA: Most databases do not do checksums by default. In the previous posts I mentioned that SQLite does not do checksums by default, but it has … Read more
aiosqlitepool is a high-performance connection pool for asyncio SQLite applications. By managing a pool of reusable database connections, it eliminates connection overhead and delivers significant performance gains. Important: aiosqlitepool is not a SQLite database driver. It’s a performance-boosting layer that … Read more
The document describes default date and time functions in SQLite. This document is a supplement to the function documentation found on the SQL Expression Syntax page. Function Overview Five date and time functions are available, as follows: date( timestring, modifier, … Read more
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables. Now let’s dive into more advanced virtual-table implementations: those that support writes … Read more
A small GUI application built in redbean that lets you explore your SQLite databases “page by page” the way SQLite sees them. SQLite (and most databases) store data in disk-block-sized pages, usually 4KB, which helps make reads and writes as … Read more
sqlite/src/os.h at e8346d0a889c89ec8a78e65abc33257a6c6fb81a · sqlite/sqlite · GitHub {{ message }} Latest commit 225 lines (211 loc) · 9.17 KB You can’t perform that action at this time.