Search: [SQL] - Anayrat links

Subtleties of time zone calculations in Postgres // CY Tech

PostgreSQL · time · SQL

December 28, 2018 at 14:40:30 GMT+1 * · permalink

https://tech.codeyellow.nl/blog/pg-timezones/

Importer OpenFoodFacts dans PostgreSQL

PostgreSQL · SQL · Opendata

December 21, 2018 at 14:38:04 GMT+1 * · permalink

http://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html

A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL" - Cybertec

PostgreSQL · NULL · SQL

December 21, 2018 at 12:31:03 GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/a-postgresql-story-about-null-is-null-null-and-not-null/

What the SQL?! JOIN me at UNION Station

SQL · PostgreSQL · UNION

December 14, 2018 at 10:28:36 GMT+1 * · permalink

https://ddrscott.github.io/blog/2018/join-me-at-union-station/

What the SQL?!? Recursive

PostgreSQL · SQL · CTE · RECURSIVE

December 14, 2018 at 10:28:11 GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-recursive/

What the SQL?!? WINDOW

SQL · PostgreSQL · Window_function

December 14, 2018 at 10:27:01 GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-window/

What the SQL?!? Lateral Joins

PostgreSQL · Lateral · SQL

December 14, 2018 at 10:26:23 GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-lateral/

Demi jointures - semi join

SQL · Postgis · Join

December 12, 2018 at 09:34:17 GMT+1 * · permalink

http://pgphil.ovh/semi_join_11_01.php

Pagination Done the PostgreSQL Way

PostgreSQL · SQL · pagination · offset

December 10, 2018 at 13:46:41 GMT+1 * · permalink

https://leopard.in.ua/2014/10/11/postgresql-paginattion#.XA5gDk6Z3mE

How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – Java, SQL and jOOQ.

PostgreSQL · SQL

November 20, 2018 at 10:17:59 GMT+1 * · permalink

https://blog.jooq.org/2018/11/16/how-to-aggregate-an-archive-logs-deltas-into-a-snapshot-with-sql/

PGDay UK 2016 -- Performace for queries with grouping

PostgreSQL · tuning · SQL · Hash · loose_index_scan

November 14, 2018 at 14:19:48 GMT+1 * · permalink

https://www.slideshare.net/AlexeyBashtanov/pgday-uk-2016-performace-for-queries-with-grouping

On the benefits of sorted paths |

PostgreSQL · SQL · tuning · Hash

November 14, 2018 at 14:07:40 GMT+1 * · permalink

https://blog.2ndquadrant.com/on-the-benefits-of-sorted-paths/

PG Conf europe - Data modeling

SQL · modelisation

October 29, 2018 at 12:58:30 GMT+1 * · permalink

https://tapoueh.org/images/confs/DataModeling.pdf

https://content.pivotal.io/white-papers/orca-a-modular-query-optimizer-architecture-for-big-data

not_read · planner · tuning · SQL · PostgreSQL

October 24, 2018 at 13:10:56 GMT+2 * · permalink

https://content.pivotal.io/white-papers/orca-a-modular-query-optimizer-architecture-for-big-data

Illuminated Computing | Postgres LATERAL JOIN

PostgreSQL · SQL · Lateral

October 22, 2018 at 19:04:21 GMT+2 * · permalink

https://illuminatedcomputing.com/posts/2015/02/postgres_lateral_join/

Illuminated Computing | Lateral Join Alternatives

PostgreSQL · SQL · Lateral

October 22, 2018 at 19:03:45 GMT+2 * · permalink

https://illuminatedcomputing.com/posts/2015/02/lateral_join_alternatives/

SELECT DISTINCT ON in PostgreSQL | Geeky Tidbits

PostgreSQL · SQL

October 1, 2018 at 21:10:17 GMT+2 * · permalink

https://www.geekytidbits.com/postgres-distinct-on/

Fetch First Rows Just Got Faster | Oracle Optimizer Blog

SQL · Oracle · limit

September 27, 2018 at 13:29:00 GMT+2 * · permalink

https://blogs.oracle.com/optimizer/fetch-first-rows-just-got-faster

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

PostgreSQL · SQL

September 26, 2018 at 18:01:41 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 GMT+2 * · permalink

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