May 16, 2015, 4:11 a.m.
postgis
,
python
,
road.lk
Which PostGIS function or operator do you use if you wanted to find the overlap between different lines? There are several candidates with ~, && , ST_Overlaps and and ST_Intersect being amongst the most prominent. They all do the job in different way and take different amounts of time a ...
May 8, 2015, 5:48 a.m.
postgresql
,
streaming
,
replication
,
repmgr
,
roadlk
On Monday road.lk was offline for nearly an hour. It was due to the primary database server crashing, no data was lost but the automatic failover hadn't kicked into action automatically. For nearly two years road.lk operated with just log shipping WAL archives. We took a pg_basebackup about once ...
April 24, 2015, 4:41 a.m.
carpool
,
sri lanka
,
roadlk
Making inroads into city traffic, that was the title of a Sunday Times article nearly two months ago. Why the hell am I writing about it now? I am a firm believer of the old adage better late than never. And I do have a very good excuse, I was kept really busy by the carpool project which is what th ...
Oct. 6, 2013, 2:24 p.m.
Django
,
Python
,
roadlk
Shut up and just give me the code? Ok, look at the bottom of this post.What is the slowest query on road.lk? It's the select count(*) on the traffic alerts table that Django admin insists on executing each time someone visit the admin page for the alerts. Though we are fully operational only in Sri ...
Feb. 21, 2013, 4:27 a.m.
gps
,
road.lk
,
sri lanka
Road.lk's traffic alert system now get's a fair bit of use, and proved it's worth whenever the congestion level in Colombo went through the roof. For example when that infamous traffic survey was conducted by the police, road.lk started reporting higher levels of traffic by 6:39am and over the next ...
Feb. 5, 2013, 3:19 a.m.
road.lk
,
security
The most under reported event of the year is the attack by Iranian hackers on nic.lk using an SQL injection. It shouldn't even be called hack because the security loop hole that was exploited was as big as a football field. They had an opportunity to cause some pretty serious damage but it seems lik ...