c# - Get data from another computer using sqlite -
now, planning have 1 main computer , 2 client computer in same domain. want run form application in main computer uses sqlite database. want query data in main computer client computers. suggestions 2 questions of mine:
- what best way implement server-client structure communicate computers.
- what best way big datatable main computer uses sqlite.
i using .net framework 4.0 form applications.
you may share directory, either via netbios (aka samba, linux users) or nfs.
however, not idea, since sqlite locks file, may break implementation if filesystem fails whatever reason. might want use real distributed architecture, helping concurrency , load balancing.
another way use sqlite, proxy through web service, made this. serve requests, , run in same server want sqlite file, can avoid sharing file/directory containing database
Comments
Post a Comment