From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <j@blockstream.io>
Received: from smtp1.linuxfoundation.org (smtp1.linux-foundation.org
	[172.17.192.35])
	by mail.linuxfoundation.org (Postfix) with ESMTPS id E55916C
	for <bitcoin-dev@lists.linuxfoundation.org>;
	Wed, 18 Nov 2015 00:07:15 +0000 (UTC)
X-Greylist: whitelisted by SQLgrey-1.7.6
Received: from mail-yk0-f172.google.com (mail-yk0-f172.google.com
	[209.85.160.172])
	by smtp1.linuxfoundation.org (Postfix) with ESMTPS id 1BD0C13A
	for <bitcoin-dev@lists.linuxfoundation.org>;
	Wed, 18 Nov 2015 00:07:15 +0000 (UTC)
Received: by ykfs79 with SMTP id s79so36961350ykf.1
	for <bitcoin-dev@lists.linuxfoundation.org>;
	Tue, 17 Nov 2015 16:07:14 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=blockstream_com.20150623.gappssmtp.com; s=20150623;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	bh=Bud4T526+uUK2+P73azbRVIg3Zu8wUXNkicCm+J3LZo=;
	b=nH80s5T1g3TIeb+LJHKxWeHYusEeBUdGEBNsCTN7PufQRs/ZVxHln8/OW50JHpqjSP
	jd7GFGOf3YUC4eG/vJbGGySghUlmBLEw6ufPNAIU/9FhQtS/zJSbprYat0GMIejDmgXc
	6kvjVOpJwDUXiz5SiVdH+pzMEvHLP37sTBMMuPek5H2d7KFkJo4jm8442PWYjj8KkF2J
	/68kL2vLk5arJXVpE001pQWqPu31fd08PRJSDbJaMSAoiIXzvxERP3Fcoh1LRKxGSJKp
	+RGpFzZsKm11liGPOH3ImlzIcEo/oKHbCbNJkvNoMLx0zfXC6guhtnCeK17cJv+Q4rjH
	pE4A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=1e100.net; s=20130820;
	h=x-gm-message-state:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:cc:content-type;
	bh=Bud4T526+uUK2+P73azbRVIg3Zu8wUXNkicCm+J3LZo=;
	b=X08+kdz/ghbZBM4fTTGZ1ed8IVeHAg50+fXrYZ64WY1e1AT2dcdGWPkHDREJJ62pbK
	R8JNylBGAy8zWnDo82Hbqrg6d17c500HEL2JQF7VPCvJSmFUcQ3SMQEXUWPPAZ94zfff
	Cc0iV+tS7JzBJVq8XgOZECMNDt+njlMn/mPRFCwrv2bIVd1vEABYuYrnF1f7XxPfMrSP
	6Gyf+rPJuxdPQj3VodJRaB47JjreybVq+bWkaS9ZZWQOqxq+Xjys2q8oGrhi8oRZkWzL
	sCHLhSrCHDkIoRFev6Ph1F97AePCulhd0og2MUAPDBqX9WXc+sh2lE4ntWDB789TS7c2
	+MDA==
X-Gm-Message-State: ALoCoQlWqsdLbAMuIfzQef2boRlXHXFlbwZmx1Sxd1WkvUp11q/4DSnd8+bhcyhYIJfVZT+wACg/
X-Received: by 10.129.159.5 with SMTP id w5mr3663515ywg.57.1447805234244; Tue,
	17 Nov 2015 16:07:14 -0800 (PST)
MIME-Version: 1.0
Received: by 10.31.3.193 with HTTP; Tue, 17 Nov 2015 16:06:44 -0800 (PST)
In-Reply-To: <562E6BC0.7010002@vt.edu>
References: <CADm_WcaLQzigsdmFR43JqiCYJVpmqkhVDc8GiVG=UN+Z1zg7+w@mail.gmail.com>
	<3162730.lzR74nC3xW@garp> <562E6BC0.7010002@vt.edu>
From: Jonathan Wilkins <j@blockstream.com>
Date: Tue, 17 Nov 2015 16:06:44 -0800
Message-ID: <CAL0tybca59rZ6KiyqY8iUFpH94Zw0T1o16OZ-uO0YYjRCo7vFw@mail.gmail.com>
To: Douglas Roark <joroark@vt.edu>
Content-Type: multipart/alternative; boundary=94eb2c0bd6a4b13e7d0524c56c7b
X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00,DKIM_SIGNED,
	DKIM_VALID,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: Wed, 18 Nov 2015 00:07:58 +0000
