Thursday, October 20, 2005

sql-flavours

when talking to lots of databases you notice there are many flavours of sql. Once in a while it drives me crazy to get for example the syntax for a limit in db2 and so on. Recently i found a nice overview of the different flavours: http://troels.arvin.dk/db/rdbms/ So now we all know that a limit in db2 sql = 'FETCH FIRST n ROWS ONLY'

Friday, October 14, 2005

bbbike.de (open source navigation)


We recently discoverded an open source navigation tool (to calculate shortest distance between points of interest) at www.bbbike.de It can be used as a standalone perl desktop application or in combination with mapserver as a server based navigation tool on the web. Good work, as far as we know, the first open source navigation map.