Databases & Programming

The world of UNIX appears to attract those interested in the more technical aspects of computing. Since Linux is cut from the same lineage, it is apt to include lists of computing languages. Both scripting and programming appear here despite the title, itself shortened for the sake of brevity. Since much code cutting involves working with databases, these appear here too.

In time, I plan to correct the imbalance between programming and scripting languages that currently exists. The original list was bare so descriptions have been added and will be more and more needed should there be any expansion of what you find here.

Programming and Scripting Languages

Perl

It has been around since the 1980’s and still pervades though it is not as dominant as it once was for creating dynamic websites or system administration. PHP has taken on much of the former while Python is making inroads into the latter. Still, no list would be complete with complete without a mention of the once ubiquitous scripting language and it once powered my online photo gallery. It may be an easier language but there is plenty of documentation on the web with Perldoc, Perl Maven and Perlmeister being some good places to look and Dan Massey has some interesting articles on his site too. Not only that but it is extensible too with plenty of extra modules to be found on CPAN.

PHP

This usurper has taken the place of Perl for powering many of the world’s websites. That the language is less verbose probably helps its case and many if not most CMS packages make use of its versatility.

Python

This Google’s preferred scripting language for system administration and it has its place in web scripting though support is not as extensive as either PHP or Perl. Nevertheless, it seems to be gaining ground if Fasthost’s support for the language in even basic shared website hosting packages is any guide.

OpenJDK

One of the acts of Jonathon Schwartz while he was head at Sun Microsystems was to make Java open source after more than a decade of its being largely proprietary. This is the website for the project. Of course, his more notable act at Sun was to sell it to Oracle but that’s another story altogether…

R

This is an open source equivalent to TIBCO’s S Plus and used an earlier version of the S language as its basis when I last looked. It is meant of statistical data analysis and, though data processing isn’t a strong point, its other strengths such as in data visualisation have seen its usage grow.

Databases

MariaDB

This essentially is a fork of MySQL (see below) now that Oracle owns it. The originators of MySQL are the creators of MariaDB so their claims of it being a drop-in replacement for it may be have some traction. So far, I have seen no exodus from MySQL though.

MySQL

After being in the hands of a number of owners until it incongruously came into the custodianship of Oracle (who of course already had and still have one of their own), the database system that powers so many dynamic websites almost is a de facto standard and looks set to remain thus for now.

MongoDB

This may a document-based and not a relationship database like many of us understand them but it still is being touted as an alternative to the more mainstream competition. Database technology isn’t just about SQL and MongoDB champions a NoSQL approach; it sounds as if the emergence of XML might be what’s facilitating the NoSQL database technologies.

PostgreSQL

This project may have more open source credibility than MySQL but it seems to remain in its shadow. It so happens that this is what Debian installs if you specify the web server option at operating system installation time.