[Rpm-maint] [rpm-software-management/rpm] RFE: proper database schema for sqlite db (aka sqlite rpmdb v2) (Issue #3229)

[Panu Matilainen]

The sqlite rpmdb as implemented in rpm >= 4.16 by yours truly would probably get you an F from any self-respecting database course, it's more like a hole-in-floor toilet train simple thing than a proper database schema. Idea was to get it working and then move to a fancier schema, but I ran out of steam and time, getting us away from Berkeley DB was more important at that point. And as it so often happens, the what was intended temporary is now in widespread use.

The sqlite database is a bit of a bloat, probably due to complete lack of normalization. It made things simple but maybe a bit too much. We should at least investigate moving to a more sophisticated design. It should be possible to preserve read-only backwards compatibility to the existing schema, and being entirely contained in a single file, backporting the fancier schema for read-write support to older releases eventually is not that far fetched either.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/rpm-software-management/rpm/issues/3229
You are receiving this because you are subscribed to this thread.

Message ID: <rpm-software-management/rpm/issues/3229 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rpm.org/pipermail/rpm-maint/attachments/20240802/9354a6fb/attachment.html>