Best columnar data formats

There are several columnar data formats that are popular, including: Both Apache Parquet and Apache ORC (Optimized Row Columnar) are open-source columnar data storage formats that are designed for efficient storage and processing of large amounts of data. They both support compression and data splittability, which can help reduce the amount of disk space required […]

Continue Reading

Columnar databases with SQL support

Columnar databases are a type of database that store data in columns rather than rows. This type of database is designed to be efficient for querying large amounts of data and is often used for data warehousing and analytics applications. There are several columnar databases that support SQL (Structured Query Language), which is a standard […]

Continue Reading

Learn the Limits of PostgreSQL

PostgreSQL is a powerful and widely-used open-source database management system (DBMS) that is known for its reliability, flexibility, and support for a wide range of data types and workloads. However, like any software, it has certain limits and constraints that users should be aware of. Here are some of the main limitations of PostgreSQL: Overall, […]

Continue Reading

How to use SQL with S3

Amazon S3 (Simple Storage Service) is an object storage service that allows you to store and retrieve data in the cloud. You can use SQL to query data stored in S3 by using a tool such as Amazon Athena or Amazon Redshift Spectrum. Here’s an overview of how to use SQL with S3: It’s worth […]

Continue Reading
Redis in GCP

Redis in GCP

Is all of my data safe when I increase the amount of RAM I have? I’m certain that my data won’t be removed for whatever reason, therefore should I store it in memory (Redis) or on the cloud? Memorystore “Basic” instances are the only ones that can suffer data loss in the case of a […]

Continue Reading
Datomic Free Open Source Version

Datomic Free Open Source Version

As a Clojure startup, we’re thrilled that Nubank has elevated the status of Clojure and Datomic. Datomic is clearly more advanced, but we must remember that our aims are distinct from Datomic’s. Only the most profitable, but tiny, segment of the market can afford to use Datomic as a backend database, which is why it […]

Continue Reading