knightly the Sneptaur

  • 1 Post
  • 471 Comments
Joined 2 years ago
cake
Cake day: July 5th, 2023

help-circle















  • To oversimplify, there are two basic kinds of databases: SQL (Structured Query Language, usually pronounced like “sequel” or spelled aloud) and noSQL (“Not Only SQL”).

    SQL databases work as you’d imagine, with tables of rows and columns like a spreadsheet that are structured according to a fixed schema.

    NoSQL includes all other forms of databases, document-based, graph-based, key-value pairs, etc.

    The former are highly consistent and efficient at processing complicated queries or recording transactions, while the latter are more flexible and can be very fast at reads/writes but are harder to keep in sync as a result.

    All large orgs will have both types in use for different purposes; SQL is better for banking needs where provable consistency is paramount, NoSQL better for real-time web apps and big data processing that need minimal response times and scalable capacity.

    That Musk would claim the government doesn’t use SQL immediately betrays him as someone who is entirely unfamiliar with database administration, because SQL is everywhere.