Outer Web | Explore

/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		antzucaro.com Planning ahead for MySQL partitioning · Random Thoughts and Geekery
\|	\|	buttondown.com Integrity Constraints and the Relational Derivative Buttondown	3.9 parsecs away Travel
\|	\|	In a SQL database, you can set up a foreign key with REFERENCES: nullbitmap=# CREATE TABLE ab (a INT PRIMARY KEY, b INT); CREATE TABLE nullbitmap=# INSERT...	3.9 parsecs away Travel
\|	\|	www.red-gate.com PostgreSQL Constraints: Learning PostgreSQL with Grant - Simple Talk	4.5 parsecs away Travel
\|	\|	One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data.	4.5 parsecs away Travel
\|	\|	nick.zoic.org MySQL: Foreign Keys between InnoDB and MyISAM · ... and another thing ...	2.8 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.	2.8 parsecs away Travel
\|	\|	tsqltuesday.azurewebsites.net T-SQL Tuesday #87 -Fixing Old Problems with Shiny New Toys - T-SQL Tuesday	26.7 parsecs away Travel
\|		[AI summary] This post invites readers to discuss how they have recently used new Microsoft data platform features like Azure, Power BI, and SQL Server 2016 to solve legacy database problems.	26.7 parsecs away Travel