Search Results

3 matches found for 'cap theorem'

CAP Patterns

The CAP Theorem dictates that only two of its three characteristics can be guaranteed at any given time. Intro to CAP Consistency Every read will be based off of the latest write Availability Every request will be given a response, although the response data might be stale Partition Tolerance It can handle network partitions or network failures MTV's The Real World If your service is in the cloud, the P in Partitioning has to always be accounted for.

December 16, 2020

PostgreSQL - a powerhouse relational database

PostgreSQL is one of the most popular SQL database engines and is widely used in the tech industry. It is a great starting point for building out an application that needs fast reads and writes with an emphasis on reads, and guarantees ACID properties through atomic transactions with various concurrency isolation levels.

July 11, 2025

RDBMS Optimization

Indexing Probably the easiest tweak to implement. It can usually be done with one SQL command. However, an index should be made based on a good column. For example, if you are frequently querying your rows by timestamp, then the timestamp can be chosen for an index.

June 23, 2020