Database Setup

Start with SQLite, move to MySQL when needed

SQLite is built in for fast single-machine setup. MySQL is available for larger shared database workflows.

SQLite is built in

SQLite is the fastest way to get a product database running. It is a good fit for a single workstation, a demo setup, or a seller who needs polished graphics without building a separate database backend first.

Use MySQL for larger workflows

MySQL is the better choice when multiple systems or operators need to share product records, pricing, vendors, inventory, and show data from one central database.

  • Use SQLite for simple setup and local control.
  • Use MySQL for shared production data and multi-system operation.
  • DB Management is the foundation for the graphics workflow because the on-air graphics need reliable item data.