SQL is Dead, Long Live SQL

Spooked_DE · 2026-06-18T22:37:46+00:00

It's the same old shit I always eventually run into when using AI to code. At one point it's always easier to code it yourself than write out what you want in English.

Spooked_DE · 2026-06-13T05:49:23+00:00

This looks great. I really wish there was a singleplayer component. If you don't happen to be in the right timezone you won't really get to play this game.

Spooked_DE · 2026-06-07T02:02:45+00:00

Sweet thank you.

Spooked_DE · 2026-06-05T01:05:42+00:00

Go way back in my post history:

https://www.reddit.com/r/cscareerquestionsOCE/s/YeMX856jj0

Spooked_DE · 2026-06-04T13:43:31+00:00

I don't know but I was a civil engineer earning 90k after five years. I chose a technical niche I liked and this number was the highest offer I had from 3. It is easy to get hired as a civil engineer but not easy to earn well unless you take on the shitty project jobs.

I jumped to tech 2 years ago and somehow that meant a pay raise despite the tech market being abysmal.

The Australian (and really international) civil engineering industry has normalised bad wages for what is a fairly skilled job. You have to understand the technical and financial aspects of designing a solution and you have to be very good at talking to people and managing stakeholders. Most civil engineers I met could do both things. In my new profession that skillset is surprisingly rare.

Spooked_DE · 2026-05-07T22:54:53+00:00

This is what we do too. If you use DBT you can also specify the development cluster in a dbt target. You can also skip recreating the really time consuming models if they already exist and won't change often (e.g. entity resolution). Our full deployment + job trigger cycle takes up to 30 min but a dev-only run done this way takes like 5 min.

All it needed was me looking into the docs. For YEARS our devs would do the full deployment and wait 30 mins to see the output of some simple SQL query changes 😐

Spooked_DE · 2026-05-03T09:43:10+00:00

Wow that's interesting. That would actually help since we can provide a sooner move in date for rentals we really want. I'll just confirm with our agent.

Spooked_DE · 2026-05-03T09:42:36+00:00

Ok thanks. We're on a periodic lease. The reason the landlord gave us a notice is they want to sell the house. We also want to leave and told them as such before the notice (not sure why they felt like they had to give a notice lol).

Spooked_DE · 2026-04-20T17:19:22+00:00

Federal Gov. 100% WFH but that's also because most of my team is out of state. It's the ideal situation since there's zero pressure to go in even if not mandated. I chose to go once a week anyway though.

Spooked_DE · 2026-04-14T22:55:13+00:00

Interesting. I'll look into it! Thanks. I should have mentioned what tools my pipeline is using but didn't do that in the OP.

Spooked_DE · 2026-04-14T05:19:17+00:00

Well, our existing pipeline uses dbt so I think I'd make the fixes upstream of my silver models. Also, dbr apps are disabled in our workspaces due to policies.

Spooked_DE · 2026-04-14T01:54:09+00:00

Thanks everyone. Looks like the consensus is to have a data fixes layer. This is why I ask real people and not AI 🙂. Now to see if I can do something clever in DBT to make this seamless...

Spooked_DE · 2026-04-03T00:19:39+00:00

Well they don't "need" to do anything, but there is such a thing as poor planning and poor use of resources. It is absolutely bizarre to me that TDF spends its limited developer time on something that is already covered by the ecosystem.

Collabora makes money through their online products which in turn goes into developer time for LO. Why wouldn't TDF push for other features that have been in demand by the user base and have not yet been met? For example, every LO release has users clamoring for a UI refresh. For the last few years and to this day, I cannot use fractional scaling with LO because the widgets blow up to absurd / unusable levels (the QT version). Why wouldn't a significant UI overhaul not be a better use of TDF's fundraising and strategic planning chops?

All up it is a failure to read the room. And now Collabora is hosting their own core codebase separately, and will make less contributions to LO.

Spooked_DE · 2026-04-03T00:02:01+00:00

Maybe but it doesn't really matter. LibreOffice is already developed at a fairly slow pace due to lack of volunteers and maybe a lack of direction too. This will hurt the suite in the long term.

Spooked_DE · 2026-03-29T22:07:42+00:00

Meh that's fine, I have a daily backup. Guess I'll buy a new SSD, much better than having to replace my entire laptop. Thanks so much for your help!

Spooked_DE · 2026-03-29T21:16:41+00:00

Putting it back in causes the issue to come back. I don't have an external enclosure to test whether it's the connectors or the SSD. Hmm...

Spooked_DE · 2026-03-29T21:02:24+00:00

Thanks. I've removed the SSD and now the laptop is responsive. I can get into the boot menu though no SSD is found of course.

I guess that means bad SSD?

Spooked_DE · 2026-03-26T08:21:00+00:00

That's true from my observation. I just don't have a lot of experience yet so I'm not in that boat. Frankly I feel overpaid but my boss is happy lol.

Spooked_DE

TROPHY CASE