Aug 19, 2020

An introduction to pgcrypto

Robert Bernier present "An introduction to pgcrypto"

This talk introduces you to one of the more important postgres security extensions "pg_crypto". We'll cover the more base functions, and how they can be used with some simple examples.

- General Hashing Functions
- Password Hashing Functions
- PGP Encryption Functions
- Raw Encryption Functions
- Random-Data Functions


Aug 19, 2020

Joining Heterogeneous Databases is a reality, not a Myth

Ibrar Ahmed present "Joining Heterogeneous Databases is a reality, not a Myth."

PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database.
The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of...


Aug 19, 2020

Elephant by the pool: PostgreSQL connection poolers overview

Sergey Kuzmichev and Jobin Augustine present "Elephant by the pool: PostgreSQL connection poolers overview."

"Everything comes at a cost, including opening and maintaining connections to the database. With PostgreSQL, this can be especially true. Using connection pooler is a known solution, but choosing one can be a daunting task. Especially, when a new one has just appeared to the party.

This talk covers:
* The general...


Aug 19, 2020

Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL

Avi Vallarapu present "Building an Enterprise Grade PostgreSQL using open source solutions"

"I migrated from a proprietary database software to PostgreSQL. I am curious to know whether I can get the same features I used to have in the proprietary database software". The market coined the term "enterprise grade" or "enterprise ready" to differentiate products and service offerings for licensed database software. For example: there...


Aug 5, 2020

Database Challenges: Open Source Vs. Open Core

Join Peter Zaitsev, CEO at Percona, as he discusses database challenges and the concepts of open source and open core. Over the years open source companies have tried to bring products to market and maximize their revenue streams. To date the most popular open source business model remains “Open Core”. But is open core software still open source? Or is it a freemium model designed to separate you from your money? Not all companies...

Open Source Database

Jul 27, 2020

Multi-Primary Replication Solutions for PostgreSQL

Join Ibrar Ahmed, Sr. Software Engineer, Percona, as he discusses the concept of multi-primary replication and elaborates on the well-known multi-master replication available.
Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an...

PostgreSQLHigh AvailabilityPerformance Optimization

Jul 22, 2020

The State of Data Platforms and Becoming Data-Driven

Data growth is expected to skyrocket for the foreseeable future, so what are enterprises to do? How can organizations leverage all their data to become a data-driven enterprise? It begins at the data layer—the place where the data lives. In this session, we will discuss current database landscape, trends, and how organizations can leverage the right data platform environment that will most prepare them to leverage their data, opening the...

Open Source DatabaseOperationsScalability

Jul 22, 2020

The Five Trends That Will Change Your Database Infrastructure in 2020 and Beyond

Databases manage your company's most critical asset: data. There are several issues and trends that could transform or even break your database infrastructure in the next 18 to 24 months by limiting access, availability, or even the safety of your data. Matt explores these trends and helps prepare you for the next wave of database changes that will force companies to evolve their strategies.

OperationsScalabilityCloud Solutions

Jul 22, 2020

Cloud-Native Databases for Cloud-Native Applications? How It Enables Increased User Productivity

Everywhere you look cloud-native and microservice-based applications are popping up. Research points to these becoming the de facto standard for application development. Designing cloud-native applications require careful planning and consideration around the database layer. Build your databases out incorrectly, and you could be in for slowdowns, availability issues, and increased complexity. Peter talks about how a new wave of technology...

Open Source DatabaseCloud Solutions

Jul 22, 2020

The Future of Databases in the Cloud - Tony Baer

Enterprises are looking to the cloud to simplify IT and support business agility, and many are looking at managed Database-as-a-Service so they can shift their attention from running databases to business innovation. But for organizations unable to move their data to a public cloud, many are considering hybrid or private cloud platforms as alternatives. The question for database managers is whether hybrid cloud platforms can provide the...

Open Source DatabaseCloud Solutions