On Thu, May 7, 2015 at 10:01 AM, Stephen Chrzanowski <pontiac76 at gmail.com> wrote:
> Although I can understand the sarcasm you're sending out, a client/server > infrastructure would be an interesting task for SQLite to do, but to answer > the OP, no, SQLite isn't inherently designed to be a client/server. > ?And not really that difficult. Embed SQLite into some "server code" to which a client connects, probably via TCPIP or some other IPC method.? The client connects to the server, which uses the embedded SQLite to access the appropriate SQLite data base file. I would guess that the server could even be multi-threaded with each thread controlling a separate SQLite data base file. > > But, think of how torrents work. Everyone is a server, everyone is a > client. Everyone has a connection to every other database, but, it has its > own working copy to query against. If Client A updates a table, the > statement is sent out to every other "server" it has a connection to. Any > differences in the data can be synced from one to another. Even with > MySQL, the client has to pull the information it needs from the database to > get its information and work with it locally in RAM (usually) then push the > data back if there is anything to be done. Instead of the queries going to > a MySQL server, you'd be talking to a server sitting right on your > machine. Any queries from any other clients are done in another > process/thread to the server database. (I'm actually kind of getting > excited about this kind of coding, honestly.....) > ?I'm not an expert in this area, but your description sounds a bit like a stored procedure to me. http://en.wikipedia.org/wiki/Stored_procedure Basically, you define the "procedure" in the data base itself, and the code runs on the server, perhaps even in the same process as the server. This saves the cost of doing the data transmission / reception between client and server. > > This isn't to say that this kind of infrastructure would be CRAZY to do, > but it isn't impossible, and the hurdles to get it done can be overcome. > So although a gas burning electric stove seems odd, getting the gas to boil > water to push the turbine to generate electricity to run the burners does > fit the particular scenario. > Well, that's "cheating" </grin> by marrying an electric generator with a normal electric oven. And I do hope the burners have good thermal insulation from the supporting wood frame. > > And a cubical sphere would be so freak'n awesome. If you get enough, it'd > redefine "office pool"..... :] > > -- If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
