Hacker News new | ask | show | jobs
by onetom 1471 days ago
Well, you can just get BLOBs out of an SQLite DB with SELECT. Also: https://www.sqlite.org/fasterthanfs.html

Not that performance or file size would matter in this case, BUT what using SQLite would allow is to use a single format for persisting all aspects of the password database, with immediate, programmatic, random access to all fields, including attachments.

But I also agree, that for this specific use-case, even SQLite is a bit of an overkill probably.

Finally, there is always https://www.passwordstore.org/ :)

1 comments

Right, but I feel we're having a miscommunication about the level of effort one should expend to recover the payloads; your mental model is that this:

    sqlite3 -noheader -newline '' export.db "select data from files where filename = 'my-file.bin'" > my-file.bin
is more user friendly than:

    unzip 1PasswordExport-ILESALYKVFDNJH3K24FEO3QRHM-20220611-100457.1pux files/my-file.bin