D4no0
I was watching this conference and I was wondering if that approach is really more scalable. In that conference the guy shows an approach where you migrate all logic related to roles and the data that can be accessed to postgres. In my opinion the downsides are:
- Harder to migrate new changes on an existing database.
- Writing raw queries in SQL.
- Debugging queries(since I didn’t try it, I’m not sure if ecto logs the trasnaction correctly)
- Possible performance degradation.
However there are some big advantages also:
- Move all the logic related to roles to postgres.
- Clear readable code without convoluted queries.
So my question is: would you move your roles logic to postgres, and if no why?
Where Next?
Trending in Discussions
Other Trending Topics
Latest Phoenix 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
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #elixirconf-us
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #elixirconf-eu
- #processes
- #security
- #api
- #forms
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
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. Next: ElixirConf EU 2027
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Producing high quality Elixir screencasts since 2017.
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 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
idi527
Might be somewhat relevant:
tjdam
I just found this talk and it blew my mind. I wasn’t even aware that Postgres had all of these features (newbie here).
So the first thing he says is that hopefully you create a role for your application, which most people don’t. I’ve been using the postgres default, as he mentioned. What is the issue with that, though? And what would be a better approach to take?