Blog » Web development

If you are a web designer or developer, most of your time is spend doing this or that.

Marco has very well quantified the time spent doing various things when you are making a website in his blog item: Time breakdown of modern web design. Oh and yeah I complete agree :)

There is an excellent article on Securing a MySQL Server on Windows at MySQL. Make sure you have a look at it.

PostgreSQL 8 (the open sources database) has been released.

Andrei Zmievski has graciously provided his slides on the Regular Expression at the php|works Toronto 2004.

Regular Expressions: every developer's best friend and worst nightmare!

Join Andrei Zmievski, PHP developer and author of the PHP Regex (PCRE) extension, on a journey that will take you from your first steps into the world of regular expressions to complete mastery of this most useful of tools.

A must for everyone who's ever wondered what /(?<=foo)(bar)/ means.

A must read!

Andrei's Regex Clinic

PostgreSQL released the new beta 8 of their database server, a couple of days ago.

The best part is that they have now released a versions that run natively on Windows. This is great for the PostgreSQL because (most) developers like me use the Windows for web development. Although I have been working with PostgrSQL for couple of years now, but I had to run it with cygwin on windows, or work on Linux. Now I can work directly on Windows.

I downloaded and installed it. There is just one problem, it didn't install on a FAT32 file system, due to not being able set permissions on the FAT32, so it can only be installed on NTFS file system at the moment. So take this into account.

While we are on the topic, I use phpPGAdmin for the web adminsitration of the PostgreSQL.

Please do tell me what software, utilities or other resources like reference material, tutorials or security info do you guys use for the PostgreSQL.

P.S: As with all the beta software, this version is not ready for the production release, so please use it at your own risk.

• PostgreSQL 8 release notes
• PostgreSQL Windows Installer