| As we started the project of our electronic auction, | | | | Open Source Code database. A matter of marketing |
| we knew that the proprietary software costs would | | | | ? Probably. |
| be too high for our financial resources. Our only | | | | As for the programming language PHP, we had to |
| option then was to make use of Open Source Code | | | | use an object oriented application structure. There |
| softwares. | | | | are many PHP application structures being offered |
| However, within the Open Source Code there are | | | | with Open Source Code license. Object oriented |
| lots of softwares to choose from, and it´s up | | | | application is very important, because it makes |
| to the system analyst/programmer to pick the ones | | | | programming very easy and scalable up to the point |
| that best suit the project goals. | | | | where the system may grow without many |
| In our case, we picked Linux as our operating | | | | problems. Also, it helps to keep PHP code separated |
| system. However we faced a big question: Which | | | | from HTML, with the help of some specific libraries, |
| Linux distribution ? There are dozens of linux | | | | such as Smarty. We make use of Smarty library and |
| distributions, each one with specific advantages, | | | | we believe that it is a very important resource, which |
| sometimes with or without paid services. | | | | can even make web pages faster thru the use of its |
| We chose linux Slackware because we thought that | | | | cache functions. |
| it would suit better our needs, in terms of stability | | | | Also a very important set of libraries worth |
| and reliability. Slackware is a conservative distribution, | | | | mentioning for PHP systems, is the PEAR libraries. In |
| meaning that it only offers in its distribution package | | | | PEAR web site, among the many libraries being |
| kernel versions and third party libraries, once it´s | | | | offered, there are the database interface DB and the |
| been proved to be stable and reliable. As a result, | | | | MAIL_QUEUE, which sends emails thru the use of |
| Slackware is one the most stable Linux operating | | | | database. |
| system on the market. If the user wishes the most | | | | As we came to the end of our web site project, we |
| recent Linux kernel and libraries, we recommend to | | | | had to use some sort of real time database |
| look for a different distribution. | | | | replication. For that we chose the DRBD and |
| Another reason for us picking Slackware, was | | | | Heartbeat libraries. The use of database replication is |
| because of its text interface, which at the beginning | | | | very important and should not be postponed. Just |
| may become a bit difficult, in the long run however it | | | | after 3 months our system got into production, our |
| offers a better understanding of the Linux | | | | server hard disk became bad. Thru the use of DRBD |
| environment. This way most of Slackware | | | | Heartbeat we were able to put the system back into |
| configurations are done thru text scripts. | | | | production within seconds, without loosing any data. |
| Once it was set the operating system, we picked | | | | DRBD/Heartbeat replication is done thru the use of a |
| Apache as our web server. Apache is one of the | | | | lan network between the server and slave nodes. |
| most popular web server in the internet. For server | | | | Our project also makes use of ImageMagick (enlarge |
| programming language, we chose PHP. Also, a very | | | | and reduce images), Iptables (firewall), Tsearch2(text |
| popular programming language. Our experience with | | | | search in portgresql) and Mon (linux monitoring tasks). |
| Apache/PHP proves that this setup is very reliable, | | | | Also a very important library worth mentioning is the |
| working extremely well in our production | | | | pseudo APC compiler for PHP. Speed is always a |
| environment. For workstation programming language, | | | | critical factor for internet sites. |
| we chose javascript, which besides of having a | | | | Our web site is already in production and based upon |
| simple syntax, it offers lots of resources. | | | | our experience we can say that the Open Source |
| Apache web server is really a complete web server. | | | | Code softwares we picked, proved to be extremely |
| Also, it can become very complex with many | | | | reliable and stable. Open Source Code softwares can |
| configuration setups. | | | | certainly be an excellent option for developing web |
| For our database, we picked Postgresql. This | | | | sites. |
| database has been made available to the public for | | | | Roberto Sedycias |
| more than 15 years, and besides of being well | | | | IT Consultant |
| debugged, it offers so many resources that it has | | | | This article is under GNU FDL license and can be |
| become one of the best database options from | | | | distributed without any previous authorization from |
| Open Source Code softwares. Extremely reliable, | | | | the author. However the author´s name and all |
| Postgresql has reported cases where there have | | | | the URL´s (links) mentioned in the article and |
| been databases in production with over 4 terabytes. | | | | biography must be kept. |
| Besides all of that, Postresql is not the most popular | | | | |