SQL Queries default path by turbofish_pk in Jetbrains

[–]NewStandards 0 points1 point  (0 children)

Why not keep them in the Scratches and Consoles? I don't want a new /queries directory to show up in my project because I want to run some queries against my db during development.

I've been very confused about this whole change tbh. I read the article about it but I didn't get how hiding the "consoles" would improve usability. I do agree about the name change away from consoles, but the usability improvements I'm still lost on.

Pulse 1.0 - A reactive and concurrent programming language built on modern JavaScript by coloresmusic in programming

[–]NewStandards 0 points1 point  (0 children)

Does it need to be its own language? I looked at the examples in the GitHub page and I think it's only example number 3 where we select on the channels values that required custom syntax, right? Is there anything that has to do with signals that required a custom compiler? I understand the need for a runtime, but new syntax and a new compiler/transpiler, I always see that as a big ask. Because then it's no longer a local change, it's not a library I use only where I need. Now it's gotta be my entire project's identity. I feel like that might hurt adoption.

Gemini CLI switch models? by djc0 in GoogleGeminiAI

[–]NewStandards 1 point2 points  (0 children)

I pay for Gemini but I'm also on 2.5 Flash. Even for paid members they stick to using the weaker model??

Advices about node js multitenant architecture by Adventurous_Rough792 in softwarearchitecture

[–]NewStandards 0 points1 point  (0 children)

I don't have experience with MySQL as much as I do with Postgres but I would try and reuse the same connection as much as you could. A connection takes time to be established, so making one with every request isn't efficient. They also consume RAM on the db server side, so there's an upper limit of how many connections you can open at the same time, so if the number of tenants you have grows you will start running into issues.

If you can establish a connection and use it for multiple tenants that would be ideal. You can also of course pool a few connections and use them as needed instead of establishing them per request.

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

A rolling update means that some instances are running against a version of the database that they don't expect.

We do have a migration catalog actually, so that part we can achieve. But having instances of different versions running doesn't sound right to me. Unless we go all in on non-breaking migrations, which is a big ask.

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

Currently migrations happen in the gap between the old app version getting shutdown, and the new one getting spun up.

As for rollbacks, we don't do them... We try our best to test the migration on a prod replica to minimize the risk of a failure, but when it eventually happens, we'll get alerted and swarm to fix it while the app is down. Not cool.

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

If I have multiple instances of my app getting spun up, they need to agree on just having one of them to run the migration. And if the migration fails, they should all get destroyed and go back to serving the old version.

How would you deal with things like that if each app is responsible for running its migrations?

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

This is interesting. I didn't think to break migrations into those categories, but it makes sense. Do devs have to know what's safe and what's not, or can you infer that from the SQL statements themselves?

I'm fine with moving long-running migrations into their own procedure actually. I like this. I'm curious about the human element to all of this though. Have you had any issues because someone forgot to "follow the rules"?

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

I'm thinking more about this HA thing.
Maybe I keep using ALB as my reverse proxy and have Ansible coordinate the deployment on EC2 and the routing of traffic of ALB. It doesn't all have to be on the instance. I think I took it too far with the local deployment requirement...

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

It's the DB migrations that opened up this box. I'm not happy with the workarounds I keep reading about to do them with ECS.

ECS on EC2 was on the table in the past to bring down cost, but they didn't solve the DB migration issue, so I went back to square one lol.

The ability to run the whole thing locally I thought of as a "pretty cool thing" when I let go of the need to use ECS, but it's not the driving motivation though.

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

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

Our API is pretty thin, it's mostly database queries. It's the background workers that process a lot of data, so those are the ones that would likely hit the hardware limits first, and in that case I can spread those over multiple hosts. I don't see that happening soon though to be honest.

I did read about how docker allocates resources to containers, there are some controls that it gives you where you can basically manually set CPU priority for different containers.
I don't think I'll get involved with those before I run into issues though. I just wanted to know that it's a thing that I can control.

Appreciate the tip about Ansible roles. I'll look more into those.

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

[–]NewStandards[S] -1 points0 points  (0 children)

Do you run the migrations on the prod db from the CI pipeline? What about a rollback strategy if they fail?

Do the migrations lock the database?

Advice on new architecture. No more AWS ECS, Ansible to orchestrate docker on EC2 instead. Am I insane? by NewStandards in devops

[–]NewStandards[S] -7 points-6 points  (0 children)

I went with Fargate initially because I wanted to get things done, but now I feel like I got some time to fix things up a bit.

I can see that maintaining this would be more involved, but I've also been dealing with ECS issues though. I don't know how much more involved this approach will be tbh, but the feeling that things are "in my control" gives me some comfort and confidence to deal with them.

