n0gg1n
Hey there 
What is the blocker to not “merge” ash_postgres and ash_sqlite and use a more general ash data_layer (e.g. ash_ecto_sql) with support for all ecto supported adapters?
And would it make sense to implement such library to benefit from ecto’s already implemented adapters?
Thanks for this great library!! 
Where Next?
Trending in Questions
Other Trending Topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Catch errors, track performance, monitor hosts and more.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #security
- #metaprogramming
Our Sponsors
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
zachdaniel
There will always need to be two separate data layers, because Ash data layers are not pure SQL drivers. They make choices based on what a given data source’s capabilities are, that kind of thing. For example, AshPostgres supports aggregates via inner lateral joins, but AshSqlite does not support that, and if we want to support aggregates with it we will need to figure out a different strategy later. Same is with atomics, because sqlite doesn’t have a way to raise an error (that I could find) in the same way that
ash_postgresdoes.however, I would really like to see an
ash_sqlpackage extracted out that allows them to share the bulk of their logic as much of it is the same.