Skip to content

DEV Community

# sqlite

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Apr 14

I built a CMS that fits in one file — here's why and how

#astro #cms #sqlite #webdev

2 min read

soy

Apr 13

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies

#database #sql #sqlite

3 min read

dwighson Pavion

Apr 13

1.5M Events/sec on SQLite: What Happens When You Stop Fighting Shared State

#typescript #database #sqlite #eventsourcing

4 min read

soy

Apr 12

PostgreSQL Credential Rotation, pgvector HALFVEC, & SQLite Type Affinity

#database #sql #sqlite

3 min read

Labby for LabEx

Apr 12

5 SQLite Performance Hacks: From Index Optimization to Full-Text Search

#sqlite #database #sql #backend

2 min read

soy

Apr 11

PostgreSQL EXPLAIN ANALYZE Viewer, Checkpoints & SQLite JSON Parsing

#database #sql #sqlite

3 min read

soy

Apr 10

PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

#database #sql #sqlite

3 min read

Apr 9

5 boring patterns I used to ship two production services on a $5 VPS in 10 days

#python #webdev #sqlite #sysadmin

7 min read

soy

Apr 9

SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

#database #sql #sqlite

3 min read

soy

Apr 8

SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

#database #sql #sqlite

3 min read

Fex Beck

Apr 8

Why SQLite+FTS5 beats Vector DBs for AI Agent Memory

#sqlite #ai #vectordatabase #typescript

1 min read

Fex Beck

Apr 8

I built an AI memory that fact-checks itself while you sleep

#ai #sqlite #typescript #opensource

2 min read

D

Apr 8

[Side A] SQLite's Shared In-Memory DB Disappears — and `deserialize()` Won't Save You

#python #opensource #sqlite #devops

5 min read

Pavel

Apr 8

Which Database Should You Self-Host? SQLite vs MySQL vs PostgreSQL vs Redis

#postgres #mysql #sqlite #redis

3 min read

soy

Apr 6

SQLite Internals: Memory Leak, Security Vuln; PostgREST Goes Edge

#database #sql #sqlite

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.