Explore >> Select a destination

You are here

 vladmihalcea.com
PostgreSQL FOR UPDATE vs FOR NO KEY UPDATE - Vlad Mihalcea
| | avestura.dev
Explaining The Postgres Meme
30.8 parsecs away

Travel
| | Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
| | pganalyze.com
Avoid Postgres performance cliffs with MultiXact IDs and foreign keys
12.9 parsecs away

Travel
| | We walk through problems you might encounter with MultiXact transaction IDs and give food for thought about when to us foreign keys in Postgres.
| | antonz.org
Upsert in SQL
15.3 parsecs away

Travel
| | Inserting and updating data with a single query.
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
54.8 parsecs away

Travel
| Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without.