Archive for September, 2009

Monday, September 28th, 2009

IT Due Diligence

I completed some IT due diligence inspection of a company for a VC.
Decided to write this post to remind myself about what it important in the process.

choose a code name for the project
sign the NDA and ensure that you have professional indemnity insurance
obtain all technical documentation in electronic form asap
obtain company org chart and a […]

No Comments » - Posted in technology by pbirnie

Monday, September 14th, 2009

Intellij and Flex

 I previously blogged about Intellij and how to use it to remote debug flex applications.
Not I am changing some of the IDEs settings
Setting utf-8 encoding of files

Now I need to be able to add some other swc files to the path
File->Project Structure
select your Flex module

select the Dependencies tab (A) and click “Add” - then navigate […]

No Comments » - Posted in technology by pbirnie

Saturday, September 12th, 2009

IntelliJ 9.0 Maya Rocks

I have to say - I have never really liked Eclipse.  Its slow, hard to find the setting you want to change and very painful to configure things like debug. When I was working as a java EJB developer, I used to use Intellij - I loved it. So easy and quick to work with […]

1 Comment » - Posted in technology by pbirnie

Tuesday, September 8th, 2009

Mysql grep - understanding a system

When working with a new system - There are various techniques I like to use to understand how it works

firebug net tab
schemaspy
any technique that allows me to print the sql fired on each page request

The following is also useful - A  simple mysql dump of the database schema with the database insert statements listed as […]

No Comments » - Posted in technology by pbirnie

Sunday, September 6th, 2009

Kaltura CE schema

I used schemaspy and its meta data feature to create the following ER diagram for Kaltura CE database schema

You can see the full schema spy output here
This is the command line I used

sudo java -jar schemaSpy_4.1.1.jar -t mysql -u root   -db master_kaltura -dp ./mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar -host localhost -hq -o /var/www/kaltura_schema_dump  -meta kaltura_schema_meta.xml

here is the kaltura_schema_meta.xml file […]

No Comments » - Posted in technology by pbirnie