HACKER Q&A
📣 codingclaws

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 Accepted Answer ✓
Publishing password hashes bad idea.

Hopefully you salted those well.