Are you considering Event Sourcing? Think again
Eduardo Bellani's blog post argues that traditional SQL RDBMS with temporal tables can provide similar benefits to event sourcing, encouraging developers to evaluate existing tools for cost-effective data management.
Read original articleEduardo Bellani's blog post discusses the potential drawbacks of adopting event sourcing for software projects, suggesting that traditional SQL relational database management systems (RDBMS) with temporal tables may offer similar benefits at a lower cost. He argues that many developers may overlook the capabilities of their existing SQL databases, which can provide features like auditing, error recovery, and trend analysis through temporal queries. These features allow for an immutable audit trail and the ability to reconstruct data without the complexities associated with event sourcing. The post highlights the advantages of using temporal tables, such as maintaining a linear programming style while still benefiting from the advantages of event sourcing. Bellani encourages developers to reconsider their approach and explore the capabilities of their current tools before committing to event sourcing.
- Event sourcing may not be necessary for all projects.
- SQL RDBMS with temporal tables can provide similar benefits to event sourcing.
- Temporal tables offer features like auditing and error recovery.
- Developers should evaluate existing tools before adopting new methodologies.
- The post promotes a more cost-effective approach to data management.
Related
At 50 Years Old, Is SQL Becoming a Niche Skill?
SQL, a foundational technology, faces scrutiny in today's IT world. Evolving roles like data scientists challenge its centrality. Debates persist on SQL's relevance against newer technologies like JSON queries, impacting its future role.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
SQL at 50: What's next for the structured query language?
SQL, celebrating its 50th anniversary, remains a vital data management tool, ranking third among programming languages, with its adaptability and mathematical foundation ensuring continued relevance despite emerging technologies.
Distributed == Relational
The article explores how distributed systems can utilize relational database principles, advocating for parallel data gathering, triggers for function invocations, and user-friendly alternatives to SQL for efficient software development.
Ask HN: State of Timeseries Databases in 2024
The user is exploring alternatives to InfluxDB for sensoric time series data due to stalling issues and migration challenges, considering VictoriaMetrics and seeking recommendations for other databases.
I could write and write and write about it, but this rather infamous blog post is so good I'll just link it. https://chriskiehl.com/article/event-sourcing-is-hard
Related
At 50 Years Old, Is SQL Becoming a Niche Skill?
SQL, a foundational technology, faces scrutiny in today's IT world. Evolving roles like data scientists challenge its centrality. Debates persist on SQL's relevance against newer technologies like JSON queries, impacting its future role.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
SQL at 50: What's next for the structured query language?
SQL, celebrating its 50th anniversary, remains a vital data management tool, ranking third among programming languages, with its adaptability and mathematical foundation ensuring continued relevance despite emerging technologies.
Distributed == Relational
The article explores how distributed systems can utilize relational database principles, advocating for parallel data gathering, triggers for function invocations, and user-friendly alternatives to SQL for efficient software development.
Ask HN: State of Timeseries Databases in 2024
The user is exploring alternatives to InfluxDB for sensoric time series data due to stalling issues and migration challenges, considering VictoriaMetrics and seeking recommendations for other databases.