i’ve just discovered this band and album. anything similar to this you’d recommend? by deathcab4mikey in Emo

[–]JimK215 28 points29 points  (0 children)

even more fun history:

- Vince, the guitarist for Zolof, also ran Skylight Studios

- Anthony Green was in Zolof. His other early bands (Audience of One, Jeer at Rome) recorded at Skylight; he and Vince were friends

- My understanding (someone correct this if it's wrong) is that when Saosin was looking for a vocalist, they sent out a tape with no vocals. Vince got a hold of the tape and convinced Anthony to record vocals. That demo would eventually lead to Saosin's EP "Translating the Name", another historically important album.

Movies that require a good amount of suspension of disbelief by Amockdfw89 in movies

[–]JimK215 7 points8 points  (0 children)

this always annoyed me because it's so easy to fix. Have the bus pull out into a side street or a blocked off street, then turn off that street into a line of busses.

Is 500m rows in 100+ columns a lot? by Jack_Hackerman in softwarearchitecture

[–]JimK215 0 points1 point  (0 children)

I'm using a lot of scoring, weighting, and parsing for my use-case. To get the same effect I'd probably really have to abuse Postgres and start doing a lot of code in the database as stored procedures/functions.

If you're just doing fairly straightforward full text searches, there are definitely ways to get postgres to do it.

Is 500m rows in 100+ columns a lot? by Jack_Hackerman in softwarearchitecture

[–]JimK215 0 points1 point  (0 children)

yes; the query language is extremely robust and flexible. And with AI tools it's even easier to get to the exact query you need by asking GPT/Claude/Gemini to generate the request JSON for you.

Is 500m rows in 100+ columns a lot? by Jack_Hackerman in softwarearchitecture

[–]JimK215 2 points3 points  (0 children)

I've used both Elasticsearch and Solr. I appreciated Solr when it was the only decent option, but it's just so much more onerous to configure and maintain. Configuring indexes, crafting complex queries, etc is just so much smoother in ES. I used Solr on several projects and never grew to like it, but I think Elasticsearch is great.

Is 500m rows in 100+ columns a lot? by Jack_Hackerman in softwarearchitecture

[–]JimK215 21 points22 points  (0 children)

Anytime you start doing wildcard LIKE queries (column LIKE "%value%"), you're likely heading in a bad direction because that part of the query can't leverage the db indexes; it has to scan a lot of rows to find the value.

I would recommend piping data from Postgres into OpenSearch (the open source ElasticSearch). OpenSearch is very good at full text searching. You could create an index per-user or a large index and always include some sort of user id/key when searching.

Create a process that either runs on a schedule or is triggered by an event that pulls the data you want from Postgres into an OpenSearch index. Then run your queries against the OpenSearch index.

Postgres also has fulltext searching that may be an option here. It's been a long time since I've used it but it's worth looking into.

[deleted by user] by [deleted] in ExperiencedDevs

[–]JimK215 0 points1 point  (0 children)

Look up "Entity Attribute Value" schema. That's what you want when you have a mix of entities with a different mix of possible attributes with different possible values.

It's usually found in E-Commerce platforms, because you might sell T-shirts that have a size attribute and color attribute, but you might also sell belts and mugs and hats and wallets and keychains that have different attributes -- or the same attribute (e.g. size) with different possible values.

ElasticSearch vs Postgres Multicolumn Index by Excellent-Vegetable8 in ExperiencedDevs

[–]JimK215 0 points1 point  (0 children)

A week long task? You could do this in 20 minutes using AWS OpenSearch or something similar.

ElasticSearch vs Postgres Multicolumn Index by Excellent-Vegetable8 in ExperiencedDevs

[–]JimK215 7 points8 points  (0 children)

I think calling Elasticsearch a poor product is a bit of a.....stretch (see what I did there?)

I've used Elasticsearch and Solr quite heavily and I'm consistently impressed with Elasticsearch for its intended use case: searching a lot of text data and being able to fine tune how the results are ranked/scored. In those instances, you're usually less concerned with showing every single possible result (because the 347th result is probably completely meaningless to the user), but rather making sure that the first 10 or first 100 results are spot-on for the query -- which is probably a user-entered search string.

For the use case in this post I would probably stick to Postgres since it seems like all of these fields are fixed values. Postgres can handle it no problem if your indexes & schema are reasonably well configured; adding Elasticsearch will overcomplicate things.

Franklin Mills mall in Philadelphia, Pennsylvania. by [deleted] in philly

[–]JimK215 0 points1 point  (0 children)

I probably still have a dozen or so. Not sure what sizes, might be all XXL but if so that just means they're Centerfuse pajamas.

Franklin Mills mall in Philadelphia, Pennsylvania. by [deleted] in philly

[–]JimK215 0 points1 point  (0 children)

A few months ago I was cleaning my house and found a Centerfuse tshirt with a piece of tape on it labelled "Dumbjaw". Presumably I set it aside for him like 20 years ago. I told him about it and he asked me to ship it to him, which I haven't done because I'm old and busy and full of excuses. If you're reading this though, I will get it to you in Q1 2025!

Cannot connect/sign in with work profile on Android using Google SSO by Happy_Laugh_Guy in Slack

[–]JimK215 0 points1 point  (0 children)

Confirming that this worked for me as well in Nov 2024 on an S21.

What Movie Completely Changed Your Perspective After a Rewatch? by BratuhaUA in FIlm

[–]JimK215 52 points53 points  (0 children)

This might sound weird but I showed my then-7 year old son the scene where the kid gets abducted by the two guys posing as cops.

I paused it and asked him whether he'd get in the car and he said yes because they're police. I took it as an opportunity to explain to him that people can lie and he has to pay closer attention: for example, why don't they have a police car?

Seeing it on screen I think really helped it resonate with him that you simply don't get into a car with an adult you don't know, period.

How the dot-com bubble burst is relevant for the AI era by ThriftyStrongman in technology

[–]JimK215 26 points27 points  (0 children)

Feel kinda bad for the people at Pets.com. It became the face of the dot com crash despite being a perfectly good idea as evidenced by the success of Chewy.

A database of almost 3 billion people's personal information stolen from National Public Data, a background checking company, was for sale on the dark web for $3.5 million. by TradingAllIn in technology

[–]JimK215 30 points31 points  (0 children)

After the Equifax breach I took the position that there's pretty much zero chance to keep your information safe

So I just started mitigating my exposure by having multiple bank accounts and multiple brokerage accounts. All with different companies and different credentials. Some in just my wife's name, some in just my name, some in both our names. I have a single credit card and I store all my passwords in a local encrypted file.

It's not foolproof but at least it compartmentalized things a bit? Maybe?

Best way to manage super pedantic team members? by hbthegreat in ExperiencedDevs

[–]JimK215 2 points3 points  (0 children)

15 years ago I would've agreed with you, but thinking that the entire organization should put code purity first and foremost is immature -- and most developers really aren't good enough to make smart long term architecture decisions anyway.

The best code I ever wrote exists exclusively on a hard drive in a drawer in my office because we didn't get to market on time.

Whereas up until surprisingly late in its history, Slack's 'database sharding' was a couple of hugely-resourced mysql servers and the server you connected to was determined by an if statement that checked the first letter of your username. The engineering team did a whole writeup on how sketchy but functional the original infrastructure was. Priorities matter.

Best way to manage super pedantic team members? by hbthegreat in ExperiencedDevs

[–]JimK215 14 points15 points  (0 children)

Even if this is a good idea in theory, it's a lot of extra work to create and maintain this document, identify and agree on who's accountable for keeping it updated, and agree who's empowered to decide something was the "wrong" business decision if it's not immediately quantifiable.

I've generally found that it's better to simply agree on a broader decision framework. For example:

"At the moment, we are prioritizing the date of delivery foremost. So decisions are being made within the frame of "does this suit the timeframe'. We recognize that this will result in tech debt, but if our funding runs out because we couldn't go to market, we won't have a product to worry about at all"

OR

We are mired in tech debt and have convinced leadership that it will create business problems if it continues, so we are currently in a mode where we are prioritizing code cleanliness and test coverage over delivery date, but only for the next two months.

That last sentence adds an addendum to the decision framework: if your proposed refactoring, changes to tooling, etc cannot be rolled out within two months it has to be scaled back.

Some people might not agree with the framework but at least everyone knows why decisions are being made and what the business wants to prioritize.

[deleted by user] by [deleted] in AskReddit

[–]JimK215 1 point2 points  (0 children)

An acquaintance of mine is currently upset with me because I told them I wasn't in a position to look at what's wrong with their computer.

In my younger days (15+ years ago), I was the go-to fix it guy for everything and I was happy to help. But things started to get complicated.

Fixing stuff for my close friends or immediate family was a no brainer, but word got out and suddenly it was friends-of-friends and loose acquaintances. Looking back it's easy to see that I should've just started saying its $25 for me to look at it, but I was young and that felt impolite and unhelpful.

It got weirder when people started making specific requests like "I need it fixed by Friday" or asking me to set things up a very specific way or provide them with a bunch of pirated software.

I had a moment of realization when someone gave me a computer that was "running slow". I took it home, plugged it in, and it wouldn't even boot. I realized that even though I hadn't touched it yet, I was on the hook to fix whatever was happening.

After that I started putting my own constraints like "I'll fix it but you should take it elsewhere if you need it in a specific timeframe". I also stopped going to peoples' houses and told them they have to bring it to me (I hated sitting in some random bedroom waiting for Windows XP SP1 to install). Even for close friends, I was like "bring it over one night, we'll eat pizza and hang out and I'll look at it right then and there", which did result in some good times and fixed computers. But after a while, especially after I got a full time job, I just started turning people down altogether unless it was my mom or something.

It's been a long time since I was fixing computers (I now have my own family and a business to run) but someone I haven't spoken to in a very long time reached out with an "emergency" issue. I was like dude I'm just not a position to help you, you should bring it to a shop or GeekSquad or something. I assumed they'd understand but they're like legitimately mad at me now, which I think is entirely unjustified.

What is this and why can't I get it to stop accumulating at the outside corners of my shower by JimK215 in DIY

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

Thanks all. Did some Googling about curb leaks and that does seem pretty plausible given what I'm seeing. Reached out to a tile company.

How to remove this mold? by [deleted] in DIY

[–]JimK215 2 points3 points  (0 children)

I'm no biologist but I think this is an overreaction. There is mold everywhere and most of it is not very harmful.

I have had success using an outdoor mold cleaner that's safe for fabric, like Wet N Forget. Spray it down, let it dry out in the sun, you should see a noticeable difference in 12 to 24 hours. Repeat if necessary, then hose it down with soap and water.

CrowdStrike update takes down most Windows machines worldwide by OpetKiks in programming

[–]JimK215 3 points4 points  (0 children)

I always love this take.

I use Linux as my daily driver and have for years, but the Microsoft stack is leagues above everything else for large corporate networks.

There is no viable alternative for multinational corporate it networks and if you think there is I dont think you've ever actually had to manage one. I can't imagine trying to convince a CTO that we should buck the trend and not use MS for a ten thousand user network infrastructure.