# Simple Data Modeling with a Test Data Set

DevFeed: [Simple Data Modeling with a Test Data Set](<https://devfeed.tech/articles/simple-data-modeling-with-a-test-data-set-34569.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2017/11/simple-data-modeling-with-a-test-data-set/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2017-11-27T15:23:44Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [test data](<https://devfeed.tech/topics/test-data.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [test-data](<https://devfeed.tech/tags/test-data.md>)

## AI overview

This tutorial explains how to develop and test a PostgreSQL database schema using SQL scripts, sample data, explicit transactions, and rollback. It demonstrates a forum-style schema populated with random data so the model can be refined interactively without affecting existing application code.

## Source excerpt

In How to Write SQL we saw how to write SQL queries as separate .sql files, and we learnt about using query parameters with the psql syntax for that (:variable, :'variable', and :"identifier"). For writing our database model, the same tooling is all we need. An important aspect of using psql is its capacity to provide immediate feedback, and we can also have that with modeling too.