[sqlite] About extension-functions.c

Hello. I have recently downloaded extension-functions.c file ( http://pastebin.com/QF6WbrW5) and I have used the command: gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so such as compile instruction said but I don't get good results. I'm now under Linux Mint 11 64bits and I

Re: [sqlite] Index on BOOLEAN field

On Tue, Sep 13, 2011 at 09:16:32PM +0100, Simon Slavin scratched on the wall: > > On 13 Sep 2011, at 7:22pm, Petite Abeille wrote: > > > On Sep 13, 2011, at 2:15 PM, Simon Slavin wrote: > > > >> It's about chunkiness, and which of the values you're looking for. > > > > Chunkiness? Surely you

Re: [sqlite] Index on BOOLEAN field

On 13 Sep 2011, at 7:22pm, Petite Abeille wrote: > On Sep 13, 2011, at 2:15 PM, Simon Slavin wrote: > >> It's about chunkiness, and which of the values you're looking for. > > Chunkiness? Surely you mean selectivity, no? I'm sorry, but I've failed to find a better word. You can have a table

Re: [sqlite] Problems

Another thing you might think about is to modify the membase code (it is open-source after all) such that membase itself invokes the backup using the sqlite3_backup() interfaces. If the backup is being performed using the same database connection that is doing the writes, then the backup will

Re: [sqlite] Database schema has changed?

> Mmmm. Looks like there's no elegant way to do it. I looked into this a couple > of years ago when designing the setup. So: > > 1) Leave things as they are. Downside is the unexplained error every few > months and it's a slightly clumsy method. Upside is if the schema changes > there's no

Re: [sqlite] how to compare time stamp

>        • TEXT as ISO8601 strings ("-MM-DD HH:MM:SS.SSS"). I personally have had the best luck with this storage mechanism. I'm lazy, and my platforms all understand this format readily, and it has the advantage of being human readable as well.

Re: [sqlite] Problems

I was unaware of this. I thought it started to write to a Journal file during the backup and then persisted it afterward. However, if this scenario was happening, wouldn't the file size tend to jump around sporadically around 200Mb instead of settling into one specific size? > > On Tue, Sep 13,

Re: [sqlite] Database schema has changed?

On 13 Sep 2011 at 17:03, Simon Slavin wrote: > On 13 Sep 2011, at 4:38pm, Tim Streater wrote: > >> In general the row could get moved around any number of databases and then >> back to the original one. > > That's one reason I think making absid unique then manually

Re: [sqlite] Problems

On Tue, Sep 13, 2011 at 2:23 PM, David Holtkamp wrote: > Hello, > I have been using Membase (a nosql database), which uses sqlite3 to > persist data to disk and have run into some problems when attempting > to backup the database files. Membase uses 4 different database

Re: [sqlite] how to compare time stamp

On Sep 13, 2011, at 8:18 AM, Akash Agrawal wrote: > I have table in which i have column of Date contain both *date and > time* Well, considering that SQLite doesn't have any "date and time" data type it's hard to tell... To quote the fine manual: SQLite does not have a storage class set

[sqlite] Problems

Hello, I have been using Membase (a nosql database), which uses sqlite3 to persist data to disk and have run into some problems when attempting to backup the database files. Membase uses 4 different database files to store the data on each Node and in my particular case, each file is around 800

Re: [sqlite] Index on BOOLEAN field

On Sep 13, 2011, at 2:15 PM, Simon Slavin wrote: > It's about chunkiness, and which of the values you're looking for. Chunkiness? Surely you mean selectivity, no? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] help to get the value of file change counter

Just a guess, but you may have to use one of the Pager functions to examine the buffer for database page 1, which is always pinned in memory and which represents the first bytes of the database file. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Database schema has changed?

On 9/13/2011 8:38 AM, Tim Streater wrote: I don't see an easy way of solving conflicting absids. The hard way of solving this is to select all the fields of the messages table explicitly (except absid), so I can then insert them into a new row in the destination table. But I'm trying to avoid

Re: [sqlite] Encoding and Collation

> It's very easy to replace the SQLite functions with user-defined ones, > so if someone wants to go the easy way (partial support for just the > common western scripts) it's easy. And already done by many, if you > search the mailing list. It's exactly what I'm looking for. It could be my

