Search: [SQL] - Anayrat links

How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently – Java, SQL and jOOQ.

PostgreSQL · SQL

September 26, 2018 at 6:01:41 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/26/how-to-use-sql-update-returning-to-run-dml-more-efficiently/

How to Write a Multiplication Aggregate Function in SQL – Java, SQL and jOOQ.

PostgreSQL · Aggregate · SQL

September 21, 2018 at 12:30:17 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/21/how-to-write-a-multiplication-aggregate-function-in-sql/

How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – Java, SQL and jOOQ.

PostgreSQL · Window_function · SQL

September 20, 2018 at 5:43:08 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/20/how-to-reduce-syntactic-overhead-using-the-sql-window-clause/

Jef Claes: Amazon Redshift - Fundamentals

Redshift · SQL · AWS

September 12, 2018 at 9:48:36 AM GMT+2 * · permalink

https://www.jefclaes.be/2018/05/amazon-redshift-fundamentals.html

Find the Next Non-NULL Row in a Series With SQL – Java, SQL and jOOQ.

PostgreSQL · sql · Window_function

September 4, 2018 at 7:31:03 PM GMT+2 * · permalink

https://blog.jooq.org/2018/09/03/find-the-next-non-null-row-in-a-series-with-sql/

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Three - CrateDB

Performance · sql

August 30, 2018 at 4:29:22 PM GMT+2 * · permalink

https://crate.io/a/lab-notes-how-we-made-joins-23-thousand-times-faster-part-three/

Preventing SQL Injections

PostgreSQL · sql · Security

August 30, 2018 at 9:58:09 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/08/preventing-sql-injections/

A Missing Link in Postgres 11: Fast Column Creation with Defaults — Brandur Leach

PostgreSQL · sql · constraint · schema_migration

August 30, 2018 at 9:57:46 AM GMT+2 * · permalink

https://brandur.org/postgres-default

Transactional Data Operations in PostgreSQL Using Common Table Expressions – Rob Conery

sql · PostgreSQL · CTE

August 14, 2018 at 4:57:51 PM GMT+2 * · permalink

https://rob.conery.io/2018/08/13/transactional-data-operations-in-postgresql-using-common-table-expressions/

SQL STANDARDS UPDATE

sql

August 4, 2018 at 12:09:35 PM GMT+2 * · permalink

https://s3.amazonaws.com/artifacts.opencypher.org/website/materials/SQLStandards_2017-10-20.pdf

Simplifying Recursive SQL Queries

PostgreSQL · sql · CTE · RECURSIVE

August 4, 2018 at 12:09:16 PM GMT+2 * · permalink

https://haughtcodeworks.com/blog/software-development/recursive-sql-queries-using-ctes/

Ask TOM "IN & EXISTS"

can you give me some example at which situation
IN is better than exist, and vice versa.

sql

July 18, 2018 at 9:47:48 PM GMT+2 * · permalink

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:953229842074

How SQL DISTINCT and ORDER BY are Related – Java, SQL and jOOQ.

PostgreSQL · sql

July 17, 2018 at 12:34:10 PM GMT+2 * · permalink

https://blog.jooq.org/2018/07/13/how-sql-distinct-and-order-by-are-related/

Range Types: Your Life Will Never Be The Same

PostgreSQL · sql · range

July 11, 2018 at 12:47:00 PM GMT+2 * · permalink

https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf

Efficient Processing of Window Functions in Analytical SQL Queries

sql · Window_function · not_read · PostgreSQL

July 10, 2018 at 11:53:17 PM GMT+2 * · permalink

http://www.vldb.org/pvldb/vol8/p1058-leis.pdf

How to store dates and times in PostgreSQL? – The system is the asset, code a liability – Medium

PostgreSQL · sql · time

July 9, 2018 at 6:31:05 PM GMT+2 * · permalink

https://medium.com/system-is-asset-code-is-liability/how-to-store-dates-and-times-in-postgresql-269bda8d6403

PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses – Java, SQL and jOOQ.

sql · PostgreSQL · Window_function

July 5, 2018 at 5:37:25 PM GMT+2 * · permalink

https://blog.jooq.org/2018/07/05/postgresql-11s-support-for-sql-standard-groups-and-exclude-window-function-clauses/

Introduction to Data Vault Modeling

modelisation · sql · data_vault · not_read

June 29, 2018 at 10:39:49 AM GMT+2 * · permalink

https://fr.slideshare.net/kgraziano/introduction-to-data-vault-modeling

PostgreSQL Concurrency: Data Modification Language

PostgreSQL · sql

June 26, 2018 at 9:40:26 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/06/postgresql-concurrency-data-modification-language/

Fun with SQL: Functions in Postgres

PostgreSQL · sql

June 22, 2018 at 8:20:01 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/