JSON有查询语言吗?

是否有(大致)SQL或类似xquery的语言来查询JSON?

我正在考虑非常小的数据集，很好地映射到JSON，它将很容易回答查询，如“X的所有值是什么，Y > 3”或做通常的SUM / COUNT类型操作。

作为一个完全虚构的例子，是这样的:

[{"x": 2, "y": 0}}, {"x": 3, "y": 1}, {"x": 4, "y": 1}]

SUM(X) WHERE Y > 0     (would equate to 7)
LIST(X) WHERE Y > 0    (would equate to [3,4])

我认为这将在客户端和服务器端工作，结果将被转换为适当的特定于语言的数据结构(或者可能保留为JSON)

快速搜索一下谷歌，就会发现人们已经考虑过它并实现了一些东西(JAQL)，但它似乎还没有一个标准的用法或库集出现。虽然单独实现每个功能都是相当琐碎的，但如果有人已经做对了，我就不想重新发明轮子。

有什么建议吗?

Edit: This may indeed be a bad idea or JSON may be too generic a format for what I'm thinking.. The reason for wanting a query language instead of just doing the summing/etc functions directly as needed is that I hope to build the queries dynamically based on user-input. Kinda like the argument that "we don't need SQL, we can just write the functions we need". Eventually that either gets out of hand or you end up writing your own version of SQL as you push it further and further. (Okay, I know that is a bit of a silly argument, but you get the idea..)

当前回答

另一种方法是使用mongoDB，你可以将JSON存储在mongoDB中，然后通过mongoDB查询语法进行查询。

2012-11-08 19:12:43

其他回答

我是一种新的JSON查询语言的开发者，叫做~Q(发音为“unquery”)。它旨在解决其他JSON查询语言的许多缺点，并平衡易用性和表达能力。作为主要开发者，我当然是有偏见的，但你可以自己看看并决定:

https://github.com/xcite-db/Unquery

对于OP的例子，~Q中的查询将是:

{
    "example1:[]" : "$sum(x)?y>0",
    "example2:[]" : ["x?y>0"]
}

2022-09-19 05:56:23

下面是一些简单的javascript库，也可以做到这一点:

Dollar Q is a nice lightweight library. It has a familiar feel to the chaining syntax made popular by jQuery and is only 373 SLOC. SpahQL is a fully featured query language with a syntax similar to XPath (Homepage, Github jFunk is an in progress query language, with a syntax similar to CSS/jQuery selectors. It looked promising, but hasn't had any development beyond its in initial commit. (added 2014): the jq command line tool has a neat syntax, but unfortunately it is a c library. Example usage: < package.json jq '.dependencies | to_entries | .[] | select(.value | startswith("git")) | .key'

2012-12-03 21:42:54

如果你使用的是。net，那么Json。NET支持JSON之上的LINQ查询。这篇文章有一些例子。它支持过滤、映射、分组等。

2009-04-26 02:24:46

PythonQL提供了一种嵌入式语法，IMHO是对SQL的改进，主要是因为group、window、where、let等可以自由混合。

$ cat x.py
#coding: pythonql
data = [{"x": 2, "y": 0}, {"x": 3, "y": 1}, {"x": 4, "y": 1}]
q = [x match {'x': as x, 'y': as y} in data where y > 0]
print(sum(q))
print(list(q))

q = [x match {'x': as x, 'y': as y} as d in data where d['y'] > 0]
print(sum(q))

这段代码显示了您的问题的两个不同答案，这取决于您需要处理整个结构或仅处理值。执行会给你预期的结果。

$ python x.py
7
[3, 4]
7

2020-03-07 18:37:08

在MongoDB中，这就是它的工作方式(在mongo shell中，存在您选择的语言的驱动程序)。

db.collection.insert({"x": 2, "y": 0}); // notice the ':' instead of ','
db.collection.insert({"x": 3, "y": 1});
db.collection.insert({"x": 4, "y": 1});

db.collection.aggregate([{$match: {"y": {$gt: 0}}}, 
                         {$group: {_id: "sum", sum: {$sum: "$x"}}}]);
db.collection.aggregate([{$match: {"y": {$gt: 0}}}, 
                         {$group: {_id: "list", list: {$push: "$x"}}}]);

前三个命令将数据插入到集合中。(只需启动mongod服务器并连接mongo客户端。)

接下来的两个处理数据。$match过滤，$group分别应用sum和list。

2015-09-16 11:57:32

JSON有查询语言吗?

推荐文章

最新文章

标签