We wanted HR to be able to 'design forms'. An HR user needed to be able to draw. We wanted HR to be able to create SQL without needing to type very complex and rigid 'statements'. So - a way to 'auto generate' SQL with mouse clicks and drags. We wanted HR users to have the ability to create their own reports, once again with simple mouse movments. HR would also need to create applications and websites for users or for their intranet or extranet. Creating a Website or Application with Simple mouse movements would be very good. HR would need dynamic Charts, with the ability to 'design the chart' and select the appropriate data. How about calculations, like: 'Life Insurance cost = ((annual wage +499)/1000)*.14*12 ... Yup, need that too. Printing? We needed a way for HR to be able to create Pdfs AND these Pdfs must be able to be Personalized. What if 6 people were working on a Project from different locations? Email is a bad solution, so Chat (conferencing) was needed. All the traditional needs; Import, export, save, save as, delete, update, insert. The list of needs continued to grow. A few of our choices for our Programming Tools are to the right.
PostgreSQL is ALSO used for everything that has to do with SQL, such as Tables, Queries, Views, Triggers, Functions and Expressions.
Our mostImportantDecision
Your ToolsA QuickOverview
- - - - - - - - - -
Programming often involves using a 'library'. An example: You could either sit down and write a book (maybe a dictionary) or go to the library and get a dictionary off the shelf. Same idea here. Some of these libraries are free, others not. Good libraries are programming 'time savers'. If libraries didn't exist, they would need to be invented. The list below of 'our IT tools' is abbreviated.
All 'drawing' and form design programming was done with Actionscript, the powerful language that lies beneath FlashPlayer.
PDFlib is a library for creating PDFs on a server. PDFLib is a German company with typically high standards of excellence.
ADODB is likely the fastest open source database abstraction library available for PHP.You won't even know it is 'there'.
JavaScript is a scripting language most often used for client-side web development. 'Client side' in this case, is your browser.
PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML.
Applications developed with xajax can asynchronously call server-side PHP functions & update content without reloading the page. Short version? Your browser will be quick.
A GUI is the graphical means of getting your computer to 'do something'. We needed to be very careful in our choice of programming tools since different programs have their own strengths and weaknesses. Another important consideration was that the HR CS was needed to work 'on the web' - or - on a local server.