Elixir-dbvisor/sql Needs a SOTA pool and I want to hear your ideas

Questions / Help
, ,
1

So the day has come, and due to unforeseen technical issues, then SQL - Brings an extensible SQL parser and sigil to Elixir, confidently write SQL with automatic parameterized queries. will require it’s own pool, we want to aim high, so we’re talking SOTA. I want to hear your ideas, but lets talk requirements so we know what we’re working with.

  • Minimal
  • Ideally no message passing, one or two is not a deal breaker
  • Affinity for prepared queries and scheduler id, all queries have a global unique integer set at compile time
  • Linear
  • Dynamic sizing
1 Like
2

When you say SOTA, do you mean state of the art? And when you say pool, do you mean a db connection pool?

(genuine questions, not trying to be a dick)

3

Yes, I’ve seen “SOTA” a lot in the last few years along with more acronyms like “AI” (Artificial Intelligence) and “LLMs” (Large Language Models), and it means state-of-the-art, which in turn is defined as:

adjective
belonging or relating to the most recent stage of technological development; having or using the latest techniques or equipment.

I don’t know, and would guess it is for something else. From the little I understand, the idea of the SQL library is to convert/compile Elixir code into SQL:

SQL
Brings an extensible SQL parser and sigil to Elixir, confidently write SQL with automatic parameterized queries.

I would think it doesn’t deal with connecting with any particular RDBMS.

All DB-related dependencies are dev/test-only.

I’m also curious to learn more about the unforeseen technical issues and how they lead to pooling :slight_smile:

4

Yes, we’re building a state of the art database connection pool, an initial implementation in under 100 lines has been done and is already out performing db_connection in every metric. Ecto uses db_connection in a way that made it impossible to introduce features like: 100% cache hit on prepared queries.

It would actually be underselling the library to only call the pool SOTA, as we’re closing in to be SOTA SQL library across all languages as I’ve never seen anything like this before.

1 Like