Large Databases at Scale - postgreSQL Edition
#neoscon #postgresql #opensource If you're using MySQL, you might be wondering if it's time to make the switch to Postgres. MySQL and Postgres are both popular relational databases, but they have some significant differences in terms of functionality, scalability, and reliability. In this talk, we'll explore the benefits of moving from MySQL to Postgres, and we'll also introduce OrioleDB, a newer database that takes many of Postgres' strengths to the next level. We'll start by examining some of the limitations of MySQL, such as its lack of full ACID compliance, limited support for advanced data types, and difficulty in handling large-scale data sets. We'll then compare these with Postgres' strengths, including its fully ACID-compliant transactions, robust support for complex data types like arrays and JSON, and superior scalability and reliability. Next, we'll introduce OrioleDB, a newer database that builds on Postgres' strengths and offers even more powerful features. OrioleDB is fully compatible with the Postgres protocol, meaning you can use the same drivers and client libraries as you would with Postgres. However, OrioleDB also adds new capabilities, such as distributed data storage and processing, built-in support for graph data structures, and advanced indexing and query optimization. We'll conclude by discussing some best practices for migrating from MySQL to Postgres, and how OrioleDB can help ease this transition. Whether you're a developer or an IT professional, you'll come away from this talk with a deeper understanding of the benefits of Postgres and OrioleDB, and how they can help you take your database infrastructure to the next level.