Re: [sqlite] pragmas in subselects?

On Jan 29, 2014, at 9:58 PM, big stone wrote: > (killing two birds with one stone) No. One bird only. Enhancing ‘alter table’ is another kettle of fish altogether. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/

Re: [sqlite] pragmas in subselects?

Would the implementation of a subset of "Information schema" also allow the "Alter table" function to work in more (SQL) standard situations ? (killing two birds with one stone) ___ sqlite-users mailing

Re: [sqlite] pragmas in subselects?

On Sun, Jan 26, 2014 at 9:45 PM, Jay Kreibich wrote: > > Chapter 10 of Using SQLite covers virtual tables. One of the examples > given shows how to wrap a PRAGMA statement, so it can be used as system > catalog and used in normal SELECT statements. It would be pretty easy to > expand the given

Re: [sqlite] pragmas in subselects?

big stone wrote: > There is a non-logicality of having "pragma table_info(my_table)" : > - answering like a select, > - but being not usable as a "select", nor queriable by a "select". SQLite's PRAGMA implementations do not plug into the internal query mechanism used by SELECT, but hardcode a VDBE

Re: [sqlite] pragmas in subselects?

On 26 Jan 2014, at 10:32pm, Petite Abeille wrote: > What SQLite would really benefit from is a proper, consistent, queryable data > dictionary such as the the standard information schema: > > http://en.wikipedia.org/wiki/Information_schema I would like that for in SQLite4. Something close to

Re: [sqlite] pragmas in subselects?

On Jan 26, 2014, at 11:19 PM, big stone wrote: > ==> Is it the reason ? Well, that pragmas are not directly queryable from SQL just add insult to injury. What SQLite would really benefit from is a proper, consistent, queryable data dictionary such as the the standard information schema: ht

Re: [sqlite] pragmas in subselects?

There is a non-logicality of having "pragma table_info(my_table)" : - answering like a select, - but being not usable as a "select", nor queriable by a "select". Other databases seem more logical on this practical matter. Multi-motor tools, like dbeaver, have currently much less good support of "

Re: [sqlite] pragmas in subselects?

Chapter 10 of Using SQLite covers virtual tables. One of the examples given shows how to wrap a PRAGMA statement, so it can be used as system catalog and used in normal SELECT statements. It would be pretty easy to expand the given example to cover almost any SQL statement (including any PRAG

Re: [sqlite] pragmas in subselects?

On 26-01-2014 17:09, Stephan Beal wrote: Hi, all, is there a syntactical construct which will allow me to use a pragma in a subselect? e.g. i'm trying to do... sqlite> pragma table_info(vfile); cid|name|type|notnull|dflt_value|pk 0|id|INTEGER|0||1 1|vid|INTEGER|0||0 ... sqlite> select name fro

Re: [sqlite] pragmas in subselects?

On Jan 26, 2014, at 5:09 PM, Stephan Beal wrote: > Is this possible? Sadly, no. Much of a PITA. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Pragmas

On Thu, Jan 16, 2014 at 2:02 PM, Tim Streater wrote: > From time to time I see the use of a particular pragma recommended by the > experts here. However, the introduction to: > > http://www.sqlite.org/pragma.html > > specifically warns that any pragma is at risk of being removed from one > releas

Re: [sqlite] Pragmas for in-memory databases

On Sat, Apr 17, 2010 at 05:27:35PM -0700, andrew fabbro scratched on the wall: > If a DB is entirely in-memory (i.e., opened with :memory:), which pragmas > can be used to improve performance? > > (1) I assume synchronous = OFF is desirable N/A. There is no such thing as synchronizing memory w

RE: [sqlite] Pragmas

quot;create table t... --- and its working the only file included is (#include "sqlite3.h") regards, TAMIMY - Original Message - From: "Anish Enos Mathew" <[EMAIL PROTECTED]> To: Sent: Monday, May 22, 2006 3:49 PM Subject: RE: [sqlite] Pragmas

RE: [sqlite] Pragmas

ja Corlija [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 1:12 AM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Pragmas On 5/21/06, Unit 5 <[EMAIL PROTECTED]> wrote: > I am a bit confused on how to change the page_size > using the pragma command. The documentati

Re: [sqlite] Pragmas

On 5/21/06, Unit 5 <[EMAIL PROTECTED]> wrote: I am a bit confused on how to change the page_size using the pragma command. The documentation says: "The page-size may only be set if the database has not yet been created." The database is created when you create first table in it. Run the pragm

Re: [sqlite] Pragmas

Drew, Stephen wrote: I would be grateful if somebody who has experience using these column name pragmas could take a look and see if either: (a) This documentation is incorrect: http://www.sqlite.org/cvstrac/wiki?p=ColumnNames (b) I am not using SQLite correctly. Steve, I have tried these pragma

RE: [sqlite] Pragmas

te help on this if anyone can spare the time. I need to either move to SQLite 3 or find an alternative. I cannot move to SQLite 3 if I cannot replicate the behaviour of SQLite 2, even with pragmas. Many thanks, Steve -Original Message- From: Drew, Stephen Sent: 03 May 2005 15:49 To: sqli

RE: [sqlite] Pragmas

rg Subject: RE: [sqlite] Pragmas Understood. I fall into case 5, and this is definitely not the way they're represented. So assuming my code was correct, and the documentation refers to 3.2.1, the documentation is STILL incorrect? Regards, Steve -Original Message- From: D. Richa

RE: [sqlite] Pragmas

Sent: 03 May 2005 15:26 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Pragmas On Tue, 2005-05-03 at 15:09 +0100, Drew, Stephen wrote: > This is not the case for the version of SQLite 3.2.1 I am using. Is > the documentation incorrect, or am I doing anything wrong? > Document

Re: [sqlite] Pragmas

On Tue, 2005-05-03 at 15:09 +0100, Drew, Stephen wrote: > This is not the case for the version of SQLite 3.2.1 I am using. Is > the documentation incorrect, or am I doing anything wrong? > Documentation is wrong. See http://www.sqlite.org/cvstrac/wiki? p=ColumnNames -- D. Richard Hipp <[EM