Create and import a database example

This tutorial helps you setup a running database example on your computer to be able to use Forest on a sample application.

Requirements: Please, check you have already installed Docker on your computer first and ensure it's running correctly.

To import the demo database, you can use the forestadmin/meals-database Docker image. Just type:

docker run -p 5432:5432 forestadmin/meals-database

That's all! Your database is running locally in a docker container.

To check if the database is correctly setup, you can use the command psql to connect to your freshly created database.

psql postgres://lumber:secret@localhost:5432/meals

Finally, you should get a prompt where you can type SQL queries or PostgreSQL command line \d to see the available list of tables.

meals=# \d
List of relations
Schema | Name | Type | Owner
--------+----------------------------+----------+--------
public | ar_internal_metadata | table | lumber
public | chef_availabilities | table | lumber
public | chef_availabilities_id_seq | sequence | lumber
public | chefs | table | lumber
public | chefs_id_seq | sequence | lumber
public | customers | table | lumber
public | customers_id_seq | sequence | lumber
public | delivery_men | table | lumber
public | delivery_men_id_seq | sequence | lumber
public | menus | table | lumber
public | menus_id_seq | sequence | lumber
public | menus_products | table | lumber
public | menus_products_id_seq | sequence | lumber
public | orders | table | lumber
public | orders_id_seq | sequence | lumber
public | orders_products | table | lumber
public | orders_products_id_seq | sequence | lumber
public | product_images | table | lumber
public | product_images_id_seq | sequence | lumber
public | products | table | lumber
public | products_id_seq | sequence | lumber
public | schema_migrations | table | lumber
(22 rows)