|
I am a technology-freak. I'm always running out of time because
life is just to interesting. To minimize the time that this site
takes of my creative spare timeI changed the portfolio-part from
a static system to a database-driven one. All the photo-related
info is pulled from a database and prepared for publishing on-line.
database: mysql
A reliable and fast database which is free. The decision to take
this database was taken at the beginning - right now I would prefer
postgreSQL, as mysql is not atomic and does not provide transactions
in a proper way. In the early days this was not a problem but
has become one. But the positive side is that mysql is really
fast compared to all the database that provide all the fance stuff.
Only recently they changed the locking-logic - as they used table
locking before. This is really bad for the performance if read
and write access occur at the same time.
server-side include: php
Php provides fast publishing of data from a database. As it
is a server-side script, it is absolutely http-client and os-independent.
The disadvantage is the load that has to be handled on the server-side.
With version 4 the also properly support classes and objects.
This makes developing more clear and easy to maintain. But as
right now there are plenty of database access there is a performance
issue.
If this site would be developed from scratch, java servlets and
jsp would be used instead of php.
web-server: apache
Standard web-server on linux-boxes!
database-client
As an administrative database client mysqlAdmin is used. This
is a rather simple web-based client to maintain the database.
|
