Category:Database - Revision history

T1t0 at 17:02, 25 January 2020

2020-01-25T17:02:55Z

← Older revision		Revision as of 17:02, 25 January 2020
Line 1:		Line 1:
			= Databases =

	* [[postgresql\|PostgreSQL]] - ([http://www.postgresql.org/ PostgreSQL object-relational database system])		* [[postgresql\|PostgreSQL]] - ([http://www.postgresql.org/ PostgreSQL object-relational database system])
	* [[mysql\|MySQL]] - ([http://www.mysql.com/products/community/ MySQL Community Edition])		* [[mysql\|MySQL]] - ([http://www.mysql.com/products/community/ MySQL Community Edition])

T1t0 at 16:58, 25 January 2020

2020-01-25T16:58:14Z

← Older revision		Revision as of 16:58, 25 January 2020
Line 4:		Line 4:
	* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])		* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])

	= SQL =		= SQL (Structured Query Language) =

	* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]		* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]
Line 13:		Line 13:
	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]		* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]		* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]

	~~= Distributed Transactions =~~

	* [https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txns003.htm#ADMIN12222 Two-Phase Commit Mechanism - Oracle.com]

	== PostgreSQL specific isolation and locks ==		== PostgreSQL specific isolation and locks ==
Line 24:		Line 20:
	* https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES		* https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES
	* https://www.postgresql.org/docs/current/sql-lock.html		* https://www.postgresql.org/docs/current/sql-lock.html

			= Distributed Transactions =

			* [https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txns003.htm#ADMIN12222 Two-Phase Commit Mechanism - Oracle.com]

T1t0 at 16:45, 25 January 2020

2020-01-25T16:45:53Z

← Older revision		Revision as of 16:45, 25 January 2020
Line 13:		Line 13:
	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]		* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]		* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]

			= Distributed Transactions =

			* [https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txns003.htm#ADMIN12222 Two-Phase Commit Mechanism - Oracle.com]

	== PostgreSQL specific isolation and locks ==		== PostgreSQL specific isolation and locks ==

T1t0 at 16:02, 9 November 2019

2019-11-09T16:02:37Z

← Older revision		Revision as of 16:02, 9 November 2019
Line 13:		Line 13:
	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]		* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]		* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]

			== PostgreSQL specific isolation and locks ==

			* https://www.2ndquadrant.com/en/blog/postgresql-anti-patterns-read-modify-write-cycles/
			* https://www.postgresql.org/docs/9.5/transaction-iso.html
			* https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES
			* https://www.postgresql.org/docs/current/sql-lock.html

T1t0 at 16:02, 9 November 2019

2019-11-09T16:02:07Z

← Older revision		Revision as of 16:02, 9 November 2019
Line 13:		Line 13:
	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]		* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]		* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]

	~~== Postgresql ==~~

	* https://www.2ndquadrant.com/en/blog/postgresql-anti-patterns-read-modify-write-cycles/
	* https://www.postgresql.org/docs/9.5/transaction-iso.html
	* https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES
	* https://www.postgresql.org/docs/current/sql-lock.html

T1t0 at 16:01, 9 November 2019

2019-11-09T16:01:15Z

← Older revision		Revision as of 16:01, 9 November 2019
Line 4:		Line 4:
	* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])		* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])

	= ~~Links~~ =		= SQL =

	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]		* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]
	* [http://oreilly.com/catalog/sqlnut/chapter/ch04.html SQL in a Nutshell: Chapter 4: SQL Functions]		* [http://oreilly.com/catalog/sqlnut/chapter/ch04.html SQL in a Nutshell: Chapter 4: SQL Functions]

			= Isolation =

			* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
			* [https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html Practical Guide to SQL Transaction Isolation]

			== Postgresql ==

			* https://www.2ndquadrant.com/en/blog/postgresql-anti-patterns-read-modify-write-cycles/
			* https://www.postgresql.org/docs/9.5/transaction-iso.html
			* https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES
			* https://www.postgresql.org/docs/current/sql-lock.html

imported>T1t0 at 02:23, 2 July 2018

2018-07-02T02:23:58Z

← Older revision		Revision as of 02:23, 2 July 2018
Line 4:		Line 4:
	* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])		* [[firebird\|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])

	== Links ==		= Links =

	* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]		* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
	* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]		* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]
	* [http://oreilly.com/catalog/sqlnut/chapter/ch04.html SQL in a Nutshell: Chapter 4: SQL Functions]		* [http://oreilly.com/catalog/sqlnut/chapter/ch04.html SQL in a Nutshell: Chapter 4: SQL Functions]

imported>T1t0: Created page with "* PostgreSQL - ([http://www.postgresql.org/ PostgreSQL object-relational database system]) * MySQL - ([http://www.mysql.com/products/community/ MySQL ..."

2012-02-07T13:01:22Z

Created page with "* PostgreSQL - ([http://www.postgresql.org/ PostgreSQL object-relational database system]) * MySQL - ([http://www.mysql.com/products/community/ MySQL ..."

New page

* [[postgresql|PostgreSQL]] - ([http://www.postgresql.org/ PostgreSQL object-relational database system])
* [[mysql|MySQL]] - ([http://www.mysql.com/products/community/ MySQL Community Edition])
* [[sqlserver|SqlServer]] - ([http://www.microsoft.com/sqlserver/ Microsoft SQL Server])
* [[firebird|Firebird]] - ([http://www.firebirdsql.org/ Firebird - The RDBMS that's going where you're going])

== Links ==

* [http://en.wikipedia.org/wiki/Isolation_(computer_science) Isolation (database systems)]
* [http://www.1keydata.com/sql/sql.html SQL Query Reference and Programming Examples]
* [http://oreilly.com/catalog/sqlnut/chapter/ch04.html SQL in a Nutshell: Chapter 4: SQL Functions]