Re: [sqlite] About extension-functions.c

2011-09-13 Thread Stephan Beal
On Wed, Sep 14, 2011 at 6:06 AM, Freddy López wrote: > I would like to know if you can help me with it. My knowledge of C is poor. > We can't possibly help until we know what the problem is. Can you please post the compiler output? -- - stephan beal http://wanderinghorse.net/home/stephan/ _

[sqlite] SQLite on AIX

2011-09-13 Thread Grice, Lynton (L)
Hi there, I will need to get SQLite working soon on AIX. I have read the compile notes from 2003 at http://www.sqlite.org/cvstrac/wiki?p=HowToCompile but was just wondering if anyone has it running happily on AIX with the newer versions of SQLIte? Any hints or suggestions from people who have

[sqlite] About extension-functions.c

2011-09-13 Thread Freddy López
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

2011-09-13 Thread Jay A. Kreibich
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 me

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Simon Slavin
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 w

Re: [sqlite] Problems

2011-09-13 Thread Richard Hipp
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 know

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Brad Stiles
> 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 extra

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Brad Stiles
>        • 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

2011-09-13 Thread David Holtkamp
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, 20

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
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 manipulating absid > values i

Re: [sqlite] Problems

2011-09-13 Thread Richard Hipp
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 files > to store the data

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Petite Abeille
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 aside

[sqlite] Problems

2011-09-13 Thread David Holtkamp
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 Mb.

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Petite Abeille
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 http://sqlite.org:8080/cgi-bin/mai

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

2011-09-13 Thread Michael Stephenson
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 [mailto:sqlite-users-boun...@sql

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Gerry Snyder
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 t

Re: [sqlite] Encoding and Collation

2011-09-13 Thread Jean-Christophe Deschamps
> 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 mis

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Simon Slavin
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 originat

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
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 down whether it's my bug (

[sqlite] Creating SQLite database from other databases

2011-09-13 Thread Anthony Scarpelli
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

2011-09-13 Thread imran_sarwar
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, Navan

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

2011-09-13 Thread Akash Agrawal
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 st

Re: [sqlite] In memory strategy guide

2011-09-13 Thread jerome moliere
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 http:/

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Richard Hipp
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 performance > will be less good? >

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Igor Tandetnik
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 looking for. > > If all poss

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread François
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, Franço

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Simon Slavin
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 distribute

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread François
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" with a BOOLEAN field "FLAG". This table > > may contain u

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Igor Tandetnik
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 you are retrieving it.

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread François
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 6:23 AM, François >

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Igor Tandetnik
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 field if we > want to improve SELEC

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Simon Slavin
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 (l

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Igor Tandetnik
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 database > $dbh->query ("atta

Re: [sqlite] In memory strategy guide

2011-09-13 Thread Simon Slavin
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 > - dumpin

Re: [sqlite] Index on BOOLEAN field

2011-09-13 Thread Richard Hipp
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 or a bad practice to add an index

Re: [sqlite] changing compiled SQL statement

2011-09-13 Thread Richard Hipp
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, &stmt, 0); > sqlite3_step(stmt); > strcpy(a, (

[sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
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

[sqlite] Index on BOOLEAN field

2011-09-13 Thread François
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 ? P

[sqlite] In memory strategy guide

2011-09-13 Thread jerome moliere
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 the

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Steffen Mangold
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 wi

Re: [sqlite] changing compiled SQL statement

2011-09-13 Thread Baruch Burstein
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, &stmt, 0); sqlite3_step(stmt); strcpy(a, (char *)sqlite3_column_text(stmt, 0)); sqlite3_free(sql); // or s

Re: [sqlite] Minimal library size

2011-09-13 Thread Baruch Burstein
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 configure and make using the same options? > > No, the

[sqlite] changing compiled SQL statement

2011-09-13 Thread Baruch Burstein
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, &stmt, 0); sqlite3_step(stmt); strcpy(a, (char *)sqlite3_column_text(stmt, 0)); sqlite3_free(sql); // or s