Видео 37
Просмотров 299 466

41:32

Postgres database versioning and schema migration with Git and Flyway

39:23

Effectively securing your PostgreSQL database

40:23

Hacking with Postgres 11 - pg_threads

42:36

Is JSONB a Silver Bullet

31:15

From models to hosted OpenAPI Specification (OAS)

40:31

Temporal Journey

Andrew Turpin
PostgresConf South Africa 2019
postgresconf.org/conferences/SouthAfrica2019/program/proposals/temporal-journey
This journey is an exploration of time range data using history tables in a scenario where micro-services utilising PostgreSQL databases rely on logical replication to publish to an eventually consistent canonical database.
The desired solution would allow for history tables to be automatically dealt with in the canonical database through temporal_tables & trigger magic and logical replication.

Видео

41:32

AutoVacuum - Tuning and Monitoring

Просмотров 4,6 тыс.4 года назад

AutoVacuum - Tuning and Monitoring

Postgres database versioning and schema migration with Git and Flyway

39:23

Postgres database versioning and schema migration with Git and Flyway

Просмотров 10 тыс.4 года назад

Postgres database versioning and schema migration with Git and Flyway

Effectively securing your PostgreSQL database

40:23

Effectively securing your PostgreSQL database

Просмотров 9 тыс.4 года назад

Effectively securing your PostgreSQL database

42:36

Hacking with Postgres 11 - pg_threads

Просмотров 8494 года назад

Hacking with Postgres 11 - pg_threads

31:15

Is JSONB a Silver Bullet

Просмотров 1,8 тыс.4 года назад

Angus Dippenaar PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/is-jsonb-a-silver-buttet I've seen many times people giving JSONB praise. But is it the silver bullet they make it out to be? I try to answer this question by taking some real-life data and testing how JSON(B) compares to tables in every-day database use-cases.

From models to hosted OpenAPI Specification (OAS)

40:31

From models to hosted OpenAPI Specification (OAS)

Просмотров 4534 года назад

Karel van der Walt PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/rapid-api-with-postgres-json-postgrest-swagger-nginx Translate a data model of a domain into a hosted, fully functional OpenAPI Specification (OAS) with minimal coding by integrating PostgreSQL with PostgREST and NGINX. This presentation goes beyond a trivial CRUD (Create/Read/Update...

41:34

Designing for Accessibility

Просмотров 1114 года назад

Rory Preddy PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/programming-for-accessibility Have you ever heard “You have to be this tall to operate a mobile phone?”. Programming for diversity serves as an unquestionable indicator that your software embraces and cares about your users’ safety and comfort. Join me on a thought-provoking look at how you...

34:31

Postgres Extensions

Просмотров 7 тыс.4 года назад

Andries Vorster PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/postgres-foreign-contribs-file_fdw-postgres_fdw Explanation of Extension Modules What are contrib modules and where can we find them ? List of contrib modules , a whole list of cool ready to install modules that would make your life easier. Installing Extensions

36:08

Basic understanding of EXPLAIN ANALYZE

Просмотров 26 тыс.4 года назад

Justin Harvey PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/basic-understanding-of-explain-analyze My talk is a beginners guide to using and understanding EXPLAIN ANALYZE. This will include understanding: -INDEX SCAN VS. BITMAP SCAN VS. SEQUENTIAL SCAN (BASICS) -B-tree vs GIN vs GiST vs SP-GiST vs BRIN vs HASH -Costs and actual times This is for u...

36:39

Event Stores and Postgres

Просмотров 2,1 тыс.4 года назад

Chris A. Pieterse PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/event-stores-and-postgres Event stores enable us to perceive other 'dimensions’ of data. Object oriented datastores run the risk of losing valuable state transition information. The CQRS design pattern distinguishes between mutable commands and immutable queries, allowing different da...

Tips and tricks for speeding up PostgreSQL in an automated testing environment

33:56

Tips and tricks for speeding up PostgreSQL in an automated testing environment

Просмотров 1,1 тыс.4 года назад

Bennie Swart PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/tips-and-tricks-for-speeding-up-postgresql-in-an-automated-testing-environment In an automated testing environment it is often a requirement to create a clean database for each group of tests, but creating and initializing new databases can be slow and resource intensive. In this talk we w...

What's all this fuss about Common Table Expressions (CTE's) anyway?

30:50

What's all this fuss about Common Table Expressions (CTE's) anyway?

Просмотров 3 тыс.4 года назад

Jacques Combrink PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/what-s-all-this-fuss-about-common-table-expressions-cte-s-anyway Introduction to CTE's. How they work, when to use them and why. Examples of use cases, and also some examples of when not to use CTE's.

Optimising full-text queries in the amaGama translation memory server

39:58

Optimising full-text queries in the amaGama translation memory server

Просмотров 2564 года назад

Friedel Wolff PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/optimising-full-text-queries-in-the-amagama-translation-memory-server The amaGama project implements a FOSS translation memory web service built with Python on top of PostgreSQL. I recently worked on improving its performance, and would like to report on what I did and how I did it. The p...

40:29

Shadow Tables vers PGAudit

Просмотров 1,8 тыс.4 года назад

Lloyd Albin PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/shadow-tables-vers-pgaudit-ec345306-7370-4c0b-8048-da43d0597c1f A shadow table is an table that is read and written by a trigger function and contains data similar to (in the same format as) its primary table, which is the table it's "shadowing" along with a few extra fields so that you can...

30:04

PL/pgSQL Control Structures

Просмотров 11 тыс.4 года назад

Andreas Nel PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/pl-pgsql-control-structures-an-introduction-827cd370-e760-44d5-9366-ce689ab353e9 PL/pgSQL is a language that allows developers to write stored procedures and functions in a procedural manner (instead of writing them in the declarative fashion of SQL) whilst still providing the speed benefit...

37:06

DBeaver

Просмотров 9 тыс.4 года назад

Nico Schlebusch PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/dbeaver-as-an-alternative-to-pgadmin-iii DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has a JDBC or ODBC driver. DBeaver provide some functionality that is really missing in pgAdmin in my opinio...

32:39

PostgreSQL performance in 5 minutes

Просмотров 58 тыс.4 года назад

Hans-Jürgen Schönig PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/postgresql-performance-in-5-minutes Are you suffering from bad performance? Is your database slow and does not satisfy your needs? In this case you should consider using a standard approach to improving performance. During this talk you will learn how to tune your database, detect b...

PostgreSQL/PostGIS devops with Docker and Rancher

35:53

PostgreSQL/PostGIS devops with Docker and Rancher

Просмотров 2 тыс.4 года назад

Gavin Fleming PostgresConf South Africa 2019 postgresconf.org/conferences/SouthAfrica2019/program/proposals/postgresql-postgis-devops-with-docker-and-rancher Kartoza is a South African company with a global footprint. We specialise in geospatial solutions with FOSS, which means we use PostGIS a lot. We deploy, host and support many instance of PostGIS for many clients in support of many differe...