Posts tagged road.lk

Which PostGIS function to use?

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 ...

Postgresql streaming replication

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 ...

Making inroads into city traffic

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 ...

Django admin select count(*) from ...

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 ...

Leveling up the traffic alerts system

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 ...

Being found out.

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 ...