[sqlite] Is this Sorting order right?

2008-05-12 Thread Mahalakshmi.m
Igor Tandetnik wrote >> I can't reproduce this particular problem. Here's the test I wrote: >> Figure out what you are doing differently. I too did the same using both UTF8 anf UTF16 .Its coming right for UTF8 but its wrong for UTF16. For both encoding I used the below procedure,

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-12 Thread Samuel Neff
Matthey, Thanks for making this change. We got latest from CVS today and configure/make worked great. One other issue we're having and are not sure about is we get a compiler error on sqlite3_profile and sqlite3_trace. We need to remove these two lines from the def file included with the

Re: [sqlite] Distributed transaction best practices

2008-05-12 Thread David Barrett
Ah, it sounds like we're building essentially the same thing -- mine is also for a financial setting. You're right, a mirror-replicating mode might be adequate, and is certainly simpler... But part of me is afraid that it leaves you vulnerable to failure conditions that a full two-phase

Re: [sqlite] Indexing virtual tables

2008-05-12 Thread Scott Hess
I'm not quite clear on your question - why wouldn't you just create any indices you need within the virtual-table implementation itself? Sort of like how fts uses SQLite tables to implement data-storage for the full-text index. -scott On Mon, May 5, 2008 at 10:13 AM, Aladdin Lampé <[EMAIL

[sqlite] Check the error message

2008-05-12 Thread Joanne Pham
Hi All, We have an application in C++ is up and running all the time to insert the data into the table. At the same time we have the shell script to dump the database to file at the end of the hour as defined below in this email. The question that I have is while the application is writting data

Re: [sqlite] Is this Sorting order right?

2008-05-12 Thread Igor Tandetnik
Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > What about Japanese Kanji? > Will sqlite sort all the Hiragana,Katakana,Kanji. > I am having some records with starting Unicode as follows. > > 6B4C Kanji 25 1 > 30A2 Katakana > > I am storing it using sqlite3_bind_text16(). > > But

Re: [sqlite] Is this Sorting order right?

2008-05-12 Thread Bob Ebert
Here's an example skeleton for a custom collation. (Using UTF8 encoding, change the declarations as necessary.) // declarations typedef int SQLiteCompare_t (void *, int, const void *, int, const void *); int MyCompare(void *userData, int str1Len, const UTF8 *str1, int

Re: [sqlite] Who is using SQLite prior to version 3.3.0?

2008-05-12 Thread D. Richard Hipp
On May 12, 2008, at 12:00 PM, Scott Baker wrote: > > What's the advantage to making all new DBs created format 4? I'm > against > breaking backwards compatibility. Please reread the post carefully. This is *not* a backwards compatibility break. Format 4 provides DESC index capability and a

Re: [sqlite] Who is using SQLite prior to version 3.3.0?

2008-05-12 Thread Scott Baker
D. Richard Hipp wrote: > Is there anybody still using a version of SQLite prior to version > 3.3.0 in a context where they might want to read a database file that > was created by the latest version of SQLite? > > The reason I ask is this: SQLite understands two slightly different > file

[sqlite] Is this Sorting order right?

2008-05-12 Thread Mahalakshmi.m
Mahalakshmi wrote > What about Japanese Kanji? > Will sqlite sort all the Hiragana,Katakana,Kanji. Igor Tandetnik wrote >> Not out of the box. You will have to implement a custom collation. Or, >> you can build SQLite with ICU support, then it >> will use ICU collation >> functions. Thanks a

[sqlite] Who is using SQLite prior to version 3.3.0?

2008-05-12 Thread D. Richard Hipp
Is there anybody still using a version of SQLite prior to version 3.3.0 in a context where they might want to read a database file that was created by the latest version of SQLite? The reason I ask is this: SQLite understands two slightly different file formats, format 1 and format 4.

Re: [sqlite] Distributed transaction best practices

2008-05-12 Thread Griggs, Donald
Hi David, Regarding: "What are the recommended "best practices" around using SQLite in a distributed scenario?" [two-phase commit, etc.] I trust that someone with some actual relevant knowledge will reply to your query later, but I imagine that many would say the the "recommend best practice"

[sqlite] Distributed transaction best practices

2008-05-12 Thread David Barrett
What are the recommended "best practices" around using SQLite in a distributed scenario? (I saw Shailesh's email in March; I'm considering building a two-phase commit layer atop SQLite nodes and looking for advice.) Clearly, this is a big topic including failover, recovery, load-balancing,