RohitPatel9999 schreef:
Please put forward your views, ideas, thoughts, comparisons (if any) ??? I
might have missed many points of comparison/similarity.
At the risk of playing the devils advocate, if your target is ms windows
(seen your interest for vistadb), i found MS-Access a very reasonable
flat-file database. It may lack fancy features like encrytion, but has
it advantages as well
Pro's: any windows client has the driver installed (no need to install
office), accessable by odbc, reasonable sql (very much like mssql
server), reasonable fast, able to be used as website-backend (!), allows
simultanious users to certain amount (max. 5 recommended by MS), and
flat-file which easifies back-ups and distribution. License not needed
since it is licensed when using windows. Good indexes.
Cons: platform dependant. Sometimes bit weird SQL dialect (as anything
from MS i guess). When not properly designed may take some time porting
an database and/or application. Size of datafile may unproportionally
grows to the amount of data. Unknown behaviour (to me) on hard crashes
but probably repairable.
You may also want to investigate embedded MySQL.
Pros: full-blown mysql engine. Very configurable. Excellent
multi-threading support. Cross-platform.
Cons: poorly documented (the embedded part (does and don'ts)), probably
still buggy (4.1 was), may need license when shipped with
commercial/closed source software. Possible crashed tables if the main
application crashes. Probably you are better off seperating client and
server (=traditional setup).
To be honest, for what sqlite was designed i think there is no serious
alternative, sqlite is the best imho for embedded usage, and does not
suffer platform or language dependancy. Small con: query parser may have
trouble optimizing indices.
regards,
Rene
