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

Reply via email to