HNHacker News
TopNewBestAskShowJobs

rograndom

1,490 karma · joined September 17, 2010

WordPress core contributor and member of the WordPress Hosting and Performance teams. 25+ years building enterprise PHP/MySQL systems, including TurboHub (Laravel platform managing 1.5M+ WordPress sites across 10,000+ servers) and A2 Optimized (cross-platform performance tools). <br /><br /> Run Soju Web Development in Vermont, working with clients from local organizations to state and federal governments. Write about mindful development practices at developmentenlightment.com and WordPress technical deep-dives at supersoju.com.<br /><br />

Currently seeking PHP/Laravel development and web operations roles. Open to remote work.<br /><br />

LinkedIn: https://www.linkedin.com/in/andrew-jones-6505766/<br /> WordPress: https://profiles.wordpress.org/supersoju/<br /> GitHub: https://github.com/supersoju/<br /><br />

I can be contacted via my profile name [at] gmail

submissionscomments
rograndom··on Ask HN: Have you used SQLite as a primary database?
I've used in "production" and as the "primary datastore", but not in the ways those terms are normally used.

1. PHP web development for the client of a client. They needed persistent data and MySQL was not available. Moving to a different webhost was straight up rejected. Used sqlite with Idiorm and it worked just fine.

2. As the local datastore for a cross platform mobile application. The sqlite DB was unique on each device. Libraries were available and worked well.

3. This is a large one. Several 10's of thousands of installs that query the filesystem, but filesystem access is throttled by the vendor. We're using sqlite to store the state of the filesystem as it doesn't really change that much. If the db is damaged or whatever, it can be wiped as it isn't the final source of truth.

rograndom··on Regolith Linux
What? It's mostly just plain text configs for i3 which is open source on it's own. There's a whole Github project here: https://github.com/regolith-linux
rograndom··on Ask Slashdot: How Powerful Is Your Computer? (1999)
Some what similar for me, in the mid-2000's I was at a design agency that was moving to PHP/MySQL development. Mostly a Mac shop, but the development server was some HP thing we got from best buy for like $400. Put Red Hat on it and did nothing else, just whatever the default PHP/MySQL package was. No tuning or anything.

A little while later, Apple released the G4 xServe. We bought 2 loaded with the largest disks at the cost of several thousand dollars. But hey, OSX Server. It has PHP & MySQL and is rack mountable, etc. We also used them for file servers for all the design files.

Got all of our development sites migrated over and the performance was noticeable worse. The HP was at least 4 times faster serving up the sites. It was amazing.

rograndom··on Nude pictures on early retro PCs – was it possible?
I remember some kids in HS were distributing floppies of women with bathing suits and some "optimized" viewing program.

On the computer lab computers, 8086's, it would take several seconds if not minutes to render on the screen, one line at a time. That gave everyone plenty of time to escape out in case a teacher or someone else walked by. And there was only sky and trees and stuff mostly on the screen at that point.

Later on, a year or so later, the typing teacher got a 6 new computers, 386s. The first kid to try them out to look at the bathing suit pictures found that the images rendered instantly and completely. He was so stunned by seeing the entire image way sooner than he expected, but also, I guess, seeing the entire image itself. He let out a "Oh shit!" which caused the teacher to turn around and see the contraband on the screen.

Student had his disk confiscated and was banned from using the school's computers for the rest of the year.

Times were simpler then.

rograndom··on How South Korean TV took over the world
There was Gangnam Style a few years ago and BTS had a whole (US) nationwide McDonalds promotion based around them for the better part of a month this past year.
rograndom··on Kodi: An Open Source Home Theater System
> It was a revelation in that the UI was amazing for the time, and the hardware was good enough to decode everything available.

Almost. I had a set of ffmpeg scripts that would encode blu-rays at 720p just so so it would playback without any dropped frames. But yeah, everything else was fantastic.

rograndom··on Art Bell Back in Time
Yup, same. Driving somewhere in between Elizabeth, NJ and Montreal every 2-3 weeks overnight. Co-driver is saying stuff like "I'm getting sleepy, find the lizard people on the radio."
rograndom··on 20 years of the iPod
And just for some context. I had a Rio MP3 flash player that came with 32mb of storage around that time. mb, not gb. Like 10 songs of space. I bought a 64mb card with it that cost more than the player did and setup some sort of thing with smart playlists in iTunes to create a playlist of 64mb of music from stuff I hadn't played recently so it could copy over with as little wasted space as possible.
rograndom··on Ask HN: Anyone working remotely for a US company internationally?
I work at a2hosting.com and while I’m not international, a few people on my team are outside of the us and large percentage of the rest of the company is as well.
rograndom··on Leaving the Apple ecosystem behind
Browse by artist, album, etc?
rograndom··on Ask HN: What type of personal NAS would you recommend?
SSH, NFS, SMB, rsync, pretty much anything. It also has built in applications to backup to another synology or S3/glacier.
rograndom··on OpenShot 2.6.0 Released – AI and Computer Vision and Audio Effects
Are they comparable? I thought Openshot was like After Effects and Kdenlive was more like Premiere?
rograndom··on Plane Food Simulator 2021
If there's any flight attendants on here, they would say "You just answered your own question"
rograndom··on Now your car is a cybersecurity risk, too
All the cars I've looked at this year that have CarPlay / Android auto only available on the mid/upper trim levels, on the lower trim levels, the entertainment system also contained the climate controls and couldn't be removed.
rograndom··on Designing a guitar with hot-swappable pickups
One of my favorite "did you know?" relates to early shoegaze bands using "vintage" jazzmaster and jaguars. The bands would buy those, sometimes original 60's instruments, because they were cheap. And the foam under the pickups would be almost gone so the pickups would be almost bottomed out and be much further away from the strings than originally intended. The guitarists didn't know this of course, but that became part of the "shoegaze" sound so people now buy brand new jazzmasters and dump the pickups all the way to the body.
rograndom··on The latest DSM update makes btrfs drives unavailable on budget Synology models
Nope, this is like if higher models of Teslas had a more in-depth mode on the display for a couple of years. When you first buy your lower model, during the on-boarding process with the dealer, they walk you through the setup process and ask if you'd like the standard view or the more detailed one. You say you want the more detailed one.

Then six months later Tesla pushes out a software update overnight that removes that view and offers no way to restore the old one, or start your car, or unlock it.

rograndom··on M1 dev setup with a virtual Linux box
It's almost like the same people that try to make things work in random ways are the same ones who frequent sites like these....
rograndom··on We Don’t Use Docker
Yup, that must have been it. I think Adobe implemented that as a feature into Photoshop within a year of us seeing that other software.
rograndom··on We Don’t Use Docker
No, it was a photo of a building. The "demo" was the guy right there playing with the software, no video.
rograndom··on We Don’t Use Docker
I was at a graphic design tradeshow back in the mid 90's and there was a guy there demonstrating this Photoshop alternative called Live Picture or Live Photos or something like that. And he had a somewhat large, at the time, print image on the screen, probably 16mb or so, and was zooming in and out and resizing the window and it was redrawing almost instantly.

This was AMAZING.

Photoshop at the time would take many many seconds to zoom in/out.

One person in the group asked, "Yeah, but how much memory is in that machine?"

The guy hemmed and hawed a bit and finally said "It's got a bit, but not a lot, just 24mb."

"Yeah, well that explains it." Nobody had 24mb of RAM at that time. Our "big" machine had 16mb.

rograndom··on When Nintendo fought a device that gave Mario 'new superpowers'
That was what Nintendo Power magazine subscriptions were for. Recurring revenue for stuff that should've been in the game manuals (maps, secret explanations, etc)
rograndom··on Ask HN: Recommend books that give you insight into other professions
"Elements of Poker" by Tommy Angelo

How to be better at Poker (and other parts of life) that has nothing to do with what cards you have.

