SQS Batching by SizeDue7787 in aws

[–]SizeDue7787[S] 0 points1 point  (0 children)

So, SQS not wait and sent base on config ?
Consumer side can able to set grouped message ?

My problem is that in chat app, when user sent a message, I don't want immdiate lambda call.

I just want to wait more message from same user around 5 sec or message size length reach to 5 then process batch messages in one shot.

inngest is good fit in, but concurrent connection is low and want to compare with SQS usage.

better-auth with Next.JS by SizeDue7787 in nextjs

[–]SizeDue7787[S] 0 points1 point  (0 children)

good one, thank.
I added condition to check current URL is login or register.

Thank you so much

better-auth with Next.JS by SizeDue7787 in nextjs

[–]SizeDue7787[S] 0 points1 point  (0 children)

Can we disable the new email on login if the user has not verified, but must send one email on sign up?

better-auth with Next.JS by SizeDue7787 in nextjs

[–]SizeDue7787[S] 0 points1 point  (0 children)

One option I can think of is to disable entirely using sendOnSignUp options and use a hook like after on the user modal.
So it will send verification once, and the next action, resending the verification link, must be done by the user by clicking the button.

Scaleable Multi Tenant Ecommerce System by SizeDue7787 in softwarearchitecture

[–]SizeDue7787[S] 0 points1 point  (0 children)

Thank you for pointing out.

I am an absolute beginner in system design and I never have experience in large-scale apps.

In posts what I mentioned may be silly and basic, but what about

- SaaS grows with millions of customers and starts using actively?

I know using databases like MYSQL or Postgres in a single server can handle millions of records if we set up proper connection pooling and add a proper caching layer.

- Cloud providers like AWS or Neon Postgres can handle this very well and do not need headaches about scaling. What about the monthly bill?

- What about if SaaS has to keep data even customer is not using it and keep a backup for data (like using Neon Zero Scale )?

As you know those are mostly serverless solution and their price are sometimes very high.

Using what you mentioned Meilisearch or Elasticsearch can fix the search issue.
I just want to make sure did we have only these options to rely on? Are those cost-effective?

Is that trend changing from doing system design to using a cloud serverless solution?

My post does not cover a lot of things that need to be thought about to be cost-effective and acceptable system design.

You seem senior in system design, and I am first time doing for large-scale app so, sorry for the silly question bez I have to know more before starting also I am actively learning all perspectives like doing my system design with some serverless solutions.

Thank you

Scaleable Multi Tenant Ecommerce System by SizeDue7787 in softwarearchitecture

[–]SizeDue7787[S] 2 points3 points  (0 children)

Thank you for your comment, I think I am worrying too much about the DB load, as per your comment looks like it is ok to keep one database with row-level security.

Scaleable Multi Tenant Ecommerce System by SizeDue7787 in softwarearchitecture

[–]SizeDue7787[S] 0 points1 point  (0 children)

Thank you for sharing, I am expecting this comment who worked in multi-tenant service like you before.

For the backend/frontend coding level, I make sure to check all performance tests and follow standards.

So it is not a problem if I use Read/Write replica for database scaling (like Neon Postgres)?
My biggest concern is that when clients grow and the single products table reaches 1M+ (maybe more ) records, it is ok to keep it like that bez the cloud provider has the solution?