Storage

• By default, Kexi stores database schema data in "system" database tables within the same database as user-defined tables. Advantages:

  • If SQLite is used, this gives a single file containing both schema and data
  • Good level of database independence (easy migration)
  • Efficiency, multiuser access and data integrity inherited from database engines