Re:Cyphernetes: A Query Language for Kubernetes
by danpalmer on Monday December 16, 2024 @12:17AM
(#42428178)
I'm not against replacing jq/jsonpath for the right tool, they're not the most ergonomic. What isn't clear to me though is why this isn't SQL? It's so nearly SQL, and seems to support almost identical semantics. I realise SQL isn't perfect, but the goal of this project isn't (I assume) to invent a new query language, but to make Kubernetes more easily queryable.
[ Parent
| on HN ]
Re:Cyphernetes: A Query Language for Kubernetes
by rubenvanwyk on Monday December 16, 2024 @12:44AM
(#42428266)
It's based on Cypher, which is a query languages for graph databases. The author/s probably thought the data is more graph-like than relational.
Re:Cyphernetes: A Query Language for Kubernetes
by danpalmer on Monday December 16, 2024 @04:56AM
(#42429572)
Ah. I’ve not heard of Cypher before.
I’d disagree and say that Kubernetes is much more relational that graph based, and SQL is pretty good for querying graphs anyway, especially with some custom extensions.
This does make more sense though.
Re:Cyphernetes: A Query Language for Kubernetes
by amanj41 on Monday December 16, 2024 @10:56AM
(#42432190)
Graph DBs are generalized relationship stores. SQL can work for querying graphs, but graph DB DSLs like Cypher become very powerful when you're trying to match across multiple relationship hops.
For example, to find all friend of a friend or friends of a friend of a friend: `MATCH (user:User {username: "amanj41"})-[:KNOWS*2..3]->(foaf) WHERE NOT((user)-[:KNOWS]->(foaf)) RETURN user, foaf`
Re:Cyphernetes: A Query Language for Kubernetes
by philsnow on Monday December 16, 2024 @12:27AM
(#42428213)
Reading your comment made me think that they're so close to "OSQuery for k8s", but that already seems to exist: https://www.uptycs.com/blog/kubequery-brings-the-power-of-os...
Re:Cyphernetes: A Query Language for Kubernetes
by captn3m0 on Monday December 16, 2024 @07:52AM
(#42430541)
I haven't tried it , but steampipe has a k8s plugin which lets you use PG/sqlite: https://hub.steampipe.io/plugins/turbot/kubernetes/tables
Re:Cyphernetes: A Query Language for Kubernetes
by ricenb on Tuesday December 17, 2024 @12:41AM
(#42438661)
For SQL based query, you could take a look at Karpor(https://github.com/KusionStack/karpor), which provides powerful, flexible queries across multi clusters, also in the next release we will support Cyphernetes as other query method.