When making use of Python's asyncio library, synchronizing code within a single process is a solved problem. A simple asyncio.Lock ensures that coroutines play nice together. But as soon as your application scales to multiple containers, servers, or ...

In the latest release of ThingsDBhttps://github.com/thingsdb/ThingsDB, we’ve introduced a way to significantly accelerate the typeall function. By enabling type indexing, you can now loop over all instances of a specific type with near-instant result...

In my previous posthttps://coderlegion.com/8421/schema-first-approach-with-thingsdb, I promised to dive into the client side. However, to truly appreciate how the client interacts with the system, we first need to pull back the curtain on what happen...

In many architectures, the separation between database and application code introduces a dangerous gap where data integrity can fail. The application code is responsible for validation, but what if multiple services access the same data? This post e...

"No code in the database" is a mantra instilled in developers from computer science school onward. It's a fundamental principle of traditional database design aimed at separation of concerns and maintainability. But what if your database IS your cod...

In the world of real-time applications, delivering instantaneous updates to users is foundational. From collaborative documents to live chat applications, the ability to instantly reflect changes across all connected clients can make or break the use...