News for hackers. Stuff that matters.
Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by antirez on Friday July 29, 2011 @02:13PM (#2823056)
As I said multiple times, in my humble opinion this is completely a useless effort. There are two cases:

1) Two databases are semantically very similar. In such a case even if the query language is different porting your application from one to another is trivial, especially if you have a minimal layer of abstraction between your program and you data, things like fetchUser(ID) or alike.

2) If the data model is different, using the same query language does not help at all.

So the question is WHY? :)

Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by Jach on Friday July 29, 2011 @03:45PM (#2823467)
A gazillion already-made programs (for example data visualization tools, analytics software, etc.) speak only SQL. If the choice is between reinventing the wheel for each NoSQL DB vs. using a SQL DB (such as http://luciddb.org/ [1] and soon postgres with their recent introduction of foreign data wrappers[2]) as an intermediate layer or even a full data mart that does what you want query-wise, a lot of people want to save time and just use the SQL DB. (Why do you think Hive exists?) There's more to DBs than storing user data for cat picture sharing sites...

[1] Disclaimer: I wrote a preliminary CouchDB connector for Lucid that'll get released separately with the upcoming 0.9.4 release.

[2] I believe one of the first postgres foreign data wrappers was around Twitter. So you move some API accessing code from an application layer that realistically only your application can talk to, to the DB layer, and now everything that can talk to the DB layer can access the data. (Unless they want it raw, then they'll get it from Twitter.)

Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by sitkack on Friday July 29, 2011 @09:38PM (#2824567)
In the same vein, I have been thinking about a mysql wrapper around various nosql products.

Same issue, installed base and connectivity.

Composition, interfaces, abstraction.

Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by mmalone on Thursday August 04, 2011 @01:59AM (#2844832)
The argument in the article that inspired this work[1] (and it may be an academic one) is that data models are all semantically very similar. The authors argue that category theory provides mathematical formalism for a generic abstraction that would bridge both the relational and K/V worlds.

The ideas all seem very formative to me. There are a bunch of assumptions, logic gaps, etc. But it's not all bad.

[1] http://cacm.acm.org/magazines/2011/4/106584-a-co-relational-...

Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by thesorrow on Friday July 29, 2011 @05:00PM (#2823774)
Obviously the only good thing is for developers who are not familiar with noSQL technologies. This is a nice try to unify the model language. Unfortunately, the additional load generated by the query parsing is a no go for me.
Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by yawniek on Friday July 29, 2011 @04:07PM (#2823572)
that is why i think that the "universal query languange" should be on a different layer. SPARQL is one answer to this very complex problem. something similar to sparql with map/reduce style distributed algorithms embedded could be an interesting approach.
Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by arockwell on Friday July 29, 2011 @11:23PM (#2824764)
SPARQL is substantially less powerful than SQL. No delete/update/insert statements, no subselects, and limited aggregation and functions. I've used SPARQL a lot in the past year and I am constantly running into limitations.

Performance has also been very poor (we use Jena SDB). I don't know if poor performance is an implementation problem or an overall weakness.

Re:Sqlite and couchdb creators announce unQL. SQL for NoSQL by yawniek on Saturday July 30, 2011 @02:40PM (#2826339)
well there are efforts for updates etc. but yes, you have limitations with sparql, thats why i think it is not the final solution. but it is a first approach to push the possibility to query data to a different layer.