On Fri, Mar 28, 2014 at 5:42 AM, Eric Kiser <[email protected]> wrote: > CURRENT SCENARIO: > - we have been given access to a network hence we can share copy and paste > files on it. We access it by ftp://xx.x.x.xx with a user and password. > > THE IDEA ON MIND: > - Create a simple program that uses sqlalchemy to query sqlite database > (this is finished but my sqlite file is on my local drive) > - Put the sqlite on the shared network so that we can all query the same > database (there's exactly 10 of us). > > WHAT I KNOW SO FAR: > - I am aware that sqlite is not a good one to use over a network, but then > again I cannot use Postgresql or MySQL because I cannot setup them on the > network. > > QUESTION: > - how do I access an sqlite file located on the network using sqlalchemy? >
SQLAlchemy just uses normal filesystem access to talk to sqlite databases, so you need a network filesystem. How you do that depends on whether you are on Windows or Unix. Under Unix, you would probably have something like NFS, at which point the file is indistinguishable from a local one. On Windows, you'd either use a UNC path (\\servername\share\path\to\file), or map a drive letter. Once you've done that, you just pass the appropriate filesystem path to SQLAlchemy. Examples are at http://docs.sqlalchemy.org/en/rel_0_9/dialects/sqlite.html#connect-strings Hope that helps, Simon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
