EdgeDB 5（エッジディービー5）
2024年EdgeDB公開EdgeDB 5 Graph-relational Database。Schema Migration+EdgeQL Native+TypeScript統合+Auth+AI Vector Search+Cloud or Self-host+PostgreSQL Foundation搭載。
概要
EdgeDB 5は2024年EdgeDB公開のEdgeDB 5 Graph-relational Databaseで、EdgeDB は2019年Yury Selivanov(asyncio Python創始者・Magic-CL同創業者)創業のNext-gen Database Project、 PostgreSQL Foundation上のGraph-relational Layer。EdgeDB は「PostgreSQL以来30年Database革命」 をModernize する Strategy で、 PostgreSQL(Mass Market RDBMS)上にGraph-relational Layer + EdgeQL(Modern Query Language) + Schema Migration + TypeScript統合 + Modern Type System を構築するNext-gen Database Approach、 ORM(Prisma / Drizzle / TypeORM)・GraphQL(Hasura / Postgraphile / Apollo)・Modern BaaS(Supabase / Neon / Convex / Firebase)対抗の独自Position。EdgeDB 1.0(2022年GA)→ EdgeDB 5(2024年・AI Vector Search + Auth + Cloud)世代Evolution、 「Graph-relational Database + EdgeQL Native + TypeScript統合 + Schema Migration + Auth + AI Vector Search + Cloud or Self-host + PostgreSQL Foundation」 のEdgeDB独自Engineering Maximization、 Mass Market RDBMS(PostgreSQL Native + ORM Layer + GraphQL Layer + Auth Layer + Vector Search Plugin + Manual Migration等)複雑Stack対比 EdgeDB 1 Tool All-in-one Strategy。「Graph-relational Database」 はEdgeDB Core Differentiation、 RDBMS(Relations / Tables / SQL JOIN)+ Graph Database(Nodes / Edges / Traversal)Hybrid Approach、 Object-oriented類似Type System + 直感的Multi-table Query + Type-safe Schema Definition で「SQL JOIN Hell」 / 「ORM N+1 Problem」 を構造的Solve、 Modern Application Data Model(Social Graph / Knowledge Graph / Multi-table Relations複雑性) Native対応。「EdgeQL Native」 はEdgeDB独自Query Language、 SQL(1974年〜)・GraphQL(2015年〜)対比 Modern Type System + Object-oriented類似Syntax + Functional Approach + Type-safe + Composable Query Language、 SQL JOIN Heavy Query をEdgeQL Object-oriented Notation で Simple+ Readable+ Type-safe表現。「Schema Migration」 はEdgeDB Native機能、 Manual SQL Migration(Mass Market RDBMS)+ Migration Tool(Flyway / Liquibase / Prisma Migrate / Drizzle Kit等)対比 EdgeDB Native Schema Migration(EdgeDB Schema Definition Language + Auto-generated Migration + Schema Diff Detection + Apply/Rollback)、 Schema Evolution Pain Point構造的Solve。「TypeScript統合」 はEdgeDB Modern Stack向け、 EdgeDB Schema → TypeScript型 Auto-generation + Type-safe Query Builder + EdgeQL String Literal型推論 + Compile-time Type Safety + Modern TypeScript Modern Web Stack(Next.js / Remix / Astro等)Native親和。「AI Vector Search」 は2024年EdgeDB 5 新機能、 PostgreSQL pgvector Extension類似機能 + EdgeQL Native Vector Search Syntax + Embedding Storage + Cosine/L2 Similarity + AI Application(RAG / Semantic Search / Recommendation)向け統合。価格 EdgeDB Cloud Pay-as-you-go + Self-host無料(Apache 2.0 OSS)。
主な特徴・仕組み
- Graph-relational Database: RDBMS + Graph Database Hybrid Approach
- EdgeQL Native: Modern Query Language、 Object-oriented類似Syntax + Type-safe
- TypeScript統合: Schema → TypeScript型 Auto-generation + Type-safe Query Builder
- Schema Migration Native: Auto-generated Migration + Schema Diff Detection
- Auth Native: User Auth + OAuth + Email Magic Link + WebAuthn等統合
- AI Vector Search: 2024年新機能、 pgvector類似 + EdgeQL Native Syntax
- Cloud or Self-host: EdgeDB Cloud Pay-as-you-go + Self-host無料
- Apache 2.0 OSS: 商用利用 + Customization自由
- PostgreSQL Foundation: PostgreSQL 16+ Foundation Layer活用
- Modern Type System: Object Types + Properties + Links + Computed + Constraints
- Functional Query: Composable Query + Functional Programming類似Approach
- Migration File Format: SDL(Schema Definition Language)+ EdgeQL Migration File
スペック比較表
| 項目 | EdgeDB 5 | PostgreSQL Native | Supabase | Convex |
|---|---|---|---|---|
| Type | Graph-relational | RDBMS Pure | RDBMS + BaaS | NoSQL Reactive BaaS |
| Query Language | EdgeQL Modern | SQL | SQL | TypeScript Functions |
| Schema Migration | Native + SDL | Manual + Migration Tool | SQL Migration | Schema Auto-detect |
| TypeScript統合 | ○ Native | △ ORM Layer | △ supabase-js | ○ Native |
| Auth Native | ○ | × | ○ Native | ○ |
| AI Vector Search | ○ Native(2024) | △ pgvector Extension | △ pgvector | × |
| OSS License | Apache 2.0 | PostgreSQL License | PostgreSQL + 自社Apache 2.0 | × Closed |
| 主用途 | Modern Type-safe Database | Mass Market RDBMS | Mass Market BaaS | Reactive BaaS |
具体例・対応製品
- EdgeDB 5 Cloud: 2024年AI Vector Search + Auth + Schema Migration
- EdgeDB 5 Self-host: Apache 2.0 OSS、 PostgreSQL 16+ Foundation
- EdgeQL CLI: Schema Migration + EdgeQL Query Execution
- edgedb-js: TypeScript Client Library + Query Builder
- edgedb-python: Python Client Library
- 競合機種: PostgreSQL Native + ORM(Prisma/Drizzle)、Supabase、Convex、Neon、Hasura、Postgraphile
自作PCでの選び方・注意点
EdgeDB 5はModern Type-safe Database + Graph-relational Approach + TypeScript統合重視組織向けNext-gen Database選択肢で、 jisaku.com の VPS API(Hono on Bun + PostgreSQL Direct + Drizzle ORM)はPostgreSQL Native + Drizzle ORM Layer Status、 EdgeDB 5はアーキテクチャ Pivot前提のため直接適用不可だが、 Modern Database Approach + Graph-relational Concept認識重要技術。「Graph-relational Database」 はEdgeDB Core Differentiation、 RDBMS(Relations / Tables / SQL JOIN)+ Graph Database(Nodes / Edges / Traversal)Hybrid Approach、 Object-oriented類似Type System + 直感的Multi-table Query + Type-safe Schema Definition で「SQL JOIN Hell」 / 「ORM N+1 Problem」 を構造的Solve、 Modern Application Data Model(Social Graph / Knowledge Graph / Multi-table Relations複雑性) Native対応、 Mass Market RDBMS + ORM Layer Stack対比 Cleaner Modern Approach。「EdgeQL Native」 はEdgeDB独自Query Language、 SQL(1974年〜)・GraphQL(2015年〜)対比 Modern Type System + Object-oriented類似Syntax + Functional Approach + Type-safe + Composable Query Language、 SQL JOIN Heavy Query をEdgeQL Object-oriented Notation で Simple+ Readable+ Type-safe表現、 SQL Familiarity前提Knowledge投資不要なModern Developer向け Definitively親和性高い。「TypeScript統合」 はModern Stack最適化、 EdgeDB Schema → TypeScript型 Auto-generation(edgedb-js)+ Type-safe Query Builder + EdgeQL String Literal型推論 + Compile-time Type Safety + Modern TypeScript Modern Web Stack(Next.js / Remix / Astro等)Native親和、 ORM Layer(Prisma / Drizzle / TypeORM等)対比 Schema → Type Auto-generation + EdgeQL Direct Type-safe Query で ORM Layer Abstraction不要 + Direct Database Type Safety、 Modern TypeScript Stack向けPositioning。「Schema Migration Native」 はEdgeDB Native機能、 Manual SQL Migration(Mass Market RDBMS)+ Migration Tool(Flyway / Liquibase / Prisma Migrate / Drizzle Kit等)対比 EdgeDB Native Schema Migration(SDL Schema Definition Language + Auto-generated Migration + Schema Diff Detection + Apply/Rollback)、 Schema Evolution Pain Point構造的Solve、 Long-term Schema Maintenance + Team Collaboration + CI/CD Pipeline統合 で Operations負担削減。「AI Vector Search」 は2024年EdgeDB 5 新機能、 PostgreSQL pgvector Extension類似機能 + EdgeQL Native Vector Search Syntax + Embedding Storage + Cosine/L2 Similarity + AI Application(RAG / Semantic Search / Recommendation)向け統合、 Modern AI Era Database要件Native対応。「PostgreSQL Foundation」 はEdgeDB Pragmatic Approach、 PostgreSQL 16+ Foundation Layer活用 + EdgeDB Layer上層構築 で「PostgreSQL Battle-tested Reliability + Modern EdgeDB Layer Innovation」 両立、 Foundation改修Risk回避 + 既存PostgreSQL Tooling(Backup / Monitoring / Migration等)継続活用 + Migration Path柔軟。価格 EdgeDB Cloud Pay-as-you-go + Self-host無料(Apache 2.0 OSS)、 Modern Database Pivot許容組織 + Graph-relational Use Case重視 + TypeScript Stack統合重視組織向けPositioning。一方、 Mass Market採用度 + Ecosystem(ORM/Migration Tool/Hosting Service)はPostgreSQL Native + ORM Layer対比 限定的、 Mainstream選択 → PostgreSQL + ORM(Prisma / Drizzle)推奨、 Modern Database Pivot + Graph-relational + TypeScript Stack統合重視Niche → EdgeDB 5選択。
関連用語との違い
PostgreSQL Native + ORMとの違い: PostgreSQL Native(Mass Market RDBMS + SQL + 30年成熟Ecosystem)+ ORM Layer(Prisma / Drizzle / TypeORM等)はLegacy/Mass Market Stack、 EdgeDB 5(Graph-relational + EdgeQL + TypeScript統合 + Schema Migration Native)はModern Type-safe Stack。Mass Market + Ecosystem広範 → PostgreSQL + ORM、 Modern Type-safe + Graph-relational → EdgeDB 5。 Supabaseとの違い: Supabase(PostgreSQL + Auth + Storage + Realtime + RESTful API + supabase-js)はMass Market BaaS、 EdgeDB 5(Graph-relational + EdgeQL + TypeScript統合 + Schema Migration + Auth + AI Vector Search)はModern Type-safe Database。Mass Market BaaS + RESTful API → Supabase、 Modern Graph-relational + EdgeQL → EdgeDB 5。
よくある質問（FAQ）
Q1: PostgreSQL + ORM vs EdgeDB 5 どちらを選ぶ？ A: Mass Market + Ecosystem広範 + 既存PostgreSQL Knowledge活用 → PostgreSQL Native + ORM(Prisma / Drizzle)推奨、 Modern Type-safe + Graph-relational + TypeScript Stack統合重視 + Schema Migration Native重視 → EdgeDB 5。Mainstream → PostgreSQL + ORM、 Modern Pivot + Type-safe → EdgeDB 5。
Q2: EdgeQL は本当に SQL より優れる？ A: Modern Use Case(TypeScript Stack統合 + Object-oriented類似Approach + Multi-table Relations複雑性)で優位、 Mass Market SQL Familiarity前提Knowledge投資 + 30年Ecosystem成熟 → SQL継続優位。Use Case + Team Knowledge + Ecosystem依存度で住み分け、 「SQL Optimal」 / 「EdgeQL Optimal」 の二者択一でなく Use Case依存。
Q3: Self-host vs Cloud どちらを選ぶ？ A: Self-host(Apache 2.0 OSS無料 + Customization自由 + Privacy + Cost優位 + Operations負担)はSelf-managed Use Case、 EdgeDB Cloud Pay-as-you-go(Managed Service + Auto-scale + Backup + Operations負担削減 + Premium Support)はManaged Use Case。Cost優位 + Self-managed → Self-host、 Operations負担削減 + Managed → Cloud。
まとめ
- EdgeDB 5 = 2024年EdgeDB Modern Graph-relational Database
- EdgeQL Native + TypeScript統合 + Schema Migration Native
- Auth + AI Vector Search + PostgreSQL Foundation + Apache 2.0 OSS
- Cloud Pay-as-you-go + Self-host両対応 + Modern Type-safe
- Modern Type-safe + Graph-relational + TypeScript Stack重視組織向けNiche最有力