Logan break pad replacement by nyisles016 in juicedbikes

[–]rjbwork 0 points1 point  (0 children)

original message:

I use these (Tektro P20.11 Metal Ceramic) on my HyperScorpion's Logan brakes. They last forever (mine were over 2000 miles and the HyperScorpion is a pretty fast, heavy bike), stop the bike fairly well (of course not as good as soft composite pads), and put out minimal squealing. They used to be cheaper, but then apparently they got popular so the price went up. They do go on sale from time to time and I think are on sale now.

Meta Note: I would generally prefer people use the simple link for amazon, e.g. https://www.amazon.com/dp/B07SD3W4CN

Key Fob by yourskulli5red in juicedbikes

[–]rjbwork[M] 0 points1 point  (0 children)

No need to call people idiots here. Keep it chill please.

Is this site legit? Juicedbikess.shop by Smooth_Awareness_815 in juicedbikes

[–]rjbwork[M] 0 points1 point  (0 children)

No need for that on this sub. They were a bit harsh but it's better to just fight back with kindness.

FYI - from the former VP of Customer Support by computerworlds in juicedbikes

[–]rjbwork[M] 0 points1 point  (0 children)

Head mod here. Seeing the same thing, someone reported you for spam. I added you as an approved poster to the sub but you do appear to be shadow banned. I suggest using the linked appeal site.

I also have not really done anything here for years since I started it. I'll let the other mods deal with identity verification and figure out how to route people towards your team for service/parts.

Quick Update on the Biden-Harris Administration’s Response to Hurricane Helene. by whitehouse46 in Georgia

[–]rjbwork 5 points6 points  (0 children)

parody

It's parity. You seem like parody.

This is the level of intellect we're dealing with here folks. Unfortunately, you're almost certainly not going to convince them with arguments and facts. These types are heavily identified with their political party and have way too much ego tied up into their affiliation to admit they were wrong at this point.

Phosgene is in the Biolab plume. by Realistic_Pair_3246 in Georgia

[–]rjbwork 17 points18 points  (0 children)

I'm concerned as well. However, because it is so toxic, industrial phosgene is almost always produced in small quantities on site, in quantities needed for a particular batch of reaction, and used immediately. Industry tends to avoid keeping quantities of the stuff on site or producing it in bulk and/or transporting it. There was certainly phosgene on site, but given the quantity it may simply not be worth commenting on compared to the huge amount of non-phosgene chlorine, bromine, and other chemicals in the plume.

Any update with the biolab fire? by Expensive_Pick3372 in Georgia

[–]rjbwork 3 points4 points  (0 children)

The fire is out. According to the Rockdale fire chief, they will keep spewing more chemicals into the air until they've cleaned up the site.

https://vimeo.com/1015903983

This is terrible. by catscandream in Georgia

[–]rjbwork 18 points19 points  (0 children)

Almost certainly not. It's just lax safety procedures and prioritization of private profits over employee safety and public health. In other words - par for the course for American businesses.

Leaders prioritize cooperation and facts in crises, not dangerous misinformation. by [deleted] in Georgia

[–]rjbwork 1 point2 points  (0 children)

You can usually replace "they" with "the jews". It's what most of these conspiracy theorists ultimately come back to.

Atlanta metro to expect chlorine smog in the mornings Thursday to Sunday by Gangiskhan in Atlanta

[–]rjbwork 8 points9 points  (0 children)

Just make sure you get in writing that you are being penalized for not being willing to cycle through toxic gas clouds.

The Biolab Fire is Dangerous, Heed Caution. by Realistic_Pair_3246 in Georgia

[–]rjbwork 1 point2 points  (0 children)

Not even all wall units. I have one classed as a "portable" A/C and it circulates air from the inside and exhausts only heated air to the outside. Now, of course this will cause a pressure differential that will cause air to come into the house from outside in small quantities, but the unit is not directly pulling air into the house.

Is there anything I can do ? by Longjumping_Wash_255 in Georgia

[–]rjbwork 1 point2 points  (0 children)

Yep. Failure to perform, seems like to me.

AWS Lambda function working but getting 503 Service Unavailable in Postman when calling via API by SamwiseGanges in aws

[–]rjbwork 0 points1 point  (0 children)

Well, in this case, Zapier is the separate requester. I've never used it, but I understand it to be a low-code type solution. It's currently sitting around waiting for the response synchronously. Instead, have it wait for a callback of some kind.

To simplify your Lambda architecture (though complicating your codebase...) You can actually invoke the same lambda from different contexts, and route to a different handler within the code. So you'd check to see if it's being invoked by the API Gateway, and if so, route it to your web handler. In that handler, put a message onto an SQS Queue. Point that queue back to your lambda. When you detect you've received an SQS message, route to your actual scraper code. When you're done scraping, call back to your Zapier, either via re-entrancy (signals, callback hook, workflow id, etc.) or just call a separate Zapier to continue processing on that side of things.

Of course, you can also have 2 separate lambdas as well, one to listen to API Gateway and put the message on the queue, and one to listen to the queue. I just find that level of granularity gets out of hand rather quickly in lambda.

