This recent session at OSDC 2011 Canberra is based on part of an Open Query training day, and (due to time constraints) without much of the usual interactivity, exercises and further MySQL specific detail. People liked it anyway, which is nice! The info as presented is not MySQL specific, it provides general insight in how [...]
Filed under: Conferences by arjen on Thursday, November 24, 2011 | Social tagging: concurrency > database > locking > mariadb > mysql > osdc > sql > transactions > video
1 Comment »
Some guidelines to choosing between MySQL’s numeric types, using longitude and latitude as a modelling example.
Filed under: Good practice / Bad practice by toby on Wednesday, December 23, 2009 | Social tagging: accuracy > decimal > double > float > integer > latitude > longitude > mariadb > modelling > mysql > numeric > precision > sql
No Comments »
The No-SQL tag really lumps together a lot of concepts that are in fact as distinct from eachother as they are from SQL/RDBMS. An object store is not at all similar to Cassandra and Hypertable, which is not at all like an column store. And when looking at BigTable derivatives, it’s quite important to realise [...]
Filed under: Uncategorized by arjen on Thursday, December 3, 2009 | Social tagging: bigtable > cassandra > couchdb > hypertable > mongodb > mysql > nosql > postgresql > rdbms > sql
No Comments »
Antony and I are busy getting the Open Query GRAPH Engine code ready so you all can play with it, but we needed to test with a larger dataset to make sure all was fundamentally well with the system. We have some intersting suitable dataset sources, but the first we tried in ernest because it [...]
Filed under: GRAPH engine by arjen on Wednesday, October 21, 2009 | Social tagging: graph > GRAPH engine > graphengine > hierarchy > mysql > open query > sql > tolweb > tree > tree of life
1 Comment »
The linux.conf.au organisers have given all miniconfs an additional few weeks to spruik for more proposal submissions, huzzah! So if you didn’t submit a proposal because you weren’t sure whether you’d be able to attend LCA2010, you now have until October 23 to convince your boss to send you and get your proposal in.
Filed under: Conferences by cafuego on Wednesday, September 30, 2009 | Social tagging: best conference in the world > community > conference > contribute > database > filesystem > lca2010 > linux > linux.conf.au > memcache > mysql > opensolaris > raid > sql > storage > zfs
No Comments »
Since you were going to linux.conf.au 2010 in Wellington, NZ anyway in January of next year, you should submit a proposal to speak at the data storage and retrieval miniconf. If you have something to say about storage hardware, file systems, raid, lvm, databases or anything else linux or open source and storage related, please [...]
Filed under: Conferences by cafuego on Monday, August 24, 2009 | Social tagging: best conference in the world > community > contribute > database > filesystem > linux > linux.conf.au > memcache > opensolaris > raid > sql > storage
No Comments »
Looking at twitter #songsincode (just search on #songsincode tag), it appears a large chunk of geeky/nerdy world has come to a halt while spending the day expression song titles in code. So far we’ve seen most programming languages as well as CSS and SQL come by. I think it’s a nice example of how “the collective” [...]
Filed under: Uncategorized by arjen on Friday, August 21, 2009 | Social tagging: code > lyrics > music > mysql > songs > songsincode > songsincodedb > sql > twitter
1 Comment »