Category Archives: the BLOG

Laziness is the devil's pillow.

Finally, to my delight, I got my data back from the old server.
I was supposed to do some modification to it and then append it to my new database. But you know what? I was too lazy to do it. I knew I would have to write a few lines of codes but I was just not going to do it, or not going to do it at that moment.
There is an old Danish proverb: [b]Laziness is the devil’s pillow.[/b]
Admit it or not, the lost data is lost for good.
Not a bad justification for my slackness, is it.:$

So I Complained.

Knowing that there’s not mutch left that I can do, I complained.
The girl at the after-sales-service was polite, as usual. She relayed my problem to their technical staff. Sadly enough, they didn’t seam to quite get what I was talking about. Nor were they able to help me regain control over the database, much less backup my data for me.
That being said, I had to come up with a solution from my side. I went over my code again and again and again, and the only flaw I was able to think of was the autosave feature. But I can’t say it for sure.
Anyway, I have disabled the feature for the moment and let’s see if it helps.
This is driving me crazy!:@

All right then… You win again.

All right then. Seems not much left to do.
I was trying to extract some data from the old server but in vain.
Weird enough, I was able to access several tables but when I was trying to read the two most important ones, the system just returned an error and the whole server went crashed right after that.:S
Anyway I’m gonna give another shot tonight and hope that everything would have been okay by then.
The whole shit has destroyed my weekend!
It sucks!

Just recovered from a system failure.

I have just restored the backup database, which was created a week ago.
Still need to determine the cause of the crash.
There might be trival data loss, which is likely to be ten posts and some twenty comments, but hopefully it will not make a huge difference.
I’m just testing to make sure everything has been set up properly.
Wish I had made regular backup’s more frequently…:'(
Or should I write a routine that fouces the system to make backup’s on a daily basis?

花了点时间,改进了Tags的数据结构

原先的数据库在设计tag表时,参照了国内某著名BLOG的系统,但是碰巧那个设计非常不合理,于是the BLOG也自然而然地继承了这份不合理。这造成了更新Tag时非常繁琐,而且极其容易出错。
今天静下心来,花了一个晚上的时间,改进了tags的数据结构,同时简化了tags的更新操作,可能还会有一些bug出现,但是总的来说,应该是利好远大于弊端的。
PS.
顺便臭屁一把,发现自己的逻辑越来越强了,改动那么大(增加一张关系表,去掉三张表里面各一个字段,修改五处后台类的更新操作,修改一处前台javascrip的更新操作,顺带把原有数据update到新建关系表),基本上没出什么差错,可以说是一气呵成。
不得不小佩服我自己一下下。(lol)