Answers questions on SQL from the Wikibooks Structured Query Language: SELECT, joins, grouping, subqueries, INSERT and UPDATE, data types, indexes and window functions, citing Wikibooks (CC BY-SA 4.0).
“| Database Management Systems (DBMS) | Structured Query Language **Relational DBMS (rDBMS)** | SQL: A Language for Working with rDBMS |”
Answers questions on PostgreSQL from its official tutorial: creating databases and tables, queries, joins, aggregates, views, foreign keys, transactions and window functions, citing postgresql.org documentation (PostgreSQL Licence).
“| 1.4. Accessing a Database | | Prev | Up | Chapter 1. Getting Started | Home | Next |”
Answers questions on Supabase Postgres, Auth, Storage, Realtime and Edge Functions, citing the exact file in the public docs of the GitHub repo supabase/supabase (Apache-2.0). Not an official Supabase product.
Answers questions on IndexedDB from MDN: opening a database, object stores, transactions, indexes, cursors and versioning, citing MDN Web Docs by Mozilla contributors (CC BY-SA 2.5).
Answers questions on Go from the go.dev documentation: Effective Go, the tutorials, modules, database access, the FAQ, generics and the garbage collector, citing go.dev (CC BY 4.0).
Answers questions on the Bun runtime, package manager, test runner and bundler, citing the exact file in the public docs of the GitHub repo oven-sh/bun (MIT). Not an official Bun product.
Answers questions on Drizzle ORM schemas, queries, relations, migrations and connections, citing the exact file in the public docs of the GitHub repo drizzle-team/drizzle-orm-docs (CC BY 4.0). Not an official Drizzle ORM product.
Answers questions on PHP from the Wikibooks PHP Programming: syntax, arrays, functions, sessions and cookies, databases with PDO, classes and security, citing Wikibooks (CC BY-SA 4.0).
“### Databases On Microsoft Windows you must always install your own database. Some popular choices are the open source Postgres, SQLite, and MySQL. Postgres and…”
Answers questions on Cloudflare Workers: runtime APIs, Wrangler, bindings and deployment, citing the exact file in the public docs of the GitHub repo cloudflare/cloudflare-docs (CC BY 4.0). Not an official Cloudflare product.
“## Databases Specify D1 Databases to add to your environment as follows: ```js const mf = new Miniflare({ d1Databases: { DB: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx…”
Answers questions on designing large-scale systems: scalability, caching, databases, load balancing and queues, citing Donne Martin's System Design Primer in the GitHub repo donnemartin/system-design-primer (CC BY 4.0).
“### Relational database management system (RDBMS) A relational database like SQL is a collection of data items organized in tables. **ACID** is a set of propert…”