If someone updates a po file with 100 translations – I need to figure out whether each translation is already in the database, and if not – insert it. The result looks like this (more about “looks” later): This is just a snippet. I am concerned that running an SQL query like this: “SELECT Translation.TranslatedString …

By Andrew Smith I will have something like this on one of the pages in the website: Each of those dropdown lists has the 190 language codes I mentioned in the previous post. It may not sound like a lot but 1900 <option> values really is a lot of HTML. It’s very easy to generate …

One of the things I will need in my database is a table with all the language codes used in Linux locales. Things like en, fr, es, etc. There are lots, but where do I get a reliable list? I’ve done some searching and found the IANA language subtag repository. It’s a 45000 line text …

I have an aversion for vi. It’s present on every linux box so I had to learn how to use it but I very much dislike it, it’s a pain the the ass to use. (Emacs is no better by the way) I found a brilliant solution for that problem though. In Linux there is …

I was always a fan of version control, even for binaries like word file for homework. This helps keep a history of stuff that may get deleted or changed, and helps a lot for working using multiple computers. But I’ve never version controlled a website. Mostly because I never had one I was doing serious …

I am the first to admit that I’m almost completely incapable of making something look good. I’m reasonably good at making things functional and easy to use, but when it comes to looks.. not me. At first I thought I would start with just plain black and white PHP output, but I felt that was …

I have a long list of ideas. Why have I chosen OSTD? Well – it had to be something I was passionate about, and I am always proud to tell people that my software is translated into 40 languages. I would love to be able to say that with my help hundreds of other software …

OSTD, the Open Source Translation Database – that’s the best I could come up with. The name and the acronym has to be unique enough that I can get to the top of search engine results relatively easily. But there’s so much more to the name. At first I wanted to get the website a …