Databases

Table of Contents

• Table of Contents
• Paradigms
  • Key-Value
  • Documental
  • Relational
  • Other
• ORM
  • Drizzle
  • Prisma
  • Supported

Paradigms

Key-Value

#	Technology	Open Source	Maintainer	Language	Recommended
1	Badger		Hypermode	Go
2	LevelDB	GitHub	Google	C++
3	Memcached	GitHub		C
4	Redis	GitHub		C	Recommended
5	RocksDB		Meta
6	Valkey	GitHub		C

Documental

#	Technology	Open Source	Maintainer	Language	Recommended
1	CouchDB	GitHub	Apache	Erlang
2	Couchbase
3	DynamoDB		AWS
4	MongoDB	GitHub		C++	Recommended
5	RethinkDB	GitHub		C++

Relational

#	Technology	Open Source	Maintainer	Language	Recommended
1	CockroachDB	GitHub		Go
2	libSQL
3	MariaDB	GitHub		C++
4	MS SQL
5	MySQL	GitHub		C++
6	PostgreSQL	GitHub		C	Recommended
7	SQLite	GitHub		C

Other

Sector	Technology	Open Source	Maintainer	Language	Recommended
Wide Column	Cassandra		Apache
Wide Column	HBase		Apache
Graph	DGraph		Hypermode
Graph	neo4j
Search Engine	ElasticSearch
Search Engine	Solr		Apache
Multi Model	Fauna

ORM

Drizzle

import { integer, pgTable, varchar } from 'drizzle-orm/pg-core';

export const usersTable = pgTable('users', {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  name: varchar({ length: 255 }).notNull(),
  age: integer().notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});

Prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id       String @id @default(uuid()) @map("id") @db.Uuid
  username String @unique @default("") @map("username") @db.Text
  email    String @unique @default("") @map("email") @db.Text

  @@index([id])
  @@map("users")
}

Supported

No	Paradigm	Database	Prisma	Drizzle	Hosting
01	Documental	DynamoDB			AWS DynamoDB
02	Documental	MongoDB	Supported		MongoDB Atlas
03	Relational	CockroachDB	Supported		CockroachDB Labs
04	Relational	libSQL		Supported	Turso
05	Relational	MariaDB	Supported
06	Relational	MS SQL	Supported
07	Relational	MySQL	Supported	Supported	PlanetScale
08	Relational	PostgreSQL	Supported	Supported	Neon / Supabase
09	Relational	SQLite	Supported	Supported	Cloudflare D1