Making the Most of Modern Database Systems

Join us for an exciting half-day workshop where you'll discover the power of modern database systems and gain valuable hands-on experience. This workshop will focus on two key areas: JSONb columns and composite types in PostgreSQL, followed by migrating our application to MongoDB. You'll learn all about storing, querying, and indexing JSON data effectively, and using composite types in PostgreSQL.

In the second part of the workshop, you'll migrate the existing application to MongoDB, giving you insights into schema design for MongoDB. You'll become familiar with the MongoDB API and learn how to interact with MongoDB programmatically. To top it off, we'll explore advanced features like the powerful aggregation pipeline, enabling us to perform complex data transformations and gain valuable insights.

Prerequisites and preparation

Users should have a modern PHP version (8.0+) and the MongoDB extension installed. Installation instructions for the extension can be found here: https://www.php.net/manual/en/mongodb.installation.php. A local MongoDB server is not required. A local installation of PostgreSQL can be used, but it is also not required.