📅 Original date posted:2015-10-23
📝 Original message:-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> 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.
Nice work!
Although not sure if we should focus directly on sqlite4 (could be
optional with a configure flag and a subtree [until stable], sqlite3
supported over depends).
Also i personally would recommend to not implement it as a
replacement, instead, support multiple backends (wrapper header /
different wrapper implementations [leveldb / sqlite3 / sqlite4]). But
– agreed – should not be the focus, but a nice additional flexibility
if it not require much more work.
And – in theory – multiple database back-ends would allow migration.
Before investigating to deep, i think we need a dbwrapper bench tool
that represents our needs and our style how we hit the database.
Gavins recently added bench target / bench environment could be used
for that.
/jonas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBAgAGBQJWKdlgAAoJECnUvLZBb1Ps7J8P/2L6215fd0rWGv5uvbLSnQvm
hy1T2AaOfH5HXd2m95icaKYk+ugvQAL80Q/67YwZbPLsT4fErgegw8n75Z6nh/Pc
OJ1EtAvD+Kc/Vm0Wcvt421HXwnm4f+j+8eoEvpG6DdC8gfIG+efhM7DljeNbPFrA
ieNe7XrQ1EZ29lMzpQv0nx3bi6tUHOWuazk82B6vnK49MjH7nrUFipcc18nXbSpM
ZKjQakXmfqIBG8QP9ZUYUlW4aoG0oaOoZnGjQA2LeXBJpIPLpE/WPg0XaXubC+No
232CJNtNyUOmjkb2qbep6vSYgqGJNy1HbCU5y3qooxJhFnKdo63CQsyJKSpL/ssi
0lWraNxjbacxsBn+63In3wEkj02orwm2zTO4I77wCrZmJgpvBFb9bZWTeL8DCYSG
DTkZoKWEK74xvm+dNpEWXK9Lm1ltfyhPdaFeMoRDub4w2uuYlk3KuD8Vdy81HYJb
sak8FbkiWw9xx2OP9+G56Arf9W6mnJ3YHJGrY4SXeRAfuNYwGFHIGt6I1JobuHy4
VWmcHuooz/Q9JLUu3Rr3HsEdXYgCmgmWuzTgWG+Hx92Y6XLWV5pOX+vFRO6J5fSm
aTYPD4GsTM3FROXw5ezlXJ+2y1+ITzmrfm03fEDQvoIyH0TwBqBc5sMBBkma5DDR
0HUthPHWCD+AxbBPbRVa
=CUMX
-----END PGP SIGNATURE-----
Jonas Schnelli [ARCHIVE] /
npub1nf…3dtxs
2023-06-07 17:43:52
in reply to nevent1q…3umd
Author Public Key
npub1nfrrurat393mqymf3s26pujyn5vujlem3pzcukr5p9d4qpklngxq43dtxsPublished at
2023-06-07 17:43:52Event JSON
{
"id": "5d2ec8d0702aabb3acf952632e08c078ee052bcfa8c052221db01481ec1e1f9a",
"pubkey": "9a463e0fab8963b013698c15a0f2449d19c97f3b88458e5874095b5006df9a0c",
"created_at": 1686159832,
"kind": 1,
"tags": [
[
"e",
"09f07bc0e1ba48805727ba44deb034dc283bfadbc39b90714e52ddd0cad07414",
"",
"root"
],
[
"e",
"e70cc3bbb968f2361ca8b77e7b8f99f3fb3b9b613f141e6aed8080f5b3ffce88",
"",
"reply"
],
[
"p",
"00685efade6198fb1c4af79347bcaafcac5dc9146f0bf11eff4ae3ee55087033"
]
],
"content": "📅 Original date posted:2015-10-23\n📝 Original message:-----BEGIN PGP SIGNED MESSAGE-----\nHash: SHA1\n\n\u003e Here is the beginnings of an implementation to replace leveldb\n\u003e with sqlite: https://github.com/jgarzik/bitcoin/tree/2015_sqlite\n\u003e \n\u003e It builds, but still needs work before passing tests.\n\nNice work!\n\nAlthough not sure if we should focus directly on sqlite4 (could be\noptional with a configure flag and a subtree [until stable], sqlite3\nsupported over depends).\n\nAlso i personally would recommend to not implement it as a\nreplacement, instead, support multiple backends (wrapper header /\ndifferent wrapper implementations [leveldb / sqlite3 / sqlite4]). But\n– agreed – should not be the focus, but a nice additional flexibility\nif it not require much more work.\nAnd – in theory – multiple database back-ends would allow migration.\n\nBefore investigating to deep, i think we need a dbwrapper bench tool\nthat represents our needs and our style how we hit the database.\nGavins recently added bench target / bench environment could be used\nfor that.\n\n/jonas\n-----BEGIN PGP SIGNATURE-----\nVersion: GnuPG v1\n\niQIcBAEBAgAGBQJWKdlgAAoJECnUvLZBb1Ps7J8P/2L6215fd0rWGv5uvbLSnQvm\nhy1T2AaOfH5HXd2m95icaKYk+ugvQAL80Q/67YwZbPLsT4fErgegw8n75Z6nh/Pc\nOJ1EtAvD+Kc/Vm0Wcvt421HXwnm4f+j+8eoEvpG6DdC8gfIG+efhM7DljeNbPFrA\nieNe7XrQ1EZ29lMzpQv0nx3bi6tUHOWuazk82B6vnK49MjH7nrUFipcc18nXbSpM\nZKjQakXmfqIBG8QP9ZUYUlW4aoG0oaOoZnGjQA2LeXBJpIPLpE/WPg0XaXubC+No\n232CJNtNyUOmjkb2qbep6vSYgqGJNy1HbCU5y3qooxJhFnKdo63CQsyJKSpL/ssi\n0lWraNxjbacxsBn+63In3wEkj02orwm2zTO4I77wCrZmJgpvBFb9bZWTeL8DCYSG\nDTkZoKWEK74xvm+dNpEWXK9Lm1ltfyhPdaFeMoRDub4w2uuYlk3KuD8Vdy81HYJb\nsak8FbkiWw9xx2OP9+G56Arf9W6mnJ3YHJGrY4SXeRAfuNYwGFHIGt6I1JobuHy4\nVWmcHuooz/Q9JLUu3Rr3HsEdXYgCmgmWuzTgWG+Hx92Y6XLWV5pOX+vFRO6J5fSm\naTYPD4GsTM3FROXw5ezlXJ+2y1+ITzmrfm03fEDQvoIyH0TwBqBc5sMBBkma5DDR\n0HUthPHWCD+AxbBPbRVa\n=CUMX\n-----END PGP SIGNATURE-----",
"sig": "ee4c30748f24d0a58404c376e112d20619c10f2accc723e869340aa0dd7835c18fa7752d490d1dacbb37dac2fcf9f76fd5882462c057e1fc47c80ee7500e2116"
}