Goose97
Avoid redundant database roundtrips
Hi everyone. I’m designing a web backend service in Elixir and having some problems. This question is not unique for Elixir language but I will post it here anyway to see if we have a solution written in Elixir.
Here’s my case:
Let’s say my business has some coupons that users can apply. To simplify, the coupon apply procedure can be broken down into two steps: validate the coupon and increase the claim counter. I would like to split the above two steps into two separate functions, each exposes a minimal interface (Eg: we can simply pass the coupon_id to the function). But doing so will result in two roundtrips to database to fetch the coupon struct and most of the time, the second one is unnecessary.
The solution that I have in my head now is to combined these two functions into a third one validate_and_claim. But that approach contains a lot of duplication code.
So is there any better approach to this problem? I know there won’t be a perfect on which is the best of both worlds but I’m willing to consider other solutions and their trade-offs.
Thanks and have a nice day!
Marked As Solved
kokolegorille
If You are validating coupon, why pass coupon_id? Just pass a coupon struct. This way, no need to call db.
And You could pattern match on Coupon to be sure You are working with a valid struct.
validate_coupon(%Coupon{} = coupon)
This would put side effect (loading from db) outside the function, making it pure.
And if You return the updated coupon, You could chain…
coupon_id
|> load_from_db()
|> validate_coupon()
|> increase_counter()
Also Liked
kokolegorille
I think the previous post from @al2o3cr is a good advice.
Most prefer to have a functional core, free of side effects, as it is easier to test.
That means pushing db calls out of the core.
Anyway, I don’t see the advantage of passing the id, because sooner or later You will use it to make db call.
NobbZ
A multi will not reduce roundtrips, it will just have them in a single transaction.
al2o3cr
IMO passing around IDs is not really “minimal”; a better alternative is to convert those incoming parameters into domain structs as soon as possible in the controller and pass the structs around in the business logic.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
Categories:
Sub Categories:
Forums
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.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"