Database
Enterprise Postgres.
Governed by default.
Every DEX project ships with a full Postgres database — not a toy wrapper, not a proprietary layer. Real Postgres with auto-generated REST APIs, row-level security, audit logging, real-time subscriptions, and vector search. Migrate your Oracle data in, build on top with the AI builder, and own the entire stack.
Everything you need
A complete data platform, not just a database
Start with Postgres. Add auth, APIs, storage, real-time, and vector search — all from one platform. No glue code, no third-party integrations, no DevOps.
Postgres Database
Every project is a full Postgres instance. 100% portable — export your data and schema at any time, run it anywhere Postgres runs. No proprietary extensions, no lock-in.
Authentication & RBAC
Built-in user management with row-level security policies. Define who can read, write, and modify every row — enforced at the database level, not in application code.
Auto-generated REST APIs
Every table and view gets a typed REST API automatically. No boilerplate, no code generation step. Changes to the schema are reflected in the API within seconds.
Real-time Subscriptions
Subscribe to database changes over WebSockets. Build dashboards, notifications, and collaborative features that update the moment the data changes. No polling.
File Storage
Store, organize, and serve files directly from the platform. Documents, images, exports — governed by the same row-level security as your database tables.
Vector Search & AI
Store and search vector embeddings natively with pgvector. Build semantic search, recommendation engines, and RAG pipelines without a separate vector database.
Edge Functions
Run custom server-side logic at the edge — webhooks, integrations, scheduled jobs, and data transformations. Deploy without managing servers.
Audit Logging
Every data mutation is logged with the user, timestamp, and change payload. SOX, HIPAA, and GDPR audit trail — built into the database layer, not bolted on.
Manage without leaving the browser
A dashboard for teams, not just DBAs
| id | name | role | created | |
|---|---|---|---|---|
| 1 | Anna K. | [email protected] | admin | 2026-01-15 |
| 2 | Rafal C. | [email protected] | editor | 2026-01-16 |
| 3 | Maciej R. | [email protected] | viewer | 2026-02-01 |
Table Editor
Browse, filter, and edit your data like a spreadsheet. Full CRUD, inline editing, foreign key navigation, and bulk operations. No SQL required for day-to-day data management.
SELECT department, COUNT(*) as headcount,
AVG(salary) as avg_salary
FROM employees
WHERE active = true
GROUP BY department
ORDER BY headcount DESC;SQL Editor
Write and run SQL directly in the browser. Auto-complete, query history, saved queries, and result export. Full power of Postgres — no restrictions, no training wheels.
Row-Level Security
Define access policies visually or in SQL. Every query is filtered at the database level — not in your application code. The data layer enforces the rules regardless of which API or service accesses it.
From Oracle to Postgres
Migrate your Oracle Database — or start fresh
The DEX migration engine handles the data layer too. Oracle tables, sequences, packages, and stored procedures are converted to Postgres equivalents. The REST API layer connects the new TypeScript UI to the same data — running in parallel with the legacy system until cutover.
Schema conversion
Oracle data types → Postgres equivalents. Sequences, constraints, indexes, and partitions mapped automatically.
Stored procedures
PL/SQL packages and stored procedures → PL/pgSQL or TypeScript functions, depending on complexity and maintainability preference.
Parallel operation
Both databases run simultaneously during the migration. The REST API layer abstracts the data source — the UI doesn't know or care which database is answering.
Zero-downtime cutover
Data synchronization keeps both databases in lockstep. The cutover is a configuration change, not a maintenance window.
Enterprise grade
The compliance your auditors expect
Financial controls audit trail on every data mutation
PHI data isolation with row-level security policies
Data portability, right to erasure, consent tracking
Infrastructure-level security controls and monitoring
Every database comes with encryption at rest, encryption in transit, automated backups, point-in-time recovery, and connection pooling. No configuration required.
Start with Postgres. Scale to enterprise.
Whether you're migrating from Oracle or building from scratch, the DEX database layer gives you production-grade Postgres with the governance enterprise teams actually need.