Swedish police saves 400 cars by using MySQL

MySQL has a press release that tells us that the Swedish police save the amount of 400 fully equipped police cars in the period of five years. Unfortunately, very few Swedish governmental organizations tells the public these kind of facts about their savings using Open Source. I hope this will be a wall breaking case.

Comments

Anonymous said…
saving 400 cars... and my income is 4.23 car/per year.(?)

Make it simple: how much money do they save?
something like this:
if such a car costs 25000 , then they save 10 million.

So the key question is : what does such a car cost?
October 3, 2007 at 12:24 AM
Magnus Runesson said…
After some searching I found that a police car costs in Sweden from about $75000.
October 3, 2007 at 8:35 AM
Anonymous said…
thanks for the research.

30m is a lot of $$$ for just a DB system.

I assume that that is the money they spend on MS-SQL licenses in the past.
If this becomes a success then I wonder if it is possible to sue public organizations for giving away millions!

I used to work for a governmental organization that spend even more on a website + documentation system. I told them they could get the same (and better) for free, but they couldn't believe it.

We need more of such examples!
October 4, 2007 at 3:09 AM
Anonymous said…
They saved this money from migrating from ORACLE database to MySQL database. That simple
August 22, 2008 at 10:29 AM
Post a Comment

Popular posts from this blog

Circles in PostGIS

Image
OGC and PostGIS has no data type to represent a circle. Instead one use ST_Buffer(geom, distance) to get a geometry that covers the area within the distance to geom . So if geom is a point you get a circle. But it does not return an exact circle. The circle is approximated represented by a polygon using eight points. One can increase the precission by adding a third argument to ST_buffer that is the number of points in the polygon returned. The unit for distance depends on what SRID is used. But what if you have a geometry that you know is a circle created with the method above? There is no exact method as far as I know, but her comes a good approximation. First we want the origo of the circle. ST_Centroid(geom) comes to handy. It returns the centeroid point of the geometry, in this case the origo of the circle. To get the radius we pick out the first point in the polygon returned by ST_Buffer with PointN(ExteriorRing(geom),1) . We need to call ExteriorRing to get the polygon of...
Read more

Create your own CA with TinyCA2 (part 1)

Image
A Certificate Authorities (CA) issues certificates to people and organization that gives us the possibility to know that we surf to the right web site and not a phising site. This concept can be nice to use on your private sites too, but you may not want to spend a lot of money to get a certificate for your site. Most common when one installs a web-mail server at home is using a self signed certificate. When one surf to the web-mail server from a friends computer one can not be sure that nobody listens to the traffic if one not verifies the signature of the self signed certificate. Maybe an easier and definitely a more scalable solution to this is to create ones own CA structure. When we are ready with this how to you will have installed a certificate on your web server, installed the root certificate into your Firefox, and you will have the root certificate stored on a USB-memory stick. First time you want to read your mail from a friends computer you install the root certificate f...
Read more

Create your own CA with TinyCA2 (part 2)

Image
In part one of this series we created a root CA, a sub-CA and a certificate for our web site All certificates are stored in TinyCA2 s configuration. In this part we will: export the root CA:s certificate import the root CA:s certificate into Firefox export the certificate for the web site configure our web server to use the web site certificate To be able to import the root CA certificate to Firefox we must export it from TinyCA2. In the main window of TinyCA2, open the CA-menu and select Open CA. Select your root CA. Select Export CA Certificate in the toolbar, which is the second icon from the right. You may change the file name. Press Save when ready. Start Firefox, select the Edit-menu and Preferences. Click the Advanced icon and then the Encryption tab. Select View certificates and then the Authorities tab. You can see all the CA:s you trust. Click Import and select the file with your exported root certificate. You can in the Downloading Certificate window control what purpo...
Read more