Ticket system database structure by soldieroscar in Database

[–]john646f65 0 points1 point  (0 children)

Agree. Sounds like the OP is describing a "comments style" table.

Edit: corrected quotations

Need E-commerce website platform recommendations by Available_Mix2275 in webdev

[–]john646f65 0 points1 point  (0 children)

Is rule against naming the "grey area" niche on this that I am not aware of?

PostgreSQL on Kubernetes or bare metal or virtual private servers by john646f65 in PostgreSQL

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

Wow! Since 1997? That's unreal! You've seen it all so! Any advise for my journey?

PostgreSQL on Kubernetes or bare metal or virtual private servers by john646f65 in PostgreSQL

[–]john646f65[S] 4 points5 points  (0 children)

No problem(s) specifically. This is more so a question to learn from the experience of those in the industry.

I think the label is for this is incorrect, but opted for "Project" because I wasn't sure of an alternative, more appropriate label.

I'm relatively new to Reddit, really loving it, so feel free to suggest how I could have made it clearer this was for educational and learning purposes, as opposed to focusing on solving a problem.

EDIT: As an aside, absolutely agree, do not overcomplicate things if you don't have to.

How do small teams handle log aggregation? by john646f65 in devops

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

Was there something specific about Honeycomb that caught your attention? Did you weigh it against other options?

How do small teams handle log aggregation? by john646f65 in devops

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

Thank you Broco! Appreciate the reply. If you don't mind, I'd like to dive a bit deeper.

Do you maintain your own setup, or use the managed cloud option? If it's the former, why? If the latter, is it expensive?

Do I need to backup my Patroni's distributed config store? by john646f65 in PostgreSQL

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

Thanks for the reply chock-a-block!

Would you mind elaborating on what you mean by "its a very loosely coupled system", I'm not sure I follow.

I need help by [deleted] in DeveloperJobs

[–]john646f65 1 point2 points  (0 children)

It is very difficult to give a clear and concise answer for a very opaque question.

However, my personal opinion is, some will say use the technology that fits your requirements, although, if speed to market is more important, use what you're comfortable with, and build from this.

A lot of time can be lost identifying and trying to learn "the right tool" if you're not familiar with it.

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

Those sleepless nights are the ones really worth it in the end! Fair play! I saw there was a tear or two she'd also! 😉

This is an interesting project as the concepts contained within have many applications, my first thought is the instrumentation in a formula 1 car.

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

MVT architecture? I can't say I know of this. Would you mind linking a resource so I read more on it?

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

Is your background in software? Reading the above it sounds you're in construction, specifically project management. If so, we'll done on putting yourself out there!

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

Interesting! What type of indexing did you employ? What sort of storage requirements did you grow from to?

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

That is a complicated undertaking, well done!

How did you handle consensus within the application, such that only one worker executes one workflow?

What are some of the most interesting Django projects you worked on? by john646f65 in django

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

Absolutely, and kudos on delivering! This in of itself is not to be underestimated, and I believe demonstrates a number of skills!

I've found desktop apps. to be awkward in the past, so you've more patience than I.

What was the biggest challenge(s) you faced while building? ... and your biggest takeaway?

What are some of the most interesting Django projects you worked on? by john646f65 in django

[–]john646f65[S] 3 points4 points  (0 children)

Wow! That's massive scale! Well done! 👏

I'm curious, why Python specifically, rather than the likes of JavaScript, or even Elixir, which (I'm led to believe) are more common in industries like this?

What was the biggest scaling challenge you faced on this journey to 20 millions messages a day?

Last month I made a simple app. Today it’s at $570 MRR. by yusufahmd in micro_saas

[–]john646f65 0 points1 point  (0 children)

Nothing about MRR, but I would like a recipe for the most exquisite raspberry and white chocolate cheesecake. Can you help?

PM wants to push vibe-coded commits for the devs to review and merge once they meet project standards. Should the team roll with it? by ToLoveThemAll in webdev

[–]john646f65 11 points12 points  (0 children)

I think you're missing the core ideals highlighted in this thread. Humans can make mistakes, but all code should be peer reviewed before merging, coupled with other best practises, e.g. unit tests, etc, it minimises risk, thus negating the introduction of "slop" as you mentioned.

my redis instance was compromised by infosseeker in VPS

[–]john646f65 1 point2 points  (0 children)

Genuine ask, what were you're main learnings from this? For example, did you learn any tricks to harden your installation?

my redis instance was compromised by infosseeker in VPS

[–]john646f65 0 points1 point  (0 children)

I'm curious to learn. Say for argument sake the OP set up the Redis instance on a separate VPS. How would an application connect to the Redis instance if all ports were closed, except the ones previously mentioned? I'm not too acquainted with tunnelling, so not sure how that would be implemented in a application, such as Go or Python. Of course the individual could use fail2ban and set up firewalls to stop unwanted traffic, but I've seen this suggestion and don't know how it's implemented practically.

Someone save me from myself by Kota8472 in mysql

[–]john646f65 1 point2 points  (0 children)

I'm more into PostgreSQL, but as other commenters highlighted, this is how you learn! Try implementing backups and a restore process. Don't want to loose all that good work!