Live data from Hacker News

What’s the jankiest piece of tech you’ve seen a company depend on?

twitter.com

61–70 of 175 posts

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#61
post #23

Earlier quoted context omitted.

>I'm working on porting a foxpro database from 1988 that's running an active business which I won't talk about much before it's done, and have actually encountered in Costa Rica an auto parts shop in one of the sketchiest parts of the capital city of this country with a green on black phosphor screen running what looked like dBase III for what they were doing on old IBM PCs. This is amazing value for money. A simple…

Sometimes their good value, other times their roughly equivalent to using paper.

Yeah, but that’s still the case with modern computers.

Marketing: “With this app, you can now buy pizza on your phone!”

Snark: *slaps a yellow pages on the desk along with a rotary dial landline*

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#62
About five years ago, I was assigned the task of writing a script that would automagically pull data out of Salesforce once a week and create mailing labels for catalogs. Seems simple enough.

Except that the catalogs were in a warehouse a few miles away from the company office. Inside the warehouse were ten label printers, each hooked up to a different computer.

My script had to organize the mailing label data into ten groups, based on USPS bulk mailing criteria, then dial each computer in the warehouse and send the right labels to the right computer, as each computer was assigned a different bulk mailing region, again based on USPS rules.

The people in the warehouse would pull each label off of the printer, slap it on a catalog, and drop the catalog into one of the bins below the corresponding printer so they could be taken to the regional bulk mailing facility all pre-sorted.

The warehouse computers couldn't be hooked up to the internet because the cable company wouldn't wire that side of the street. It did the other side because it was on a block with homes, but didn't see the cost benefit of doing the side with a single warehouse. A one-off line from the cableco was cost-prohibitive. I was told that before I joined the company, they tried DSL, but it was unreliable.

It's surprising how a technology we considered so fragile back in the 70's and 80's is sometimes the only thing that works today.

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#64
post #51

A large insurance company as of X years ago implemented iteratively reweighted least squares in pure SQL running against the claim database to fit their risk models. Honestly their implementation was impressive, in a WTF way, but doing literally thousands of queries and then manual adjustments of coefficients meant it took days to fit models that would have taken seconds to download the relevant data and train a mode…

Your insurance company used SQL? Luxury! My insurance company had everything in a collection of inter-linked Excel spreadsheets on a shared file server, millions of dollars a day being moved around with VBA macros :P

(Though for the specific use-case of statistical analysis, perhaps excel is actually the lesser evil...)

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#66
post #30
post #24

Earlier quoted context omitted.

More generally, modern cloud

Are you saying that cloud used to be better? (Real question, I don't know if cloud is getting worse)

It used to be simpler. Subjectively, I think it used to be less janky. Or, at least fewer things used to run on cloud, so the jankiness was a smaller problem.

Not sure, maybe my comment is a case of "grass used to be greener" ;-)

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#67
post #43

I worked at a well known UK newspaper about 6-7 years ago. I found out that the daily print newspaper was edited in quarkXPress without a CMS. After publishing the newspaper each night, a team of night workers would come in and copy-paste articles into the tablet edition CMS before morning (for iPad & android tablet subscribers). Entirely by hand. The main website was on a totally separate CMS so the next day, news a…

This is janky. Most of this thread describes OLD tech, but this is janky tech.

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#68

A small industrial automation shop, 40 total, 5 software people. The "IT department" was some kid who hadn't worked IT before. Spent most of his time learning how to manage exchange by messing around with our live locally hosted exchange server. Their controls were written in C. The development process was you checked a computer out of the warehouse, installed Windows, then some janky realtime OS addon, visual studio…

Good old sneaker net backups

Re: What’s the jankiest piece of tech you’ve seen a company depend on?

#70
Most of the answers are about software. Here's one about hardware, from my personal files.

In one of my early businesses we manufactured these small boards with about 50 through-hole components. Think mid-80's range.

I didn't have the money to buy any real manufacturing equipment at all. This was all self-funded, which, at that time in my life, meant thousands of dollars rather than hundreds of thousands or more.

I bought a really old Bridgeport CNC machine for $1800. I worked. The transmission sounded like it had rocks in it, but it worked. I used this machine to make a lot of our fixtures and tools. The prior owner had replaced the control system with one that took DXF files and cut one depth layer at a time. I had to design the toolpaths using AutoCAD rather than any tool that would output G-code.

I remember at least three things we made.

The first was a fixture that consisted of two rails with a groove cut into them so you could place about 25 board into the fixture and stuff the components. No budget for metal, so it was made out of pine and CNC machined. This allowed for the component leads to go through and not touch the table.

The second was a set of component benders, also made out of wood, so you could bend the various component leads as required with reasonable repeatability. The jig to bend MOSFET leads to 90 degrees was this contraption with a hinge, a bunch of springs from Home Depot and a pocket for the transistor to fit into. You'd push down on this lever and it would bend the leads to 90 degrees. I wish I had pictures. We bent thousands of MOSFETs that way.

Soldering. Boy, was this a horrific thing. Again, no money for a real soldering setup. What we did instead is build a preheating box with some stuff I got from a surplus store. We would then dip the boards (just the bottom) into flux. After that we'd dip them (again, just the bottom) into a molten solder bath. The pot was about 4 x 4 inches, just enough to have enough solder and maintain temperature. From there they went back onto the wooden frames for slow cooling. Talk about janky!

Finally, the through-hole leads had to be cut. This was not something you wanted to do by hand. We did, for a batch or two, and then decided that was enough.

We made a jig (again, wood, this time I believe it was oak) to hold about 50 boards upside-down on the CNC mill. We then got a small circular thin blade (not an end-mill, that does not work at all as we discovered) and programmed a slow lead cutoff cycle. Think of it like a cutoff wheel from a Dremel tool but without the screw sticking out of the bottom. We could cut the leads to within one or two mm from the board with reasonable consistency.

There's more. Everything in that garage was janky as can be. We eventually made enough money to move out of the garage, buy some SMT equipment, redo the designs in SMT and hire a few more engineering students to help. Crazy as can be. Had as can be. Fun too.

Post reply on HN