Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: reading sqlite db from a remote server

by tirwhan (Abbot)
on Sep 24, 2010 at 08:55 UTC ( #861756=note: print w/ replies, xml ) Need Help??


in reply to reading sqlite db from a remote server

This is not a Perl question. Google for "sqlite network" and you'll find your answer (hint:sqlite does not provide a server you can connect to over the network, you need to set one up yourself).


All dogma is stupid.


Comment on Re: reading sqlite db from a remote server
Download Code
Re^2: reading sqlite db from a remote server
by Anonymous Monk on Sep 25, 2010 at 19:03 UTC
    Hi,

    Having Googled as requested - from SQLite documentation -

    Situations Where Another RDBMS May Work Better Client/Server Applications

    If you have many client programs accessing a common database over a network, you should consider using a client/server database engine instead of SQLite. SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great. Also, the file locking logic of many network filesystems implementation contains bugs (on both Unix and Windows). If file locking does not work like it should, it might be possible for two or more client programs to modify the same part of the same database at the same time, resulting in database corruption. Because this problem results from bugs in the underlying filesystem implementation, there is nothing SQLite can do to prevent it.

    A good rule of thumb is that you should avoid using SQLite in situations where the same database will be accessed simultaneously from many computers over a network filesystem.

    So, possible but probably not ideal.

    J.C.
    A different Anon Monk.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://861756]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (5)
As of 2014-08-31 05:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls