Discourse Database with Dummy Data

AI-generated summary

gassim is seeking a Discourse database with dummy data to study its complex schema using pgAdmin, finding Data Explorer less flexible for exploring tables and columns. merefield responds that this is an out-of-the-box feature, directing them to use the dev migration rake job to populate an instance with dummy data via the commands: ./launcher enter app, ALLOW_DEV_POPULATE=1 bundle install, and ALLOW_DEV_POPULATE=1 rake dev:populate. gassim thanks them for the helpful solution.

Hi
I’m wondering if there’s any Discourse database online with dummy data that I could download. If you have a database with dummy data, would you like to share it with me?

Why I’m asking for a dummy database? Discourse database tables are very complicated and I would like to study the tables as well as columns using queries on pgAdmin. I would like to understand the schema better. Data Explorer is somewhat not very user friendly. The IU is not very flexible, there are a couple of limitations, and it’s not easy to go over the columns and tables…etc It’s been very helpful creating queries but takes a lot of effort when one needs to understand the columns in the tables and how they’re related to each other. It will be so much easier to study this on pgAdmin as well as keep things organized.

If you have an idea, please share! Thank you so much!

This is an out of the box feature.

Use the dev migration rake job that’s discussed in this post to populate an instance with dummy data.

Thank you! :+1: