Data Sources

A data source is a connection to a real database – IllusionDB reads its schema and provides a spreadsheet-like interface plus a REST API on top of it. Your actual data always stays in that external database; IllusionDB only stores metadata (column configuration, views, formulas, …) in its own internal database.

PostgreSQL, MySQL, MariaDB, and SQLite are supported.

In this chapter:

• Connect a data source
• Create a new SQLite database directly
• Synchronizing
• Export and import schema
• Manage a data source (download, delete)