在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称(OpenSource Name):solidsnack/GraphpostgresQL开源软件地址(OpenSource Url):https://github.com/solidsnack/GraphpostgresQL开源编程语言(OpenSource Language):PLpgSQL 100.0%开源软件介绍(OpenSource Introduction):GraphpostgresQL -- a graph interface to relational dataGraphpostgresQL is inspired by Facebook's A Proof of ConceptGraphpostgresQL is alpha quality and has undergone neither extensive optimization nor comprehensive testing. To use it for production workloads would needlessly tempt fate. Install GraphpostgresQLUsing \i graphql.sql All definitions are created under the Using GraphpostgresQLTo generate a query, use SELECT graphql.to_sql($$
user("f3411edc-e1d0-452a-bc19-b42c0d5a0e36") {
full_name,
friendship
}
$$); Which should result in something like: SELECT to_json("sub/2") AS "user"
FROM "user",
LATERAL (
SELECT json_agg("user") AS friendship
FROM "user"
JOIN friendship ON (("user".id) = (friendship.second))
WHERE (friendship.first)
= ('f3411edc-e1d0-452a-bc19-b42c0d5a0e36'::uuid)
) AS "sub/1",
LATERAL (
SELECT "user".full_name, "sub/1".friendship
) AS "sub/2"
WHERE (("user".id) = ('f3411edc-e1d0-452a-bc19-b42c0d5a0e36'::uuid)) To run a query, use Removing GraphpostgresQLIt's easy to remove GraphpostgresQL: DROP SCHEMA IF EXISTS graphql CASCADE; RoadmapIn GraphpostgresQL64, we'll introduce expanded selectors (nested selection in JSON columns, for example), an interface that accepts keyword parameters, and the ability to store and re-execute queries. In GraphpostgresQL3D, we'll introduce a PL/V8 implementation, with extensible parsing, hooks and overall more modular implementation. |
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论