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		boringsql.com PostgreSQL MVCC, Byte by Byte \| boringSQL
\|	\|	hakibenita.com Row Locks With Joins Can Produce Surprising Results in PostgreSQL \| Haki Benita	5.5 parsecs away Travel
\|	\|	You execute a query that joins two tables with a valid an enforces foreign key and it returns no results. How is it possible? We thought it wasn't possible, but a recent incident revealed an edge case we never thought about. In this article I show how under some circumstances row locks with joins can produce surprising results, and suggest ways to prevent it.	5.5 parsecs away Travel
\|	\|	postgresql.verite.pro Isolation Repeatable Read in PostgreSQL versus MySQL	4.7 parsecs away Travel
\|	\|	To avoid having concurrent transactions interfere with each other,SQL engines implement isolation as a feature.This property corresponds to the I letter in t...	4.7 parsecs away Travel
\|	\|	www.cs.cmu.edu Yes, PostgreSQL Has Problems. But We're Sticking With It! // Blog // Andy Pavlo - Carnegie Mellon University	4.3 parsecs away Travel
\|	\|	Yes, PostgreSQL Has Problems. But We're Sticking With It!, Andy Pavlo - Carnegie Mellon University,	4.3 parsecs away Travel
\|	\|	leopard.in.ua World of the NoSQL databases	21.1 parsecs away Travel
\|			21.1 parsecs away Travel