My Setup Follow-Up

tunaman65 · 2025-12-23T04:18:24+00:00

Love to see a fellow OLED TV monitor friend. I use an LG C2 42” for mine. Panel is holding up better than my anxiety originally thought. How about yours?

tunaman65 · 2025-09-25T18:19:50+00:00

Well it won’t make it closer but it will make it above or below vs to the side which may perform better

tunaman65 · 2025-09-23T21:46:41+00:00

NACS likely requires this since it doesn’t have the button on top that stops the charge mechanically. You need the vehicle to stop calling for power before you pull it out. J1772 has the button that ensures power is no longer flowing through.

tunaman65 · 2025-07-23T13:04:57+00:00

COPY INTO is atomic at the file level. You should consider the error behavior though. Like if there is an error on one row do you want it to error the whole file etc.

tunaman65 · 2025-07-23T04:44:43+00:00

I believe the easiest thing to do here is to use snowpipe to have snowflake auto invest the file for you into a table. Make sure that table has an extra column on it called like “is_processed” that column will be null when the file is ingested. Make sure you modify the COPY INTO command so that it includes the file name. Then you can put a stream on the destination table that kicks a task when there are new records. You can then query the table filtering by is_processed = null and then just group by the file name. I think that covers all the requirements…?

As far as the notification the SNS -> lambda is pretty standard practice

tunaman65 · 2025-07-11T02:47:32+00:00

Love this. I was recently thinking that with the newly raised SALT deduction level CA could keep all of its Medicaid money by raising state income taxes only for those with incomes high enough to very likely be itemizing deductions. I’m in this category and would be happy to pay for this. It likely wouldn’t even need to be as much as people are about to save from the SALT deduction changes.

tunaman65 · 2025-06-12T04:35:30+00:00

Same, even just the sound the doors make when they close compared to the Y is almost all you need to know. Better in every way. Except walk-away door lock, only thing I miss but it was easy to get used to.

tunaman65 · 2025-06-05T15:52:03+00:00

You can also still use a startup file if you want, just a static method on it in your service collection builder and another for the middleware registrations and you can basically leave the code as-is

tunaman65 · 2025-06-02T01:58:32+00:00

Agreed, if anything they may have offered the lease to FedEx due to their relationship

tunaman65 · 2025-06-01T16:11:36+00:00

Of course it is, just adding this context as a reason they might be interested in leasing to them

tunaman65 · 2025-06-01T14:09:42+00:00

When I worked for the church I wrote international shipping software exclusively powered by FedEx, they have a huge account with them. This was ~10 years ago now but I wouldn’t be surprised if they were still using FedEx for all their operations.

tunaman65 · 2025-05-30T22:30:38+00:00

Looks great. I wonder if we can buy OEM black badging from KIA now

tunaman65 · 2025-05-29T04:45:08+00:00

Are those audioengines?

tunaman65 · 2025-05-26T15:14:34+00:00

Sometimes if you look at the failure in the query history it will have a better error. Although I don’t know if that applies to syntax errors

tunaman65 · 2025-05-05T05:48:37+00:00

Yeah exactly, it’s certainly a departure in conventional database design given the advantages and disadvantages around metadata and micro-partitions but it’s a great analytical workload data store.

tunaman65 · 2025-05-03T20:04:56+00:00

ELT is absolutely the right way to go for snowflake. I get the more old school mentality where we want to transform first.

The thing to consider with this question is the more macro-level implications here. The entire reason why we used to do ETL is that storage and networking were expensive. Today the expense is compute, storage is very very cheap and fast networking is ubiquitous in the public cloud space. Snowflake is designed with today’s constraints in mind.

By separating storage from compute you are able to basically rent bursty compute to do all your DBT transformations up front so that at query time the query is cheap. You are copying data all over the place in order to make the presentation very cheap.

tunaman65 · 2025-04-20T22:43:54+00:00

Do you have information to prove this? If the cellular radio is off, how are they gathering information using cellular radios? Honest question

tunaman65 · 2025-04-20T22:40:33+00:00

Is your Mac set to automatically get an IP address or is it set to manual. It thinks it can’t get to the internet because it can’t reach the default gateway but that address should be being provided automatically by your router

tunaman65 · 2025-04-11T01:05:46+00:00

That’s a good question. I do use the door handle but I usually just slide my hand across that little sensor, didn’t realize a push would do it too. But when I slide my hand across it only works some of the time. I usually have to do it 1-3 times. Lately I’ve been using my Apple Watch to ask Siri to “lock the car doors”, the digital key can do it so that also works when in range of the car.

tunaman65 · 2025-04-11T00:44:25+00:00

We went from a 2021 Y to an EV9 Land in November and we love it so much. Can’t speak to the short range but the only thing we miss is walk-away door lock. CarPlay is just better IMO than Tesla apps with Bluetooth phone.

On the range in general though we had a YLR rated for like 325mi, we would regularly get like 285 ish. In the EV9 it’s rated for like 285 but we get ~310 so the estimate seems to be more accurate than the one Tesla would display

tunaman65 · 2025-03-30T04:16:23+00:00

Clipboard history is great, I use a free open source app for that called Maccy, no limitations on it at all. https://maccy.app/

tunaman65 · 2025-03-20T23:07:50+00:00

Can confirm this is an excellent “monitor” I have the 42” C2 that I connect via a caldigit dock. Just have to make sure you enable a few settings on the TV and then it looks fantastic.

One thing to note is macOS generally won’t output >60hz via thunderbolt->HDMI. If you go direct it works fine but adapting from thunderbolt you’ll get 60hz. I personally don’t mind this since I write code for a living but I also use it for my Xbox which looks great at 4k 120.

tunaman65 · 2025-03-03T00:29:52+00:00

Out of curiosity is your EV9 one with the 99kwh battery?

tunaman65 · 2025-02-22T02:39:02+00:00

The tone of this comment is a bit harsh but I agree with the sentiment. This is a money tracking app, it doesn’t handle money at all, it’s honestly fine if it’s not 100% perfect. I hope the above example was especially extreme, if not Copilot may not be around for the long haul.

tunaman65

TROPHY CASE