Glossary / Data & databases

SQL vs NoSQL

SQL databases store data in related tables with a strict schema and shine at complex queries and transactions; NoSQL databases (documents, key-value) trade that rigor for flexibility and effortless horizontal scale. Neither is "better" — invoicing wants SQL's guarantees, a high-traffic session store wants NoSQL's speed. Serious systems often use both, each where it's strongest.