Ask HN: Who is hiring? (September 2022)

Your certificate is broken, clicked on the click but decided not to bother after the five warnings from Safari and the need to unlock the system security settings to set an exception.

The temptation is to have the message date and/or ranking number in the message table. This is fine and good.

The next temptation is to have the index on that date or (date, rank) and use that for displaying the list of messages. This is bad.

For the list of threads (messages without a parent) you want to know which to show… but there are a lot of calculations that would make this inefficient. Is it a root message? Is it deleted? Is it marked by spam or other content filters? Is it approved?

You can start to see how this gets messy. How do you show messages that are approved for one group of readers and not for others? And what is their order? So separate the concerns… in the db. SQL is your friend if the db has the right data packaged and indexed the right way.

It’s a different problem and has a different solution. Now mind you, I cut my teeth on this in the late 1990s and early 2000s when we grew quickly into the Alexa 1000 and farther up. China blocked us as one of the original dozen sites on the great firewall (via dns resolved IPs, not the domain itself… hahaha, oh the chaos they empowered!). Databases were more expensive than engineering time back then, so efficiency mattered. People do dumb things now and use giant clusters when a single machine would do, but I digress…

Tulip | https://tulip.co/eng | Boston, MA, Munich, Germany, and Budapest, Hungary | Full time | Onsite & Remote

Do you want to help transform manufacturing? We are building the best team in the industry to bring consumer-grade user experiences to a space dominated by ancient enterprise technology. Our platform enables our customers to create apps without code and to connect their apps to machines, sensors and smart tools. These augmented production lines would otherwise rely on paper to share information.

We have offices in Somerville, MA, Munich, Germany and Budapest, Hungary. We just closed a $100m series C and are using that capital to grow dramatically. Our customers include some of the largest manufacturers in the world across numerous verticals of the manufacturing industry.

We'd love to talk to anyone interested, but in particular we are looking to bring folks on in:

- SRE/DevOps: Kubernetes-admin, scalable monitoring across the firewall, hybrid cloud/on-prem deployment

- Web Development: React+Redux frontend, NodeJS+Mongo+Postgres+Redis backend, syncing data with Meteor, delivering useful, real-time experiences in the browser and on Electron

- Data & Pipeline Engineering: planning, implementing, and finding insights with our next generation of process & sensor analytics

- IoT/Embedded Software: delivering a reliable, extensible HW platform across arm and x86, all manner of bus/IO tech

- Machine Learning & Computer Vision: build end-to-end ML and CV products to track and extract valuable insights from raw data, interact with clients to solve real-world problems with data.

Apply at https://tulip.co/careers or email us at jobs@tulip.co

Salv | Product Engineer | Tallinn/Tartu, EE, or Vilnius, LT | onsite | full time

We build a platform for banks and other fintechs to help fight money-laundering. Well-funded and growing startup where your work will have positive impact on many people.

We're looking for multiple engineering roles. We use Kotlin and Typescript. The work is remote but you must be tax resident of Estonia or Lithuania.

Read more about this and other engineering positions: https://salv.com/careers/