Open Source

Crap that’s happening in the open source world.

I got to implementing one of the primary use cases for OSTD – user uploads a template .pot file and gets a bunch of .po files with as many translated strings as possible. From a design point of view this isn’t a big deal: parse the .pot into a data structure, make a query per …

Continue reading Translating template files

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 …

Continue reading Number of SQL queries per page

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 …

Continue reading Smaler PHP-generated HTML