the form of the SQLDB() for SQLite includes the filename - since SQLite database is based on this file. For other backends (such as postgres) you connect thru a server - so the form of your connection would be the same as your first connection. The point is that in both cases you want to connect to the same db - but for SQLite, there is no server (e.g. "lite") so you have to tell it relative file-path information.
Hope that helps. Yarko On Oct 6, 6:00 am, annet <[EMAIL PROTECTED]> wrote: > > You can have two apps connect to the same database by using the same db URI > > string. > > In the model of my initial application called b2c I have the following > URI string: > > db=SQLDB('postgres://fitwise:[EMAIL PROTECTED]:5432/fitwise_nl') > > > For SQLite one of the two should have > > SQLDB('sqlite:../../otherapp/databases/filename.db') > > From this sentence I understand that in the model of my second > application called b2b I should have the following URI string: > > SQLDB('postgres:../../b2c/databases/filename.db') > > That is SQLDB without the db= part, a reference to the databases > folder in my initial application and finally the file name filename.db > This I do not understand, there is no file in the databases folder of > my b2c application with a .db extension. Could you please explain, > what file you are referencing here. > > Best regards, > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---