The central database here should really be a multi-user db such as MySQL. You may have a multi-user application with a rich client UI installed on many users computers. However Oracle, MySQL, SQL Server etc are still definitely preferred for multi-user applications (even small-scale applications) if you have the ability to access/utilise a database server.Īlso, don't forget that choice of database is not mutually exclusive. Of late there has been discsussion that it can even support smaller scale multi-user applications. The 2 big benefits of using SQLite are that the actual database is completely self contained in a single file controlled by your application, and that it supports standard SQL DDL and DML commands (ie SELECT, INSERT, UPDATE, DELETE, CREATE DATABASE/TABLE etc).įor a single user application SQLite is an excellent (one of the best) ways of storing both application data and settings. NET has which, in one file, is both the database provider and engine. There are bindings for various platforms. Like others, I can strongly recommend SQLite for this purpose. XML isn't a flat file format (or flat file database), but from reading your goal it sounds like what you really want is a self contained relational database rather than an actual flat file. You may have got your definitions a bit mixed up, understandable due to the large number of similar technologies around today.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |