HNHacker News
TopNewBestAskShowJobs

spikej

289 karma · joined February 13, 2015

submissionscomments
spikej··on Database Migrations
You're describing the "R" in CRUD, my friend: https://en.wikipedia.org/wiki/Create,_read,_update_and_delet...

In the example above, the select statements were inside stored procedures, and applications were only granted permissions to execute those with appropriate parameters.

spikej··on Database Migrations
Both decent approaches and we reduced a lot of friction by using code generation.

Unfortunately, modern development favors having all logic on the application side. There are a lot of benefits that brings including better testing (stored proc testing frameworks never really caught on) however I find now a lot of people I work with rely too heavily on the ORM and don't know how to work with the databases (writing sub optimal queries, not properly indexing, etc)

spikej··on Database Migrations
I don't think that's what's meant by #2... About 12 years ago I worked at a place where all the crud operations were stored procs (calling tables/views/functions as needed). The application was only granted execute on the specific schemas. That meant no direct access for crud.

A number of Schema changes and query optimizations could be handled by updating the stored procs without having to recompile the application.

spikej··on Sesame Street Pinball Number Count [video]
...And the new Sesame Street isn't the same. Older Sesame Street isn't available in the same episode format in high quality. The DVDs containing older Sesame Street have various clips.
spikej··on R.I.P. Macromedia FreeHand (2007)
It was far more intuitive and the vector drawings copied over flawlessly to Flash. Illustrator drawings copy/pasted always had issues.
spikej··on I used Stable Diffusion and Dreambooth to create an art portrait of my dog
They like it. And it was a good excuse to work with new tech. Why poo poo on it?
spikej··on Ask HN: How do I keep my elderly father safe on the internet?
A simpler option is family filtered DNS like this https://blog.cloudflare.com/introducing-1
spikej··on 200-year old heat pump technology is back
There must be a more aesthetically pleasing option...
spikej··on Ask HN: What is the best advice you got on any aspect of life?
Have you looked into isometric weight training? Heavier weight, lower reps, static holds for longer duration. Typically used in physio for rehabilitation but can also work as exercises on their own, especially when you get older and have joint issues.
spikej··on How a heat pump works
Genuine question that I haven't been able to find a clear answer for: are heat pumps now different from air conditioners two to three decades ago? (other than the fact that they heat and cool)

Memory is fuzzy but I remember when I was a little kid and even captain planet cartoon showed air conditioners being bad for the environment...

Or is it that heat pumps are better than the fossil fuel counterparts and so if you're going to do something bad you might as well do something less bad?

spikej··on DetectGPT: Zero-Shot Machine-Generated Text Detection
The problem is that people aren't doing what you're doing, and ARE just copy/pasting whatever gets spit out. Using it to enhance your wording + thoughts is absolutely the way to make use of these tools.
spikej··on Ask HN: What's a build vs. buy decision that you got wrong?
Thanks for the tip! I'd never heard of Logical Increments before!
spikej··on Ask HN: What's a build vs. buy decision that you got wrong?
If you ever feel the need again, vs a look through pcpartpicker. They'll warn if parts are incompatible and you can also look at other's successful builds to get ideas.

The computer shop near me will price match parts and for $25 will put them all together and run the system through tests like memtest etc. That is a small price to pay in my mind for them to handle RMA, etc. I can load up the OS etc after and know that the system will boot up.

spikej··on 26 Programming Languages in 25 Days
We did the same but the idea was to do it in different paradigms: iterative, OO, functional, etc. And the code was very different
spikej··on Hard truths I learned when I got laid off from my SWE job
What were those niche skills, if you don't mind?
spikej··on A no-code tool that generates code
I wasn't clear... I meant the hurdles go away. Spreadsheets from 90s versions of office still work just fine, whereas my nodejs app from last year is another story
spikej··on A no-code tool that generates code
That's only half the story. Bigger hurdles are the framework fatigue and the constant of having to keep things up to date even after you've got a "complete" product. This is why you see shadow IT in the form of MS Access DBs and spreadsheets that (no matter how terribly implemented) won't die.

With no-code, those at least go away.

You're no longer having to deal with unnecessary complications of having to learn or deal with WebPack, etc, and you're no longer needing to stay in an endless cycle of dependency hell updates.

spikej··on I worked at LastPass as an engineer
Most likely for the convenience that it offers. Getting non-technical family members to actually use KeePass, etc is next to impossible.
spikej··on Microsoft's ex-UI chief is shocked about the Windows 11 start menu
Heck I still say that about Windows 2000. Clean, minimal interface, with all the power options easily available.
spikej··on DontBuyDell.com
Well that and Windows. Not starting any OS debates, but would an M1 achieve the same performance and battery life if constantly running Windows in Parallels? If so, then that would put it ahead of the X1.
spikej··on Tell HN: YouTube's web UI just got even worse
Same with the 3 dots that show extra options like saving to playlist. They pop in after the rest of the site has loaded.
spikej··on DontBuyDell.com
I have an XPS 13 also that I'll probably be replacing in another year or two. What is your new go-to I should look into?
spikej··on Robot Framework: generic open source automation framework
or cypess
spikej··on I help seniors with technology issues
I used to spend hours customizing everything I used to make them "just right" and updates to software would always inevitibly break them, and I'd repeat the cycle. As I've gotten older with less free time, I've just started changing my own preferences and workflows to fit the defaults. Even that doesn't always seem to be the way as UI/UX changes mean disruptions for disruptions sakes rather than changes that make my life easier...
spikej··on Ask HN: Am I getting older or did typing on the iPhone become unbearable?
My 2 and 5 year olds do this every night after talking to grandparents. The paragraphs they produce are pure nonsense
spikej··on Heatwaves kill more Americans than hurricanes, tornadoes and floods
That's the reason there's now a major push in a lot of places to replace those with heat pumps...
spikej··on Ask HN: Why is the printer industry so scammy?
Same here.

The android brother plug in sucks and I wish google cloud print was still around. I tried mobility print but it didn't quite work as expected and decided to just stick to printing from my laptop.

spikej··on Are we going back to the cable days?
It's called Pirate Bay :P
spikej··on Programming breakthroughs we need
But take a step higher and you get this https://youtu.be/FvNRlE4E9QQ
spikej··on Programming breakthroughs we need
Or more realistically the rapid application development tools need to be better so we're not bogged down dealing with latest fad or resume driven development
← PreviousPage 2 of 6Next →