On Fri, Mar 20, 2020 at 17:00, Stephan Kulow wrote:

Am 20.03.20 um 16:42 schrieb Jan Engelhardt:

...

There was talk that Fedora wanted to switch to the sqlite backend. If that is preferable to ndb (and I would envision that the Fedora guys did their work on the numbers), would it not make sense to skip ndb altogether?

I doubt they ever looked at nbd - Fedora's plan to move to sqlite is much older than that. And we just as Fedora want to get rid of BDB - and the difference is that Fedora got a plan and Tumbleweed got a new backend :)

It is being done in Fedora 33 https://fedoraproject.org/wiki/Changes/Sqlite_Rpmdb It's not a plan anymore, it is going to be implemented LCP [Stasiek] https://lcp.world -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org

On Fri, Mar 20, 2020 at 12:01 PM Stephan Kulow wrote:

Am 20.03.20 um 16:42 schrieb Jan Engelhardt:

...

There was talk that Fedora wanted to switch to the sqlite backend. If that is preferable to ndb (and I would envision that the Fedora guys did their work on the numbers), would it not make sense to skip ndb altogether?

I doubt they ever looked at nbd - Fedora's plan to move to sqlite is much older than that. And we just as Fedora want to get rid of BDB - and the difference is that Fedora got a plan and Tumbleweed got a new backend :)

That's not even close to true. Fedora considered moving to NDB back in Fedora 24 (and later 25)[1]. The discussion that occurred on that topic[2] led to the integration of the LMDB backend[3], which was then dismissed after upstream promised to fix things for us[4] and then didn't after three years, so it's been removed[5]. The SQLite backend was developed after giving up on LMDB[6], and now Fedora is moving to SQLite in Fedora 33[7]. In conclusion, it was definitely considered, but it was rejected by the community, so Fedora went with a different option. [1]: https://fedoraproject.org/wiki/Changes/NewRpmDBFormat [2]: https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org/... [3]: https://github.com/rpm-software-management/rpm/commit/ed9de1992f5e1c23e8d8db... [4]: https://bugzilla.redhat.com/show_bug.cgi?id=1086784 [5]: https://github.com/rpm-software-management/rpm/commit/7de982ac0957c42f228b43... [6]: https://github.com/rpm-software-management/rpm/commit/07129b641b733ab30995c9... [7]: https://fedoraproject.org/wiki/Changes/Sqlite_Rpmdb -- 真実はいつも一つ！/ Always, there's only one truth! -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org

On Fri, Mar 20, 2020 at 2:26 PM Stephan Kulow wrote:

Am 20.03.20 um 17:15 schrieb Neal Gompa:

...

On Fri, Mar 20, 2020 at 12:01 PM Stephan Kulow wrote:

...

Am 20.03.20 um 16:42 schrieb Jan Engelhardt:

...

There was talk that Fedora wanted to switch to the sqlite backend. If that is preferable to ndb (and I would envision that the Fedora guys did their work on the numbers), would it not make sense to skip ndb altogether?

I doubt they ever looked at nbd - Fedora's plan to move to sqlite is much older than that. And we just as Fedora want to get rid of BDB - and the difference is that Fedora got a plan and Tumbleweed got a new backend :)

That's not even close to true. Fedora considered moving to NDB back in Fedora 24 (and later 25)[1].

I can't find the numbers Jan asked for in that thread.

I know that Panu has looked at the performance characteristics quite a bit, because a lot of the commits that have gone into the SQLite backend over the past few months have been specifically about that. Anecdotally, it appears faster on my rpm development machines on Rawhide than BDB... I've asked for some more specific numbers[0] in the thread about the SQLite rpmdb change[1]. [0]: https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org/... [1]: https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org/... -- 真実はいつも一つ！/ Always, there's only one truth! -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org

Am Freitag, 20. März 2020, 20:42:05 CET schrieb Jan Engelhardt:

On Friday 2020-03-20 20:27, Neal Gompa wrote:

...

...

...

...

Am 20.03.20 um 16:42 schrieb Jan Engelhardt:

...

There was talk that Fedora wanted to switch to the sqlite backend. If that is preferable to ndb (and I would envision that the Fedora guys did their work on the numbers), would it not make sense to skip ndb altogether?

I can't find the numbers Jan asked for in that thread.

I know that Panu has looked at the performance characteristics quite a bit, because a lot of the commits that have gone into the SQLite backend over the past few months have been specifically about that. Anecdotally, it appears faster on my rpm development machines on Rawhide than BDB...

Oh that was not my intent... I had hoped to convey "Did Fedora do some numbers on ndb <-> sqlite, and how were they?"

But now that's nugatory given the sqlite effort is apparently much older than ndb to begin with.

SQLite is pretty good suited for this kind of application, both performance and robustness wise. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org