#throwback How does multi-master PostgreSQL really perform under pressure? 🔁 Alfredo Rodriguez shares a real-world case study using pgEdge/spock, stress-testing millions of transactions, conflicts, latency, and failover scenarios.

▶️ Watch the talk now! https://www.youtube.com/watch?v=79ueF49PI9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced

#PostgreSQL #PGDay #PPDD #Replication #DatabaseEngineering

🚨 Multi-Master PostgreSQL gotchas: INSERT/INSERT conflicts can silently lose data, UPDATE/UPDATE overwrites entire tuples (not just changed columns), and 3-node clusters risk permanent divergence.

New blog post from Shaun Thomas dives deep into CRDTs (Conflict Resistant Data Types 😉), sequence safety, and conflict resolution strategies 👇

https://www.pgedge.com/blog/living-on-the-edge

#PostgreSQL #Postgres #DistributedSystems #DatabaseEngineering #OpenSource #Databases #Data

When using a #MySQL database, is it possible in one go, when adding a new column to an existing table, to use one default value for existing columns (initial migration, so to speak), but another for every new row going forward (real default)?

Scenario: I want to set the value in pre-existing columns to true, but in all subsequent rows to false by default.

#amCoding #amProgramming #softwareDevelopment #softwareEngineering #databaseEngineering #databaseArchitecture #dbms #SQL

💣💣 Call for Papers for IDEAS 2025.
🗺️ Location: School of Computing at Newcastle University
📅 When: 14ᵗʰ - 16ᵗʰ of July, 2025

📌 Submission Deadline: 15ᵗʰ of May, 2025
🔔 Notification of Acceptance: 13ᵗʰ of June, 2025

The annual IDEAS conference is a top international forum for data engineering researchers, practitioners, developers, and application users to explore revolutionary ideas and results and exchange techniques, tools, and experiences. We invite the participation of all interested in this event, which provides insight into original research contributions relating to all aspects of #databaseengineering defined broadly, and particularly topics of emerging interest describing work on integrating new #technologies into #products and #applications, on experiences with existing and novel techniques, and on the identification of unsolved #challenges.

For the time being, we will have the honour of presenting an invited talk by Jim Webber from Neo4j, and we will also have an #EDI session organized by Laura Heels, so do not miss this! I will update you all via my social media for new exciting updates.

More information concerning the CfP can be found on the Conference Website: https://lnkd.in/dEFJ8dGZ. We are also welcoming Sponsoring Opportunities for companies, for which do not hesitate to contact me (more information on: https://lnkd.in/dPbu7H27)

Selected papers will be invited to an #MDPI Information Special Issue (https://lnkd.in/dXrM-zhE).

So, what are you waiting for? Plan ahead for your next paper. I hope to see you all soon in Newcastle!!!

#databases #bigdata #datamining #informationsystems #verifiedartificialintelligence #xai