1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
Return-Path: <fireduck@gmail.com>
Received: from smtp1.linuxfoundation.org (smtp1.linux-foundation.org
[172.17.192.35])
by mail.linuxfoundation.org (Postfix) with ESMTPS id 80C3A89F
for <bitcoin-dev@lists.linuxfoundation.org>;
Thu, 22 Oct 2015 21:56:30 +0000 (UTC)
X-Greylist: whitelisted by SQLgrey-1.7.6
Received: from mail-wi0-f178.google.com (mail-wi0-f178.google.com
[209.85.212.178])
by smtp1.linuxfoundation.org (Postfix) with ESMTPS id C7F11166
for <bitcoin-dev@lists.linuxfoundation.org>;
Thu, 22 Oct 2015 21:56:29 +0000 (UTC)
Received: by wicfx6 with SMTP id fx6so7383957wic.1
for <bitcoin-dev@lists.linuxfoundation.org>;
Thu, 22 Oct 2015 14:56:28 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
h=mime-version:references:in-reply-to:from:date:message-id:subject:to
:content-type; bh=C3f/CP2OC18Lftjfrp/nBTWodIxkFLvm8qPpEouaTys=;
b=izUUkp0d2+p21riR+xGtmSbmgckcm22ibx4IN6HaNvV5+4mDurO7bLwWn70fMkK3Z5
DoE2PBhPvBxOtEKvtx61sNIpEvIb7I5DS+vT9+To5XQ6jy+6oEo6JgG8g98PMlEswrpX
aks73oDADgcd+ydak/QXoLyAsLEvAdDAYbdj1Lkg8oCJxH3hIehCXNPXusvlJ8QDX2FU
jyCrtoGlB8zWAbAXCBgXnzPHTSQca8dVYOYInxaItmQmCVr6zKMbvwuGBOS0ev9I0Xfk
X4MjSS5PAyLnSK69/Lk6qtn60pXw1txhaMsrx9++IuMXjXQGZ6boAh309StZ4wiULWpX
JkDw==
X-Received: by 10.28.131.84 with SMTP id f81mr36719wmd.57.1445550988436; Thu,
22 Oct 2015 14:56:28 -0700 (PDT)
MIME-Version: 1.0
References: <CADm_WcaLQzigsdmFR43JqiCYJVpmqkhVDc8GiVG=UN+Z1zg7+w@mail.gmail.com>
In-Reply-To: <CADm_WcaLQzigsdmFR43JqiCYJVpmqkhVDc8GiVG=UN+Z1zg7+w@mail.gmail.com>
From: =?UTF-8?B?Sm9zZXBoIEdsZWFzb24g4pGI?= <fireduck@gmail.com>
Date: Thu, 22 Oct 2015 21:56:18 +0000
Message-ID: <CA+ASnrH6VEawDmmD8FwQPFGYyJvsuicyTcHWxg-AU9RikwK8hg@mail.gmail.com>
To: Jeff Garzik <jgarzik@gmail.com>, Bitcoin development mailing list
<bitcoin-dev@lists.linuxfoundation.org>
Content-Type: multipart/alternative; boundary=001a11443d1c2bacbe0522b89116
X-Spam-Status: No, score=-2.7 required=5.0 tests=BAYES_00,DKIM_SIGNED,
DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW
autolearn=ham version=3.3.1
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
smtp1.linux-foundation.org
X-Mailman-Approved-At: Thu, 22 Oct 2015 22:41:32 +0000
Subject: Re: [bitcoin-dev] [patch] Switching Bitcoin Core to sqlite db
X-BeenThere: bitcoin-dev@lists.linuxfoundation.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: Bitcoin Development Discussion <bitcoin-dev.lists.linuxfoundation.org>
List-Unsubscribe: <https://lists.linuxfoundation.org/mailman/options/bitcoin-dev>,
<mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=unsubscribe>
List-Archive: <http://lists.linuxfoundation.org/pipermail/bitcoin-dev/>
List-Post: <mailto:bitcoin-dev@lists.linuxfoundation.org>
List-Help: <mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=help>
List-Subscribe: <https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev>,
<mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=subscribe>
X-List-Received-Date: Thu, 22 Oct 2015 21:56:30 -0000
--001a11443d1c2bacbe0522b89116
Content-Type: text/plain; charset=UTF-8
I have done a lot of recent work on local key value stores, mostly for a
java electrum server I am working on.
I'd suggest considering LMDB. One downside is that it is memory mapped so
32-bit systems that need over 2gb of storage are right out. Other than
that, it is quite fast and seems reliable in my testing.
On Thu, Oct 22, 2015 at 2:37 PM Jeff Garzik via bitcoin-dev <
bitcoin-dev@lists.linuxfoundation.org> wrote:
> Here is the beginnings of an implementation to replace leveldb with
> sqlite: https://github.com/jgarzik/bitcoin/tree/2015_sqlite
>
> It builds, but still needs work before passing tests.
>
> It was noted that leveldb is unmaintained, and this is part of researching
> alternatives that are maintained and reliable.
>
>
> _______________________________________________
> bitcoin-dev mailing list
> bitcoin-dev@lists.linuxfoundation.org
> https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev
>
--001a11443d1c2bacbe0522b89116
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">I have done a lot of recent work on local key value stores=
, mostly for a java electrum server I am working on.<div><br></div><div>I&#=
39;d suggest considering LMDB.=C2=A0 One downside is that it is memory mapp=
ed so 32-bit systems that need over 2gb of storage are right out.=C2=A0 Oth=
er than that, it is quite fast and seems reliable in my testing.</div><div>=
<br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Thu, Oct=
22, 2015 at 2:37 PM Jeff Garzik via bitcoin-dev <<a href=3D"mailto:bitc=
oin-dev@lists.linuxfoundation.org">bitcoin-dev@lists.linuxfoundation.org</a=
>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0=
0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Here =
is the beginnings of an implementation to replace leveldb with sqlite:=C2=
=A0<a href=3D"https://github.com/jgarzik/bitcoin/tree/2015_sqlite" target=
=3D"_blank">https://github.com/jgarzik/bitcoin/tree/2015_sqlite</a><div><br=
></div><div>It builds, but still needs work before passing tests.</div><div=
><br></div><div>It was noted that leveldb is unmaintained, and this is part=
of researching alternatives that are maintained and reliable.</div><div><b=
r></div><div><br></div></div>
_______________________________________________<br>
bitcoin-dev mailing list<br>
<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org" target=3D"_blank">=
bitcoin-dev@lists.linuxfoundation.org</a><br>
<a href=3D"https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev" =
rel=3D"noreferrer" target=3D"_blank">https://lists.linuxfoundation.org/mail=
man/listinfo/bitcoin-dev</a><br>
</blockquote></div>
--001a11443d1c2bacbe0522b89116--
|
