D4no0
Hello,
I want to build a small payment system. I want to store all the transactions and cross-check the user balance when he wants to make a purchase by evaluating his balance from all his transactions.
I am using postgres for most of my data storage so I thought about creating a table there with all the transactions and use it to calculate balance, however I am concerned about the performance implications when it comes to multiple users and more transactions.
Is there a better/more standardized way to achieve this?
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixir-ls
- #ai
- #elixirconf-us
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
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 - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Enabling companies to succeed by building software people love.
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 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
egze
Postgres can handle a lot. Performance will depend how you design your application, schemas/tables, indices etc.
For calculating balance, if you recalculate every time using all transactions - it will get slow. What is common is to calculate snapshots every now and then. Then to get the current balance you can do:
latest_snapshot.balance + sum of all transactions since the last_snapshotD4no0
Yeah that is a great idea, I was thinking about this too!
In general I was thinking about calculating the balance on each new transaction, and it can be optimized later to use snapshots like you mentioned if the performance is an issue.
Thanks!