Dave Stokes
Technology Evangelist at n/a
Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide
Upcoming presentations
No upcoming presentations...
Past presentations
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...
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!
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 ...
Apr 17 2024
MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!
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.
Apr 18 2024
PostgreSQL High Availability: The Considerations and the Candidates
Better performance can be yours
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...
Apr 20 2023
MERGE() - A Quick Introduction
Unleash the Power of SQL with one new function!
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...
Apr 21 2023