databases.md

Databases

• Build Your Own X From Scratch Books

  • database book_done

• how query engines work

  • Good description of query (loads of step by step detail)
    • Like average over a dataset etc

• [sql]

  • [sqlite]

• [nosql]

• Vector Database's

  • A Gentle Introduction to Vector Databases
    • Float for how related two items are

• Stackoverflow: How does database indexing work?

https://www.prisma.io/blog/comparison-of-database-models-1iz9u29nwn37

• 42 things I learned from building a production database

Just use memory?

Redis? 200ms loss Mongo(ohno)db My(els)SQL -> MariaDB Elastic Search (stemming -> plurals) File system S3?

Relication (cascade)

Test your backups

[postgresql]

in browser

• drawsql.app ER diagrams of open source projects

Activity Idea

generate SQL database relations and data based off a student name hash. Ask questions (with known results) Mark SQL compitence (no cheating)

• geocode-sqlite - Geocode rows in a SQLite database table
  • take address and use web api to get lat/lon

Immutable - Zero Trust

• immudb

Object Relational Model (ORM) #orm

• prisma.io
  • Next-generation Node.js and TypeScript ORM
  • Prisma helps app developers build faster and make fewer errors with an open source database toolkit for PostgreSQL, MySQL and SQLite.

Moving away from database api to data layer

[nosql]

• NoneSQL, All the DevEx

  • Most products today are database focused
  • Database internals will eventually just not matter
  • Moving towards [developer-experience]
    • Migrations
    • Version control (for data)
    • user management

• fauna.com

  • The data API for modern applications
  • Fauna is a flexible, developer-friendly, transactional database delivered as a secure and scalable cloud API with native GraphQL. Never again worry about database provisioning, scaling, sharding, replication, or correctness.
  • Think data, not database operations

---

• Joins 13 Ways
  • 13 different conceptual understandings of a JOIN in sql
  • A join is a nested loop over rows
  • A join is a lookup
  • A join is flatMap
  • A join is the solution to the N+1 problem
  • A join is paths through a graph
  • A join is typechecking