Hi George,
Thanks for the link
(http://www.codeproject.com/KB/database/CppSQLite.aspx) that you gave
me, it really help me to start progamming in C++.
Ok, read the code in http://www.sqlite.org/quickstart.html, but it
looks like no SEE implementation.
#include
#include
static int callback(vo
> BTW while wandering in the 3.6.18 amalgamation source looking at how
> allocation failures are handled, I found a number of sqlite3_malloc
> whose return values are used (written to) head first without prior
> checking against 0.
We know there are still some of these cases in the fts3 code. If y
On 4 Oct 2009, at 3:26am, Roger Binns wrote:
> Matthew Tippett wrote:
>> Any takers?
>
> It isn't clear what you want. It mostly appears to be people to fix
> the
> Phoronix test suite. That is really their problem!
>
> SQLite already includes various speed tests.
I like this as a response.
Simon Slavin writes:
> On 4 Oct 2009, at 3:08am, Andi Suhandi wrote:
>
> > Since SQLite support C++, I have to ask these questions
>
> You could ask somewhere else.
>
> SQLite supports C. It does not support C++, it just doesn't violate
> it. There is nothing in SQLite that takes any
On 4 Oct 2009, at 3:08am, Andi Suhandi wrote:
> Since SQLite support C++, I have to ask these questions
You could ask somewhere else.
SQLite supports C. It does not support C++, it just doesn't violate
it. There is nothing in SQLite that takes any advantage of anything
the '++' adds: SQLi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Tippett wrote:
> Any takers?
It isn't clear what you want. It mostly appears to be people to fix the
Phoronix test suite. That is really their problem!
SQLite already includes various speed tests. For other people the only
benchmark that i
Well,
Since SQLite support C++, I have to ask these questions
Regards,
Andi
On 10/4/09, Simon Slavin wrote:
>
> On 4 Oct 2009, at 2:12am, Andi Suhandi wrote:
>
>> Are there anyone can give simple sample code in Visual C++,
>> implementation SQLite with and without SEE ? SO I can compare it ?
On 4 Oct 2009, at 2:12am, Andi Suhandi wrote:
> Are there anyone can give simple sample code in Visual C++,
> implementation SQLite with and without SEE ? SO I can compare it ?
> Starting from :
> 1. how to connect to database
> 2. query
> 3. close the database
Which is it you are: someone who k
Dear All,
Thank you to the member for fast reply
Are there anyone can give simple sample code in Visual C++,
implementation SQLite with and without SEE ? SO I can compare it ?
Starting from :
1. how to connect to database
2. query
3. close the database
Regards,
Andi
===
Software
Any takers?
Matt
Original Message
Subject: [sqlite] Phoronix SQLite benchmark Improvements - [was Re:
SQLite behaviour on FreeBSD and KVM]
From: Matthew Tippett
To: General Discussion of SQLite Database
Date: 09/29/2009 10:00 PM
> Relabling to provide focus on this thread t
Igor,
´¯¯¯
>It seems fairly easy to me to
>implement the kind of collation you describe using only a fixed amount
>of extra memory.
`---
I didn't say it was impossible. Just that in this case, the code gets
slowed down in convoluted loops everywhere. Also I feel that clear,
straightforward cod
Roger,
´¯¯¯
>There is now a ticket for this issue:
`---
Thanks, not high priority but useful someday.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> I'm pretty sure the license
Rather than speculating, the SEE usage and license is documented at
http://www.hwaci.com/sw/sqlite/see.html
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jean-Christophe Deschamps wrote:
> Really, SQLite doesn't have emergency brakes?
Not for collations, just user defined functions. It is a bit of a pain to
deal with. I have the same issue in APSW but at least I can still report a
Python level error
Jean-Christophe Deschamps wrote:
>> Can't you preallocate sufficient memory at the time the collation is
>> created?
>
> This is for getting unaccented copies of input strings, which
> sometimes involves expansion of a single character into 2 to 5 or 6
> simpler characters. I use this for offering
Igor,
>Can't you preallocate sufficient memory at the time the collation is
>created?
Unfornately I can't do that: it would mean I place a maximum size on a
work space allocated at creation for manipulating user strings, which
is taboo in my view.
This is for getting unaccented copies of inpu
Jean-Christophe Deschamps wrote:
>> It would be best, of course, to write your collation function in
>> such a way that it can't fail.
>
> Certainly, in a perfect world, but I'm afraid I forcably need small
> chunks of memory, whose allocation could possibly fail "ungracefully"
> (?).
Can't you pr
On 3 Oct 2009, at 9:50pm, George Hartzell wrote:
> One of the tables has almost 19 million rows. This is the table on
> which I build my 2-D rtree index.
>
> I read the data from tab delimited mysql dumps into the basic tables,
> then run a query that pulls the data I want to rtree-index out of
Igor,
>I'm not sure where you are seeing this. The collation function doesn't
>have a sqlite3* parameter
No, of course you're right (surprised ? ;-) ): I was doing more things
than my personal stack could hold. Sorry for that. Great age, slow
multitask...
>SQLite doesn't seem prepared to han
Hi all,
I use an SQLite database w/ the rtree extension to hold information
about genetic polymorphism (snp's), based on UCSC's mapping work and
their mysql table dumps. My database is write-once, read from then
on.
One of the tables has almost 19 million rows. This is the table on
which I bui
Jean-Christophe Deschamps wrote:
> I need to have a context* for use inside a collation function (to
> report possible memory allocation errors for instance), but the spec
> for collation doesn't give me a context pointer, only an
> sqlite3*.
I'm not sure where you are seeing this. The collation f
If there were problems, then Dr. H wouldn't sell it ...
The SEE extensions add a couple new API calls, specifically sqlite_key() and
rekey() functions to specify the password (or change the password) for an
encrypted database. Other than that, your code remains the same.
I'm pretty sure the lice
Dear All
Hi, I was using sqlite as a database for my program. My program is
based on C++ . Well, for my next project I want encryt the database,
and I read about SQLite Encryption Extensions(SEE).
My questions :
1. Are there problems if I add SEE ?
2. Do I have change a lot in my program ?
3. How
Thanks. Obviously it's going to take awhile to remember my C.
Jack
- Original Message -
From: "Dan Kennedy"
To: "General Discussion of SQLite Database"
Sent: Saturday, October 03, 2009 1:05 PM
Subject: Re: [sqlite] Need help To Get Started with SQLITE
>
> On Oct 4, 2009, at 12:01 AM
Ned Fleming wrote:
> Is it possible to dump an in-memory sqlite database (or table?) to a
> file from within Tcl?
>
> I create it like so:
>
> sqlite3 dbFireData :memory:
>
> and insert a bunch of records, and then commit.
Is there reason not to attach a file (old or new), and either
create
On Oct 4, 2009, at 12:01 AM, jack wrote:
> I just setting out to learn how to use sqlite3 (3.6.18). Obviouly
> I'm missing some very important points.
>
> The very simple test app below is to open (and create) an sql
> datbase then close it
>
> Using windows XP. Using a precompiled .LIB. I
I just setting out to learn how to use sqlite3 (3.6.18). Obviouly I'm missing
some very important points.
The very simple test app below is to open (and create) an sql datbase then
close it
Using windows XP. Using a precompiled .LIB. I confirmed the version number from
the command line.
It
Hi all,
I need to have a context* for use inside a collation function (to
report possible memory allocation errors for instance), but the spec
for collation doesn't give me a context pointer, only an
sqlite3*. This later guy is defined as an "opaque" structure, so I'm a
little scared to misu
Thank you for the link.
Then I started solving the callback problem. After a bit research, I found
out that I could end up with a new exec() function. So I took the original
exec() and modified it. It's working, no guaratee :-D
int sqlite3_exec16(
sqlite3 *db,/* The database on
29 matches
Mail list logo