Re: Test::Database and Test::DSN

On 2014-04-03, 7:22 AM, Tim Bunce wrote:
> I'd caution against making a hard distinction between file and non-file DBDs
> as it may influence the design it ways that cause limitations later.
>
> It seems to me that the key distinction is "can we reliably and safely
> create and delete a private database". That's true for file-based DBDs
> (ie create a subdirectory and rm -rf it afterwards) but may also be true
> for some non-file DBDs in some situations.

I agree with this.  There is also precedent.

As I recall the DBD::Pg test suite will create a whole new Postgres database 
cluster and associated server process in order to do its testing, these are 
completely separate files in their own directory and separate server on its own 
port, so isolated from any production/other use of Postgres that may be on the 
system.

Such solutions should be utilized by a generic database testing infrastructure 
where ever possible.  In such cases there is no distinction between "file based" 
and not.

-- Darren Duncan