Cc: bitcoin-dev@lists.linuxfoundation.org
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: Wed, 18 Nov 2015 00:07:16 -0000

--94eb2c0bd6a4b13e7d0524c56c7b
Content-Type: text/plain; charset=UTF-8

Benchmarks for various DBs under discussion:
http://symas.com/mdb/microbench/


On Mon, Oct 26, 2015 at 11:06 AM, Douglas Roark via bitcoin-dev <
bitcoin-dev@lists.linuxfoundation.org> wrote:

> On 2015/10/23 03:30, Tom Zander via bitcoin-dev wrote:
> > On Thursday 22 Oct 2015 17:26:42 Jeff Garzik via bitcoin-dev wrote:
> >> It was noted that leveldb is unmaintained, and this is part of
> researching
> >> alternatives that are maintained and reliable.
> >
> > Apart from it being unmaintained, any links to what are problems with
> levelDB?
>
> While not exactly the most rigorous link,
> https://en.wikipedia.org/wiki/LevelDB#Bugs_and_Reliability seems like an
> okay place to start. One thing I can attest to is that, when Armory used
> LevelDB (0.8 - 0.92, IIRC), quite a few users had DB corruption issues,
> particularly on Windows. Even when a switch to LMDB occurred for 0.93,
> loads of complaints would come in from users whose LevelDB-based Core
> DBs would fail. I know that the guy who moved Armory over to LMDB would
> love to have more time in the day so that he could write a Core patch
> that does the same. It's a very sore spot for him.
>
> (FWIW, LMDB seems to work quite nicely, at least once you patch up the
> source a little bit. The latest version is also compatible with Core's
> cross-compiling scheme. I'd love to see it added to Core one day.)
>
> Doug
> _______________________________________________
> bitcoin-dev mailing list
> bitcoin-dev@lists.linuxfoundation.org
> https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev
>

--94eb2c0bd6a4b13e7d0524c56c7b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Benchmarks for various DBs under discussion:<br><a href=3D=
"http://symas.com/mdb/microbench/">http://symas.com/mdb/microbench/</a><br>=
<br></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Mon,=
 Oct 26, 2015 at 11:06 AM, Douglas Roark via bitcoin-dev <span dir=3D"ltr">=
&lt;<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org" target=3D"_bla=
nk">bitcoin-dev@lists.linuxfoundation.org</a>&gt;</span> wrote:<br><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex"><span class=3D"">On 2015/10/23 03:30, Tom Zander via=
 bitcoin-dev wrote:<br>
&gt; On Thursday 22 Oct 2015 17:26:42 Jeff Garzik via bitcoin-dev wrote:<br=
>
&gt;&gt; It was noted that leveldb is unmaintained, and this is part of res=
earching<br>
&gt;&gt; alternatives that are maintained and reliable.<br>
&gt;<br>
&gt; Apart from it being unmaintained, any links to what are problems with =
levelDB?<br>
<br>
</span>While not exactly the most rigorous link,<br>
<a href=3D"https://en.wikipedia.org/wiki/LevelDB#Bugs_and_Reliability" rel=
=3D"noreferrer" target=3D"_blank">https://en.wikipedia.org/wiki/LevelDB#Bug=
s_and_Reliability</a> seems like an<br>
okay place to start. One thing I can attest to is that, when Armory used<br=
>
LevelDB (0.8 - 0.92, IIRC), quite a few users had DB corruption issues,<br>
particularly on Windows. Even when a switch to LMDB occurred for 0.93,<br>
loads of complaints would come in from users whose LevelDB-based Core<br>
DBs would fail. I know that the guy who moved Armory over to LMDB would<br>
love to have more time in the day so that he could write a Core patch<br>
that does the same. It&#39;s a very sore spot for him.<br>
<br>
(FWIW, LMDB seems to work quite nicely, at least once you patch up the<br>
source a little bit. The latest version is also compatible with Core&#39;s<=
br>
cross-compiling scheme. I&#39;d love to see it added to Core one day.)<br>
<br>
Doug<br>
<div class=3D"HOEnZb"><div class=3D"h5">___________________________________=
____________<br>
bitcoin-dev mailing list<br>
<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org">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>
</div></div></blockquote></div><br></div>

--94eb2c0bd6a4b13e7d0524c56c7b--