Hacker Newsnew | past | comments | ask | show | jobs | submit | F_r_k's commentslogin

Did an interview for them. They sent me a 3 page IQ-like test ("how much triangles are inside this triangle"-type of thing).

I guess they didn't like my reply of "many"


BTW, netbird is a cool alternative also


I prefer it too and I like that it's 100% open source. Server, client, everything. Pangolin also looks interesting if you don't need a full vpn. And if you go that way, Authentik with its embedded proxy is also worth considering.


I don't want my competitors to know about my number of clients, etc.


Don't expose your PKs


So you have a second, opaque unique identifier for the frontend to fetch? At that point why not just use a single column (UUID)?


Yes, this is standard. And the point is performance. The needs of user-facing ID's (short alphanumeric, randomly ordered) tend to be pretty orthogonal to the needs of internal ID's (raw bits, monotonically increasing, maybe timestamp data).


Yep, you'll probably join like 20 of those for each public uuid lookup. There are potential reasons not to do it this way, but it's a good default.


Higher density for indexes you use for joins. Also you can then use UUIDv4 to hide creation times if that's sensitive too.


It makes more sense to have two columns yes, one autoincrement for the primary key, and another uuidv4. Because uuids are too large and makes indexes slower


So when public APIs use uuidv4 to fetch item, those uuidv4 still need to be indexed...


Right, but that's one lookup vs the many joins you're probably doing internally


This was hard enough to enforce when it was just people writing code, and once one of those stupid incrementing integer IDs go in a public API or important codepath, it can be a real pain to rip out.


This can be a valid reason. Will say though, in my experience, the AI coders have been good at respecting the comments above the PKs saying not to expose.


Use snowflake? It leaks some info, but not nearly as much.


RIP Kevin. Used these sites a lot!

I hope they give then to a charity/charitable person. I proposed to continue the service ad free, for free to them. Hopefully they accept my proposal. It would be such a shame for the service to become "enshittified" by some greedy company


To know your IP


kWh


Found my phone account; I'm quite impressed, really !


I have this same car (made in 2016 for me) and I would never trade it for the world. Comfortable enough, efficient, and quite good imho


Didn't you meant to write: "you are good to go to pollute"


[flagged]


It's always interesting when this is brought up, because private flights emissions are literally nothing compared to the transport industry emissions. They might as well be zero. Introduction of AdBlue has been one of the greatest improvements in diesel emissions that we have done - calling it "peddling by brussels" is uninformed at best and actively malicious at worst.


Demanding that our leaders follow the same lifestyle they are forcing on us is I think a very straightforward thing.


This has nothing to do with CO2 emissions and everything to do with particle pollution.

Our leaders do not live inside urban centers, and do not suffer from particle pollution. Or at least way less than the average citizen, and i'm not even talking about the people living near the Paris ring road, who aren't exactly the richest.

I understand if you're from the countryside (i am too) that you dislike adBlue, but think that it probably add years of living to the poorest urbanites.


Of course - and they should.

But the argument that you shouldn't be using AdBlue in your diesel because rich people fly private jets is frankly, crazy. Both things should be addressed, but one of those things is far more important to tackle right now for the health of everyone.


They are as cheap as you are wasteful


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: