37
304 269

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.

มุมมอง: 708

วีดีโอ

41:32

AutoVacuum - Tuning and Monitoring

มุมมอง 4.6K5 ปีที่แล้ว

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

มุมมอง 10K5 ปีที่แล้ว

Postgres database versioning and schema migration with Git and Flyway

Effectively securing your PostgreSQL database

40:23

Effectively securing your PostgreSQL database

มุมมอง 9K5 ปีที่แล้ว

Effectively securing your PostgreSQL database

42:36

Hacking with Postgres 11 - pg_threads

มุมมอง 8745 ปีที่แล้ว

Hacking with Postgres 11 - pg_threads

31:15

Is JSONB a Silver Bullet

มุมมอง 1.9K5 ปีที่แล้ว

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)

มุมมอง 4605 ปีที่แล้ว

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

มุมมอง 8K5 ปีที่แล้ว

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

มุมมอง 26K5 ปีที่แล้ว

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.2K5 ปีที่แล้ว

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.1K5 ปีที่แล้ว

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?

มุมมอง 3K5 ปีที่แล้ว

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

มุมมอง 2625 ปีที่แล้ว

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.9K5 ปีที่แล้ว

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

มุมมอง 11K5 ปีที่แล้ว

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

มุมมอง 10K5 ปีที่แล้ว

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

มุมมอง 58K5 ปีที่แล้ว

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.1K5 ปีที่แล้ว

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