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:

  1. what best way implement server-client structure communicate computers.
  2. 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

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -