System.Data.SQLite

Hi, I am using VPN as a remote network storage to let my client access our .NET Application. Client can just click the program and it will run like installed on their PC (the logic is the files still need to be downloaded to their computer and loaded into their RAM) Still in the development phase but I would like to know for flat file database like this, will it be downloaded to client's computer and execute query from there or will it be executed remotely. Will this type of database be like MS SQL where client submit a query and server will only return the results, or it will actually have to download the whole db to user's PC and from there fetch the result? Thanks.

1. sqlite is not a flat file database

2. it's not a server database. If you want make a remote server using sqlite you could wrap it in a WCF based server application.

 

 

 

Hmm, ok so it's not a flat file database. I am accessing my database with a connection string like this: Data Source=10.0.0.1\database\main.db3;Version=3;UseSharedServer=true; It actually works and the IP address is the IP of my VPN The problem is I don't know whether the database operation will be executed on server side or client side. If it operates on client side, does it means it will have to download the database to local machine and query it? Or does the SQLite.dll actually able to query it remotely? Thanks again!

You could look at this thread:

http://sqlite.phxsoftware.com/forums/t/956.aspx

There is no support for what you are doing. The 'UseSharedServer' setting is not anywhere in the System.Data.SQLite source code, and does nothing. I am also interested in getting it to work over a network and will try a Data Source setting like yours with a url to test it out.  I can't answer your question. I use zone alarm, and it has a send/receive UI for traffic, I would watch that and see what's happening on the network. You could also use a program like Ethereal to look at the traffic. I apologize in advance for any mistakes.

 

 

Thanks a lot for the suggestion. I will try out using SQLite server or using a web service to query it out. Guess it's more effective to have a host server instead. Thanks again!