The following SQL databases are currently supported by SystemWeaver:

  • SQLite
  • MS SQL Server
  • Oracle


Systemite highly recommends using SQLite in part because of the performance advantages over the others. 


SQLite

+ No latency as the SQLite file is stored on the SystemWeaver server.

+ Fastest start-up time.

+ No costs for additional hardware. The file is stored on the same machine as the server.

+ Runtime backup option provided.



As a result, the benefits of future optimization of SystemWeaver will be greater for systems running SQLite. 


For instructions on how to create a new SQLite database, see Creating an Empty SQ Lite Database.