Access crate via HTTP or via PostgreSQL

Hi,

Long time no hear, I hope you are well.

What is your use case?, what are you trying to do?.

Under the scenes both protocols’s purpose is to serialise and send to and receive from CrateDB queries and result-sets. Each protocol has it’s own overhead, but the differences are small from my own experience. Also, a lot of the performance can be milked through improving the original query, or by batching inserts, and other techniques that have nothing to do with the choice of protocol.

Here is an example of how you can interact using java.

Here is an example on how you can achieve launch using a different technology/language, node.js/javascript.

Happy days!