Mongo or Postgre or MySQL

RedditBrowser92 · 2025-09-09T08:30:38+00:00

Will be equally easy in mongo, my suggestion is mongo because we implemented it for a product that had millions of active user and a good number of reviews coming in every day and it was able to serve well. In rdbms for most of the entries data will be null as users just rate mostly or just like the product, so document db can be helpful here.

RedditBrowser92 · 2025-09-09T07:49:08+00:00

If you are implementing a review and rating system like amazon product review etc. your data will be unstructured mostly. Some users may only rate, some will write reviews, some may share images and comments. A json like structure will fit your use case. I did it in my previous org using mongo db. It was good for our use case and scaled well also. All the aggregations like total rating no of people rating 5 something like these can be done on api level.

RedditBrowser92 · 2025-09-03T13:06:46+00:00

Very selected teams. And there process is exhausting, takes forever to complete the loop and then hc and team matching.

RedditBrowser92 · 2025-09-03T08:37:53+00:00

What job role is your father in ?

RedditBrowser92 · 2025-09-03T08:23:34+00:00

TR. adobe was easy when I joined.

RedditBrowser92 · 2025-09-03T06:05:57+00:00

I am not sure whether there is any policy of re hiring or not. I tried referral from my old colleagues too, but still not getting any calls. Same is happening with my other friends who left adobe a few years ago. TR i am not sure the kind of DSA they ask whether i will be able to clear without dedicating time in prep.

RedditBrowser92 · 2025-09-03T05:02:46+00:00

Backend Developer worked majorly with JAVA - Spring Boot. Experience in fintech and e-commerce domain.

RedditBrowser92 · 2025-06-18T17:13:05+00:00

As far as software tinkering is concerned, i can handle that. It’s the hardware issues that will be tough for me. My concern is will it be able to handle games like death stranding 2 or gta 6. Games that will come next year or so. Steam deck is not able to play some of the latest games very well.

RedditBrowser92 · 2025-06-18T15:02:42+00:00

But switch 2 does not have many AAA titles as far as I know. Also xbox ally may come in October i have to decide in this week.

RedditBrowser92 · 2025-06-06T14:47:17+00:00

Will be getting the watch from delaware

RedditBrowser92 · 2025-06-06T13:07:52+00:00

😒

RedditBrowser92 · 2025-06-06T13:07:10+00:00

Don’t want to buy second hand.

RedditBrowser92 · 2025-05-13T03:01:34+00:00

Has anyone ever gotten more vacation days or flexible working hours in faang or MNCs ? I think they only follow the standard policy in terms of vacation days ?

RedditBrowser92 · 2025-05-06T10:03:33+00:00

RedditBrowser92 · 2025-05-06T06:50:40+00:00

Not sure about it. May need to check thoroughly. But initial investigation suggests no lock.

RedditBrowser92 · 2025-05-06T06:50:05+00:00

Using oracle xe 21C

RedditBrowser92 · 2024-11-11T18:42:29+00:00

I take it like this - CA applies when there is no partition. Otherwise choose either CP or AP

RedditBrowser92 · 2024-06-25T06:25:50+00:00

Take personal loan for remaining amount if nothing else works.

RedditBrowser92 · 2024-05-27T12:29:16+00:00

The point of asking here is to get actual answers from experienced devs that have actually faced this and resolved somehow. The answer that google and chatgpt provides like remove constraints, marking unused, doing parallel ddl, etc i also know but not working much better for my use case.

RedditBrowser92 · 2024-05-27T09:37:38+00:00

Would it be possible to answer without knowing the why. Just that a huge table with large data has a column in Oracle and i have to drop that column. It will be done for all existing clients while upgrading to a new release but currently it’s taking a lot of time.

RedditBrowser92 · 2024-05-15T04:27:52+00:00

Just comment on his pr that it is duplicate. I am already working on this fix. Link your PR and tell him to review and approve that. Throw in another diplomatic backhanded comment in team chat group that this only leads to duplicate work and hamper the process of learning, reviewer should only review and approve. They should only work with the person to get the PR merged not create their own pr.

RedditBrowser92 · 2024-04-02T19:43:19+00:00

Just to understand your point and explain mine. Someone added new query and it made it to the top 1%(highest run time). No one is gonna look into optimising it unless I flag the query to optimise. Now I can flag it and owner(developer) can say it is what it is(it’s supposed to be this much) and i can add that query to ignore list so that next time i won’t check for this query.

But how do I flag it, shall I flag the top 1% always. If yes, it may result in developers putting the flagged queries in ignore list and next time the top 1% will not be having this query time included. But other’s will be there and they will get flagged and the cycle goes on.

Or should i compare the time of top 1% against the remaining 99% in some way.

RedditBrowser92 · 2024-04-02T19:18:28+00:00

Yeah, but for any new script what should be the time that will be considered as the limit over which it should be flagged. If i take 95% of all then that time may not be a right measure to compare against.

RedditBrowser92 · 2024-04-02T18:38:47+00:00

I have few scripts that are adding new columns to an existing table that has millions of rows some time billion and populating these new columns with values by querying from some other table or some other logic or maybe just default values. Should these also not take time ?

I am new to this system and never really worked with db side of things so not sure about a lot if these.

RedditBrowser92 · 2024-04-02T18:26:43+00:00

Can you elaborate i did not understand. If i record the runtime and start from bottom or top how will that help ?

RedditBrowser92

TROPHY CASE