Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by pyuser583 on Thursday May 11, 2023 @04:59PM
(#35908318)
Does Postgres have an archive mode?
[ Parent
| on HN ]
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by dijit on Thursday May 11, 2023 @05:03PM
(#35908367)
If you say what you’re trying to actually achieve I can help with a solution, but asking if it supports an arbitrary feature is not going to get the answer you want because depending on what you’re actually using an archive table for, Postgres might have something already built in but it will almost assuredly not be exactly like an archive table storage type.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by pyuser583 on Friday May 12, 2023 @02:21AM
(#35912658)
Sorry, ARCHIVE is a MySQL storage engine. It supports only non destructive transactions: INSERT, REPLACE, and SELECT, but not DELETE and UPDATE.
It’s an excellent alternative to use a WORM drive when you’re trying to preserve everything (say, a list of financial transaction).
I’ve looked for something like this in Postgres (which I love!), but sadly it doesn’t seem supported.
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engi...
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by ants_a on Friday May 12, 2023 @03:59AM
(#35913304)
Why is revoking permissions to run deletes/updates not an option?
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by yencabulator on Friday May 12, 2023 @12:41PM
(#35918634)
Saying that REPLACE is non-destructive is a bit weird. Overwriting data is destructive, by definition -- and even if ARCHIVE is append-only underneath, it seems this use of REPLACE is very much a "logical overwrite", as there doesn't seem to be any kind of time travel view of the old state.
Also, you might be interested in Parquet, perhaps as seen through Delta Lake https://delta.io/ or Postgres Foreign Data Wrappers like https://github.com/adjust/parquet_fdw -- Delta Lake's simple "LSM of Parquet files in an object store" design is pretty sweet.