InfiniDB vs. Oracle MySQL HeatWave vs. Postico vs. django-mysql Comparison Chart

InfiniDB is a column-store DBMS optimized for OLAP workloads. It has a distributed architecture to support Massive Paralllel Processing (MPP). It uses MySQL as its front-end such that users familiar with MySQL can quickly migrate to InfiniDB. Due to this fact, users can connect to InfiniDB using any MySQL connector. InfiniDB applies MVCC to do concurrency control. It uses term System Change Number (SCN) to indicate a version of the system. In its Block Resolution Manager (BRM), it utilizes three structures, version buffer, version substitution structure, and version buffer block manager, to manage multiple versions. InfiniDB applies deadlock detection to resolve conflicts. InfiniDB uses MySQL as its front-end and supports all MySQL syntaxes, including foreign keys. InfiniDB is a columnar DBMS. For each column, InfiniDB applies range partitioning and stores the minimum and maximum value of each partition in a small structure called extent map.

Postico is a database client. Postico can connect to a local PostgreSQL server running on your Mac, or to remote servers running on a different computer. If you want to install a local PostgreSQL server on your Mac, I recommend Postgres.app. Postgres.app starts a PostgreSQL server running locally on your Mac. The first time it starts it will automatically create a new data directory and set up an empty database. After a few moments, the server will be running and waiting for connections. Postgres.app can't start when another PostgreSQL server is already running on your computer. If you run into problems, make sure to deactivate or uninstall other PostgreSQL installations. Reboot your computer after uninstalling! To connect to a PostgreSQL server with Postico, you must first create a favorite. A favorite contains parameters for connecting to a server. Some connection parameters are optional.