About
Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide and a Technology Evangelist for Percona.
Learning PostgreSQL
presented by Dave Stokes
video
Learning PostgreSQL and/or SQL can take time and effort. This webinar showcases an option that does not require installation or access to a PG server. Pgexercises.com provides access to a PG server through a web browser, has established exercises, and has an outstanding user interface. It is easy to work through the exercises, and the website provides detailed explanations of the answers if you...
more Wed 10 2024 Fundamentals
Do You Know A CID From An OID Or An XID? A beginners guide to the alphabet soup found in and around PostgreSQL touples.
Who is on first? And What is on second!
presented by Dave Stokes
The learning curve for PostgreSQL can be nearly verticle for those caught up in the terminology. So if you find yourself stuck between MIN and CMAX, or have no idea what those things are, then you should be in this talk. This will be a gentle introduction for those new to PostgreSQL to some of the more common but no less obscure terminology that you will stumble over when trying to discern the ...
more Wed 17 2024 Essentials
MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!
presented by Dave Stokes
Merge() was introduced in PostgreSQL 15 and a few unkind individuals have dismissed it as a fancy 'upcert'. But MEREGE() is more than that! If you run batch data, like cash register transaction logs, and need to reconcile them against your main table, MEREGE() becomes a fantastic tool to speed processing and make your life much easier.
Thu 18 2024 Essentials
PostgreSQL High Availability: The Considerations and the Candidates
Better performance can be yours
presented by Dave Stokes
Almost every organization that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilizing PostgreSQL for critical business applications. In some cases, it is a move away from other major database systems like Oracle or even Teradata. We are going to define the basic criteria for a high availability system, and have a qui...
more Thu 20 2023 Ops
MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!
presented by Dave Stokes
MERGE() is a powerful function for processing data like transaction logs. It is powerful as it allows you to insert, update, or delete data in one statement instead of using an application that requires numerous round trips between the server and the application to do the same tasks (which is much more resource and time intensive). However, this is not an easy function to learn from reading the...
more Fri 21 2023 Data