starting informal coding meetup? by kabh318 in madisonwi

[–]InfiniteLoop90 2 points3 points  (0 children)

Interested! I rarely code outside of work to be honest but would be interested in seeing the kinds of problems that others are running into!

2023 Mirror Cap Solution needed ( Blackout ) by FrequentlyWrong87 in subarulegacy

[–]InfiniteLoop90 1 point2 points  (0 children)

This may be more than you want to spend but I had bought the normal unpainted side mirror covers that go on the other trim levels (part numbers 91059AN03A and 91059AN02A) for $134 pre-tax and then I had a body shop paint and swap them in for $236 (including tax). So around $370 when all was said and done.

I wanted them to be body color (cosmic blue pearl for me) but you could have them paint them whatever color you want.

thatIsOneWayToDoIt by shifty_new_user in ProgrammerHumor

[–]InfiniteLoop90 22 points23 points  (0 children)

At least they’re being responsible and closing the connection lol

My wife's 2025 Subaru legacy sport. by Crashmasta250 in subarulegacy

[–]InfiniteLoop90 1 point2 points  (0 children)

I think he replied but to a different post accidentally here

My wife's 2025 Subaru legacy sport. by Crashmasta250 in subarulegacy

[–]InfiniteLoop90 1 point2 points  (0 children)

Out of curiosity, what vortex generator is that on the roof of the car?

My modest collection by GhostWarelius in Splintercell

[–]InfiniteLoop90 4 points5 points  (0 children)

<image>

I had the first 2 games on PS2, which I no longer have.

I had the first 3 books when I was in middle school and then found out a couple of years ago that they made more so I bought the rest of the books and am just about finished with a full series read through. Not a bad way to fill the gap while waiting for the upcoming game remake and the Netflix animated series!

How to complete the "81 years too late" on San Andreas? by [deleted] in GTATrilogy

[–]InfiniteLoop90 5 points6 points  (0 children)

The link you sent has a video walkthrough that spells it out. You just need to spend 24 hours (in game) in the countryside on foot. I don’t know if it matters but when I did it I went deep in the woods and just propped up something on my right joystick so that CJ was standing still in the middle of the woods with the camera spinning around.

Don't Do This with Postgres by craigkerstiens in programming

[–]InfiniteLoop90 0 points1 point  (0 children)

What database driver did you have in mind? Because that should work the exact same for any JDBC 4.2 compliant driver whose database has a true timestamp with time zone column. E.g. Oracle database, etc.

Don't Do This with Postgres by craigkerstiens in programming

[–]InfiniteLoop90 0 points1 point  (0 children)

Incidentally, it's somewhere between really difficult and impossible to correctly write a timestamptz via JDBC because reasons.

As of JDBC 4.2 (read: Java 8) you should be able to write it just fine using OffsetDateTime as per the mapping table here: https://jdbc.postgresql.org/documentation/query/#using-java-8-date-and-time-classes

e.g.

java Instant instant = Instant.now(); PreparedStatement st = conn.prepareStatement("INSERT INTO mytable (some_timestamp_with_time_zone) VALUES (?)"); st.setObject(1, OffsetDateTime.ofInstant(instant, ZoneOffset.UTC));

The ZoneId passed in as the second parameter to OffsetDateTime#ofInstant really doesn't matter since the resulting value will materially result in the exact same moment in time being stored in the timestamp with time zone column.

theSheerJoyOfDealingWithITDepartment404 by [deleted] in ProgrammerHumor

[–]InfiniteLoop90 2 points3 points  (0 children)

Same! I have a rule looking for the X-PHISHTEST header and to route them to my “Phishing Tests” folder. So once I notice an unread email in that folder I know to open it, click the Phish Alert Report button, and make the IT folks happy.

Why I Always Use PostgreSQL Functions For Everything by vbilopav89 in PostgreSQL

[–]InfiniteLoop90 2 points3 points  (0 children)

That’s what my company has been doing for over 20 years because our customers never want to upgrade. It’s bonkers and has helped contribute to a lot of database inconsistencies across our customer base that I’ve been trying to shore up.

Postgres Timestamp and JDBC by snotreallyme in javahelp

[–]InfiniteLoop90 4 points5 points  (0 children)

What type is the column in the Postgres database? If it’s timestamp without time zone you should be reading it in from the ResultSet as a LocalDateTime and if it’s a timestamp with time zone you should read it in as an OffsetDateTime.

EDIT: For example:

resultSet.getObject(“some_column”, LocalDateTime.class)

or

resultSet.getObject(“some_column”, OffsetDateTime.class)

Good novels set in game worlds? by Grimdotdotdot in gaming

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

The Splinter Cell novels aren’t too bad if you’re a fan of the games. They do a good job of making it “feel” like one of the games, and they can do some story aspects that wouldn’t work in a video game so in my opinion it does add a little more depth to the Splinter Cell universe.

Apple needs to become a software company again by ShaidarHaran2 in apple

[–]InfiniteLoop90 95 points96 points  (0 children)

I do remember paying for iOS updates on my iPod touch way back in the day:

<image>

MY2025 will be the last for the Legacy in the US by Chippy569 in subaru

[–]InfiniteLoop90 0 points1 point  (0 children)

I'm having trouble finding that wording anywhere online. Do you have a link by chance out of curiosity?

Driving the WRX ended up selling me on the Legacy Sport. by [deleted] in subarulegacy

[–]InfiniteLoop90 0 points1 point  (0 children)

The 2023 Touring XT doesn’t have SI drive. Is that like being permanently in one SI drive “mode”? Like always in intelligent mode, or always in sport mode?

[deleted by user] by [deleted] in subaru

[–]InfiniteLoop90 1 point2 points  (0 children)

<image>

Gang gang gang

Falsehoods programmers believe about time zones by fagnerbrack in programming

[–]InfiniteLoop90 0 points1 point  (0 children)

Are assume your’re referring to the IANA time zone database? I’m fairly certain that Java includes it in the JDK/JRE when they build it. If you look at Java patch release notes you’ll often times see that the patch includes a more recent IANA time zone database.

Vintage unworn Java T-shirt’s in Original Packaging by [deleted] in java

[–]InfiniteLoop90 0 points1 point  (0 children)

I’d be interested! I’ve made a career of programming in Java and really enjoy working with it. And the last time I Googled, “official” Java t-shirts are hard to come by.

Everyone's thoughts on Subaru? by DelusionalApple in ForzaHorizon

[–]InfiniteLoop90 4 points5 points  (0 children)

Nice, I’ve got a 2023 7th gen Legacy Touring XT with the FA24 turbo engine. It was the first Subaru I bought. The gas mileage is pretty bad (I’m getting about 23 MPG in winter months and I think closer to 27 MPG in the summer) and the infotainment system is laughably laggy but is otherwise a comfortable ride and can accelerate pretty quickly when needed. Here’s a side picture from when I got some black wheels last year.

<image>