Skip Navigation

TootSweet

@ TootSweet @lemmy.world

Posts

20
Comments

1096
Joined

2 yr. ago

Moderating

Intellectual Property lemmy.world

4d ago

What would be a valuable thing to have memorized by heart?
Jump
TootSweet @lemmy.world 4d ago

If you're a software engineer, memorizing an ASCII table (particularly the hex numbers of each character code) is definitely helpful. If for no other reason than so that you can read things that are randomly written in binary without having to consult a table.
Something not really otherwise terribly useful that nonetheless helped me keep my sanity: learn how to convert to base64 in your head. At work, we had really boring 8-hours-a-day training for a couple of weeks. To pass the time, I came up with random strings to base64 encode in my head. "Hat is 48 61 7a. The first six bits are 010010 which in base64 is an S. The next six bits would be 000110 which in base64 is G." Etc. I'd write down the base64 strings character by character as I derived them and then check my results for errors when I got back to my desk.

4d ago

What would be a valuable thing to have memorized by heart?

Jump

TootSweet @lemmy.world 4d ago

How to convert various units of measurement. (Including between imperial and metric.)

2.54 centimeters in an inch. Degrees Fahrenheit is nine fifths of degrees Celsius plus 32. Stuff like that.

4d ago

What would be a valuable thing to have memorized by heart?

Jump

TootSweet @lemmy.world 4d ago

5d ago

What are some of the worst code you have seen in a production environment?

Jump

TootSweet @lemmy.world 5d ago

Java, Postgres mostly but also LDAP and random in-house-written RESTful services, almost 20 years.

The objects we store in the Postgres database are very "hierarchical" in nature, with one top-level object and lots of child/grandchild/great-grandchild objects. (We asked for a Mongo database but the infra team at the time said "make do with Postgres.)
As I mentioned, some of that hierarchy is in LDAP or RESTful services, not in Postgres, so we needed something capable of dealing with multiple storage backends that would stitch the objects together as necessary. So the "ORM" needed to have backends for multiple backend systems.
We knew clients would need a vast number of different queries. So we made a RESTful endpoint that gave the full power of the ORM to (authorized) clients. If they needed different data, we'd be like "change your query like this" and they didn't have to wait on us.
Early in the project, we consciously designed an extensible JSON representation of our hierarchical objects. That is what's returned from the aforementioned RESTful endpoint.
However, we also created a "shortcuts" system to allow us to "balance" how much of the logic lived on the server vs in the client. (It can mix and match. Like "apply this shortcut, but also filter this way and paginate" or whatever.)
We made the API of the ORM such that it could both be used to query from the database/LDAP/RESTful systems, or be used as a client SDK for the aforementioned RESTful query endpoint that the application exposed.
It's both "more than an ORM" (querying from non-database sort of backends) and not fully an ORM (read only, doesn't handle schema evolution.) But it's fair to say it's more "an ORM" than "not an ORM".
The implementation of the Postgres backend part of it is heavily inspired by Django's ORM.

We couldn't have pressed Hibernate into this use case. It doesn't really deal with hierarchical data and sure as hell doesn't know how to query from LDAP. I don't know that anything existed at the time (nor am I sure anything exists now) that would fulfill our use case.

And the alternative to what we built was a massive, unmaintainable DAO with ridiculous numbers of individual queries in it that would have to be modified or added to endlessly every time someone needed to filter a bit differently or whatever.

6d ago

What are some of the worst code you have seen in a production environment?

Jump

TootSweet @lemmy.world 6d ago

This was a developed-in-house e-commerce web application at a major e-retailer. So fortunately that monstrosity of a cookie-handling mess was only ever used by one company.

You know what, though? Talking about this reminds me of another story about the same e-commerce application.

After a customer placed an order on this e-commerce site, the company's fraud department had to evaluate the order to make sure it wasn't fraudulently placed. (As in, with a credit card not owned or authorized for use by the purchaser.) Once that was done, the order had to be communicated to a worker at the warehouse so they could pack the right items into a box, put on a shipping label, and set the box aside to be picked up by the UPS truck which would come once a day near the end of the day.

