Why AI Agents Make Me Reach for SQLite
Lately I keep reaching for SQLite where, before, I'd have reached for Postgres without thinking. It started with small services, then a bigger questio…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
softwareengineering
tutorial
typescript
webdev
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into SQ…
Expanding the Sovereign AI Stack: Moving the Specification from Gateway to Local Silicon
When I first introduced the Sovereign Systems Specification and released the initial foundation of the SDK, sovereign-core and its accompanying sovere…
Metering a Paid API Without Overselling: the Credit Ledger Behind a Solo SaaS
I charge per invoice extracted. One upload of a five-invoice PDF should cost five credits, a failed extraction should cost nothing, and a user with on…
SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests
Running SQLite in production for a multi-tenant SaaS means giving up the operational comfort of a managed database. No automatic backups, no point-in-…
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's Highlights Today's highlights include critical insights into Patroni's repli…
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data Today's Highlights Today's highlights include DuckDB's innovative data inlinin…
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug
SQLite ON CONFLICT DO SELECT Proposal, PostgreSQL 19 Features & SQLite Critical Bug Today's Highlights This week in databases, a proposal seeks to…
Why SQLite FTS5's default tokenizer drops your Japanese substrings (and the one-line fix)
If you're building any kind of personal-memory layer on top of SQLite — Claude Code conversation history, notes app, indexed knowledge base — there's …
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem Today's Highlights This week's highlights include DuckDB's new Duc…
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning Today's Highlights This week's database news highlights significant advan…
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s Today's Highlights This week, DuckDB introduces integrated vector and hybri…
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture Today's Highlights This week, we explore SQLite's query planner o…
Building an Event Sourced Video Moderation Audit Log with PHP and SQLite
The 3am call from a Japanese rightsholder Last quarter a Japanese label sent a takedown notice for fourteen music videos we'd been aggregating across …
Как фронтендер из Bay Area, который почти не пишет код руками, сделал на Rust трекер расходов для ИИ-агентов — и зачем
Я фронтенд-разработчик. Работаю в Bay Area, в компании, которая выдаёт всем инженерам корпоративные подписки на Claude Code и Cursor. То есть лично из…
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns Today's Highlights PostgreSQL 19 introduces major features with SQL/PGQ for gra…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning Today's Highlights Today's highlights include DuckDB's enhanced Iceberg i…
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's Highlights This week, we dive into a critical SQLite predicate evaluation b…
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's Highlights This week, we dive into SQLite's build process with SQLITE_DQ…
Эволюция Telegram‑бота на C++: от «лапши» в main() до ООП, in‑memory кэша и мутов по Фибоначчи
Привет, Хабр! В этой статье я расскажу об эволюции моего проекта — GroupModerBot , бота для модерации Telegram‑групп. Я покажу, ка…
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives Today's Highlights This week features significant advancements for DuckDB'…
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec Today's Highlights This week's highlights feature a practical checklist f…
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions Today's Highlights DuckDB announces its 1.5.2 patch release with perf…
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension Today's Highlights This week, DuckDB releases version 1.5.3 with the Quack c…
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations Today's Highlights This week's highlights include advanced SQL techniques …
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production Today's Highlights This week's highlights feature new PostgreSQL…
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity Today's Highlights This week features crucial insights into optimizing Du…
Making the Filing Cabinet Enterprise-Ready: Tricks to Scale with SQLite
In my previous article , we talked about why big databases (like Postgres or MySQL) act like a remote, slow mega-warehouse. Meanwhile, SQLite acts lik…
The Secret of the Small Database: Why "Big" Technology Often Slows You Down
Imagine you are running a business. You need to save and retrieve files every day. You have two choices: The Remote Mega-Warehouse: A massive, high-se…
PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization
PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization Today's Highlights This week's highlights feature a new mul…