There seem to be a trend in using DBs like SQL Express for everything. Is this a good thing ?
For larger systems sure , for small systems im not sure..
The reason why people use these is obvious good tools/Apis and data protection /management.
However for small systems DB's are not that easy to manage , they have to be installed , connection string and security setup and most importantly maintained. Having a corruption in an index is a major issue when the DB is on a client laptop a lot of small apps dont provide Reindex faciities.
Considering these DB's are often less than 50 Meg for cases with a small amount of writes i much prefer , running it all out of memory and using an XML file. You get data integrity by always having a backup file ( eg copy the old file after a successful update).
I think this part of growing trend to apply things designed for large systems too small ones due to the better tools available.
Print | posted on Sunday, March 29, 2009 9:05 AM