#aaronpk!tell tantek I found a MediaWiki plugin to send 301 redirects for MediaWiki redirect pages instead of serving the duplicate content, it's running on indiewebcamp.com now!
#Loqitantek: aaronpk left you a message 4 hours, 12 minutes ago: I found a MediaWiki plugin to send 301 redirects for MediaWiki redirect pages instead of serving the duplicate content, it's running on indiewebcamp.com now!
#Loqitantek: aaronpk left you a message 1 hour, 36 minutes ago: would be curious to hear your thoughts on indieweb post translations http://indiewebcamp.com/translations
tantek, friedcell, lmorchard, adactio, scor, Stevef_, danbri and mxuribe joined the channel
morrocco_mole, danbri and barnabywalters joined the channel
#Loqibarnabywalters: aaronpk left you a message 10 hours, 10 minutes ago: would be curious to hear your thoughts on indieweb post translations http://indiewebcamp.com/translations
#Loqitommorris: aaronpk left you a message 10 hours, 52 minutes ago: would be curious to hear your thoughts on indieweb post translations http://indiewebcamp.com/translations
#tommorrisI wonder what we use on Wikipedia. (if anything)
#barnabywalterstommorris: I was looking on wikipedia language pages for those awkward codes, but they don’t seem to be on there. How does one go about adding them to the infobox things on the right?
#tommorrisyeah, we're using @hreflang on Wikipedia. check the 'languages' sidebar.
#tommorrisso, I'm presuming that @hreflang in HTML uses ISO 639-1 language codes like pretty much everything else on the web. HTML, XML, RDF, loads of stuff use ISO 639-1 language codes.
#barnabywalterstommorris: according to mdn it uses BCP47, but it looks like that’s another name for (or variant of) ISO 639-1
#tommorriswell, frequently one doesn't directly refer to ISO standards because ISO tend to have rather anti-sane policies like charging 120 euros to read a PDF etc.
#barnabywaltersat the moment I am leaning toward the OpenGIS functions in MySQL, as they work with what I’ve already got and don’t seem to be as bad as everyone says
#barnabywaltersaaronpk: I’m mainly using Doctrine at the mo so that shouldn’t be a problem
#tommorrisTsearch2 - full-text search without having to use Sphinx or whatever.
#aaronpkinteresting... was just considering installing sphinx
#tommorrisHStore - lets you have a simple indexed key-value store in a column in your database
#tommorrisArrays - you can declare a column as, say, int[] and can store an array of integers in it.
#tommorrisarrays also mean you don't have to denormalize excessively, which I think can be something of a SQL antipattern when taken to excess.
#aaronpkwhoa that's awesome, I didn't know about arrays
#tommorrisSELECT * FROM posts WHERE ANY(tag) == "microformats";
tantek joined the channel
#barnabywalterstommorris: that’s great because for most of where I would use that, I can keep my current version for people using mysql
#aaronpkinteresting. so my site doesn't have a DB backend yet bceause I wanted to make it as generic as possible. right now it's just .md files which I find in the filesystem.
#barnabywaltersokay well over the week I’ll have a go at getting PostGIS installed
#aaronpkbut now I want to add tags and searching, so I need some sort of index. maybe i should try PostGIS for it
#tommorrisbarnabywalters: Postgres is pretty good for geo stuff. a little project called OpenStreetMap uses it for that reason. ;-)
#barnabywaltersI’m starting to record more and more of my own location data, so I’d like it to be just as queryable as my notes are
#barnabywaltersso when open source AR hardware is a thing, I have a load of data to pipe in :)
#tommorrison the geo front, I'm very annoyed that I don't have any iOS6-compatible iOS hardware. someone has finally made a half-decent OpenStreetMap editor for iOS.
#barnabywalterstommorris: I’ve been using Pushpin for that, which only does area editing and POI adding/editing, but is sufficient for my basic usage