Databases: Bespoke Tailoring and Perfect Fit
summary
The talk examines using relational databases (PostgreSQL in particular) as a foundation for custom message queues and for modeling complex domains, covering how modern RDBMS implement queues, how to build a reliable message queue on PostgreSQL, and the Java-specific issues of using and maintaining such queues. It also addresses working with complex domain models in relational databases, pitfalls of becoming dependent on ORMs, schema-evolution challenges during project development, and finishes with remarks about building custom ('bicycle') solutions.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 1:25Project context and requirements
- 5:17Payment system structure
- 13:21Queue problems and solutions
- 21:46PostgreSQL queue implementation
- 33:43Storing complex data in DB
- 46:14Data migration and versions
- 50:27Why PostgreSQL is best
- 57:07Summary
related talks
48mUsing Asynchronous Message Queues with PostgreSQL
23mRethinking Message Queues: PostgreSQL's Role
44mBuilding a Distributed Queue with Delayed Jobs on PostgreSQL
23mPostgres as a Message Broker
30mQueues in PostgreSQL
43mSQL vs Prejudice
39mFrom PostgreSQL to Tarantool: Choosing When There Is No Choice
29mPostgreSQL queues done right with PgQ