Relational Databases and SQL
Under active development - July 2020
Databases
This guide will use the following relational databases
- H2 database - lightweight in-process database that writes to disk, easily added for a fast and simple dev environment.
- Postgresql - open source, feature rich and production grade database (defacto production choice)
Interesting databases in the Clojure spaces include Datomic and Crux.
Other persistent storage approach include
- Amazon RDS
- Redis
- RocksDB is a high performance embedded persistent key-value store with fast storage writes (fork of Google's LevelDB)
- CockroachDB an elastic, indestructible SQL database for developers building modern applications
- yugabyteDB open source, cloud native relational DB for powering global, internet-scale apps.
Database drivers
Database drivers for commonly used database
- Apache Derby
- H2
- HSQLDB
- Microsoft SQL Server jTDS
- Microsoft SQL Server -- Official MS Version
- MySQL
- PostgreSQL
- SQLite
Database drivers may require a minimum version of Java, so consider Java 8 as the minimum version and Java 11 as the recommended version (until a new long term support version of Java is release).
see database support at http://clojure-doc.org/articles/ecosystem/java_jdbc/home.html (is this up to date?)