Skip to main content

Database ↔ Organized collection of data, to access/store digitally

aka DB

Relational DB​

Database with Serialized data with each row map to UID Primary Key, with Join Table related by Foreign Key

SQL​

DSL to manage structured data in Relational DB

prisma​

ORM with Node.js + TS to data model, with UI to view/mod db

Source: www.prisma.io/

NoSQL​

Non-relational non-SQL database of field-value pair data structure

NewSQL​

subset of RDBMS to add scalability to NoSQL system

Computer Cluster​

group of Computer nodes LAN connect to compute load as single system

Cloud Storage​

Model of storing Computer Data across Pools

Redis​

free tier ONE DATABASE ONLY - max 256MB - 10K ops/d 1GB/m storage. INT: AWS GCP. INT fly.io free tier!

References​

  1. Relational DB ↔ Database with Serialized data with each row map to UID Primary Key, with Join Table related by Foreign Key

  2. SQL Injection ↔ exploit to execute naughty SQL code on DB - to spoof identity, access/destroy data

  3. UID ↔ Unique ID for DB entry || user

  4. Data Modelling ↔ (process) to transform raw unstructured data (from real-world scenario) into structured logical data model in DB

  5. structured ↔ organized into DB

  6. MongoDB ↔ BaaS NoSQL DB where each DB consists of 1+ Collection in BSON

  7. MongoDB CLI ↔ can CRUD on DB via CLI to create/query/update/delete docs from terminal - but maybe simpler to just use compass instead?!

  8. ORM ↔ (Design Pattern) data layer to abstract Backend Code from DB

  9. Search Engine ↔ Software to search/query/sort/filter data from DB

  10. Back-end App (JS) ↔ App to execute Node.js Runtime with access to fs, DB and network servers

  11. Dynamic Content ↔ Data to generate/process on-the-fly (from DB )

  12. Content Repo ↔ DB to store/mod digital content, for search/serve, API to link CMS