Re: [sqlite] Database schema has changed?

On 13 Sep 2011, at 4:38pm, Tim Streater wrote: > In general the row could get moved around any number of databases and then > back to the original one. That's one reason I think making absid unique then manually manipulating absid values is a bad idea. Labelling which system each row

Re: [sqlite] Database schema has changed?

On 13 Sep 2011 at 13:04, Simon Slavin wrote: > On 13 Sep 2011, at 12:13pm, Tim Streater wrote: > >> SQLite error: general code: HY000 error: 17, database schema has changed >> >> and since all the rest of the time the code works fine I'm having some >> trouble pinning

[sqlite] Creating SQLite database from other databases

I was wondering if there is a good way to create SQLite databases from either SQL Server or FoxPro? Thanks. CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the use of the intended recipient(s) only and may contain information that is privileged, confidential,

Re: [sqlite] Problem in cross compiling sqlite for MIPS Little endian target

try this ./configure --host=mips-linux-gnu CFLAGS=-EL CXXFLAGS=-EL LDFLAGS=-EL CPPFLAGS=-EL ASFLAGS=-EL CC="mips-linux-gnu-gcc -EL" it will work! Navaneeth Sen B wrote: > > Is there any helping suggestions on this topic..?? > > Regards, > Sen > > * > * > > > On 4/5/2010 3:04 PM,

Re: [sqlite] help to get the value of file change counter

hii thank you for suggestion. but when reading the value from sqlite header it printing same value no change i can see i pasting the c++ code below /CODE/ #include #include using namespace

Re: [sqlite] In memory strategy guide

Sorry for any inconveniance as I supposed the second strategy works like a charm while the first one fails... Thanks J.MOLIERE - Mentor/J auteur Eyrolles blog: http://romjethoughts.blogspot.com ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Index on BOOLEAN field

On Tue, Sep 13, 2011 at 8:21 AM, François wrote: > Richard, Igor, > > I made some tests based on a) and b) cases described by Igor. > > I can see much faster SELECT with an index than without it: so Igor > seems to be right. Richard, can you tell me in what cases

Re: [sqlite] Index on BOOLEAN field

Simon Slavin wrote: > On 13 Sep 2011, at 1:07pm, François wrote: > >> Can we consider that creating an index for an integer field is a good >> practice if this field has at least 3 possible values ? Or more ? > > It's about chunkiness, and which of the values you're

Re: [sqlite] Index on BOOLEAN field

Richard, Igor, I made some tests based on a) and b) cases described by Igor. I can see much faster SELECT with an index than without it: so Igor seems to be right. Richard, can you tell me in what cases performance will be less good? Thank you, Best Regards, François On 13 sep, 14:12,

Re: [sqlite] Index on BOOLEAN field

On 13 Sep 2011, at 1:07pm, François wrote: > Can we consider that creating an index for an integer field is a good > practice if this field has at least 3 possible values ? Or more ? It's about chunkiness, and which of the values you're looking for. If all possible values are equally

Re: [sqlite] Index on BOOLEAN field

Thank you Igor!. Igor, your a) and b) cases do concern me. But reading your both answers I am quite confused now :-) Best Regards, François On 13 sep, 14:03, "Igor Tandetnik" wrote: > François wrote: > > Let us consider a table "ITEM"

Re: [sqlite] how to compare time stamp

Akash Agrawal wrote: > I have table in which i have column of Date contain both *date and > time*when compare the value in my c++ program it is not giving me > correct > result . can you help to solve my problem. Show how you are inserting the data into the table, and how

Re: [sqlite] Index on BOOLEAN field

Hello Richard, and thank you for this fast answer. Can we consider that creating an index for an integer field is a good practice if this field has at least 3 possible values ? Or more ? Best Regards, François On 13 sep, 13:33, Richard Hipp wrote: > On Tue, Sep 13, 2011 at

Re: [sqlite] Index on BOOLEAN field

François wrote: > Let us consider a table "ITEM" with a BOOLEAN field "FLAG". This table > may contain up to 100 000 entries and those entries can be selected > using "WHERE ITEM.FLAG = ?" conditions. > > Is then a good or a bad practice to add an index on this

