Data consistency in distributed systems requires understanding local and global scopes, with long-running processes and the Saga Pattern offering solutions for managing eventual consistency.
About:
Igor Roztropiński is a programmer passionate about software and digital machines, sharing insights on his blog and YouTube channel.
Website:
Specializations:
Interests:
Outgoing Links:
Subscribe to RSS:
The article discusses the importance of modularity in system design, emphasizing that the number of deployment units (monolith vs. microservices) is less critical than how modules are structured based on functionality and responsi...
The blog post discusses various identity models used in social media and online platforms, focusing on centralized, federated, decentralized, and delegated approaches. It explains how the centralized model, while convenient, poses...
The text discusses the concept of modularity in software development, focusing on the benefits of autonomy in modules, which can be independently developed, tested, and deployed. It emphasizes that a properly modularized system al...
PostgreSQL outperforms MySQL in performance tests across various workloads, showcasing better throughput and lower latency in inserts, updates, deletes, and selects.
The post provides an in-depth analysis of the Bitcoin Core software, detailing its codebase, structure, and implementation. It discusses the programming languages used (primarily C/C++ and Python), the complexity of the code, its ...
A comparative analysis of MongoDB and PostgreSQL reveals strengths and weaknesses in handling JSON documents, with PostgreSQL emerging as a more versatile database solution.
The blog post discusses the Concurrency Control problem in applications, focusing on the issues of conflicting and lost updates when multiple users or services attempt to modify the same data simultaneously. It explains two primar...
Authentication is crucial for verifying identity online, utilizing methods like passwords, codes, and tokens to ensure secure access to systems.
0EventSQL: events over SQL
2025-06-14 • performance database sql events
The text discusses the use of SQL databases to build a scalable events platform. It explains the benefits of using SQL, the architecture of EventSQL, and its performance in handling events. The text also provides benchmarks to tes...
The text discusses the challenges and solutions of Peer-to-Peer (P2P) Networks, using the Bitcoin Network as an example. It covers topics such as bootstrapping, reachability, resilience, and incentives. It analyzes the distributio...
The text compares Multi Page Application (MPA) and Single Page Application (SPA) in terms of user experience, performance, complexity, and tradeoffs. It discusses the differences between MPA and SPA, their impact on user experienc...
The text discusses the differences between JSON-centric and HTML-centric approaches to building web applications, focusing on the tradeoffs and complexities of each. It explains the historical context of JSON-centric single page a...
0SQLite DB: simple, in-process, reliable, fast
2024-12-24 •
The text discusses the simplicity and reliability of SQLite as a single-file, in-process database. It compares its performance and scalability with other traditional database servers and explores its availability and features. The...
The text discusses the different approaches of MySQL and PostgreSQL to solve the same problem of storing and providing access to data in an ACID-compliant way. It compares the clustered indexes vs heap tables, multiversion concurr...
The text discusses the use of HTMX with Shoelace Web Components to build a real application. It explains the benefits and drawbacks of using Shadow DOM and the Shoelace library. The author also provides an example of an app setup ...
0Programmer in Wonderland
2024-09-15 •
The text discusses the vast ecosystem of software engineering, the over-reliance on tools and frameworks, and the consequences of being a 'Lost Programmer'. It emphasizes the importance of understanding the fundamentals and how to...
0Who controls the Internet and How it works?
2024-08-31 •
The text explains the functioning of the Internet, including its physical infrastructure, identity, routing, and domain names. It also discusses who controls the Internet, highlighting the roles of organizations like IANA, ICANN, ...
The text discusses the need for web analytics and presents a simple yet scalable solution using JSON in SQL with batch inserts. It explains the backend implementation, detailed walkthrough, example data and analytics, performance,...
The text discusses the consequences of module design and the communication between modules. It explores different approaches such as Clients/APIs, Application Events, Outbox Pattern, and Background Data Synchronization. It emphasi...
0HTMX: a setup ready for Production
2024-05-04 •
HTMX is a promising technology that simplifies many things when building web applications/systems. It eliminates the need for separate frontend and backend applications, and it does not require any additional dependencies and comp...
The text discusses load testing on a single machine with a single database to determine how many HTTP requests per second it can handle. The results show that a single machine can handle a significant amount of requests, with diff...
The text discusses the infrastructure requirements for a software system, emphasizing the need for simplicity. It provides a list of required and optional features, and discusses the complexity of using Kubernetes as a container o...
0HTMX and Web Components: a Perfect Match
2023-12-21 •
The text discusses the use of Web Components in the context of HTMX, a JavaScript library for making arbitrary http requests from any HTML element. It explains how Web Components can be used to create reusable, custom HTML element...