Schultzer
Elixir-dbvisor/sql Needs a SOTA pool and I want to hear your ideas
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
Most Liked
Schultzer
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.







