UI Bakery Database
Last updated
Was this helpful?
Last updated
Was this helpful?
UI Bakery Postgres offers a robust, fully-hosted database solution leveraging the power and flexibility of PostgreSQL. Designed to streamline database management and integration within UI Bakery applications, it empowers developers to create, modify, and interact with databases directly through an intuitive interface.
Create tables: Easily design new tables to store data defining the necessary schema to suit your application's requirements.
Modify columns: Add, remove, or alter columns in your tables to evolve your database schema as your project grows.
Primary keys: Set and modify primary keys ensuring data integrity and efficient querying.
Foreign keys: Define relationships between different tables with foreign keys, enabling complex data structures and queries.
Inline cell editing: Directly edit data within cells for quick updates and fixes ensuring a smooth and efficient data management experience.
New row creation: Insert new rows into your tables effortlessly expanding your dataset as needed.
AI-Generated rows: Utilize AI capabilities to auto-generate data rows based on existing patterns and structures in your database.
Sorting: Organize your data with powerful sorting capabilities. Sort by any column in ascending or descending order to analyze your data effectively.
Advanced filtering: Apply comprehensive filters to your data enabling precise data retrieval. Create complex filter combinations to drill down into your dataset.
UI Bakery Postgres has a current limitation of 5GB per workspace. Unlike cloud-based solutions, on-premise instances are not subject to size limitations.
UI Bakery Postgres supports various action types for different operations:
SQL: Write and execute custom SQL queries for complex data retrieval or manipulation.
Load Table: Quickly retrieve data from a specific table in your database based on your filters.
Load Row: Load a single row of data - ideal for detailed views or editing specific records.
Create Row: Insert new data into your table.
Bulk Create Rows: Create multiple rows in a table.
Update Row: Update single or multiple rows in the table.
Delete Row: Remove data from your table.
Bulk Delete Rows: Delete multiple rows in a table by a given condition.
By default, executing the update.sh script automatically adds a new Postgres container without the need for additional configuration. For more complex or custom setups, or to host a standalone Postgres instance, please refer to .
UI Bakery Postgres integrates seamlessly into your UI Bakery applications allowing you to execute various actions like querying and modifying data through SQL. The process of creating an action using UI Bakery Postgres is straightforward and intuitive. You can learn more about creating actions .
