About

Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide and a Technology Evangelist for Percona.


Dave Stokes has presented the following presentations

    Dave Stokes Learning PostgreSQL at Postgres World Webinar Series 2024

    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
    Dave Stokes Do You Know A CID From An OID Or An XID? A beginners guide to the alphabet soup found in and around PostgreSQL touples. at Postgres Conference 2024
    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
    Dave Stokes MERGE() - A Quick Introduction at Postgres Conference 2024
    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
    Dave Stokes PostgreSQL High Availability: The Considerations and the Candidates at Silicon Valley 2023
    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
    Dave Stokes MERGE() - A Quick Introduction at Silicon Valley 2023
    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