Skip to main content

Database Operations

ZeyOS database access operates on two distinct layers:

  1. Object-Level Operations: Work with ZeyOS business entities (Contacts, Accounts, etc.). They handle ExtData, tags, and business logic automatically.
  2. SQL-Level Operations: Specific SQL interface for complex queries, joins, and aggregations.
  3. Extending the Data Model: Augment entities with custom fields using ExtData, without changing the database schema.
  4. Tags: Label records with free-form tags for classification, filtering, and workflow routing.

Architecture Guidelines​

  • Use Object-Level Operations for standard CRUD (Create, Read, Update, Delete) on single entities.
  • Use SQL-Level Operations for reporting, bulk updates, or when you need specific fields/joins.

Connection Management​

By default, operations run against the ZeyOS application database. Use Connections to connect to external databases.