The Altan Database Service is a modular system for managing structured data collaboratively. It consists of five core entities: Databases, Tables, Fields, Records, and Views.Database#
A Database (or "Base") is the top-level entity containing one or more tables. It includes:Access Control: Permissions for creating, updating, and deleting data.
Collaboration: Shared access, invitations, and real-time notifications.
Integration: API endpoints for database creation, duplication, and external connections.
Tables#
A Table organizes data into structured records. Key features:Metadata: Name, description, versioning, and ordering.
Views: Default views auto-generated, customizable as needed.
Creation Modes: Supports both single and batch table creation.
Fields#
Fields define the schema (columns) of a table, specifying data types and rules. Features include:Data Types: Text, numbers, dates, references, etc., with validation options.
Schema Migration: API for adding, updating, and altering PostgreSQL tables.
Relationships: One-to-one or one-to-many links between tables with cascading rules.
Records#
Records (rows) store actual data within a table, ensuring:Data Persistence: Managed via PostgreSQL.
CRUD Operations: APIs for inserting, updating, and deleting records.
View Interplay: Sorting, filtering, and grouping records dynamically.
Views#
Views customize how data is displayed and interacted with. Features include:Types: Grid, calendar, kanban, form, and gallery views.
Customization: Sorting, filtering, and grouping for tailored displays.
Dynamic Updates: Automatically reflect changes without performance loss.
By combining these components, Altan Database Service provides a flexible, scalable, and collaborative data platform. Whether for developers or end-users, it ensures seamless integration, data integrity, and intuitive management.Happy building with Altan! 🚀 Modified at 2025-02-04 20:44:30