Re: [sqlite] SQLite 4

[Simon Slavin]

On 26 Jul 2016, at 8:02am, sanhua.zh  wrote:

> Is SQLite 4 in a developing status?

You are correct.  Please do not use SQLite 4 for serious work.  At the moment 
it is just a way for the developers to experiment with ideas for a future 
version of SQLite.  Everything about it may change before it is released.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 4

[sanhua.zh]

Hello,
I found this pagewhich is about SQLite 4. But there are no download page in it 
and the most recently update is 2015.08.15. Is SQLite 4 in a developing status?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Gabriel Corneanu]

The problem is, it is not ported to Windows as all...
I made a quick (and dirty) port of lsm_unix, but other things (e.g. the 
environment) are also missing.


Gabriel

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Cory Nelson]

On Tue, Feb 19, 2013 at 3:25 AM, Gabriel Corneanu
 wrote:
> I understand, but I wanted to make a performance comparison. I read some
> good news, but I need to test it for my case.
> Am in a situation where the bottleneck is the CPU (sqlite), not IO.
> Therefore I'm very interested in an early idea about performance.
> Even if it's not ready, I could at least prepare it better for a later
> switch.

A daily amalgamation would be pretty cool. I'd love to start playing
around with LSM.

-- 
Cory Nelson
http://int64.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Gabriel Corneanu]

I understand, but I wanted to make a performance comparison. I read some  
good news, but I need to test it for my case.
Am in a situation where the bottleneck is the CPU (sqlite), not IO.  
Therefore I'm very interested in an early idea about performance.
Even if it's not ready, I could at least prepare it better for a later  
switch.


Gabriel

--
Using Opera's revolutionary email client: http://www.opera.com/mail/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Dan Kennedy]

On 02/19/2013 03:50 PM, Gabriel Corneanu wrote:

I am also on final steps of a new project, and I would love to compare
sqlite4 before release (the data files will be public, therefore a later
switch would be problematic).
Is there any chance to get it for windows? I usually need the dll.
Last time I could not compile it (mingw), there are some memory mapping
operations only for unix/linux (lsm_unix).
They have equivalents for windows, so it should be possible to port it.



Realistically speaking it's not ready to be used for that sort of
thing. There are probably even (minor) file format changes still to
come.

Dan.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Gabriel Corneanu]

I am also on final steps of a new project, and I would love to compare  
sqlite4 before release (the data files will be public, therefore a later  
switch would be problematic).

Is there any chance to get it for windows? I usually need the dll.
Last time I could not compile it (mingw), there are some memory mapping  
operations only for unix/linux (lsm_unix).

They have equivalents for windows, so it should be possible to port it.

Thanks,
Gabriel

--
Using Opera's revolutionary email client: http://www.opera.com/mail/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Eduardo Morras]

On Tue, 12 Feb 2013 10:26:09 -0600
"Marc L. Allen"  wrote:

> I'm sorry if this isn't the right group, but an earlier message mentioned it, 
> and I found some stuff on the SQLite website.
> 

My answer may be a bit off topic, but if you search the subdomains under 
sqlite.org you can find more stuff like unql.sqlite.org

Go here 
http://www.magic-net.info/dns-and-ip-tools.dnslookup?subd=sqlite.org&Search+subdomains=Find+subdomains
 and check other subdomains, some works others not.

> Although I've had a long-standing project to incorporate SQLite into our 
> product (and have done so), it has never been deployed.  I like the looks of 
> SQLite 4, but have not been able to find any proposed release schedules.
> 
> Can someone point me to an appropriate page or let me know if an official 
> release is planned anytime soon?  Our platform is proprietary, so I'll need 
> to be incorporating source, not binaries.
> 
> Thanks,
> 
> Marc
> ---   ---
Eduardo Morras 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Richard Hipp]

On Tue, Feb 12, 2013 at 11:34 AM, Marc L. Allen  wrote:

> Thanks.  Any clue on whether we'll use an amalgamation as with SQLite4 or
> direct sources?
>

Amalgamation.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

[Marc L. Allen]

Thanks.  Any clue on whether we'll use an amalgamation as with SQLite4 or 
direct sources?

Marc

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Richard Hipp
Sent: Tuesday, February 12, 2013 11:32 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite 4

On Tue, Feb 12, 2013 at 11:26 AM, Marc L. Allen  wrote:

> I'm sorry if this isn't the right group, but an earlier message 
> mentioned it, and I found some stuff on the SQLite website.
>
> Although I've had a long-standing project to incorporate SQLite into 
> our product (and have done so), it has never been deployed.  I like 
> the looks of SQLite 4, but have not been able to find any proposed release 
> schedules.
>
> Can someone point me to an appropriate page or let me know if an 
> official release is planned anytime soon?  Our platform is 
> proprietary, so I'll need to be incorporating source, not binaries.
>

