On Tue, Oct 20, 2009 at 1:33 PM, John Crenshaw <johncrens...@priacta.com> wrote: > database = the physical file itself > database connection = a specific reference to the database, obtained > using sqlite3_open > > page_size has to be set before the database is created (though I'm NOT > entirely sure how you would execute the pragma before creating the > database, since executing the pragma should require a connection, and a > connection should require a database. Hmm...)
before any table is created... > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Doug > Sent: Tuesday, October 20, 2009 2:28 PM > To: 'General Discussion of SQLite Database' > Subject: [sqlite] PRAGMA scope > > I'm reading about the different PRAGMA operations. Cache_size mentions > that > it is per-database connection. Page_size says it is per database (must > be > used before the database is created), which sounds like per-connection > (ie > if I create two databases, I'm guessing I need to set the page_size > after > calling sqlite3_open each time). > > > > Temp_store and synchronous don't make any mention of files or > connections. > Can/should it be assumed that they are global to the SQLite library? > > > > Thanks > > Doug > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users