Skip to main content

"Classic" Programming Languages

In my time in government, I've worked on modernizing legacy systems. Though not all legacy systems are worth modernizing, I've found a few "classic" languages in the process that are not the ones you'd expect.

All these "classic" languages share a few things:
  1. They're all proprietary.
  2. They all had or have enterprise support
  3. They all have outdated UI (user interface) elements reminiscent of the '90s.

Microsoft's (Visual) FoxPro  

License: Proprietary
Latest Release: 2007

Top on these languages I've encountered is FoxPro, a language that is unsupported now, but was back in the '90s a good language. It was bought by Microsoft and that gave it a sense of enterprise support. I encountered this language at the Environmental Quality Board in Puerto Rico, where there were two "programmers" in this language and a system running on it.

The environmental complaints/issues ticketing system had been modernized not too long ago and it had substituted the outdated FoxPro system. However, this new system was hardcoded with the date as a way for the programmer who made it to ensure job security. When this person wasn't paid or left the consulting company where he worked, maintenance to the application was not given. The tickets for the environmental issues (which included emergencies) had the year as part of the ticket id. When the new numbers for the ticket id's ran out of digits, the system became unusable.

Due to the person that had coded it having moved on from the original consulting company, that company would not have an easy job repairing the old system. Not to mention that putting the year into the ticket id was a design flaw from the very beginning. Cost-wise it made more sense to build a new system right. But in the meantime, the tech people at the agency had resuscitated the old FoxPro system to handle the tickets.

This was an internal system to the agency not exposed to the internet so there were no major security issues, still it's functionality was limited and I was shocked to find not only such an old language but one that had not been supported since 2007. I project managed the project from the RFP (request for proposal) stage, all the way to delivery, in a system written in C# that leveraged the agency's permanent employee's knowledge of Microsoft's SharePoint while extending it to provide an extensible system (with an API) ready for integration with other systems that needed modernizing as well.

But why was FoxPro still used at the agency? In fact, there were trained programmers in it at the agency. FoxPro allowed not just coding but also database management all rolled into one. With the inclusion of "visual" aspects, it allowed for novice coders to be productive in the language. For whatever reason, Visual FoxPro was also very popular in Latin America.

Oracle's PeopleSoft

License: Proprietary
Latest Release: 2015 or 2018 for IDE

Second is a still supported language, Oracle's PeopleSoft. This software is very popular for Human Resources needs. I also encountered this at the Environmental Quality Board. Like Visual FoxPro, PeopleSoft has database administration capabilities as well. This integration with the database, combines the concerns in the code, of both logic and data.

From the Oracle website:

In PeopleSoft Application Engine, a program is a set of SQL statements, PeopleCode, and program control actions that enable looping and conditional logic. A program is defined in PeopleSoft Application Designer and performs a business process.

One of the benefits of PeopleSoft is that it is a system created for Human Resources functions. However, due to federal requirements from the grant money received from the EPA (Environmental Protection Agency), this system required a lot of custom code. And being a proprietary system it required specialized contractors. Thankfully, this was a purely internal system managed by a small team and was still being maintained, so the only thing to do was to ensure and support its continued development.




Comments

Popular posts from this blog

Multiple Assignments in Ruby

In this Rails project I'm running I need to set a whole bunch of individual variables to 'disabled' at once depending on the group the current user belongs to. We can use multiple assignment in this case but with a caveat. Multiple assignments are a quick way of setting a lot of variables at once. h, k = 1,2  => [1,2] h => 1 k => 2 but   h, k = 1      => 1 h => 1 k => nil In that case we can do this: h = k = 1   => 1 h => 1 h => 1  Beware this sets them to the same object. So if you change one you change both. h = k = [] h << 1 h => [1] k => [1] While we're at it here is how to reverse two variables: h = 1 k = 2 h,k = k,h h => 2 k => 1

What Medieval Economics can teach us about tariffs.

As a teen, I used to play Dungeons and Dragons (D&D) with my friends. This started an interest in the medieval period that led to me taking a medieval history class in college just to understand the period more. Over the years I've also read great books like " Dungeon, Fire and Sword " about the crusades (I recommend the book) and yet with all that knowledge it wasn't until recently that it occurred to me I had a completely wrong understanding of economics in the Medieval Period. "Viking helmets, sword and footwear" by eltpics is licensed under CC BY-NC 2.0 In my D&D games, players who are adventures battling monsters and creatures would need equipment and on the trips to town, they'd get resupplied with their adventuring necessities. I'd run these moments referencing my imagination of what it must have been and fantasy books I'd read. There be an inn with a raucous bar, a gruffly black-smith, if a city also a weapon and armor sm...

Setting up the Marble Mouse for Ubuntu

I have a Logitech trackball which I love. I bought it when my wrists started hurting after hours of long Photoshop sessions. The switch to the trackball fixed all that. It allows me to hold my hand in the perfect position and it's great for most browsing with one exception: It lacks a middle-click wheel. This presents a bigger problem than it seems, as design seems to be removing the scroll bars at the edges of windows in favor of small slits. So to get around this you can emulate a scroll wheel or use the middle click to activate a scroll motion on various programs. Logitech has a utility that sets this up in Windows but in Ubuntu you have a better (if more hard-work required) option. The Ubuntu option is better because unlike in Windows you can emulate the wheel with the track-ball by holding down a button. This is the option I like to use. In Ubuntu you write a configuration file to set up the trackball to work the way you want it. I have to re-create this...