search

comsysto / jumbodb

22 stars 1 forks source link

Provide a simple query language #96

Open devproof opened 11 years ago

devproof commented 11 years ago

Provide a simple query language, maybe in a SQL style

e.g. Query on Json Field

FROM <collection_name> where myJsonField IN(EQ: 'myValue', GT: 'otherValue')

Query on Index ($ + index name)

FROM <collection_name> where $myIndexName IN(EQ:'myValue', GT: 'otherValue')

Combi Json Field and Index

FROM <collection_name> where  myJsonField IN(EQ: 'myValue', GT: 'otherValue') AND $myIndexName IN(EQ: 'myValue', GT: 'otherValue')

but how to provide subqueries? any other ideas?

devproof commented 10 years ago

https://github.com/FoundationDB/sql-parser/

devproof commented 10 years ago

http://codemirror.net/mode/sql/index.html use this for sql highlighting