Add Elixir tests for Crate

[corck]

Add basic elixir qa tests

[marregui]

Hi @corck ,

Would you be up for it?, would you like to contribute it?.

Best regards,

[corck]

Currently I've no time, but would love to see Elixir's Ecto library play well with Crate.

[marregui]

I have a little experience with Elixir, i.e. I have watched everything Jose Valim has on youtube, and I went through Introducing Elixir in the past. This could be done, but it is not a priority at the moment.

Would you have a use case, or is it just curiosity?.

Thank you

[corck]

We're working on a smart city platform and will eventually connect thousands of sensors to it, and at some point will need to rethink our db backend. we've tried ecto's postgres adapter at one point (better said, Jodok did for us) but failed due to some postgres tables or configuration that crate doesn't have, can't remember exactly. but it wasn't trivial to fix as far as I remember, but it's been over a year I guess, maybe its working now ...

[marregui]

I assume you will be using Elixir/phoenix, and Ecto comes with it. What's your backend now?

I had personal interest in the language in the past. When asking internally, it seems we have not seen much demand to support it. It would help if you would start a discussion in https://github.com/crate/crate/discussions to check the interest and attract demand that would justify supporting Elixir/Ecto.
If the discussion raises the thumbs up from PM, I volunteer to enhance crate-qa to spin up an Elixir client doing the same as the node-postgres example.

[corck]

yes, we are building up on Phoenix (& Ecto) with Postgres.
Phoenix LiveView is a total game changer, we got rid of most of our SPA and replaced with it, will attract more people in the near future.

[corck]

There you go: crate/crate#10296

[marregui]

I saw, thank you!.

I will leave this issue open and I will keep an eye on the discussion.

[amotl]

Hi. We've verified the Elixir Postgrex driver, see how to connect to CrateDB from Elixir applications.

• Elixir Support crate#10296 (reply in thread)

We are validating this on behalf of a CI/GHA workflow running each night after CrateDB nightly has been released. Do you think this is good enough to close this request?