Re: Sample databases

On Wednesday, January 16, 2013, Vraj Mohan wrote:

> Is there a good sample database (with decent data volumes) for
> postgresql? I am interested in one for learning and automated testing.
>

What do you mean by decent data volumes? Numbers and units are wonderful
things!

What things are you looking to learn and test automatically? I like to
learn about and test performance, and I find pgbench often quite good for
doing that.

If you want to learn and test a framework like Django or Rails or whatever
the latest and greatest is, I would think that those frameworks would
provide their own sample data for doing that.

>
> I looked at http://pgfoundry.org/projects/dbsamples/ (specifically at
> pagila), but it seemed incomplete and not maintained,
>

Is there a specific thing about the completeness that concerns you?

Not being maintained doesn't bother me, unless of course it is actually
broken in the first place. Data is data. It isn't like programs, which
decay over time.

Have you looked at the Dell DVD store? It is also on that site you linked
above, but it seems to be more up to date on Dell's own site.

> I also looked at http://dev.mysql.com/doc/index-other.html. Employee
> data (large dataset, includes data and test/verification suite) looks
> interesting. Is there anything similar for postgresql?
>

I don't know enough about it to say. The data itself should probably not
be all that hard to port (easy to say for someone who doesn't have to do
it...). The verification suite, on the other hand, might be. Is that your
primary interest, the code and not the data?

>
> Is there a dataset used by postgresql development for testing?
>

There is a regression database used by "make check", but it is designed to
test specific features of the database system that people worried might get
broken by future work, not to provide a cohesive thing that looks like a
web application.

Cheers,

Jeff