Search: [SQL] - Anayrat links

Scalable incremental data aggregation on Postgres and Citus

PostgreSQL · sql · citus · Aggregate

June 14, 2018 at 9:52:50 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregation/

PostgreSQL 11: Instant add column with a non null default value - Blog dbi services

PostgreSQL · sql

June 6, 2018 at 12:12:50 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgresql-11-instant-add-column-with-a-non-null-default-value/

Pivots statiques et dynamiques

PostgreSQL · sql · plpgsql

June 4, 2018 at 9:41:37 AM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2018/06/02/crosstab-pivot.html

Standard SQL Gap Analysis

Features where PostgreSQL lags behind its competitors

PostgreSQL · sql

June 4, 2018 at 9:41:01 AM GMT+2 * · permalink

http://www.pgcon.org/2018/schedule/attachments/494_standard-sql-gap-analysis.pdf

PostgreSQL 11 : Procedures are coming - Blog dbi services

PostgreSQL · sql · plpgsql · procedure

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

https://blog.dbi-services.com/postgresql-11-procedures-are-coming/

Fun with SQL: Window functions in Postgres

PostgreSQL · Window_function · sql

June 4, 2018 at 9:39:51 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/01/fun-with-sql-window-functions-in-postgresql/

Volatilité - partie 2

PostgreSQL · sql

June 4, 2018 at 9:36:30 AM GMT+2 * · permalink

http://pgphil.ovh/volatility_11_beta_02.php

Volatilité - partie 1

PostgreSQL · sql

June 4, 2018 at 9:36:12 AM GMT+2 * · permalink

http://pgphil.ovh/volatility_10_01.php

Index skip scan | Oracle Scratchpad

Oracle · sql · skip · not_read

June 4, 2018 at 9:35:41 AM GMT+2 * · permalink

https://jonathanlewis.wordpress.com/category/oracle/indexing/index-skip-scan/

CREATE VIEW vs. ALTER TABLE in PostgreSQL - Cybertec

PostgreSQL · sql · view

June 1, 2018 at 10:35:21 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/create-view-vs-alter-table-in-postgresql/

PostgreSQL: Detecting periods of activity in a timeseries - Cybertec

Window_function · PostgreSQL · sql · TimeSeries

May 30, 2018 at 10:11:00 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-detecting-periods-of-activity-in-a-timeseries/

PostgreSQL Data Types

PostgreSQL · sql · types

May 24, 2018 at 11:01:21 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types/

Fun with SQL: Recursive CTEs in Postgres

PostgreSQL · CTE · sql · RECURSIVE

May 16, 2018 at 9:06:00 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/

Selecting all Columns Except One in PostgreSQL – Java, SQL and jOOQ.

PostgreSQL · sql

May 14, 2018 at 7:02:02 PM GMT+2 * · permalink

https://blog.jooq.org/2018/05/14/selecting-all-columns-except-one-in-postgresql/

The maze of the elephant

PostgreSQL · sql · constraint

May 9, 2018 at 2:04:06 PM GMT+2 * · permalink

http://www.pgdba.org/post/2018/05/dependency_maze/

PostgreSQL Data Types: Point

PostgreSQL · types · sql · GiST

May 7, 2018 at 2:25:06 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types-point/

avoid OR for better PostgreSQL query performance - Cybertec

PostgreSQL · sql

May 7, 2018 at 11:27:02 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/

Tech preview: PostgreSQL 11 - CREATE PROCEDURE - Cybertec

PostgreSQL · sql · plpgsql · procedure

April 30, 2018 at 4:42:01 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/tech-preview-postgresql-11-create-procedure/

How does Stack Overflow do pagination? - Meta Stack Overflow

sql · offset

April 27, 2018 at 5:49:03 PM GMT+2 * · permalink

https://meta.stackoverflow.com/questions/322164/how-does-stack-overflow-do-pagination

PostgresConf US 2018 - ANSI, Schmansi! How I learned to stop worrying and love Postgres-isms

PostgreSQL · sql

April 23, 2018 at 5:58:42 PM GMT+2 * · permalink

https://sehrope.github.io/postgres-conf-2018-ansi-schmansi/#/