Title
c
Charles Nguyen
04/15/2023, 1:37 AMHey all, I'm looking around at creating gRPC client (https://github.com/questdb/questdb/issues/2073), and I guess a Python script would suffice/be best? With any other language, it would require having dependency in our codebase which goes against our philosophy
actually to implement server side of gRPC, that would still require a dependency on their https://github.com/grpc/grpc-java, or any other one of gRPC's 10 languages supported...
n
Nicolas Hourcard
04/17/2023, 11:10 AM@javier ramirez any hint we could give to @Charles Nguyen? thanks!
j
javier ramirez
04/17/2023, 11:31 AMI am afraid I am not super familiar with this. I have used grpc and protobuf in the past, but I have never used those in the context of running SQL queries on a database. I used protobuf as a lingua franca when working with kafka and similar tools across languages, but never grpc to execute queries
I can see cockroach DB, who also implements SQL using pgwire, uses grpc, but they don´t actually expose it to end applications, but as a way to coordinate different nodes in the cluster https://www.cockroachlabs.com/docs/stable/architecture/distribution-layer.html https://www.cockroachlabs.com/blog/a-tale-of-two-ports/
In any case, to the best of my knowledge, having a gRpc client means the server needs to be gRPC aware, and that means adding the grpc-java dependency as identified by Charles
c
Charles Nguyen
04/17/2023, 1:57 PMI see… looking at this feature I don’t have any specific in mind other than what the issue mentions above… gRPC is faster so it’s just a good alternative to be exposed alongside REST and wire
n
Nicolas Hourcard
04/17/2023, 1:59 PMwhat is your use case/industry?
c
Charles Nguyen
04/17/2023, 2:07 PMThe use case is pretty general, just that gRPC is considered faster with receiving and sending data (loading database and returning query result)
But questDB also supports quite a few protocols and from the demo it’s pretty fast already… so I can see not much incentive for adding gRPC
n
Nicolas Hourcard
04/17/2023, 2:08 PMit would be great to see if you face performance issues with PostgresWire / HTTP on the query side?
You are right in terms of prioritisation, there are quite a few items that we are focusing on completing asap at the moment !
c
Charles Nguyen
04/17/2023, 2:14 PMThere’s not any performance issue I’m facing right now… but I don’t mean to be pushy on this feature either =)) I’m just looking at working on this github issue and asking around here for opinions
Thanks for all the helps!