37
303 072

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 тис.5 років тому

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 тис.5 років тому

Postgres database versioning and schema migration with Git and Flyway

Effectively securing your PostgreSQL database

40:23

Effectively securing your PostgreSQL database

Переглядів 9 тис.5 років тому

Effectively securing your PostgreSQL database

42:36

Hacking with Postgres 11 - pg_threads

Переглядів 8675 років тому

Hacking with Postgres 11 - pg_threads

31:15

Is JSONB a Silver Bullet

Переглядів 1,9 тис.5 років тому

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)

Переглядів 4595 років тому

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

Переглядів 1135 років тому

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 тис.5 років тому

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 тис.5 років тому

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,2 тис.5 років тому

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 тис.5 років тому

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 тис.5 років тому

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

Переглядів 2605 років тому

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,9 тис.5 років тому

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 тис.5 років тому

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 тис.5 років тому

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 тис.5 років тому

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,1 тис.5 років тому

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...