Search: [SQL] - Anayrat links

PostgreSQL Data Types: Arrays

PostgreSQL · Array · sql

April 20, 2018 at 16:23:12 GMT+2 * · permalink

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

PostgreSQL Data Types: Date and Time Processing

PostgreSQL · sql · types · time

April 18, 2018 at 12:08:59 GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-date-and-time-processing/

PostgreSQL Data Types: Date, Timestamp, and Time Zones

PostgreSQL · sql · types · time

April 18, 2018 at 11:23:39 GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-date-timestamp-and-time-zones/

PostgreSQL Data Types: Text Processing

PostgreSQL · sql · types

April 12, 2018 at 21:56:12 GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-text-processing/

Chasser les requêtes N+1 avec Bullet

sql · Performance

April 7, 2018 at 11:20:20 GMT+2 * · permalink

https://www.synbioz.com/blog/chasser_les_requetes_n+1_avec_bullet

PostgreSQL Data Types: an intro

sql · PostgreSQL · types

April 7, 2018 at 11:19:38 GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-an-intro/

Advanced SQL: Why first_value and last_value are no bugs - Cybertec

PostgreSQL · sql · Window_function

April 2, 2018 at 18:10:50 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/advanced-sql-why-first_value-and-last_value-are-no-bugs/

When you execute the same statement thousands of times -> prepare it - Blog dbi services

PostgreSQL · prepare · sql · oltp · Performance

March 26, 2018 at 15:38:48 GMT+2 * · permalink

https://blog.dbi-services.com/when-you-execute-the-same-statement-thousands-of-times-prepare-it/

Object Relational Database Management System

PostgreSQL · sql

March 24, 2018 at 15:54:17 GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/object-relational-database-management-system/

Data Modeling, Normalization and Denormalization

PostgreSQL · normalisation · sql

March 20, 2018 at 14:26:18 GMT+1 * · permalink

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

PostgreSQL Query optimization, step by step

PostgreSQL · optimizer · Performance · sql · CTE · RECURSIVE · index · loose_index_scan

March 20, 2018 at 14:18:54 GMT+1 * · permalink

https://www.postgresql.eu/events/nordicpgday2018/sessions/session/1858/slides/68/query-optimization-techniques_talk.pdf

Database constraints in Postgres: The last line of defense

PostgreSQL · constraint · sql

March 19, 2018 at 18:37:20 GMT+1 * · permalink

https://www.citusdata.com/blog/2018/03/19/postgres-database-constraints/

Introduction [La théorie de la normalisation relationnelle]

sql · normalisation · not_read

March 19, 2018 at 15:52:55 GMT+1 * · permalink

https://stph.scenari-community.org/bdd/nor1-lin/co/nor_1.html

PostgreSQL: Speeding up analytics and windowing functions

PostgreSQL · optimizer · Window_function · Performance · sql

March 19, 2018 at 13:16:19 GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-speeding-up-analytics-and-windowing-functions/

Repeatable Read Is Not Repeatable – Database Journal Club – Medium

PostgreSQL · Isolation · sql

March 17, 2018 at 17:01:40 GMT+1 * · permalink

https://medium.com/db-journal/repeatable-read-is-not-repeatable-c700b2ce1c76

Database Normalization and Primary Keys

PostgreSQL · sql · normalisation

March 10, 2018 at 10:47:08 GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/database-normalization-and-primary-keys/

Database Modelization Anti-Patterns

PostgreSQL · sql · normalisation

March 10, 2018 at 10:46:45 GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/

New features for sequences: gains and pitfalls - Cybertec

PostgreSQL · sequence · sql

February 26, 2018 at 13:51:36 GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/sequences-gains-and-pitfalls/

Database migrations and Pum

PostgreSQL · sql

February 23, 2018 at 14:00:16 GMT+1 * · permalink

http://oslandia.com/en/2018/02/23/database-migrations-and-pum/

Range Types & Recursion: How to Search Availability with PostgreSQL

PostgreSQL · sql · range · CTE · RECURSIVE · not_read

February 22, 2018 at 19:22:39 GMT+1 * · permalink

http://info.crunchydata.com/blog/range-types-recursion-how-to-search-availability-with-postgresql