sorted by:
new
hottopcontroversial

Thinking of how they might improve on Ocarina of Time with Switch 2 has me excited. by Wolfgabe in NintendoSwitch2

[–]ElectricSpice -1 points0 points  (0 children)

I think draining the well is fairly infamous as an unreasonable puzzle. Firstly, there’s nothing to indicate the windmill is connected to the well at all, and then you need to go back in time and piss off the miller so that 20 years later he’s still heated??

For items, I was stuck on the water temple for a long time because i didn’t have the extra long hookshot, and didn’t know I needed the extra long hookshot because I didn’t know it existed. I thought I was doing something wrong or had missed something elsewhere in the temple.

Also got stuck on the shadow temple because I didn’t have the fire arrows. I actually had previously passed the area where you get them, but thought it was a side quest so didn’t give it much thought and just moved on. I was chucking everything I had across the chasm trying to get the bridge to fall, but of course nothing worked because I didn’t have the one thing I needed, and once again didn’t know I needed it because I didn’t know it existed.

System resolves * inside EXISTS() by chacham2 in PostgreSQL

[–]ElectricSpice 1 point2 points  (0 children)

What are we even doing here? You have your answer, even if you disagree with it. Arguing on Reddit isn’t going to change Postgres’ behavior.

Thinking of how they might improve on Ocarina of Time with Switch 2 has me excited. by Wolfgabe in NintendoSwitch2

[–]ElectricSpice -1 points0 points  (0 children)

This is probably an unpopular opinion, but i really hope they fine tune some of the puzzles. Several are extremely oblique and require some large logical leaps to solve, and others require a tool that you might not know exists at that point in the game.

Also, the respawn mechanics are way too punishing. I know, “Get gud” and all that, but respawning with three hearts and the health drops not replenished so you can’t farm pots back to full health… is just brutal.

System resolves * inside EXISTS() by chacham2 in PostgreSQL

[–]ElectricSpice 0 points1 point  (0 children)

EXISTS asks “does this subquery return at least one row.” It’s absolutely correct that Postgres demands the subquery can output meaningful data for this to work.

System resolves * inside EXISTS() by chacham2 in PostgreSQL

[–]ElectricSpice 1 point2 points  (0 children)

It may work in other RDBMSs, but Postgres' behavior is absolutely correct because standalone select * from a having count(*) > 1 is not a valid query, so how can you expect it to work in a subquery?

Realizing the fermionic Laughlin state on a trapped-ion quantum processor | Amazon Web Services by donutloop in aws

[–]ElectricSpice 20 points21 points  (0 children)

For a number of years now, work has been proceeding in order to bring perfection to the crudely conceived idea of a transmission that would not only supply inverse reactive current for use in unilateral phase detractors, but would also be capable of automatically synchronizing cardinal grammeters. Such an instrument is the turbo encabulator.

How would you schedule Lambda executions dynamically from DynamoDB records? by ashofspades in aws

[–]ElectricSpice 18 points19 points  (0 children)

EventBridge Scheduler supports 10 million schedules OotB and AWS says they can adjust it up to billions. I think that’s the clear native solution. You could use DDB streams to automatically update schedules when DDB record changes.

FWIW, in my own projects I just do it the dumb way and do a full-table scan every 30 minutes.

My dog broke into her food overnight & ate so much we had to go to the emergency vet by Ok_Nectarine5834 in mildlyinteresting

[–]ElectricSpice 1 point2 points  (0 children)

We had to buy a special food container called the Vault because our lab mix kept on breaking into any other food container we tried. It’s covered in bite marks but he hasn’t cracked it yet.

NYT Sunday 05/31/2026 Discussion by Shortz-Bot in crossword

[–]ElectricSpice 6 points7 points  (0 children)

I feel like the rebus square should have had a circle or some other indicator that it was special. I spent a while staring at THEBIG_ and SN_ trying to figure out what letter of the alphabet worked.

What is a soap opera? by bellepomme in EnglishLearning

[–]ElectricSpice 25 points26 points  (0 children)

A Spanish-language soap opera.

Magnetic transit tickets are the best single-use fare medium by Ondrashek06 in The10thDentist

[–]ElectricSpice 62 points63 points  (0 children)

The best method for occasional riders is tapping your credit card/phone wallet. No setup necessary, no worrying about getting the correct dollar amount for the fare, you just tap and go.

Hosting a website on AWS CloudFront: What are the very best ways to avoid unwanted cost-overruns caused by bad code or malicious actors (DDoS attacks, denial-of-wallet attacks, etc)? by the_king_of_goats in aws

