Why are we using the SQLite Database?
Why are you using SQLite? Why can't this application
interact with a different database like MySQL or
Microsoft SQL Server instead of SQLite?
Answer: SQLite is very fast and tightly
integrated into the software. SQLite is a standalone
database without the overhead of client/server. It is
not 'installed' in the same sense as the other database.
It uses a DLL to interact with database files containing
one or more SQL tables. By using SQLite, we are most
likely providing a much faster set of results than we
would with other server database packages. There may be
a time later on when we allow connection to an external
server databases for the purpose of sending history
results or some other tables for quick review by other
software. If you are interested in SQLite, please visit
- the software is open source and you are probably using
it every day: it is used in Firefox, iPhones, iPads,
Android and many other products.