Robust data management with the relational data model

Saltcorn uses a relational data model, a powerful tool for organizing and managing databases. Its key strengths are its ability to represent complex relationships between different pieces of data using tables and foreign keys while ensuring a high degree of data integrity.

The relational data model is tried-and-tested, widely used in many different types of applications. Saltcorn uses this model to organise not only your data but also the user interface.

Spreadsheet-like admin interface

Manage the relational database

Manage the relational database from inside Saltcorn. We give you an interface that you can use to see the structure of your data and data itself. Define and edit fields, and the table rows in a spreadsheet-like admin interface.

Table relationships

User interfaces are based on the relational structure

Manage the relational database from inside Saltcorn. We give you an interface that you can use to see the structure of your data and data itself. Define and edit fields, and the table rows in a spreadsheet-like admin interface.

Version History

enable version history for a table to automatically save past versions of individual rows, which can be restored to the previous content

Entity-Attribute Pattern

with JSON fields – complex, highly heterogeneous data can be captured with the entity-attribute value pattern using JSON fields. This enables database tables with large scale optional fields based on unique conditions.

Import/Export CSV Files

import spreadsheet files (CSV format) into existing tables to add rows or to modify existing rows. Or create a new table by uploading a CSV file, which defines your fields for you. Download database tables as CSV files.

Learn relational data modelling with Saltcorn

If you don’t know the relational model, using Saltcorn is a great way to learn it. Thinking about which type of user interface you want to build will help you learn good database design, such as which table should have the foreign key.

ENGINE

PostgreSQL or SQLite backend

Saltcorn is based on the powerful PostgreSQL database engine. Tables created inside Saltcorn have the straightforward structure that you see reflected in the SQL design, so you can use other tools alongside Saltcorn. If PostgreSQL is not available, Saltcorn can also work with SQLite backend. This is useful for setting up a development machine on Windows or Mac.

API built-in

Saltcorn has a simple JSON REST API built in. Alternatively, for more complex API use cases, run an API server such as Hasura or PostgREST concurrently against the same database.