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/
_
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
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
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
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
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
> 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
> • 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.
___
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
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
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
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
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.
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
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
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
> 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
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
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 (
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,
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
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
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:/
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?
>
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
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
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
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
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.
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
>
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
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
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
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
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
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, (
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
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
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
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
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
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
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
43 matches
Mail list logo
