6 articles tagged #PostgreSQL
Your partial index exists, VACUUM has run, and EXPLAIN still shows a sequential scan. The culprit is almost always a type mismatch between your query's WHERE clause and the index predicate. Here's how to diagnose and fix it fast.
Choosing between PlanetScale and Xata isn't just about pricing. While both target modern cloud applications, they solve different problems with different database architectures. Learn how they compare in branching workflows, free tiers, query performance, scalability, developer experience
Bulk inserts combined with PostgreSQL's ON CONFLICT DO NOTHING can dramatically improve performance and simplify deduplication. However, many developers are surprised when rows silently disappear during large imports. Learn why missing rows occur, how SQLAlchemy handles conflicts, and how to safely
Supabase and PlanetScale both promise hassle-free databases for production, but their free tiers, scaling ceilings, and operational quirks differ in ways that only show up when traffic spikes. Here's what we found after pushing both hard.
Your PostgreSQL queries were fast at 100k rows, but now that the table has crossed a million records, everything crawls. Here's exactly what's happening and how to fix it without rewriting your entire schema.
Managing databases remotely can significantly enhance your workflow, especially when working on applications or projects hosted online. Whether you're a developer, a data analyst, or a website administrator, gaining remote access to databases like PostgreSQL or MySQL through cPanel opens the door