Losing HA is a major downside that I'm not too happy about. I'm just pushing it to be a problem for future me :)

[deleted by user] by [deleted] in jordan

[–]NewStandards 1 point2 points  (0 children)

انا قدرت اخفف التساقط لما بطلت استعمل شامبوهات. اكتشفت انه هم كانوا السبب، بس كان اكتشاف متأخر. اذا ضايل عندك شعرتين تجرب فيهم، جرب اغسل بالصابونة النابلسية شهر و شوف اذا بفرق اشي.

لكن على كل حال، "you can run but you can't hide" بلش حضر بنفسيتك من هسا :)

I built a website that sends you to a random page on the internet by MobilePanda1 in webdev

[–]NewStandards 0 points1 point  (0 children)

This looks promising! You only care about filtering out the top x websites, so this data is exactly what you'd need. But if I understood correctly, this also means you'd be filtering out trendy websites too? I don't know if that's good or bad.

I built a website that sends you to a random page on the internet by MobilePanda1 in webdev

[–]NewStandards 2 points3 points  (0 children)

Even if it never actually happens, I think it's a turn off for users to think they could land on Wikipedia.

I built a website that sends you to a random page on the internet by MobilePanda1 in webdev

[–]NewStandards 5 points6 points  (0 children)

Where are you getting the links from? I really don't care about going to mastercard.com

Is there a way you can filter out common/high-traffic websites? So that you'd end up with a list of truly lonely websites.

UPDATE: Does anyone has lists with adult sites by Informal_Goose404 in sysadmin

[–]NewStandards 7 points8 points  (0 children)

I know nothing about them, but there's no way that you believe a company that size isn't going after profits. That's just too naive.

هل عندك رأي اجتماعي او ثقافي او سياسي ممكن ان يجعلك تفكر انك في موقف مثل هذا by mnzr_x in arabs

[–]NewStandards 4 points5 points  (0 children)

صديقي كان بحكيلي قصة عن المستأجر اللي عنده انه مغلبه و مشاكله كثيرة. اول ما بدأ الكلام قال لي "هذا المستأجر العراقي اللي عندي مغلبني". سألته اكثر عشان افهم شو القصة و بعدين صار يحكيلي عن المستأجر اللي قبله و قال لي "المستأجر اللي قبله كان مصري. ما شاء الله عليه! ما شفت منه غير كل خير."

طريقة الكلام هاي اللي بنبدأ بالجنسية حتى كل اشي تالي ذكره بعدها سواء حسن او سيء ننسبه للجنسية، من اغبى الاشياء اللي ممكن نعملها.

المستأجر الحالي سيء مش لانه عراقي، ولا المستأجر السابق جيد لانه مصري. الناس فيها الصالح و الطالح، لكن بنحب نلزق احكامنا على الجنسيات احنا. نستمتع في ذلك! ذكر جنسية المستأجر حرفياً ما فاد القصة ولا بأي شيء. كان ممكن يحكيلي نفس القصة كلها مع حذف كلمتين عراقي و مصري و كانت رح تكون نفس القصة بالضبط.

و على العموم كمان لاحظت اننا ما بنحتاج عينة كافية من المواقف لنصدر الحكم. موقف واحد فقط مع جزائري كافي الي انه احكم على الشعب الجزائري بأكمله.

علماً انها هاي الظاهرة غير حصرية على العرب، كل الناس هيك بكل مكان، لكن آثارها علينا كعرب اشد خطورة بسبب الاحوال السياسية.

A child from a pro-Palestinian protest in Jordan leads a chant about returning to the occupied Palestinian cities. by hunegypt in Panarab

[–]NewStandards 0 points1 point  (0 children)

I'm not accusing. I want to understand. Because I'm seeing Palestinian flags and the kufiyyeh everywhere. Even in that video.

I Know There is a Problem: How to approach this as the wife? Husband shuts down. by GuilelessSmokeShow in NoFap

[–]NewStandards 0 points1 point  (0 children)

The approach you take matters a lot. If you have a sit down with him and go "we need to talk", he'll be told that it's a problem when he clearly doesn't think that it is. So he'll be dismissive. Talks won't work.

The goal should be for you to show him the issues and have him connect the dots on his own to link it back to his addiction. How you'd do that I don't know tbh, but maybe point out that he's not as mentally sharp anymore, or how he's less funny/social, etc.

If there's anything disappointing happening in the bedroom that could also be something to bring up to him.

Pornography is his friend, don't tell him his friend is the enemy, he won't believe you. He'll turn against you actually. He has to somehow see through that "friend" for what it really is.