SurrealDB

vs

PostgreSQL

Supabase is a free and open-source self-hosted and SaaS provided alternative to Firebase. With Supabase you can add a realtime REST API to a PostgreSQL without writing a single line of code.

Fauna is the data API for client-serverless applications. It provides web-native GraphQL interface, with support for custom business logic and integration with the serverless ecosystem. Fauna transforms the traditional DBMS into a Data API that gives you all of the capabilities of traditional database, without sacrificing flexibility, scale, and performance. By utilizing a globally-distributed storage and compute fabric, Fauna-powered applications are delivered to end-users fast and reliably on modern security infrastructure.

EdgeDB is a database designed on top of Postgres with the goal of eliminating some of the shortcommings of relation and NoSQL databases.  At first glance, EdgeDB looks like a regular object relational mapper (ORM), however it's far more than that, It's a full-fledged database with a formally-defined query language, a migrations system, a suite of client libraries in different languages, a command line tool, and a soon comming cloud hosting platform. The goal of EdgeDB has been to rethink every aspect of how developers model, migrate, manage, and query their database.

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.

The worlds most popular free open-source relational database, MySQL is used by 150,000 + companies across the globe. The relational database management system is released and distributed under the GPL license and openly developed by the community. MySQL uses SQL as its query language and is fully integrated and ACID compliant.

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.