Amazon Redshift

vs

Snowflake

PostgreSQL, or Postgres for short is a widely popular, free and open-source relational database management system. PostgreSQL is available for all major operating systems including macOS, Linux, Windows, BSD and Solaris. The project has been in active development for over 30 years now, and powers many of the applications you use on a daily basis.

MariaDB is an free and open-source, community-developed relational database management system. MariaDB is a fork of MySQL, and is developed and maintained by the creators of MySQL, after concerns over its acquisition by Oracle Corporation in 2009. The databases comes bundled by default with most Linux distributions and is also apart of most cloud offerings. MariaDB is built upon the values of performance, stability, and openness which is ensured through the MariaDB Foundation.

SQLite is a free and open-source relational database management system that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. Rather than being a typical client–server database engine, SQLite is self-contained and can be embedded into applications. Making it perfect for development frameworks that want to provide a default database without setup, or applications that needs an embedded database. SQLite is built into all mobile operating systems and most computers and comes bundled with a countless applications. SQLite is also ACID-compliant and implements most of the SQL standard, generally following PostgreSQL syntax.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. The database uses Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs. Microsoft SQL server are used by enterprise-scale companies such as JPMorgan Chase, Thermo Fisher Scientific and CDK Global for finance, manufacturing and business service applications. Microsoft SQL server is also released as a free version under the name Microsoft SQL Server Express.

Redis is a free and open-source, in in-memory data structure store that can be used as a database, cache or message broker. The project is community developed and released under the BSD license. Redis supports common data structures including strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes with radius queries and streams.