Re: [sqlite] Clone SQLite databases
Could there be a different page_size, resulting in differing amounts of 'wasted' space? Check with "PRAGMA page_size;" or sqlite3_analyzer program. Thanks Steve csabi81 wrote: > I have made .dump for each database, original and clone, and saved into > separated files. Than compare them. > Differences are in INSERT INTO entries, in the clone database those entries > are missing which I did not copy from the original. But the CREATE TABLE, > CREATE INDEX, CREATE TRIGGER Commands are the same 100% > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Endianness
But please don't do this! The resulting database files will NOT be sqlite database files. You won't be able to look at them on other systems (or even using the 'real' library on the same system). Thanks Steve Shane Harrelson wrote: > If you're really serious about storing your data in a "native" form to > reduce read/write overhead for handling endian-ness (and I think this is > going to be more trouble than it's worth) then you can look at replacing the > following functions in vdbeaux.c: > > ** sqlite3VdbeSerialType() > ** sqlite3VdbeSerialTypeLen() > ** sqlite3VdbeSerialLen() > ** sqlite3VdbeSerialPut() > ** sqlite3VdbeSerialGet() > > You can probably get by with just replacing put/get which for integer and > real types break up the value into a series of bytes and read/write those > to/from a passed buffer in big-endian order. > > HTH. > -Shane > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is quicker?
D. Richard Hipp wrote: > On Jun 4, 2008, at 7:13 AM, Derrell Lipman wrote: > >> On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]> >> wrote: >> >>> Let me strongly reiterate that you look into using the new R-Tree >>> virtual table available for SQLite. R-Trees are specifically >>> designed >>> to do exactly the kind of query you are asking to do. See >>> >>>http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/README&v=1.2 >>> >> The README contains this text: >> >> CREATE VIRTUAL TABLE USING rtree() >> >>For example: >> >> CREATE VIRTUAL TABLE boxes USING rtree(boxno, xmin, xmax, ymin, >> ymax); >> CREATE VIRTUAL TABLE boxes USING rtree(1, 1.0, 3.0, 2.0, 4.0); >> >> Is that last line supposed to be >> INSERT INTO boxes VALUES (1, 1.0, 3.0, 2.0, 4.0); >> ? > > Yes. > http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/README&v=1.3 > > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > In the same document: "For each pair of real values, the first (leftmost) must be less than or greater than the second." should presumable read "less than or equal to" Thanks SteveK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users