Re: Optimise PostgreSQL for fast testing - Mailing list pgsql-general

From David Salisbury
Subject Re: Optimise PostgreSQL for fast testing
Date
Msg-id 4F4671E9.404@globe.gov
Whole thread Raw
In response to Re: Optimise PostgreSQL for fast testing  (Jack Christensen <jackc@hylesanderson.edu>)
Responses Re: Optimise PostgreSQL for fast testing  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general

On 2/23/12 9:06 AM, Jack Christensen wrote:
> As another Rails developer using PostgreSQL I think I can explain the
> use case. In standard Rails usage, the ORM handles all SQL query
> generation and thus the application is database agnostic. It is typical
> to use SQLite in development and testing and MySQL or PostgreSQL in
> production. However, if any PostgreSQL specific functionality is used
> then obviously PostgreSQL must also be used in development and testing.
>
> Another common practice is test-driven development. So the test suite
> for the application may run scores or hundreds of times per day per
> developer. So the speed of the test suite is of vital importance to
> developers. A 30 second difference 100's of times per day really can add
> up.

Perhaps the emphasis should be on the tests themselves, and not PG cycles.
Is he using Factory or Factory.build?.. that sort of thing.  Is he running
the entire test suite, when in fact just running one test would do until
final checkin?

And I'm curious as to why anyone would need to run tests 100s of times a day.
How much code can ya write, or is he simply writing tests themselves all day?

-ds


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How to enable thread safety on postgresql 8.3.6
Next
From: Scott Marlowe
Date:
Subject: Re: Optimise PostgreSQL for fast testing