superice

8 ms·

31.
by superice 2y ago
You should look into Secure Container Release, Certified PickUp, Secure Chain, and a whole bunch of other initiatives doing this. Here is the Dutch one: https://www.portbase.com/en/programs/secure-chain/
32.
by superice 2y ago
Container terminals will take any minor efficiency win on their side, even if it comes at the cost of massive efficiency loss for truck transporters. It's optimizing for a local maximum. The market is structured in such a way that it i
33.
by superice 2y ago
That's a pretty reasonable mental model. The only real requirement during unloading is ship stability, other than that just use max concurrency with all the cranes and equipment to max throughput. Even just on the crane level, you can
34.
by superice 2y ago
Yes, although that's the same for loading. As a general rule, container ships are unloaded tier-by-tier, breadth-first if you will, not shaft-by-shift (depth-first), so this is not much of a problem in practice. That does start to chan
35.
by superice 2y ago
So about truck appointment systems, you should probably be thankful those are NOT the norm. Generally speaking container terminal operators and transport companies are antagonistic to eachother, since they are NOT in a direct business relat
36.
by superice 2y ago
That's not true in my experience. Loading outbound cargo is way more complex, since the stowage plan of the ship dictates where each container goes. Theoretically a lot of containers can be swapped as long as weight is similar, the con
37.
by superice 2y ago
We’ve done this for an SME customer of ours. We were essentially building a new module on top of their existing in-house systems. We laid out our query patterns in advance so they could index properly, and only query specific views. Write-o
38.
by superice 2y ago
My cheesy tagline for this is “The customer is always right about their problems, rarely about the solution to it”. They know their business inside and out, and I’m not about to tell them otherwise. Metaphorically: if they need to cross a r
39.
by superice 2y ago
Fair enough. To clarify, my point was not necessarily “I know better”, but that it is incredibly difficult to get a broad view of the market from a single perspective. This market is by definition a chain of steps with parties that may be a
40.
by superice 2y ago
I'd recommend against it, but then again, I'm building software products in this exact space with my launching customer being a 200-300M annual revenue logistics company. I don't think they could do it in-house. You don'
41.
by superice 2y ago
I'm a little confused about the point-in-time restore functionality, I'm pretty sure there must be a way to not have to force those one minute WAL boundaries. DigitalOceans managed PostgreSQL for instance just allows you to specif
42.
by superice 2y ago
Yes, CSS variables. Defining a preset of variables on :root for sizes and color ranges goes a long way. The design philosophies behind Tailwind are sound, but like so many I dislike the technical implementation. I feel like there is a lot o
43.
by superice 2y ago
Yes, and that's leaving aside the explainability problem. Let say for arguments sake that you have an optimal planning algorithm, if you cannot explain to the people using it why it generates a certain solution, it will not get adopted
44.
by superice 2y ago
For the customers in my size category (50k to 1 million TEU / year) the answer is that they may have 2 or 3 planners, optimizing berthing slots and stowage plans, but other than that there is no coordinated effort. You have to realize
45.
by superice 2y ago
There is a talk by the Technical University of Denmark (DTU) online by a researcher in this space, which is a pretty good introduction to the problem of stowage: https://www.youtube.com/watch?v=9ltz4G-lPdg As somebody activ
46.
by superice 2y ago
Same here, I'm in the business of terminals as well as hinterland transportation companies. There is no shortage of people trying to solve the 'sexy' academic problems like stowage plan optimization, berth assignment problems
47.
by superice 2y ago
No, probably not, but SQL and ORMs aren’t used just for consumer grade applications ;) I’m sure N+1 is not a big problem in those use cases, but saying that thereforr the problem doesn’t exist is overgeneralizing a bit. B2B is not a small m
48.
by superice 2y ago
At risk of sounding like the Dropbox-guy: it's not that hard to implement these yourself. I've had to write a service mimicking a PostgreSQL database for... reasons, and expanding the Postgres connection protocol to have functiona
49.
by superice 2y ago
I wasn't aware of Joist until I read a comment of yours somewhere else in this comment section, interesting stuff! I think Joist is the closest thing I've seen to an actual fix to this problem. The way you use the JS event loop as
50.
by superice 2y ago
Happy to name a concrete use case: showing a manifest of containers to load/unload from a ship. Search needs to happen client-side for many reasons, ballpark figures may be 1000 loads, 1000 unloads, the info about the shipvisit, and a
51.
by superice 2y ago
Oh it definitely isn't. Data volume may be small, but latency will kill you, especially if your database server isn't on the same machine as your application. If you fetch an entity A with a one-to-many to entity B, with a typical
52.
by superice 2y ago
Well, looking at something like the PostgreSQL protocol, it's decently efficient already. You could probably run a layer of compression on top of it, like HTTP gzip or so, but I doubt that will give a significant performance gain. If y
53.
by superice 2y ago
I see all these comments stating 'oh ORMs are bad' and 'just write some SQL'. Yes, you should probably not be afraid of SQL, and yes, using an ORM for everything is probably not great, and no, ORMs aren't a full rep
54.
by superice 2y ago
Interesting. Does it do this separate query for all entities in scope, or per entiry like Hibernates SELECT FetchMode? I find a separate SELECT is usually possible, but doesn’t quite solve this in the general case. Perhaps I missed Django,
55.
by superice 2y ago
This seems fundamentally unfixable with current ORMs. You either have to pick between lazy loading per entity, or eager load and carthesian product everything, which breaks badly if you are dealing with multiple one-to-many relations. Our s
56.
by superice 2y ago
Tech debt is more like being in debt to violent mobsters, who will show up at your house unannounced at the most inconvenient of times, during which they will hit you with a wrench until you pay whatever is in your wallet right now. They wi
57.
by superice 3y ago
Oh that’s easy to fake with type narrowing: function expectType<A, B extends A>() {} expectType<never, typeof yourUnion>(); The function call will fail at compile time if yourUnion is anything more than never, which you can use
58.
by superice 3y ago
I have been programming since 2008, but I truly started my professional webdev career in 2014. The company I started at was providing software in a B2B-sector. Very boring, very non-startupy. They were considered innovators for doing webapp
59.
by superice 3y ago
If you don't happen to have the time to visit him, here is a playlist of videos Numberphile did on Klein Bottles, his basement warehouse, the intrinsic curvature of pizza, and a whole bunch of other interesting things: https:/&#x
60.
by superice 3y ago
A quick google search seemed to indicate it was a general e-commerce related law, which is why I brought it up, but happy to take your word over mine.

More ›