Re: [sqlite] Database schema has changed?

On 13 Sep 2011, at 12:13pm, Tim Streater wrote: > SQLite error: general code: HY000 error: 17, database schema has changed > > and since all the rest of the time the code works fine I'm having some > trouble pinning down whether it's my bug (more likely) and if so where, or an > SQLite bug

Re: [sqlite] Database schema has changed?

Tim Streater wrote: > I'm using the PDO interface in PHP and what I do is ($dbh is a handle to the > source database): > > $dbh->query ("attach database ':memory:' as mem"); > $dbh->query ($create_messages); // Create the messages table in > the memory

Re: [sqlite] In memory strategy guide

On 13 Sep 2011, at 10:50am, jerome moliere wrote: > I'm about trying to use SQLite as a pure in memory mode but I am still > facing problems, > I wrote a small Java program doing this: > - opening a connection using the in memory syntax > - create a stupid table > - insert dummy values > -

Re: [sqlite] Index on BOOLEAN field

On Tue, Sep 13, 2011 at 6:23 AM, François wrote: > Hello, > > Let us consider a table "ITEM" with a BOOLEAN field "FLAG". This table > may contain up to 100 000 entries and those entries can be selected > using "WHERE ITEM.FLAG = ?" conditions. > > Is then a good

Re: [sqlite] changing compiled SQL statement

On Tue, Sep 13, 2011 at 4:36 AM, Baruch Burstein wrote: > If I compile a SQL statement, can I immediately change that sql string? > e.g., Is this allowed: > > sql = sqlite3_mprintf("select a from b where c = %Q;", d); > sqlite3_prepare_v2(db, sql, -1, , 0); >

[sqlite] Database schema has changed?

About once every few months I get this error (under OS X 10.7.1): SQLite error: general code: HY000 error: 17, database schema has changed and since all the rest of the time the code works fine I'm having some trouble pinning down whether it's my bug (more likely) and if so where, or an

[sqlite] Index on BOOLEAN field

Hello, Let us consider a table "ITEM" with a BOOLEAN field "FLAG". This table may contain up to 100 000 entries and those entries can be selected using "WHERE ITEM.FLAG = ?" conditions. Is then a good or a bad practice to add an index on this field if we want to improve SELECT time execution ?

[sqlite] In memory strategy guide

Hi all, I'm about trying to use SQLite as a pure in memory mode but I am still facing problems, I wrote a small Java program doing this: - opening a connection using the in memory syntax - create a stupid table - insert dummy values - dumping the table to a file - dropping the table - restoring

Re: [sqlite] how to compare time stamp

Akash Agrawal wrotes: > > I have table in which i have column of Date contain both *date and time*when > compare the value in my c++ program it is not giving me correct result . can > you help to solve my problem. > Hi, I had a similar problem. How accurate is your time? I had such a problem

Re: [sqlite] changing compiled SQL statement

If I compile a SQL statement, can I immediately change that sql string? e.g., Is this allowed: sql = sqlite3_mprintf("select a from b where c = %Q;", d); sqlite3_prepare_v2(db, sql, -1, , 0); sqlite3_step(stmt); strcpy(a, (char *)sqlite3_column_text(stmt, 0)); sqlite3_free(sql); // or sql =

Re: [sqlite] Minimal library size

I compiled down to 255Kb, but I don't use all the OMITs, only most. I compiled with mingw, and used msys's configure. On Sun, Sep 11, 2011 at 2:31 PM, Richard Tew wrote: > On Sun, Sep 11, 2011 at 4:37 PM, Baruch Burstein > wrote: > > Did you

[sqlite] changing compiled SQL statement

If I compile a SQL statement, can I immediately change that sql string? e.g., Is this allowed: sql = sqlite3_mprintf("select a from b where c = %Q;", d); sqlite3_prepare_v2(db, sql, -1, , 0); sqlite3_step(stmt); strcpy(a, (char *)sqlite3_column_text(stmt, 0)); sqlite3_free(sql); // or sql =

[sqlite] how to compare time stamp

Hi, I have table in which i have column of Date contain both *date and time*when compare the value in my c++ program it is not giving me correct result . can you help to solve my problem. -- Thank you Akash Agrawal ___ sqlite-users mailing list