rograndom··on Hosting Provider Leaked 63M Records Including Magento and WordPress Credentials
60 million records. They could have reseller hosting where one "customer" has 100's or 1000's of sites on their account. Each of those sites is probably a record.
rograndom··on Hosting Provider Leaked 63M Records Including Magento and WordPress Credentials
There are a few hosting billing system -> account creation products that will generate the login information at purchase time so they can be presented to the user in plain text before being sent over to the provisioned server. It could be being logged accidentally at that point.
rograndom··on Hyper-regional chippy traditions of Britain and Ireland
"American" pizza in Montreal is just Pepperoni pizza. Which I always find funny.
rograndom··on Show HN: SmartGuitarAmp – Guitar plugin made with deep learning
Small anecdote in the similar vein.

I gigged around Boston in the early 2000's playing guitar in various rock and metal bands, usually in front of 15-20 people. I had been using a 1960's Fender Bassman and changed out the tubes to some Sovtek ones. Sound guy at one of the clubs (who's had been around for 20+ years at that point and seen everything) noticed right away and asked why my amp sounded off. A little while later I bought one of the first Line 6 modeling amps and my first gig with it the same sound guy said "Ahh, you put the old tubes back in". I'm like, "Nope, totally different amp, and it's all digital.". He didn't believe me and while he was inspecting the amp kept saying "No, no, no. There's tubes in here I can smell them warming up".

rograndom··on Rolling Stone's 500 Greatest Albums 2003 vs. 2012 vs. 2020
And to make you feel even older, today Nevermind is more than TWICE as old as London Calling was when Nevermind was released.
rograndom··on Apple Tried Charging the Price of a New MacBook Pro for a Screen Replacement
I have a iPhone 5s that I only replaced because of battery issues. It's been sitting in my drawer for a couple of years and thought it would be good to hand off to one of the kids as a mp3 player or something. When Apple was running a deal on battery replacements I sent it in for that. I got a call saying that it has water damage and the main board was inoperable. I could have it repaired for $600 or they could recycle it for me for $25. Sending it back to me was not an option. It took 2 escalations to get someone who could authorize returning it as I was unwilling to pay for either of those options. It's now back in my desk.
rograndom··on Daddy, did you need to buy an electric car?
I had a very similar experience during my first somewhat long trip in my Leaf. It has a range of "150" miles, but it's closer to 120. My destination was 60 miles away, should be good for a round trip, maybe a short charge at the destination or on the way back.

Nope. It's 30F out and that left me with 5% battery when I reached my destination. There was a charger nearby at a CVS. Arrived there an it was out of order. The town had a charger in their parking garage, get in and that's out of order as well and I had to pay $5 for the 5 minutes I was in garage.

Drove to the next town over for the next closest charger. 2 blocks away and I'm at 0%, the car is yelling at me but managed to make it to the charger. It works! It's a level 2, but should charge to full in an hour. Head to the shopping area and keep track of the charging process on my phone, which was nice. An hour later and I'm only up to 30% and I have to go back and start the charging process again. Wander around for another hour to get to 75% and can't stay longer because the garage is closing.

Thankfully that 75%, with the heater off and not going above 45mph let me get home with 5% battery left. Many lessons learned that day.

rograndom··on Ask HN: Mind bending books to read and never be the same as before?
A lot of decisions are based on choosing one of two actions. You can think of them as doors. "Do I pick Door A or Door B?"

Sometimes you know that Door A is by far the "right" choice, but maybe it's the harder one. Taking a minute to drop your ego may make the choice easier. "Yeah, A is hard now, but B will bring much more pain later."

It may help to frame you decisions based on the hypothetical "1000x programmer". You acknowledge that this programmer is the absolute best. Every choice they make is literary a life or death decision, so they always make the right choice. What would they do in this situation? They would write that unit test!

Other times you don't know which one is the "right" choice. In those cases it actually doesn't matter, does it? Worrying about what may happen if you choose "wrong" will not change what's on either side of the doors.

Choose one and get on to the next set of doors. If you weren't happy with the outcome don't beat yourself up over it, instead use what you learned to better inform your future decisions.

← PreviousPage 2 of 5Next →