Tag2 articles

PostgreSQL

Everything on CoreConcept tagged with PostgreSQL. Explore related tags below.

Articles

Database Indexing Explained: B-Trees, Composite Indexes, and Query Optimization

A query that takes 4 seconds without an index takes 0.2ms with one. That's a 20,000x improvement from a single line of SQL. Indexes are the most impactful perfo…

Jul 4, 202614 min read

Read

SQL NoSQL Database

SQL vs NoSQL: A Developer's Comparison

SQL and NoSQL are not opposites — they solve different data problems. SQL databases store data in normalized tables with strict schemas, ACID transactions, and …

Jul 4, 202611 min read

Read

Want a curated collection instead? Topic hubs group the best content by subject.

Browse Topics