Skip to main content

OLTP

Short for Online Transaction Processing — the "normal" database, optimised for lots of small reads and writes to an application's live state: creating a user, saving a form, loading one record. This is what's running behind almost every self-hosted app in this catalog.

AppLicenseFOSS problemsSSOUsersTested
PostgreSQLGeneral-purpose relational database with strong standards compliance, JSONB, and an extension ecosystem covering geospatial and vector search.PostgreSQL LicensePermissive license. An MIT/BSD-style permissive license — use, modify, and redistribute freely, including in proprietary products, with no obligation to share changes.Unlimited
MariaDBCommunity-governed fork of MySQL, created after Oracle's acquisition of Sun Microsystems, staying close to drop-in compatible.GPLv2Copyleft license. If you distribute it, modified or not, you must publish the source under GPLv2 too. No network-service clause — running it as a hosted service doesn't trigger that.Unlimited
MySQLWidely deployed relational database, dual-licensed and owned by Oracle since its 2010 acquisition of Sun Microsystems.GPLv2Copyleft license. If you distribute it, modified or not, you must publish the source under GPLv2 too. No network-service clause — running it as a hosted service doesn't trigger that.Dual-licensed, Oracle-owned, commercial tier gated behind a separate licenseUnlimited
SQLiteSelf-contained, serverless, file-based database engine — the whole database is one file, with no separate server process to run.Public DomainPublic domain license. No rights reserved — copyright is waived entirely. No conditions, no attribution required, use it however you want.Unlimited