San Francisco based Stripe has announced MoSQL, a tool for making reporting from MongoDB much easier via a live-replicating PostgreSQL database. MoSQL is based on MongoRiver, their companion product for monitoring MongoDB data updates in near-realtime.
At its heart, SQL is a domain specific language designed to allow non-professional programmers to query databases and write ad hock reports. When a company moves from a relational database to a NoSQL offering the need for ad hock reporting doesn’t go away, it just becomes harder. Simba’s ODBC drivers shift the power back into the hands of the users.
Cloud service provider Tier 3 has released Iron Foundry, a .NET-friendly fork of VMware’s Cloud Foundry platform-as-a-service. Iron Foundry gives the sizeable number of .NET developers an open source alternative to Windows Azure and lets them participate in the increasingly popular Cloud Foundry ecosystem.
VMware is adding support for PostgreSQL to CloudFoundry, it's open source PAAS solution.
Recently there have been two fairly high profile field reports on MongoDB that show it in a very unfavorable light. The majority of the criticism centers on a combination of performance problems and data loss.
MongoDB's new journaling feature improves reliability with write-ahead redo logs. Log entries are written before permanent storage is updated. When a server restarts after a crash outstanding journal files will be replayed before the server goes online. Other changes include sharding performance boosts, shell tab completion, and the addition of covering and sparse indexes.
Foursquare recently suffered a total site outage for eleven hours. The outage was caused by unexpected uneven growth in their MongoDB database that their monitoring didn't detect. The system outage was prolonged when an attempt to add a partition didn't work due to fragmentation, and required taking the database offline to compact it. Learn what happened and what responses are planned.
The first four NoSQL datastores are available as Add-ons for the Heroku PaaS (platform-as-a-service) platform. Using the Add-on system that was introduced in October 2009, CouchDB from Cloudant, Membase from NorthScale, MongoDB from MongoHQ and Redis were made available for Heroku users.
The 2nd annual RubyConf China, this year in Shanghai, China, featured Ruby creator Matz who talked about Ruby Community and Ruby 2.0. InfoQ takes a look at the other talks and what tools and databases Ruby developers in and around China use.