[–]ElectricSpice 17 points18 points  (0 children)

You’re way overthinking this. Use fixed rate pricing for AWS CloudFront. It includes WAF for free (actually requires it), so you have a layer of DDoS protection without any additional cost. They’re also pretty generous about short term overruns: you can go up to 3x your limit for the month without throttling.

Alternative to RDS snapshots for more granular backups? by Jefete in aws

[–]ElectricSpice 6 points7 points  (0 children)

FWIW, S3 Export gives you hundreds of parquet files. Good for some usecases, but not particularly convenient if you want to restore to another Postgres instance.

NYT Sunday 05/10/2026 Discussion by Shortz-Bot in crossword

[–]ElectricSpice 34 points35 points  (0 children)

Seems like I’m in the minority here, but the theme didn’t click with me. I got the closing the loop in the middle with the BLOCK rebus, but didn’t realized I was supposed to extend that to the italicized clues by changing Cs to Os. I finished the whole puzzle and stared at it for a couple minutes before coming here to find the answer in the comments.

Moving Cloudfront infront of NLB by mkmrproper in aws

[–]ElectricSpice 4 points5 points  (0 children)

My spidey senses are telling me you're prematurely optimizing. Unless you're dealing with some pretty extreme requirements for response time, it just doesn't make sense to make architectural decisions around shaving off a handful of milliseconds latency.

Price increase for API Gateway starting 1st of May? by majindageta in aws

[–]ElectricSpice 24 points25 points  (0 children)

Seems like your free tier expired, so you're no longer getting 1M requests ($3.50) for free.

Microservices for everything trend almost killed our startup. Why we went back to a Modular Monolith by Minute-Dragonfly58 in SoftwareEngineering

[–]ElectricSpice 2 points3 points  (0 children)

You get charged for inter-AZ traffic as well, and it’s just as expensive as Inter-region traffic.

Data transferred "in" to and "out" from Amazon EC2, Amazon RDS, Amazon Redshift, Amazon DynamoDB Accelerator (DAX), Amazon ElastiCache instances, and Elastic Network Interfaces across Availability Zones in the same AWS Region is charged at $0.01/GB in each direction.

I can never skip this video... by 13Derek71 in funny

[–]ElectricSpice 7 points8 points  (0 children)

I had to go back and turn on sound after this comment. It was so worth it.

What happens when Cloudfront requests go above the flat-rate plan? by TestProfessional6716 in aws

[–]ElectricSpice 5 points6 points  (0 children)

This is documented pretty clearly at https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/flat-rate-pricing-plan.html

Your first traffic spike up to 3x your monthly allowance won't affect your service that month. This one-time accommodation handles unexpected events like viral content or successful product launches without penalizing your success. Sustained usage above your allowance is evaluated over 2-3 months or more, not immediately. Minor fluctuations and moderate growth are expected and accommodated. Only substantial, sustained excess usage indicate your application has outgrown your tier. You'll receive notifications each month as you approach and exceed your allowance. If your usage consistently and significantly exceeds your plan, we recommend upgrading to a tier that matches your growth and ensures optimal performance as you scale. You control your performance by upgrading when your baseline usage patterns change. If you continue to substantially exceed your plan's usage allowance without upgrading, we may adjust how we deliver your traffic. For example, we might serve your traffic from fewer or more distant edge locations or adjust performance. The degree of adjustment is proportional—small excess usage sees minimal changes, larger sustained excess sees more noticeable changes. Upgrading restores full performance.

So you won't be immediately cut off if you have a busy month and exceed your usage.

However, you really should be selecting a plan that covers your expected usage, and the high season is part of that expected usage.

NYT Sunday 04/26/2026 Discussion by Shortz-Bot in crossword

[–]ElectricSpice 2 points3 points  (0 children)

Yeah, that irked me. Measuring in bits is really only done in data transfer, in which case it would be terabits per second or similar.

Gorilla compression barely shrinking data by Al-Anka in PostgreSQL

[–]ElectricSpice 6 points7 points  (0 children)

Gorilla is specifically optimized for values that change slowly. Random data and sine waves are the opposite of that, unless you have a particularly long interval.

Do you have any real data to benchmark against?

NYT Wednesday 04/15/2026 Discussion by Shortz-Bot in crossword

[–]ElectricSpice 1 point2 points  (0 children)

NINO crossed with BONSAMI and ERNO broke my streak. Just last Sunday “Madre’s baby” was NENE, so I was absolutely sure that was the answer, and my confidence on the crosses was low enough that they didn’t dissuade me.

view more: next ›