Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

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

Re: [sqlite] How do I get context in collation function?

> 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

Re: [sqlite] Phoronix SQLite benchmark Improvements - [was Re: SQLite behaviour on FreeBSD and KVM]

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.

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

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

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

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

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

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

[sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

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 ===

Re: [sqlite] Phoronix SQLite benchmark Improvements - [was Re: SQLite behaviour on FreeBSD and KVM]

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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] SQLite Encryption Extensions(SEE) for SQLite

-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

Re: [sqlite] How do I get context in collation function?

-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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] build db in memory then dump to a persistent file.

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

[sqlite] build db in memory then dump to a persistent file.

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

Re: [sqlite] How do I get context in collation function?

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

Re: [sqlite] SQLite Encryption Extensions(SEE) for SQLite

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

[sqlite] SQLite Encryption Extensions(SEE) for SQLite

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

Re: [sqlite] Need help To Get Started with SQLITE

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

Re: [sqlite] dump in-memory db to file in tcl

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

Re: [sqlite] Need help To Get Started with SQLITE

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

Re: [sqlite] How to use sqlite3_exec() to execute SQL command with Unicode text?

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