Skip to content
KG.
  • Blog
  • Hire me, or see what I ship.

    • ProjectsCase studies & shipped work
    • ServicesWork with me
    • SponsorSponsor the blog
  • Essays and references on AI engineering.

    • BlogEssays on AI engineering
    • Learning PathsGuided curricula
    • Topic PillarsDeep-dive hubs
    • GlossaryAI & dev terms, defined
    • CheatsheetsQuick references
    • ComparisonsX vs Y, decided
  • Things to click, play, and take apart.

    • Tools29 dev & AI utilities
    • Games16 browser games
    • DemosInteractive explainers
    • ChallengesDaily coding puzzles
  • Me

    • AboutWho I am
    • UsesMy gear & setup
    • ResumeCV (PDF)

    Shelf

    • BookshelfBooks I recommend
    • Reading ListWhat I'm reading
  • Subscribe
  • Let's talk
  1. Home
  2. ›
  3. Blog
  4. ›
  5. Database Performance

Database Performance

2 posts tagged #database-performance

SQLite vs PostgreSQL 2026: Which DB Wins for App Backends? Developer Tools

SQLite vs PostgreSQL for App Backends: When to Use Each

I'd pick SQLite for single-server apps under ~10k daily active users and PostgreSQL the moment you need concurrent writes, multi-node deployments, or a team larger than one. The fault line isn't size — it's concurrency and operational complexity.

July 11, 2026 11 min read
Read more
postgresql database server terminal linux — illustration for article on PostgreSQL Performance Halved on Linux Kernel Technology

PostgreSQL and THP on Linux Kernel 6.8: Diagnose and Fix

Transparent Huge Pages set to always can stall PostgreSQL backends during memory compaction. How to check THP and mTHP on Linux Kernel 6.8, fix them, and make the fix survive reboots.

April 5, 2026 14 min read
Read more

Keep exploring

Close to this topic, not on this page.

  • MongoDB vs PostgreSQL: Which Database Wins? I'd pick MongoDB for rapidly evolving document-heavy workloads and PostgreSQL for anything that touches relational integrity, analytics… 11 min read
  • PostgreSQL vs MySQL: Which to Pick for New Projects PostgreSQL 18 (September 2025) and MySQL 9.7 (2026) both added AI-native features, but DB-Engines data shows only one database is still… 13 min read
  • Ubuntu Sudo Password Asterisks: Why 26.04 Ended the Silence Ubuntu 26.04 LTS shows sudo password asterisks by default, breaking a 46-year Unix tradition. 7 min read

Content

  • Blog
  • Topic Pillars
  • Learning Paths
  • Games
  • Demos

Resources

  • Tools
  • Glossary
  • Cheatsheets
  • Comparisons
  • LLM Prices
  • Embedding Prices

About Me

  • About
  • Uses
  • Bookshelf
  • Reading List

Meta

  • Subscribe
  • Changelog
  • Sitemap
  • Privacy
  • Terms
  • RSS
KG

Building intelligent systems. Still chasing those sour icecreams.

Made with coffee and curiosity in Toronto. 2026.