Kfirlog

Now that I am actually getting payed to program instead of paying to program, I find myself in greater need of practical information. Putting some of it on my blog will help me keep all the knowledge in one place. To start off, I’ll mention Cascading delete in SQL.
In the database schema there are 3 tables used to store different objects. As there is a many to many relationship between the the objects, there are relation tables.

Using cascading delete I can define that if an object is removed from its table, all relation tables entries with that object id are also removed. Quite handy. the way this achieves is MySQL is through the use of foreign keys. If I define in the table members the unique id of a user as a foreign key I can also define tell the RDMS to delete the entries in members where that foreign key exist. Here is an example of the definitions:


CREATE TABLE members (
usr_id VARCHAR(30) NOT NULL,
grp_id VARCHAR(30) NOT NULL,
FOREIGN KEY usr_id REFERENCE user (usr_id) ON DELETE CASCADE,
FOREIGN KEY grp_id REFERENCE group (grp_id) ON DELETE CASCADE);


As you can see the table is created normally by defining the fields, then the foreign keys are named. The REFERENCE shows to which column in what table they refer to.

It has now been two weeks since I started working so I figured it might be a good time for a post about how things are.

Before I started working all I heard from the working people is how they miss the student time. How much more demanding working life is. It won’t be an overstatment to say I went to my first day a bit worried.

My first day was like Christmas.  I got a mobile phone, a laptop and a car. And that was pretty much it. The next two days have been just as nice. Together with all the people who started working for Getronics-Pinkroccade this month we had a 2 day into plan. Some presentation, some group talks, and beer. Yes every building in the company has its own beer tap with a barman. I like that. Did I mention, its free beer? The people I met were intellegent, interesting and fun. If this is how most people in the company are, I made a good choice coming to work here.

From the forth day on, and for the coming 2 weeks I’m in courses in Amersfoort. Its quite relaxed. I’m doing the courses alone, with a tutor I can turn to for questions. My tempo is quite high (im going almost at twice the expected rate) so I might be finished earlier then expected.

After I finish the courses I have a month of stage to build some web app (interesting ideas for what exactly are welcome). Then it will be time to actually work on real projects.

In a streak of luck and some good talks, I got a job at Pinkroccade. I will be following the Young IT professional program they offer. Starting on the 1/3/2008. this should give me a month to visit Israel, and have some time with my brothers in the Netherlands before starting to work full time.