/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
| | nick.zoic.org
MySQL: Foreign Keys between InnoDB and MyISAM · ... and another thing ...
15.1 parsecs away

Travel
| | [AI summary] The post explains the error caused by defining foreign keys between InnoDB and MyISAM tables in MySQL and MariaDB, offering a solution to migrate legacy tables to InnoDB.
| | 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.
| | antzucaro.com
Planning ahead for MySQL partitioning · Random Thoughts and Geekery
13.6 parsecs away

Travel
| | The Scenario Let's suppose you are modeling a database in MySQL 5.5. Based on your knowledge of the requirements for the application behind this database you can guess which of the tables within it are going to be huge. For those huge tables you want to plan ahead to make sure that you can scale out your data such that you have less headaches in the future. Here's the catch: you want to keep it simple until it comes time to scale out.
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
45.8 parsecs away

Travel
| The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....