Explore >> Select a destination
|
You are here 
|
martinheinz.dev | ||
| | | | |
schinckel.net
|
|
| | | | | ||
| | | | |
andreabergia.com
|
|
| | | | | 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. | |
| | | | |
dylanpaulus.com
|
|
| | | | | PostgreSQL (Postgres), is a powerful relational database that can store a wide range of data types and data structures. When it comes to storing graph data structures we might reach for a database marketed for that use case like Neo4J or Dgraph. Hold your horses! While Postgres is not generally thou... | |
| | | | |
sigpwned.com
|
|
| | | The excellent PostgreSQL database supports the following syntax for the common upsert SQL pattern: INSERT INTO table(id, column1, column2) VALUES (@id, @value1, @value2) ON CONFLICT (id) DO UPDATE SET column1=EXCLUDED.value1, column2=EXCLUDED.value2 RETURNING * With this syntax, you can insert a new row with the given values, or update the existing row to the given values, | ||
