There are a whole lot of Database platform in the IT world. For instance , Oracle, Firebird, Sybase etc. I only choose two of them in this tutorial, they are mysql and postgresql. Mysql is a open source project. It is a most popular database component in the personal hosting service. It can work very well with PHP together. And, postgresql is also a open source project base on the BSD license. It’s an object-relational database system. compare with mysql. postgresql is more powerful feature like Views, Triggers, and Unions. on the other hand, the speed of mysql is faster than postgresql.

The ports system also will be used in building database. make sure your ports system has been update. and versions of mysql and postgresql need be latest.

READ MORE

Why is DesktopBSD neither freeBSD or Linux. Firstly, DesktopBSD 1.6 is base on Freebsd 6.3. It is distribution ofFreeBSD. And Linux is same pretty good, but BSD is more better in old machine such as PIII cpu, 128M memory, Linux maybe can run in these kind of computers, but Linux can’t run other applications like postgresql.

And, DesktopBSD have pretty good graphical interface environment with KDE. that should save time of configuration of GUI. DesktopBSD also uses the ports system. we can easily install any software.

I plan to build a server support following service:

1. Databases service such as MySQL, PostgreSQL.
2. PHP development environment with Apache2
3. Files share service like NFS and Samba.
4. JSP/Java development environment with Tomcat6
5. FTP server
6. DNS and Mail server.

READ MORE