# Discourse Database with Dummy Data

**URL:** https://meta.discourse.org/t/discourse-database-with-dummy-data/269247
**Category:** Development
**Created:** [June 22, 2023, 9:47am UTC](https://meta.discourse.org/t/discourse-database-with-dummy-data/269247 "2023-06-22T09:47:26Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![gassim](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gassim/32/220910_2.png) [@gassim](https://meta.discourse.org/u/gassim)
#### Post date: [June 22, 2023, 9:47am UTC](https://meta.discourse.org/t/discourse-database-with-dummy-data/269247/1 "2023-06-22T09:47:26Z")

</div>

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](https://meta.discourse.org/t/32566?silent=true) 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!

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [June 22, 2023, 9:50am UTC](https://meta.discourse.org/t/discourse-database-with-dummy-data/269247/2 "2023-06-22T09:50:51Z")

</div>

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.

> [@Set up a staging server](https://meta.discourse.org/t/set-up-a-staging-server/225951/1):
>
> If what you want is a test server to see what Discourse is like, though, you might want to check things out with some fake data, and if you do, you can do this:
> 
> ```plaintext
> ./launcher enter app
> ALLOW_DEV_POPULATE=1 bundle install
> ALLOW_DEV_POPULATE=1 rake dev:populate
> 
> ```

---

<div class="post-metadata">

### Author: ![gassim](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gassim/32/220910_2.png) [@gassim](https://meta.discourse.org/u/gassim)
#### Post date: [June 22, 2023, 11:12am UTC](https://meta.discourse.org/t/discourse-database-with-dummy-data/269247/3 "2023-06-22T11:12:59Z")

</div>

Thank you! 👍

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [July 22, 2023, 11:13am UTC](https://meta.discourse.org/t/discourse-database-with-dummy-data/269247/4 "2023-07-22T11:13:54Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
