Study Guide 2023+

nosql

Warning: These notes are partial, ongoing, incomplete, and may contain typos/inaccuracies. (They are kept factually accurate, time permitting.)

They are being united from many disparate notes created in the past and the layout/organization will gradually improve with time!

Please view them on a computer as they are not optimized for mobile (although you can still view them on Mobile along with the Flashcards at your own risk)!

Topics and code examples are lazy-loaded and may require two-clicks from the TOC to correctly calculate the updated x,y coordinates (after rendering). Thanks!

NoSQL: Overview

Generally favors:

  1. Documents vs. Rows
  2. Collections vs. Columns
  3. Non-rectangular data with flexible schemas
  4. Aggregation and flat denormalization
  5. Enhanced support for Many-to-Many and Graph Relational data
  6. DBRefs vs. Foreign Keys

Many Relational SQL Databases have gradually added support for the above through:

  1. Graph semantics
  2. JSONB, JSONP, etc. Column Types
  3. JSON Query Interpolation (Postgres)
  1. DynamoDB
  2. https://www.mongodb.com/docs/drivers/
  3. https://www.mongodb.com/docs/manual/core/aggregation-pipeline/
  4. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/programming-with-javascript.html
  5. Postgres JSON

Code samples:

  1. https://github.com/Thoughtscript/java_spring_graph_2025
  2. https://github.com/Thoughtscript/rust_go_fun_2024
  3. https://github.com/Thoughtscript/mearn_2024
  4. https://github.com/Thoughtscript/mean_2023
  5. https://github.com/Thoughtscript/spring_2023