Made to Order Software Corporation Logo


Change the encoding of a Postgres database

Ever wondered how you could change the encoding of one of your Postgres database?

I have had that problem several times, and in most cases people tell you to:

  1. Dump your database, may have to use –encoding on the command line
  2. Drop the existing database (or rename it)
  3. Create a new database with the proper encoding
  4. Restore the database

The problem is that there is no support for altering the encoding of a database. The ALTER DATABASE does not include that option. And since it should be really rare, it makes sense.

Now, there is an easier way ...

Internet Explorer “Save As …”

Today, I found a good one. Internet Explorer has a “Save As …” feature that let you save a page that you are visiting.

The page I have includes a table with a cell that has the align and valign attributes set to center and middle respectively. Once saved with Internet Explorer, these change to vAlign and align and center and middle respectively. Yes. Meaning that the values are swapped. Now the valign says center instead of middle, which will work with most browsers, but the worst is the align that is set to middle. That should never happen.

Drop the cords!

No more cords for your computers to run? Is that a joke? Not really. All these cords to get electricity to our computers and other gadgets are annoyingly in our way.

One document with all translations

Have you ever thought that it would be great to write one document including all the translations in a single file? Outside of the fact that this makes the document relatively large, it makes the translation really fast, the translator can see the sentence in all the other languages and translate from that.

I actually wrote an HTML test file with two styles. One is named English and the other is named Français. And since a style entry can depend on the currently selected language, you can write style entries that get hidden when on or the other language is selected.

So, if you ...

Order Made!® version 1.10

We have finally published version 1.10 of Order Made!®

This version include one important change: the ® after Order Made!. Made to Order Software now owns the Order Made!® trademark.

We also included a few bug fixes, mostly transparent to our users.

Free Speech on the Internet

Many people think of the Internet as an incredible system that let people of all nations communicate without a problem.

The fact is that governments are in control, as always.

The Internet was born in 1995 and, with it, cheap worldwide communications. The truth is that the Internet, very early, was used as much by programmers as it was by marketers and political minorities. This is where the problem started.

LinuxWorld Conference & Expo 2008

This year, 2008, I decided to register and go to LinuxWorld. It is in August and my kids are not at school so it was easy to manage. Also, I had to go to the French consulate to get a birth certificate for my daughter. In other words, I had the chance to do two things at once!

I found it quite interesting to hear that many people were not too excited about the event. Many of the people walking around are like me: they themselves sell their own Linux solution. In other words, they are not going to be customers. I had the chance to talk with Roger Levi, the Vice President of the Open Platform ...

July 2008, a new limit reached!

I heard of Voyager 2 and the fact that it was still functional: 30 years after it left Earth! Just that is amazing to me.

The craft went through the termination shock several times now (5 if I’m correct). This is far. Further away from the Sun than Pluto. And Pluto is on average around 39.5 AU from the Sun. It is even further than Eris and Eris lies at about 67 AU on average.

Amazon Checkout and Simple Pay

This week, Amazon published a brand new set of tools for merchants. We already had PayPal and Google Checkout, now we have the same with Amazon.

AJAX, CSS, HTML, XML, SOAP, LAMP… and now Web 2.0?

Dear reader,

Yes. With all these terms, it is quite easy to get lost.

As a developer, my skills are quite extensive. I started with Logo, learned assembly language, BASIC, C, C++… and all these other languages in between, those that most people pass by such as Ada, Eiffel, Icon… And the languages you kind of have to learn because you’re in it: Bourne Shell, configuration files for 100 different software, Makefile, etc.

And once you know all of these languages, you think you’re done. Well… Not quite!

The web has got it’s own set of languages! It