/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 buttondown.com
Integrity Constraints and the Relational Derivative Buttondown
| | stribny.name
Scaling relational SQL databases
14.6 parsecs away

Travel
| | A list of things that we can do when we need to scale a SQL database.
| | parvu.org
Oracle Database: Constraints Tutorial - Est. 2016
15.1 parsecs away

Travel
| | This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai.
| | hashrocket.com
PostgreSQL 18 - Temporal Constraints | Hashrocket
5.2 parsecs away

Travel
| | PostgreSQL 18 introduced a powerful new feature that lets you enforce uniqueness across time periods: Temporal Constraints. With this addition, you can now define UNIQUE, PRIMARY KEY, or FOREIGN KEY constraints by either Date Range or Timestamp Range fields, making it easier than ever to prevent overlapping data.
| | muratbuffalo.blogspot.com
Use of Time in Distributed Databases (part 4): Synchronized clocks in production databases
39.1 parsecs away

Travel
| This is part 4 of our "Use of Time in Distributed Databases" series . In this post, we explore how synchronized physical clocks enhance prod...