Over the past few months I have been experimenting with building a fast, distributed, in-memory, append-only database designed for analytics. The idea being that many No-SQL databases are pretty terrible at ad-hoc querying, and while ordinary relational databases provide good support for ad-hoc queries, their performance leaves a lot to be desired for large data sets. Basically an open source Vertica / KDB.<p>The system will accept data over HTTP (as JSON / CSV) and can be queried in either SQL, or an SQL like language, with full support for joins, sub-queries and aggregations, with output as CSV or JSON over HTTP.<p>The idea being that you can fire of a JSON request to your analytics database whenever something happens (be it a signup, purchase, click, etc) and have that data captured, ready for use in your dashboards or for ad-hoc querying. The system will also be able to integrate with R for statistical fanciness.<p>If such a system existed, would you use it?<p>I will probably continue working on it regardless of any feedback (because its fun!), but I'll spend more time on it if its something people feel they might use.<p>If you would like to develop it too (using a combination of C for data manipulation and go-lang for everythign else), send me an email.