5 ms·
Ask HN: How to do open data for Postgres data?
I run an internet forum and I want to do "open data". So, should I publish a postgres dump? More thoughts:
- There are private forums that are currently unencrypted. I think I can either encrypt and include in the dump, or simply delete all private forums from the dump.
- Delete OAuth data.
- Possibly reset user settings to defaults that are stored in the database.
- There are auto increment user_ids and password hashes. Can I leave those in? It would be nice to leave those in so that the app still works.
- Anything else? Should the formatting of the data be something other than a postgres dump?
- thelastparadise 3y agoPublishing password hashes bad idea. Hopefully you salted those well.
- codingclaws 3y agoI haven't published anything yet. It seems like most hashing libs come with salt included. I'm using argon2. They look like this: $argon2i$v=19$m=4096,t=3,p=1$KfzPd+sotGTwIJieTapmuw$4AKHcr0JDQQwId4OcLtDBc7cv8tAfwSKFCMYU4opooQ