Re: RDBMS comparison tool

On 07/01/2013 13:08, Lyle wrote:
> On 07/01/2013 10:43, H.Merijn Brand wrote:
>> On Sun, 30 Dec 2012 02:53:33 +0000, Lyle <[email protected]>
>> wrote:
>>
>>> Hi All,
>>>     Whilst working on another project it made sense to write a tool for
>>> comparing the various RDBMSs...
>> Very useful indeed, but I'm afraid that it also depends on the version
>> of the database(s). I've done several talks about the deficiencies of
>> RDBMS's and basically, there is no perfect database: they all have
>> their hatred areas *). Choose the one that best fits your current needs
>> (even if that is a flat-file solution).
>>
>> What would you need (as perl-script output) to extend that info for
>> DBD::Unify (which I still have access to) and DBD::CSV, DBD::SQLite
>
> I've got a tight deadline for this project submission, and I'm only 
> focusing on those four databases. If you want to wait four months 
> until after my deadline then I'll take a look, otherwise it's probably 
> easiest to grab a copy off github:
> https://github.com/cosmicnet/CompareRDBMS

I couldn't resist having a quick look at SQLite, turns out they haven't 
implemented type_info so it doesn't return anything.

sub type_info_all {
     return; # XXX code just copied from DBD::Oracle, not yet thought about

DBD::CSV does return type info, for some reason it returns two identical 
BLOBs?

I've updated the reports:
http://www.cosmicperl.com/rdbms/compare_types.html
http://www.cosmicperl.com/rdbms/compare_type_details.html


Lyle