Sources

Sources

This Knowledge Pack is grounded in the following authoritative, primary sources for databases and SQL. Each is the official documentation, standard, or canonical reference for the claims made in the pack. Upstream sources retain their own licenses; verify critical, version-specific details against the primary documentation before relying on them in production.

Standards and specifications

  • ISO/IEC 9075 (SQL standard), overview - https://www.iso.org/standard/76583.html
  • ISO 8601 date and time format - https://www.iso.org/iso-8601-date-and-time-format.html
  • RFC 9562, Universally Unique IDentifiers (UUIDs) - https://www.rfc-editor.org/rfc/rfc9562.html
  • Jakarta Persistence 3.1 specification (JPA) - https://jakarta.ee/specifications/persistence/3.1/

Official database documentation

  • PostgreSQL 16 documentation - https://www.postgresql.org/docs/16/index.html
  • PostgreSQL transaction isolation - https://www.postgresql.org/docs/16/transaction-iso.html
  • PostgreSQL indexes - https://www.postgresql.org/docs/16/indexes.html
  • PostgreSQL EXPLAIN / using EXPLAIN - https://www.postgresql.org/docs/16/using-explain.html
  • PostgreSQL MVCC / concurrency control - https://www.postgresql.org/docs/16/mvcc.html
  • PostgreSQL Write-Ahead Logging (WAL) - https://www.postgresql.org/docs/16/wal-intro.html
  • MySQL 8.0 reference manual - https://dev.mysql.com/doc/refman/8.0/en/
  • MySQL InnoDB locking and transaction model - https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html
  • Microsoft SQL Server Transact-SQL reference - https://learn.microsoft.com/en-us/sql/t-sql/language-reference
  • Oracle Database SQL Language Reference (23ai) - https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/index.html
  • SQLite documentation - https://www.sqlite.org/docs.html

Extensions, tools, and references

  • pgvector (vector similarity search for PostgreSQL) - https://github.com/pgvector/pgvector
  • Hibernate ORM 6.6 user guide - https://docs.jboss.org/hibernate/orm/6.6/userguide/html_single/Hibernate_User_Guide.html
  • Prisma ORM documentation - https://www.prisma.io/docs
  • HikariCP (JDBC connection pool) - https://github.com/brettwooldridge/HikariCP
  • Use The Index, Luke! (SQL indexing and tuning) - https://use-the-index-luke.com/

Foundational papers

  • E. F. Codd, "A Relational Model of Data for Large Shared Data Banks" (1970) - https://dl.acm.org/doi/10.1145/362384.362685
  • Eric Brewer / CAP theorem (Martin Fowler's summary) - https://martinfowler.com/bliki/CAP.html