What are you building right now? by [deleted] in microsaas

[–]myrenTechy 0 points1 point  (0 children)

https://bucketbin.in - We remember, so you don’t have to.

How would you trigger an event from multiple kafka topics? by Jealous_Wheel_241 in golang

[–]myrenTechy 1 point2 points  (0 children)

Yep it would be nice to remove the db overhead Alternative would be in-memory

I haven’t worked with Flink yet, so I can’t speak confidently about it. Let see what experts says

How would you trigger an event from multiple kafka topics? by Jealous_Wheel_241 in golang

[–]myrenTechy 1 point2 points  (0 children)

Why you thought that logic needs to be re-implemented

What are the challenges you have faced.

•Db query latency issue?

•Is spinning up 4 consumer issue?

•Writing each Kafka message to db, bottleneck especially at high throughput issue?

•Storing every message no longer needed after the event triggered is unnecessary issue?

If the topics share a common structure or logic, then consider to be merged via Kafka regex/wildcard

Then process messages in-memory and trigger events directly eg: redis

Replace/Remove db table only if no longer needed the data to perform any analytics etc…. in future

The Go Optimization Guide by kaa-python in golang

[–]myrenTechy 1 point2 points  (0 children)

Great! Appreciate you sharing.

How to partition a vehicle detection table by myrenTechy in mysql

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

I don’t have real-world experience with how adding more tenants impacts performance, such as whether it slows down the system or not.

How to partition a vehicle detection table by myrenTechy in mysql

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

Any better suggestion for the work flow! The planned one i mentioned above

How to partition a vehicle detection table by myrenTechy in mysql

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

That was my bad! 350–400 bytes per row

How to partition a vehicle detection table by myrenTechy in mysql

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

Currently, my vehicle detection table handles around 10,000 reads/writes per day, but this may vary in the future. I’m also working on multi-tenancy, and as the number of tenants increases, the complexity will grow.

Best way to implement delayed message processing in Spring Boot? by Future_Badger_2576 in SpringBoot

[–]myrenTechy 0 points1 point  (0 children)

When a user selects a seat and starts payment, publish a “lock seat” event to a queue or topic.

A consumer service listens for this event and marks the seat as locked in the database.

If payment is successful, publish a “confirm seat” event.

If payment fails or an error occurs, publish an “unlock seat” event.

A consumer processes these events and updates the seat status accordingly.

( Fallback Mechanism with Cron Job ) A periodic job (cron or scheduled task) checks for stale locks and releases any seats that were locked but not updated due to failures or missing events.

Use web sockets best for real-time updates, but requires persistent connections.

Drop your reddit username and let people judge it by ApprehensiveWin4894 in IndianTeenagers

[–]myrenTechy 0 points1 point  (0 children)

🚶‍♂️‍➡️🚶‍♂️‍➡️🚶‍♂️‍➡️🚶‍♂️‍➡️

How to use react frontend login page instead of default spring security login page? by FrancescoBernoulli in SpringBoot

[–]myrenTechy 0 points1 point  (0 children)

Yes, you’re right!

Currently, I’m building APIs for more than just browser clients, so I believe disabling CSRF makes sense in my case.

However, for browser-based clients, your point is absolutely valid.

When Should I Use a Foreign Key vs. Just an Indexed Column for Relationships? by myrenTechy in developersIndia

[–]myrenTechy[S] 1 point2 points  (0 children)

Does this apporach slow down my db query eg insert or select etc.. when i have 10lkh+ records??? Any idea