[sqlite] PRAGMA table_info() reveals primary keys

I had need of a programmatic interface to determine the primary keys of a table, so I went to add it to pragma table_info, only to discover it is already there. The comment in pragma.c seems out of date, failing to mention the sixth column 'pk', and so is sqlite.org/pragma.html. -- David --

Re: [sqlite] transaction w/ large journal fails

Try using strace on linux. Maybe it will give you some insight to the failure. Make sure you have enough free space on your temp dir as specified by: PRAGMA temp_store_directory Alternatively, if you have the memory, try: PRAGMA temp_store = MEMORY; and see if it behaves differently.

Re: [sqlite] Is it bad to...

"David Gewirtz" <[EMAIL PROTECTED]> wrote: > > Basically, is it bad if I decide to open and close the same database a LOT? It isn't the best choice if performance is your goal. Every time you open the database, it has to read and parse the entire schema. SQLite does that pretty quickly as databa

Re: [sqlite] Is it bad to...

On Thu, 9 Nov 2006, David Gewirtz wrote: Basically, is it bad if I decide to open and close the same database a LOT? For example, rather than opening a database when the server boots and keeping it open for the duration, is it bad if I open it for every query and close it right away? I'd set som

[sqlite] Is it bad to...

In my ongoing attempt to find the best approach for integrating SQLite into a threaded Web-serving environment, I came upon a truly crude kludge, and I wanted to know if it's bad from an SQLite architectural standpoint. I know it's bad morally and ethically. Basically, is it bad if I decide to op

Re: [sqlite] transaction w/ large journal fails

Preston Z wrote: I am running into a situation where on linux (fc5 and debian3) I have a transaction that is consistently failing using sqlite 3.3.7. The same transaction completes on windows every time. Some hardware information would probably help... Martin -

[sqlite] transaction w/ large journal fails

I am running into a situation where on linux (fc5 and debian3) I have a transaction that is consistently failing using sqlite 3.3.7. The same transaction completes on windows every time. I have a large database (1.2gb) that i run a transaction on. In windows the journal file for this transaction

Re: [sqlite] indexes in memory

- Original Message From: Christian Smith <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, November 9, 2006 8:38:51 AM Subject: Re: [sqlite] indexes in memory > chetana bhargav uttered: > > Hi, > > > I have a question regrading indexes, > > > > When I open a connection, >

Re: [sqlite] Insert statement taking too long

- Original Message From: Unit 5 <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, November 9, 2006 8:02:51 AM Subject: RE: [sqlite] Insert statement taking too long > --- Robert Simpson <[EMAIL PROTECTED]> wrote: > > You need to create an index on the columns you're > > joi

Re: [sqlite] Stored procedures

Sqlite supports user loaded functions and triggers but not stored procedures. You can probably achieve the functionality you need with functions and/or triggers. VIGNY Cecilia wrote: Hi, Does SQLite supports stored procedures ? If it does, what is the appropriated syntax ? Thanks. Ce m

RE: [sqlite] Insert statement taking too long

Unit 5 uttered: --- Robert Simpson <[EMAIL PROTECTED]> wrote: You need to create an index on the columns you're joining. Otherwise I believe 100,000,000 rows (10k x 10k) in table 2 will be scanned while SQLite looks for matches against the 10,000 rows in table 1. While that makes sense, I su

Re: [sqlite] indexes in memory

chetana bhargav uttered: Hi, I have a question regrading indexes, When I open a connection, Will indexes be loaded into memory. If one of the tables in the DB, the connection for which I have opened, has an index. If, so is there any way to selectively load/unload that from memory. In

RE: [sqlite] Insert statement taking too long

--- Robert Simpson <[EMAIL PROTECTED]> wrote: > You need to create an index on the columns you're > joining. Otherwise I > believe 100,000,000 rows (10k x 10k) in table 2 will > be scanned while SQLite > looks for matches against the 10,000 rows in table > 1. While that makes sense, I suspect the

[sqlite] Re: Stored procedures

VIGNY Cecilia wrote: Does SQLite supports stored procedures ? If it does, what is the appropriated syntax ? http://article.gmane.org/gmane.comp.db.sqlite.general/16099 Igor Tandetnik - To unsubscribe, send email to

[sqlite] Stored procedures

Hi, Does SQLite supports stored procedures ? If it does, what is the appropriated syntax ? Thanks. Ce message est protégé par les règles relatives au secret des correspondances. Il est donc établi à destination exclusive de son destinataire. Celui-ci peut donc contenir des informations co

[sqlite] indexes in memory

Hi, I have a question regrading indexes, When I open a connection, Will indexes be loaded into memory. If one of the tables in the DB, the connection for which I have opened, has an index. If, so is there any way to selectively load/unload that from memory. ... Chetana.