Building File4Base: The Modern, Open-Source Alternative to old file bases (Powered by Antigravity)

For decades, platforms like Claris FileMaker, Microsoft Access, and 4D enabled businesses to build...

title: Building File4Base: The Modern, Open-Source Alternative to old file bases (Powered by Antigravity) published: true tags: opensource, flutter, golang, postgres cover_image: https://dev-to-uploads.s3.us-east-2.amazonaws.com/uploads/articles/8dsce3xxd0txso2shxb1.jpg canonical_url: https://github.com/file4base/file4base-app

For decades, platforms like Claris FileMaker, Microsoft Access, and 4D enabled businesses to build tailored database applications rapidly without needing dedicated enterprise engineering teams.

However, the legacy RAD (Rapid Application Development) ecosystem comes with well-known bottlenecks: proprietary runtimes, opaque file formats, steep licensing costs, and vendor lock-in.

Today, I’m excited to share File4Base: an open-source, modern alternative designed to bring back the speed and visual intuition of FileMaker, powered by clean architecture, open databases, and native cross-platform performance.

🎯 The Vision: What is File4Base?

File4Base aims to bridge the gap between relational databases and business users by providing:

1. A Visual Canvas Layout Engine: Design forms, lists, reports, and search queries dynamically.
2. First-Class Relational Schemas: Real PostgreSQL tables and columns under the hood—no black-box database engines.
3. Visual Scripting Workspace: Step-based automation (similar to FileMaker’s Script Workspace), serialized in structured JSON and executed deterministically.
4. Self-Hostable & Zero Lock-in: Fully dockerized backend with standard SQL data access.

🏗️ The Modern Stack

Instead of building a monolith, File4Base separates the presentation layer from the database engine using modern industry standards:

• Client (Desktop & Tablet): Flutter (macOS, Windows, Linux). Native rendering, fast UI redraws, and cross-platform consistency.
• Backend Core: Go (Golang). A lightweight, memory-efficient service managing metadata catalogs, generic dynamic CRUD operations, and permission enforcement.
• Database: PostgreSQL 16. Rock-solid reliability with JSONB metadata support, native migrations, and real-time triggers via LISTEN/NOTIFY.
• Deployment: Single command via docker compose up -d for the server infrastructure.

┌──────────────────────────────────────────────┐
│        Flutter Desktop Client (Native)       │
│  [Layout Designer]  [Browse]  [Scripts]      │
└──────────────────────┬───────────────────────┘
                       │ REST / WebSockets
┌──────────────────────▼───────────────────────┐
│              Go Backend Engine               │
│   (Schema Manager, CEL Evaluator, Auth)      │
└──────────────────────┬───────────────────────┘
                       │ pgx / SQL
┌──────────────────────▼───────────────────────┐
│                PostgreSQL 16                 │
│      (Dynamic Schemas + System Catalogs)     │
└──────────────────────────────────────────────┘

🤖 Built with Google Antigravity: Spec-Driven Development

A unique aspect of how File4Base is coming to life is the engineering workflow. We are orchestrating development through Google Antigravity.

Instead of writing repetitive boilerplate manually:

1. We write rigorous architectural blueprints, JSON schemas, and roadmap documents (.antigravity/rules.md, docs/specs/*).
2. Antigravity takes these specifications and iteratively develops tested modules in Go and Flutter.
3. The codebase stays decoupled, clean, and strictly aligned with documented architectural standards.

🚀 What's in Progress?

We've already mapped out the foundational layers:

• Monorepo architecture & Dockerized development environment.
• Complete FileMaker Menu & Feature functional reference guide.
• Script Workspace UI specification and mockups (3-panel workflow).
• Backend metadata catalog (sys_tables, sys_columns, sys_layouts).
• Dynamic JSON layout renderer in Flutter.

🤝 Join the Project!

File4Base is 100% open-source, and we are building it in public from day one.

If you have experience with:

• Flutter / Dart (Desktop layouts, state management, drag-and-drop engines)
• Go / Golang (Dynamic SQL builders, AST parsers, real-time WebSockets)
• FileMaker / Low-Code architecture (Feature parity, ergonomic UX workflows)

We would love your feedback, stars, and contributions!

👉 GitHub Repository: https://github.com/file4base/file4base-app

Let us know in the comments: what is the single most critical feature you miss from classic desktop database builders?