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