acrolink
I am considering using Amazon Aurora PostgreSQL Limitless Database in my next project. There will be very large amounts of data and this solution seems to handle built-in most of the scaling and sharding concerns.
My questions:
- Any experiences doing this in a Phoenix / Ecto based application ?!
- Can regular migration files be used ?!
- Any general thoughs on this ?!
Thank you.
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io
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
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
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.
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
The deployment platform built for Elixir: PaaS ease, VPS control.
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 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
garrison
I have not used Aurora, but I believe they are quite compatible with Postgres (last I remember it’s a fork with a new backend - maybe different now), so you should be able to use Ecto with no issues.
I do remember seeing a post on here about weird latency characteristics with Oban using Aurora - I don’t remember if they sorted it out or how big of a deal it was, but you could search for it.
VictorGaiva
In general, I personally would avoid going to fully managed “customized” solution as it could result in vender lock-in, which is kind of AWS’s whole business model.
It usually costs very little when starting, and it might actually cost them money to provide you the service, but ends up costing a whole lot more if you get to scale pass a point, where they end up getting back their money.
That being said, if you don’t plan to scale past a certain point and is not worried about possibly having to migrate to another service when they inevitably increase their pricing, you should be good.
garrison
I agree about AWS/Cloud in general but this is managed Postgres so you can always take your backups and run. Postgres is quite possibly the only database left that we can say for certain won’t be rugpulled, which is why we all use it!
acrolink
@VictorGaiva .. I agree, seems better to implement and manage sharding at application level so I can avoid vendor lock. This way, I can still use regular migration commands for Ecto.
Besides that, to even start using the Amazon Aurora PostgreSQL Limitless Database, there is a minimum requirement of running 16 ACU / Hour service, which is around 2,200 USD / Month! To just start using managed sharding