pbreit, Simon and Anthony, Thanks very much for your responses. I am trying out Anthony's suggestions first.
Can you please help me with the path? I can connect when I give the absolute path on the filesystem, but I want to use relative path so that it works on different computers and I can email the application to colleagues. I tried the path '/myapplicationname/databases/test.sqlite', the sort of path that can be used for images. But I get the following error. <class 'sqlite3.OperationalError'> unable to open database file What is request.folder? How do I find it? The reason I want to do this without DAL is the following: I am new to databases, SQL and Sqlite, webdevelopment, and web2py. I feel that I should gain some basic understanding of sqlite before I connect to it using other facilities such as DAL, and hence want to play directly with it along with learning development of web applications. Also, while I am learning it, I want to avoid the automation, such as creation of id column. Thanks again. On Fri, May 4, 2012 at 8:31 AM, Anthony <[email protected]> wrote: >> (a) Where do I save the .db database file (i.e., which folder within the >> application). > > > Anywhere you want. One option is in /web2py/applications/yourapp/databases, > but doesn't have to be in the application folder at all. > >> >> (b) Can I connect to it and use it (read information, store information) >> using the standard python sqlite3 module commands? > > > Sure. > >> >> If so, is there a specific way to specify the path to the database (from >> the controller functions)? > > > The path to your application folder is available in request.folder, so you > could use that as the starting point and traverse up or down from there. Or > just use an absolute path on your filesystem. > > Anthony