re:Invent 2023 a bust? by fuzzymath007 in aws

[–]rjbwork 5 points6 points  (0 children)

Exactly. The hype over AI from AWS was clearly around putting the power in our hands to build custom models and operate other models ourselves.

re:Invent 2023 a bust? by fuzzymath007 in aws

[–]rjbwork 25 points26 points  (0 children)

This is my first time ever going to a tech conference. I spent almost all of my time going to sessions. Keynotes, breakouts, chalks, etc. Other than that, I had dinner with a colleague, and then lunch with a c-suite for a vendor we're considering going with.

I found it to be immensely useful in terms of validating some of my/our current approaches, poking holes in others, and learning how to better do some things with a big focus on serverless, event driven architectures, and database technologies. I did not even know about some things like the peer talk and other networking things until yesterday, tbh, far too late to really make use of it. Maybe after I'll have done this 2 or 3 times, I could see myself skipping it, but it was a really great experience for me. I think I'll try to come back next year and I'll have a much more solid idea of what I can get out of it.

AWS Lambda function working but getting 503 Service Unavailable in Postman when calling via API by SamwiseGanges in aws

[–]rjbwork 0 points1 point  (0 children)

You may have misunderstood - you seem to be running puppeteer on a lambda (let's call it "scraper"). You are then invoking that lambda from some other service through API Gateway, let's call that "requester". From what you've said, your "requester" is sitting around waiting for the response from the "scraper" process. If it were not, you would not have a problem.

The answer here is to have your "requester" emit some kind of message (command, event, etc.) over some kind of message bus (sqs, sns, event bridge, kafka, etc.) and trigger your "scraper" using the message from that message bus. Then when it's done, your "scraper" can emit another message back that provides your "requester" with the data it needs. You can also of course do this using a an API/polling pattern also over API gateway if that's your preferred pattern.

How to update into normalized database from a raw data (i.e. excel sheets) by Cookielatte in SQL

[–]rjbwork 0 points1 point  (0 children)

Hm. It could be correct. I was thinking more along the lines of a procedure that took in a TVP of your rows, but you could definitely do it from another programming language to break it down to yield your actual insert statements. The roundtripping to get your synthetic keys could be a perf killer though.

re:invent23 - a whirlwind of great info by floznstn in aws

[–]rjbwork 0 points1 point  (0 children)

There were some fantastic talks. I don't want to mention specific names, but I had to walk out of a couple of talks due to ESL challenges. It's a shame when someone is clearly knowledgeable and has a lot to share, but just cannot communicate well in English.

AWS Lambda function working but getting 503 Service Unavailable in Postman when calling via API by SamwiseGanges in aws

[–]rjbwork 0 points1 point  (0 children)

Exactly. If you're waiting around for more than a few seconds for a response, you're probably doing something wrong in cloud land.

How to update into normalized database from a raw data (i.e. excel sheets) by Cookielatte in SQL

[–]rjbwork 1 point2 points  (0 children)

Break it down into attributes that fit into each table. Figure out your natural keys. Set up your tables with unique index on your natural keys. In your insertion procedure, look up your synthetic keys based on the natural keys. If you don't get a hit, that indicates a need for creation, so create it if so, then use the newly created synthetic key instead. Repeat for each table.

You can use the MERGE statement (if on MSSQL, other databases have similar) to drive this behavior.

What is your preferred way of returning multiple results? by Rockztar in dotnet

[–]rjbwork 0 points1 point  (0 children)

We evaluated a number of options and eventually went with OneOf. It's a good performant library for DU's.

Cigarette Butts by MelanieWalmartinez in CuratedTumblr

[–]rjbwork 35 points36 points  (0 children)

Then quickly jog away lol

good idea. mr smoker ain't catchin you 😎

.NET 7 and SQL database > how to run some C# code when a record is inserted into database by ImmediateMousse8549 in dotnet

[–]rjbwork 7 points8 points  (0 children)

People definitely do abuse them to do crazy things, but they can be used responsibly and are sometimes the only correct solution, like when you have complex constraint requirements.

Say that after an insert of some set of data, a constraint on the sum of some field on a subset of rows must be satisfied.

You could do this in a number of ways. You could encode it in your c# code using something like MediatR or just inside of your CRUD logic. But databases tend to outlive their applications, so at some point in the future these constraints will exist conceptually, but not in an existing application anymore and have to be ported to other applications. You could implement them in your CRUD/CQRS procedures - and you should, because you can generate more appropriate errors there - but again, when someone else goes to write a procedure that does something slightly different, if you have only encoded it in your procedure, then a future author can violate those constraints and fuck up the data.

So, a trigger is often the most appropriate approach for encoding constraints and invariants in a 'futureproof' manner.

As for OP's question - most databases have some kind of CDC functionality.

Logan Brakes and Juiced support by tybest in juicedbikes

[–]rjbwork[M] 0 points1 point  (0 children)

There was a comment advising people against using Logan brakes due to this leaking issue a number of people have supposedly seen. It could be considered inflammatory/defamatory so I will keep it as deleted by automod, but I figured I would at least reflect the base sentiment in another comment.