Recently I needed to hook up a rails app to MSSQL 2005. Some quick google searches and I get tons of information that is contradictory and out of date. Once I figured out all the right steps, it is very easy to get running:
Link: http://rhomobile.com/
Shameless plug here - I'm working for a cool startup in Cupertino that has brought ruby to the mobile device. You write apps in ruby and html, quite similar to rails apps, and then you can deploy your app on several mobile platforms. From their website:
Rhomobile's open source mobile application framework Rhodes lets you quickly build native mobile applications for all smartphone operating systems: iPhone, BlackBerry, Windows Mobile, Symbian and Android. These are true native device applications (not mobile web apps) which work with synchronized local data and take advantage of device capabilities such as GPS, PIM contacts and camera.
Another cool thing that Rhomobile provides is an online IDE. You create your apps there, and then select what device you want a build for. No need to spend time setting up mobile SDKs, it's there for you already. Currently in open beta: http://www.rhohub.com
As I dive into the world of datawarehousing, designing the schema for this case is much different than you would for a transactional database. In a standard transactional database you would first find all your entities and relationships, and proceed to normalize to 3NF. In a datawarhousing environment you are actually de-normalizing the tables.
The startup I had been working for went under, so I have been busy finding a new job and settling in. Got a good gig now at a new place and things are going well.
I'm not doing as much Ruby any more, but I am doing lots of datawarehousing work. There is a new engine out for mysql called 'infobright'. It has proven to be very quick when doing the kinds of queries you do when analyzing web statistics. Easily 10x as fast as MyISAM tables.
I am a big fan of the Mobwars game on facebook. It is pretty fun, but there is lots of tedious things that you have to do to start making money. One of these things is attacking various users attempting to boost your rating or steal money.
As a fun task, I decided to see what I could do with page scraping and Mechanize. Here is some examples on how to use it.
Recent Comments