Re: [sqlite] Of shared cache, table locks and transactions

On 1/14/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: So you're right, when you use shared-cache mode there is less concurrency in some circumstances. Thanks for your confirmation and additional comments on the situation! It's good to know that I'm interpreting the source correctly at least.

Re: [sqlite] Restricting integer primary key values

"Brett Keating" <[EMAIL PROTECTED]> wrote: > Hi, > > I don't want to spam the list but basically, if "id INTEGER PRIMARY KEY > CHECK (id > 0 and id < 0x)" or something along those lines will > work, please let me know. It's not clear if sqlite3 supports checks on > primary keys from what

RE: [sqlite] Restricting integer primary key values

Hi, I don't want to spam the list but basically, if "id INTEGER PRIMARY KEY CHECK (id > 0 and id < 0x)" or something along those lines will work, please let me know. It's not clear if sqlite3 supports checks on primary keys from what I can tell. Thanks, Brett -Original Message-

[sqlite] Restricting integer primary key values

Hi, I'm interested in the ability to restrict the values my integer primary key is allowed to take. Specifically, I would like to restrict the value to be between (but not including) 0x and 0x. In other words, a 32 bit number where all zeroes and all ones is not allowed. Is this

Re: [sqlite] Re: How to optimize a select that gets 17 rows from a 700k row DB (via perl using DBI)?

Hi Jonathan, Splitting and automatic updating of history via triggers isn't very complicated. BEGIN TRANSACTION; CREATE TABLE StatsCurrent ( MachineVARCHAR(16) NOT NULL, Load REAL, ScratchCHAR(4), MemINTEGER, MemPctFree INTEGER,

Re: Re: [sqlite] Re: How to optimize a select that gets 17 rows from a 700k row DB (via perl using DBI)?

I'm gonna cut all the content and say just one thing. If Sqlite supported table partitioning this would be piece of cake without any complications. http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html -- It's time to get rid of your current e-mail client ... ... and start using

[sqlite] FTS1

Hi I am reading http://www.sqlite.org/cvstrac/wiki?p=FtsOne about the Full Text Search plugin to SQLite and trying to compile it, and I am wondering why it is not activated using the configure script, or at least why it does not contain a Makefile in its directory. I know it is beta (forever...

Re: [sqlite] Re: How to optimize a select that gets 17 rows from a 700k row DB (via perl using DBI)?

On 1/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Jay: The closer to real-time, the better. The most often a cron job can run under Linux is minutely, and minutely is pretty good. I guess I could have the summary process occur at the end of the script that polls the machines. It

AW: [sqlite] Of shared cache, table locks and transactions

Yes, I second this opinion. However I believe sqlite is ACID, just not when shared cache mode is enabled... Mike -Ursprüngliche Nachricht- Von: Ken [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 14. Januar 2007 17:00 An: sqlite-users@sqlite.org; [EMAIL PROTECTED] Betreff: Re: [sqlite] Of