The ramblings of a geek often have interesting side effects of often being entertaining and sometimes correct. Jason L. Froebe talks about many subjects but primarily databases and perl.
As many of you know, I’ve been working on a free magazine regarding various database systems (dbms) called My Databases. I hope to have multiple authors in future issues covering all sorts of open source and proprietary databases.
ASE implements a subset of SQL 92 and isn’t 100% compliant with the SQL 92 standard (no DBMS on the planet is btw).
SQL99 compliance isn’t seriously being looked at by the major commercial DBMS vendors. Disregarding the fact the the SQL standards aren’t all they are cracked up to be, the vendors have too much invested in their own proprietary SQL variants (and other components) to be 100% compliant. If they were 100% compliant with the SQL92/99/whatever standard, then wholesale migrations from one vendor to another would take place.
I believe as time goes forward the opensource DBMSs (PostgreSQL, MySQL, etc) may become far more compliant with the standards than the commercial vendors as vendor lock in doesn’t mean as much to them.
Look into what the vendors (Oracle, MS, IBM,etc) are saying what constitutes as “compliance”. Ask each vendor what parts of the SQL99 standard they will be implementing and which parts they won’t be. If any vendor says that they are 100% compliant with the SQL92 or SQL99 ANSI standard, then that particular person is lying to you. Granted, that person may have been told their DBMS was 100% compliant and believes it. An honest vendor says that they comply with features X,Y and Z of the SQL 92 or SQL 99 standards.
Personally, I have found no significant movement by any of the commercial DBMS vendors to implement the SQL99 standard. So far it has just been lip service IMHO.
I’m working on a Historical Server replacement. I need to check with my employer as to whether I can open source it or not but the guts of it consist of:
Perl POE/DBD::Sybase for the daemon/ASE db connections (using FreeTDS instead of OpenClient)
SQLite for the local storage (way lower overhead than ASE or SQL Anywhere)
Perl Catalyst / Template::Toolkit web front end with REST web services
All of this goes into a VMWare Appliance running Ubuntu 7.10 Server… a drop-in solution that can even be run on a laptop. I’m hoping that my employer lets me release it as then I can zip it up and put it on sourceforge so everyone can benefit.
I downloaded the excellent SQLite administration tool, SQLiteman, today. Take a look at the screenshots. I’m very impressed with it but was disappointed that they don’t provide an Ubuntu binary package. So… I built my own Ubuntu package using checkinstall:
Listen to this podcast
)
Recent Comments