How Programmers write Software to Support Your Company's
Business Systems
Non-programmers are shocked to find out how many different types of software
are involved in producing an interactive web site.
- First of all there is the software operating on the Web Server. You
can think of this as the main program that contains all the processing steps
needed to produce the results. I use PERL - a scripting
language that operates on the Web Server to generate web pages in html for
your browser to see. You click on an option shown on your screen and
PERL takes that piece of data and follows a series of steps to process it.
- Secondly there is the database program itself that sits on the Web
Server. Most use SQL - Structured Query Language for the engine
to run the database program. It tells the database to store, retrieve
and manipulate the data to produce a result. I primarily us MySQL as
the database program of choice due to its speed.
- Thirdly, you must have a program that will interface between the main
program and the database. The most commonly used one is DBI or
Database Interface. This program operates between PERL and MySQL to
connect the two programs.
- Fourthly, there is HTML. Not a programming language in the
strict sense, but rather a markup language that tells your browser how to
display the data. Your programmer and web-designer are both required
to have a though understanding of HTML or you won't be able to see it.
- Finally, there is Java Script. Java Script applets operate on
your local computer and give the programmer the ability to do limited data
checking and manipulation without calling the Web Server programs.
This is a big time saver for checking such things like 'is there a
legal date of February 31?'
These are the basics for any competent web programmer. There are other
exotic programs available that can be used, each with there strengths and
weaknesses. As a CPA, I was used to producing highly technical tax returns
in a manner of hours or maybe a few days. As a programmer, I have to think
in weeks and months to complete a project.
Business Consulting in Florida
to include Tampa Gainesville Orlando Jacksonville Daytona Beach
Tallahassee Panama City Pensacola Lakeland
© Business Systems Design & Software, Inc.
This Web site presents information to educate
members of the public on various business subjects.
The information on this Web
site is compiled from a variety of sources. It may not be complete or timely. It
does not cover all aspects of any tax, financial or accounting matter. If
you have any tax, financial, accounting or related questions, please consult a
qualified certified public accountant licensed in your jurisdiction or in the
appropriate jurisdiction promptly.