Here we go again. Now I’m and Arood is developing the new version of W3sidan, 3.0. This version will hold a whole remake of the site. From top to toe. We’re changing from XHTML to HTML5 and to CSS3 and rebuilding every single code behind it.

And while we’re at it, we’re also changing database from MySQL to PostgreSQL. Which for me is a lot of fun. I like playing with databases, most of the time (Except when search-functions which involves a lot of JOINS and Subqueries is involved.). They are quite much alike except for some minor things which I had to experience the other day. By some reason PgSQL doesn’t have the Last_insert_id() function which MySQL have. After a bit of googleing I found a few solutions, the other one better then the other. And I ended up with this:

INSERT INTO table (name, surname) VALUES (‘Erik’, ‘Thunberg’) RETURNING id

and then just make a fetch after the query. And I actually like this one better than Last_insert_id().

We’ll try to have the complete site out of development before july hits us because we’re both going on a social event called Minigeek Camp where we’re going to do some advertisement for the site.

And if you want some sneakpeaks or come with ideas, join us in our IRC-channel #w3sidan at our own IRC-net, irc.w3sidan.net.