You could go half way and use the DAL to connect to the database and execute SQL commands directly. This would give you ability to experiment with sqlite and also allow access to the time saving things in the DAL later.: http://web2py.com/books/default/chapter/29/6#Raw-sql
The database file is in the "databases" folder (gee why do they make it so complicated!!!) You can still use the database outside web2py whether using the DAL or not.. If you use db.define_table then it will automatically add an id field to each table. Other than that it is just a standard database. On Friday, 4 May 2012 03:23:47 UTC+1, curiouslearn wrote: > > Hi, > > I would like to use web2py without DAL. I want to use it with an sqlite > database in a .db file. Are there good examples of how to do this? I am > looking for things such as > > (a) Where do I save the .db database file (i.e., which folder within the > application). > (b) Can I connect to it and use it (read information, store information) > using the standard python sqlite3 module commands? If so, is there a > specific way to specify the path to the database (from the controller > functions)? > > I know I cannot use SQLFORM and other facilities to generate forms. I > don't really care about it right now. I am learning sqlite also and would > like to use the raw sqlite commands to work with it (or sqlite3 python > module) and would like to have the database available for use even outside > web2py. > > Thanks for your help. >
