Back to articles
EdgeDB Has a Free API — The Post-SQL Database with a Better Query Language

EdgeDB Has a Free API — The Post-SQL Database with a Better Query Language

via Dev.to WebdevAlex Spinov

EdgeDB is a database that replaces SQL with EdgeQL — a more expressive, composable query language. Built on PostgreSQL, it gives you schemas, migrations, and type safety without the ORM. Why EdgeDB? EdgeQL — more readable and powerful than SQL Schema-first — define schema with SDL, auto-generate migrations Built-in auth — user management included Type generation — generates TypeScript types from schema Quick Start curl --proto '=https' --tlsv1 .2 -sSf https://sh.edgedb.com | sh edgedb project init Schema # dbschema/default.esdl module default { type User { required name: str; required email: str { constraint exclusive; }; multi posts: Post; } type Post { required title: str; required content: str; required author: User; created_at: datetime { default := datetime_current(); }; tags: array<str>; } } edgedb migration create edgedb migrate EdgeQL Queries # Insert insert User { name := 'Alice', email := 'alice@example.com' }; # Select with nested data select User { name, email, posts: { tit

Continue reading on Dev.to Webdev

Opens in a new tab

Read Full Article
2 views

Related Articles