/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
| | nick.zoic.org

[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.
15.1 parsecs

Travel
| |
| | parvu.org

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.
15.1 parsecs

Travel
| |
| | antzucaro.com

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.
13.6 parsecs

Travel
| |
| | remy.wang


44.3 parsecs

Travel
|