Tool of the day: Atlassian Confluence

Since many years I am working now with atlassian confluence as project documentation plattform. I am still suprised, how easy the integration with jira, greenhopper and co. works.4 months ago I introduced confluence in my current company with a lot of non technical employees.It was very cool, to see how easy they got confident in working on a day to day base with confluece.

We are very happy with it and I personally think that everybody should use it: freelancers, startups and big companys!Atlassian has a very nice license model. Until 10 User Accounts you just pay 10$  a moth to use confluence.That is not much money, for such a great documentation plattform. Also that setup with an MySQL and the deployment to a java Tomcat Server is pretty simple. The documentation of confluence is awesome.For me more or less one of the best tools I ever worked with. There is also a free trial version available.

Check the demonstration video to build yourself a picture!

SQL alter table column commands

Today I had to change a little bit some column of some database tables. I don't like in future to search the SQL-Commands again, so I like to add them to
my blog and hope, that they will also helpfully for you.
Drop Not Null Constraint from column :

ALTER TABLE TEST_ABC MODIFY ID_CUSTOMER bigint(20) NULL

Remove column

ALTER TABLE SALESORDER DROP columname1

Add column

ALTER TABLE CUSTOMER_ADRESS ADD testcolumnName2 VARCHAR(255) NULL

Rename column

ALTER TABLE WEB_SITE change `headerURL`  `headerURLorData` text

All commands are tested on MySQL 5.5.28.