Re: [sqlite] accessing table column names other then via pragma, or...

On Tue, Nov 9, 2010 at 9:08 PM, Chris Wolf wrote: > ...can pragma result sets be accessed in other sql statements? > > I wish to use SQLite to perform some data re-formatting, as such, I need > to output the results > in CSV format.  Unfortunately, the ".output" command does not emit the > column

[sqlite] accessing table column names other then via pragma, or...

...can pragma result sets be accessed in other sql statements? I wish to use SQLite to perform some data re-formatting, as such, I need to output the results in CSV format. Unfortunately, the ".output" command does not emit the column names in the first row. I was hoping that something like this

Re: [sqlite] constraint doubled database size

linux fan wrote: > I rebuilt a table after adding a multi-column constraint > and the database disk file size is more than double > compared to the size that it was without the constraint. > > Is this the expected behavior, or have I done something wrong? It's expected. An index is created to en

[sqlite] constraint doubled database size

I rebuilt a table after adding a multi-column constraint and the database disk file size is more than double compared to the size that it was without the constraint. Is this the expected behavior, or have I done something wrong? # .schema for TABLE builds CREATE TABLE IF NOT EXISTS buil

[sqlite] specific behavior of busy_timeout with different transaction modes

While debugging an issue with using SQLite with a Rails application, we discovered that the behavior of SQLite when setting the 'sqlite3_busy_timeout' option was unexpected. After reading and grokking the SQLite documentation about locking (or doing our best to, at least!) it seems that this is

Re: [sqlite] sqlite3_step to select and update the same table

Well, with your 5 gig table, the select statement needs to still compile a set of results somehow, be it data or pointers to the data, and remember which row has been read. As I said, I've never looked or traced the code, but something has be be created somewhere that says "This is the next record

Re: [sqlite] Question about SQLite features.

> That's I don't know SQLite have stored procedure support? No. There's only limited support of triggers, i.e. triggers don't have some full-featured programming language, they are just a set of selects, updates, deletes or inserts Pavel On Tue, Nov 9, 2010 at 2:29 AM, Tran Van Hoc wrote: > De

Re: [sqlite] SQLite latest version RPM download location

> We're planning to upgrade SQLite to the latest version (atleast to v3.5.0) The latest version is 3.7.3. > Can somebody point me to the RPM download link location of the same? SQLite doesn't have RPM. You can download SQLite's sources or prebuild library from here: http://www.sqlite.org/downloa

[sqlite] Question about SQLite features.

Dear all. I'm using SQLite and many thanks for your supports. I have problem about SQLite features. That's I don't know SQLite have stored procedure support? Expect your respond. Thanks you very much. ___ sqlite-users mailing list sqlite-users