Developer Articles | TechForDev

Latest AI / ML JavaScript Python React Next.js Web Dev DevOps Cloud

Building a zero-infra job queue with SQLite (and stress-testing it to 14 jobs/sec)

D_SECURITY5d ago • 4 min read

Building a zero-infra job queue with SQLite (and stress-testing it to 14 jobs/sec)

I needed to trigger automation scripts on an old Android phone from a cloud VPS, without opening...

#python#sqlite#architecture#opensource

1 1

SQLite as an offline metrics buffer in a monitoring agent

Alex Zhdankov1d ago • 6 min read

SQLite as an offline metrics buffer in a monitoring agent

Reliable monitoring becomes surprisingly hard once you assume the network will eventually...

#python#postgres#sqlite#devops

0 0

SQLite FTS5 won't tokenize Chinese — here's the 7-line bigram fix that did

foxck0160775d ago • 4 min read

SQLite FTS5 won't tokenize Chinese — here's the 7-line bigram fix that did

I shipped a personal RAG bot spike in 25 minutes. SQLite FTS5 with unicode61 returned 0 hits for eve...

#sqlite#search#ai#rag

0 1

DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions

soy5d ago • 4 min read

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 ...

#database#sql#sqlite

0 0

DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework

soy23h ago • 3 min read

DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework

DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework ...

#database#sql#sqlite

0 0

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

soy3d ago • 3 min read

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives ...

#database#sql#sqlite

0 0

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

soy4d ago • 3 min read

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec ...

#database#sql#sqlite

0 0

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

soy2d ago • 3 min read

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's...

#database#sql#sqlite

0 0

DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension

soy6d ago • 3 min read

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...

#database#sql#sqlite

0 0

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm

soy1d ago • 3 min read

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's...

#database#sql#sqlite

0 0

I Built a Brain Orchestrator for My 142 Agents. Here's the Bash It's Mostly Made Of.

guardlabs_team3d ago • 2 min read

I Built a Brain Orchestrator for My 142 Agents. Here's the Bash It's Mostly Made Of.

Postmortem & howto: ecosystem orchestrator на bash + SQLite + systemd timers без heavy framework.

#systemd#bash#sqlite#devops

0 0

Building a Video Deduplication Pipeline with Perceptual Hashing in Python

ahmet gedik3d ago • 10 min read

Building a Video Deduplication Pipeline with Perceptual Hashing in Python

Production pipeline for catching duplicate videos using pHash and dHash in Python, with FAISS-accele

#python#video#computervision#sqlite

0 0

Streaming Live Video View Counts with Server-Sent Events on PHP and LiteSpeed

ahmet gedik1d ago • 11 min read

Streaming Live Video View Counts with Server-Sent Events on PHP and LiteSpeed

Walk-through of streaming live video view counts using Server-Sent Events on PHP 8.4 and LiteSpeed,

#php#sse#sqlite#webdev

0 0

Tanay Kedia5d ago • 22 min read

Your ORM is the bottleneck

SQLite handles 88,000 writes per second on commodity hardware. My ORM caps at 3,800. PRAGMA tuning.....

#database#backend#sqlite#python

0 0

Tech Articles

Building a zero-infra job queue with SQLite (and stress-testing it to 14 jobs/sec)

SQLite as an offline metrics buffer in a monitoring agent

SQLite FTS5 won't tokenize Chinese — here's the 7-line bigram fix that did

DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions

DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm

I Built a Brain Orchestrator for My 142 Agents. Here's the Bash It's Mostly Made Of.

Building a Video Deduplication Pipeline with Perceptual Hashing in Python

Streaming Live Video View Counts with Server-Sent Events on PHP and LiteSpeed

Your ORM is the bottleneck