Re: [sqlite] SQLite4 key encoding -- Is it ever decoded?

: ¹ http://www.sqlite.org/src4/doc/trunk/www/design.wiki -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite4 key encoding -- Is it ever decoded?

to tell whether this decoding is ever necessary, though. -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Floating point numbers

which uses a base-100 binary-coded "centimal digit" representation, as described on the aforementioned Wiki page. Have you read it? -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

[sqlite] SQLite4 key encoding of numbers

.0101 * 1 = 101 Are these examples wrong on the Wiki page, or am I misunderstanding the encoding approach? Footnotes: ¹ http://www.sqlite.org/src4/doc/trunk/www/key_encoding.wiki -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

use it as "X" in the "2*X+0" formula, shouldn't we wind up with 198, or 0xC6? Likewise, for the second two examples, I'd expect 2*99+1 to yield 199, or 0xC7. (The later entry for has bytes 0xC7 and 0xC6, which match my expectation.) -- Steven E. Harris __

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

ared with one call to memcmp() for each pair of values, or does "value by value" mean simply that the concatenated values' bytes will be compared from left to right, with one call to memcmp() for the entire key? -- Steven E. Harris ___ sqlite-user

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

en the/ Thank you for documenting all of this. It's ugly for a good reason, which makes it beautiful at the same time. -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

en the/ Thank you for documenting all of this. It's ugly for a good reason, which makes it beautiful at the same time. -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

en the/ Thank you for documenting all of this. It's ugly for a good reason, which makes it beautiful at the same time. -- Steven E. Harris ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Understanding table-level locking in shared-cache mode

focused solely on writing in batches, which multiple threads looking to write to different tables concurrently, your response thus far says that shared-cache mode isn't going to help with that contention. Footnotes: ¹ http://code.google.com/p/sqlite-jdbc/source/browse/src/main

[sqlite] Understanding table-level locking in shared-cache mode

he.html [2] http://thread.gmane.org/gmane.comp.db.sqlite.general/52767 [3] http://article.gmane.org/gmane.comp.db.sqlite.general/52784 [4] http://thread.gmane.org/gmane.comp.db.sqlite.general/51381/focus=51885 [5] http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC -- Steven E. Harris

[sqlite] Re: Java wrapper for both windows and linux

Xavier RAYNAUD <[EMAIL PROTECTED]> writes: > I use native JNI libraries, and choose at runtime the native library > to open. (on eclipse, with OS-dependant fragments, it's easy to do) Can you elaborate on how you make this selection, and how you package the fragment? -- Stev

[sqlite] Re: Running multiple DDL statements in a batch (via JDBC)

, or on lines beginning with the comment "-- go" or something more deliberate. Or, going even further, putting each statement in a separate XML element, and letting an XML parser do the splitting. I'll be working on this problem this morning, so any more advice would be most welcome. Fo

[sqlite] Re: Running multiple DDL statements in a batch (via JDBC)

3_exec() interface executes every statement in the string > you hand it. Unfortunately this library has yet to wrap this function. Ouch. Footnotes: ¹ http://www.sqlite.org/capi3ref.html#sqlite3_prepare -- Steven E. Harris ---

[sqlite] Running multiple DDL statements in a batch (via JDBC)

s: ¹ http://www.zentus.com/sqlitejdbc/ -- Steven E. Harris - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: Atomically creating a database and bootstrapping its tables

Dennis Cote <[EMAIL PROTECTED]> writes: >if the user version is not zero ITYM "is zero". -- Steven E. Harris - To unsubscribe, send email to [EMAIL PROTECTED] -