There is no planned release schedule for SQLite4 at this time.  It seems to be 
working pretty well, but it is not nearly as well-tested as is SQLite3.
And there are more interface changes that we want to make before it goes into 
any kind of official release.
--
D. Richard Hipp
d...@sqlite.org
___
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] SQLite 4

[Richard Hipp]

On Tue, Feb 12, 2013 at 11:26 AM, Marc L. Allen  wrote:

> I'm sorry if this isn't the right group, but an earlier message mentioned
> it, and I found some stuff on the SQLite website.
>
> Although I've had a long-standing project to incorporate SQLite into our
> product (and have done so), it has never been deployed.  I like the looks
> of SQLite 4, but have not been able to find any proposed release schedules.
>
> Can someone point me to an appropriate page or let me know if an official
> release is planned anytime soon?  Our platform is proprietary, so I'll need
> to be incorporating source, not binaries.
>

There is no planned release schedule for SQLite4 at this time.  It seems to
be working pretty well, but it is not nearly as well-tested as is SQLite3.
And there are more interface changes that we want to make before it goes
into any kind of official release.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 4

[Marc L. Allen]

I'm sorry if this isn't the right group, but an earlier message mentioned it, 
and I found some stuff on the SQLite website.

Although I've had a long-standing project to incorporate SQLite into our 
product (and have done so), it has never been deployed.  I like the looks of 
SQLite 4, but have not been able to find any proposed release schedules.

Can someone point me to an appropriate page or let me know if an official 
release is planned anytime soon?  Our platform is proprietary, so I'll need to 
be incorporating source, not binaries.

Thanks,

Marc

--
**
* *  *
* Marc L. Allen   *  "... so many things are *
* *  possible just as long as you*
* Outsite Networks, Inc.  *  don't know they're impossible." *
* (757) 853-3000 #215 *  *
* *  *
* mlal...@outsitenetworks.com *   -- 
The Phantom Tollbooth   *
* *  *
**

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 4 bytes write

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Julian Qian wrote:
> I would like us to understand the write patterns of Sqlite. 

It looks like the 4 bytes is some sort of header for each database page.
 Your trace seems to be of the Android emulator rather than your
application (there are no syncs or fcntl).

If you want to see why each write happens then attach to the process
using a debugger and put a breakpoint on the relevant VFS write routine
(eg unixWrite for Unix/Linux systems).  Examining the backtrace will
then tell you which code is responsible.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIq2/OmOOfHg372QQRAh8JAJ4qIC6pVttNXdoykgNmw+jLz7kI0ACfboOZ
DpaOfJx08KVNMRUZSnnx3vE=
=QFie
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite 4 bytes write

[Julian Qian]

I would like us to understand the write patterns of Sqlite. . That
write pattern happens first to the journal then to the database. I
found a lot of 4 byte writes.

What are these 4 byte writes and can the be avoided? I would also like
data on the write patterns for a 1k,2k,128k, and 256k writes to a
database. Is there some flags we can set in Sqlite to less these
writes?