The application used by the fraud department and the application that displayed new orders to warehouse workers was one and the same application. Whether a user had fraud-evaluating powers or pack-items-in-boxes powers just depended on what permissions their particular user had. (That may have been decided by LDAP groups. I don't remember for sure.)

Meanwhile, the e-commerce site offered gift cards for sale online. The gift card would be shipped to the customer. And there was a box where you could write a message associated with the gift card. So, for instance, someone could buy a gift card to be sent to their nephew's address or whatever and include a little note like "Happy Birthday. Don't spend it all at once." or whatever. And the fraud/pick-and-pack application would display all details of the order including any messages associated with the gift cards.

Well, I found a stored cross-site scripting vulnerability where if you put <script>...</script> tags with some JavaScript in the gift card message box and completed the order, the JavaScript would execute any time someone viewed the details page for the order in the fraud/pick-and-pack application. And of course, the JavaScript could do within that application just about anything the user could do with their given permissions.

The main danger was that a malicious actor with sufficient knowledge of how our fraud application worked could place an order fraudulently with someone else's credit card and include in the order a gift card with a malicious JavaScript payload in the message box, and then that malicious JavaScript could automatically mark the order "a-ok, no fraud here" when a fraud department worker loaded the order details page, letting the order be fulfilled without any actual fraud review.

The fix was pretty simple. Just stick a <c:out>...</c:out> in the appropriate place in the fraud/pick-and-pack application code. But it was an interesting example of a vulnerability in a not-customer-facing application that could none-the-less be exploited by any public customer/user without any particular special access.

If you're interested in one more interesting story about the same e-commerce application, see this comment I made a while ago.

6d ago

What are some of the worst code you have seen in a production environment?

Jump

TootSweet @lemmy.world 6d ago

Never roll your own ORM

I've done this. Probably 10 years ago. Even today, I maintain the same application that has the ORM in it that I designed. If I could go back in time and do something else, I'd do the same thing again. Honest to god. For my use case, I feel it was warranted. It was risky, but it worked out surprisingly well.

6d ago

What are some of the worst code you have seen in a production environment?

Jump

TootSweet @lemmy.world 6d ago

Java webapp. Customer facing. E-commerce application, so in PCI scope and dealt with credit card info and such.

There was one specific cookie that stored some site-wide preference for the customer. (Why not just put that preference in the database associated with the user? Because that would make too much sense is why.)

But the way they encoded the data to go into the cookie? Take the data, use the Java serialization framework (which is like Python's "Pickle" or Go's "Gob") to turn that into a string. But that string has binary data in it and raw binary data is kindof weird to put in a cookie, so you base64 encode the result. (The base64 encoding was the only sane step in the whole process.) Then you do the reverse when you receive the cookie back from the browser. (And no, there was no signature check or anything.)

The thing about the Java serialization framework, though is that decoding back into Java objects runs arbitrary object constructors and such. As in, arbitrary code execution. And there's no checking in the deserialization part of the Java serialization framework until your code tries to cast the object to whatever type you're expecting. And by that point, the arbitrary code execution has already happened. In short, this left a gaping vulnerability that could easily have been used to extremely ill effect, like a payment information breach or some such.

So all a malicious user had to do to run arbitrary code on our application server was serialize something, base64 encode it, and then send it to our servers as a cookie value. (Insert nail biting here.)

When we found out that there was a severe vulnerability, I got the task of closing the hole. But the existing cookies had to continue to be honored. The boss wasn't ok with just not honoring the old cookies and developing a new cookie format that didn't involve the Java serialization framework.

So I went and learned enough about the internal workings of how the Java serialization framework turned a Java value into a binary blob to write custom code that worked for only the subset of the Java serialization format that we absolutely needed for this use case and no more. And my custom code did not allow for arbitrary code execution. It was weird and gross and I made sure to leave a great big comment talking about why we'd do such a thing. But it closed the vulnerability while still honoring all the existing cookies, making it so that customers didn't lose the preference they'd set. I was proud of it, even though it was weird and gross.

The value that was serialized to put into the cookie? A single Java int. Not a big POJO of any sort. Just a single solitary integer. They could just as well have "serialized" it using base-10 rather than using the Java serialization framework plus base64.

6d ago

How did bittorrent fail to become essential technology?

Jump

TootSweet @lemmy.world 6d ago

The costs of distribution aren't really that expensive for big companies.

You can't really trust that users are going to be willing to donate hard drive space and upload bandwidth to help your maps service or whatever work. (Though, to be fair, you did mention things like OpenStreetMap which is probably more likely for users to be willing to support that way.)

Bittorrent isn't something you can seamlessly integrate into browser-based apps.

But also, there are newer technologes based on a very Bittorrent-like P2P way of doing things. IPFS is basically reskinned Bittorrent. And Peertube uses in-browser P2P to distribute videos. I don't think there's any standard in, say, HTML5 that allows for P2P without some hacks, but it sounds like there's a good chance such a standard is likely to make its way into browsers in the relatively near future. Also, it sounds like Chrome supports more than Firefox in that area right now.

1w ago

What show is weirdly or oddly cozy for you?

Jump

TootSweet @lemmy.world 1w ago

Star Trek: Voyager. I was raised on that shit. Not objectively the "best" Star Trek. (Far from the worst, though.) But it's the one that's most nostalgic and, indeed, "cozy" for me.

2w ago

What is this thing in Star Wars for?

Jump

TootSweet @lemmy.world 2w ago

Crocheting gloves for rancors.

2w ago

@Grok is this true?

Jump

TootSweet @lemmy.world 2w ago

I was thinking more Senator Kelly from the X-Men movie.

2w ago

Permanently Deleted

Jump

TootSweet @lemmy.world 2w ago

If you're ever able to and need to go no-contact with him, just don't feel any guilt over it.

2w ago

Where are Lemmy.World servers located?

Jump

TootSweet @lemmy.world 2w ago

The IP address of lemmy.world is 104.26.8.209 which appears to be in San Francisco.

2w ago

Save icon

Jump

TootSweet @lemmy.world 2w ago

Not a vending machine. It's clearly the third member of Daft Punk with a snaggletooth.

2w ago

The Six Stages of Code Grief

Jump

TootSweet @lemmy.world 2w ago

The next row would be "boss fires you thinking Claude can maintain the codebase."

2w ago

How do you stave off depression?

Jump

TootSweet @lemmy.world 2w ago

5-MTHF.

3w ago

What's your silly little website.

Jump

TootSweet @lemmy.world 3w ago

https://zombo.com/

4w ago

Are you less likely to comment on a bot post?

Jump

TootSweet @lemmy.world 4w ago

Nope. I reply to bots quite frequently. I'm often the only commenter in the thread, but if I have something to say about what the bot posted, I'll comment.

Often my comments are to make fun of blockchain or LLMs. But if the Hacker News bot posts a link to a blog post on underwater beekeeping and I have an opinion, I'll post whatever I think adds to the conversation.

4w ago

Does anyone actually have home safes or does everyone just use bank safes? (or do you hide stuff under your mattress?)

Jump

TootSweet @lemmy.world 4w ago

Nice try, Danny Ocean.

4w ago

How does one learn or start to manage thair life better?

Jump

TootSweet @lemmy.world 4w ago

That sounds like exactly the sort of thing therapy is for. I'm no kind of expert, but it's very likely there's a lot of deeper things keeping you from developing achieving the kind of skills you're wanting. And it sounds very much like it's a problem in your life that's causing you a lot of anxiety and pain. I think if there's any way you can do talk therapy, that's the place to start.