Re: [GENERAL] Testing Technique when using a DB

2013-03-16 Thread Jasen Betts
On 2013-03-13, Joe Van Dyk j...@tanga.com wrote: --047d7b6226a405604904d7d09001 Content-Type: text/plain; charset=UTF-8 On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford scrawf...@pinpointresearch.com wrote: On 03/12/2013 09:05 PM, Perry Smith wrote: To all who replied: Thank you. ...

Re: [GENERAL] Testing Technique when using a DB

2013-03-13 Thread Steven Schlansker
On Mar 12, 2013, at 8:09 PM, Joe Van Dyk j...@tanga.com wrote: On Mar 12, 2013, at 8:42 AM, Perry Smith pedz...@gmail.com wrote: The other thought is perhaps there is a snap shot type concept. I don't see it in the list of SQL commands. A snap shot would do exactly what it sounds

Re: [GENERAL] Testing Technique when using a DB

2013-03-13 Thread Steve Crawford
On 03/12/2013 09:05 PM, Perry Smith wrote: To all who replied: Thank you. ... I had not seriously considered pg_dump / pg_restore because I assumed it would be fairly slow but I will experiment with pg_restore and template techniques this weekend and see which ones prove viable. Another

Re: [GENERAL] Testing Technique when using a DB

2013-03-13 Thread Joe Van Dyk
On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford scrawf...@pinpointresearch.com wrote: On 03/12/2013 09:05 PM, Perry Smith wrote: To all who replied: Thank you. ... I had not seriously considered pg_dump / pg_restore because I assumed it would be fairly slow but I will experiment with

[GENERAL] Testing Technique when using a DB

2013-03-12 Thread Perry Smith
I tried posting this from Google Groups but I did not see it come through after an hour so this may be a duplicate message for some. The current testing technique for things like Ruby On Rails has three choices but all of the choices will not work in my case. The first choice is truncate

Re: [GENERAL] Testing Technique when using a DB

2013-03-12 Thread Steve Crawford
On 03/12/2013 08:41 AM, Perry Smith wrote: One choice would be to create the database, use it, and then drop it for each test. I would create the database from a template that already has data taken from the production database (and probably trimmed down to a small subset of it). This

Re: [GENERAL] Testing Technique when using a DB

2013-03-12 Thread Steve Atkins
On Mar 12, 2013, at 8:41 AM, Perry Smith pedz...@gmail.com wrote: One choice would be to create the database, use it, and then drop it for each test. I would create the database from a template that already has data taken from the production database (and probably trimmed down to a

Re: [GENERAL] Testing Technique when using a DB

2013-03-12 Thread Joe Van Dyk
On Mar 12, 2013, at 8:42 AM, Perry Smith pedz...@gmail.com wrote: I tried posting this from Google Groups but I did not see it come through after an hour so this may be a duplicate message for some. The current testing technique for things like Ruby On Rails has three choices but all of the

Re: [GENERAL] Testing Technique when using a DB

2013-03-12 Thread Perry Smith
To all who replied: Thank you. I did typo. I meant transaction instead of truncate. I had not seriously considered pg_dump / pg_restore because I assumed it would be fairly slow but I will experiment with pg_restore and template techniques this weekend and see which ones prove viable. I