.net - Port Sqlite application to a server/client application -
i have wrote application organisation , had let app run in lan using samba, worked perfect. want work on internet. problem have written app sqlite, means working so:
they have exe , sqlite dll , sqlite database on samba server , connected network drive on windows pc run it. means every pc writing on samba sqlite database.
i tried on internet, thought sqlite local database , slow, if ping under 50ms.
i create tcp server, handles , writes sqlite database, have written around 20.000 code lines project, not best option lazy me. have used 1 sqlite class in client querieng, thought work without work, if replace sqlite database adapter mysql database adapter, since sqlite has same syntax mysql.
or has better idea?
sqlite not designed concurrent transaction (it can done, that's post). if it's going available via internet best bet migrate database 1 of free databases (mysql, sql server express, oracle express...etc)
Comments
Post a Comment