below is the write log of 3.5.9
[pid  3452] lseek(54, 0, SEEK_SET)  = 0
[pid  3452] write(54, "??\5?
?c?\0\0\0\0iܷ?\0\0\4?\0\0\2\0\0\0\10\0ttac"..., 512) = 512
[pid  3452] lseek(54, 512, SEEK_SET)= 512
[pid  3452] write(54, "\0\0\0\7", 4)= 4
[pid  3452] lseek(54, 516, SEEK_SET)= 516
[pid  3452] write(54,
"\n\0\0\0\22\6K\0\7\227\7q\7E\6?\7?\6?\7?\6?\7?\7$\6K\6"..., 1024) =
1024
[pid  3452] lseek(54, 2564, SEEK_SET)   = 2564
[pid  3452] write(54, "iܸ?", 4)= 4
[pid  3452] lseek(54, 2568, SEEK_SET)   = 2568
[pid  3452] write(54, "\0\0\0\6", 4)= 4
[pid  3452] lseek(54, 2572, SEEK_SET)   = 2572
[pid  3452] write(54,
"\r\7\212\0\22\4C\2\7?\7r\0070\6?\6?\6\234\6l\7`\6Q\4?\7"..., 1024) =
1024
[pid  3452] lseek(54, 4620, SEEK_SET)   = 4620
[pid  3452] write(54, "iܹ=", 4)= 4
[pid  3452] lseek(54, 4624, SEEK_SET)   = 4624
[pid  3452] write(54, "\0\0\0\1", 4)= 4
[pid  3452] lseek(54, 4628, SEEK_SET)   = 4628
[pid  3452] write(54, "SQLite format 3\0\10\0\1\1\0@
\0\0\6\r\0\0\0\0"..., 1024) = 1024
[pid  3452] lseek(54, 6676, SEEK_SET)   = 6676
[pid  3452] write(54, "iܷ?", 4)= 4
[pid  3452] close(55)   = 0
[pid  3452] lseek(54, 8, SEEK_SET)  = 8
[pid  3452] write(54, "\0\0\0\3", 4)= 4
[pid  3452] lseek(29, 0, SEEK_SET)  = 0
[pid  3452] write(29, "SQLite format 3\0\10\0\1\1\0@
\0\0\6\16\0\0\0\0"..., 1024) = 1024
[pid  3452] lseek(29, 10240, SEEK_SET)  = 10240
[pid  3452] write(29,
"\r\7\212\0\22\4C\2\7?\7r\0070\6?\6?\6\234\6l\7`\6Q\4?\7"..., 1024) =
1024
[pid  3452] lseek(29, 12288, SEEK_SET)  = 12288
[pid  3452] write(29,
"\n\0\0\0\22\6K\0\7\227\7q\7E\6?\7?\6?\7?\6?\7?\7$\6K\6"..., 1024) =
1024
[pid  3452] close(54)   = 0
[pid  3452] lseek(29, 24, SEEK_SET) = 24

for 3.6:
[pid   211] 
open("/data/data/com.google.android.providers.gmail/databases/[EMAIL 
PROTECTED]",
O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE|O_NOFOLLOW, 0644) = 55
[pid   211] open("/data/data/com.google.android.providers.gmail/databases",
O_RDONLY|O_LARGEFILE) = 56
[pid   211] lseek(55, 0, SEEK_SET)  = 0
[pid   211] write(55, "ÙÕ\5ù
¡c×\0\0\0\0\221FßÈ\0\0\2~\0\0\2\0\0\0\4\0\0\0\0\0"..., 512) = 512
[pid   211] open("/dev/ashmem", O_RDWR|O_LARGEFILE) = 58
[pid   211] close(58)   = 0
[pid   211] open("/dev/ashmem", O_RDWR|O_LARGEFILE) = 58
[pid   211] close(58)   = 0
[pid   211] open("/dev/ashmem", O_RDWR|O_LARGEFILE) = 58
[pid   211] close(58)   = 0
[pid   211] writev(3, [{"\3", 1}, {"gmail-ls\0", 9}, {"Starting
purging messages. Oldes"..., 78}], 3) = 88
[pid   211] open("/dev/ashmem", O_RDWR|O_LARGEFILE) = 58
[pid   211] writev(3, [{"\3", 1}, {"gmail-ls\0", 9}, {"Finished
purging messages \0", 27}], 3) = 37
[pid   211] close(58)   = 0
[pid   211] close(56)   = 0
[pid   211] close(55)   = 0
[pid   211] lseek(39, 24, SEEK_SET) = 24
[pid   211] open("/dev/ashmem", O_RDWR|O_LARGEFILE) = 55
[pid   211] lseek(39, 24, SEEK_SET) = 24
[pid   211] close(55)   = 0
[pid   211] writev(3, [{"\3", 1}, {"gmail-ls\0", 9}, {"considering
sending notification"..., 102}], 3) = 112
[pid   211] lseek(39, 24, SEEK_SET) = 24
[pid   211] 
open("/data/data/com.google.android.providers.gmail/databases/[EMAIL 
PROTECTED]",
O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE|O_NOFOLLOW, 0644) = 55
[pid   211] open("/data/data/com.google.android.providers.gmail/databases",
O_RDONLY|O_LARGEFILE) = 56
[pid   211] lseek(55, 0, SEEK_SET)  = 0
[pid   211] write(55, "ÙÕ\5ù
¡c×\0\0\0\0É\25á?\0\0\2~\0\0\2\0\0\0\4\0\0\0\0\0"..., 512) = 512
[pid   211] lseek(55, 512, SEEK_SET)= 512
[pid   211] write(55, "\0\0\0\17", 4)   = 4
[pid   211] lseek(55, 516, SEEK_SET)= 516
[pid   211] write(55,
"\n\0\0\0\2\3Å\0\3â\3Å\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 1024) =
1024
[pid   211] lseek(55, 1540, SEEK_SET)   = 1540
[pid   211] write(55, "É\25á?", 4)  = 4
[pid   211] lseek(55, 1544, SEEK_SET)   = 1544
[pid   211] write(55, "\0\0\0\16", 4)   = 4
[pid   211] lseek(55, 1548, SEEK_SET)   = 1548
[pid   211] write(55,
"\r\0\0\0\2\3¾\0\3à\3¾\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 1024) =
1024
[pid   211] lseek(55, 2572, SEEK_SET)   = 2572
[pid   211] write(55, "É\25á?", 4)  = 4
[pid   211] lseek(55, 2576, SEEK_SET)   = 2576
[pid   211] write(55, "\0\0\0\1", 4)= 4
[pid   211] lseek(55, 2580, SEEK_SET)   = 2580
[pid   211] write(55, "SQLite format 3\0\4\0\1\1\0@
\0\0\34t\0\0\0\0"..., 1024) = 1024
[pid   211] lseek(55, 3604, SEEK_SET)   = 3604
[pid   211] write(55, "É\25á?", 4)  = 4
[pid   211] close(56)   = 0