12 articles in this category
ACID protects correctness, BASE protects availability. Here is what each model guarantees, what eventual consistency means under real traffic, how CAP connects them, and a 4-question test for choosing between them.
One is an identifier your server looks up, the other carries its own claims. The real deciding factor is not statelessness, it is how fast you can revoke access.
A working chat application database design in PostgreSQL, with the tables, foreign keys, and indexes that hold up. Covers keyset pagination, Redis caching, read receipts, conversation titles, and the order to fix things when the message table gets large.
Your query is not slow. It has just never met enough data to be slow. Here is how to take a query from 28 ms to 0.075 ms on a table of 1 million rows, using EXPLAIN ANALYZE, one composite index, and keyset pagination, with every number reproduced on a real database.
We are going to explore and introduce you to what the entity-relationship model is all about and how to design and interpret Entity Relationship, this article is also going to learn how to create a basic ER model and why it is very important for a backend developer to learn it.
In this MongoDB tutorial, I will explore everything you need to know about MongoDB, from installation to creating your first collections and retrieving your document