HNHacker News
TopNewBestAskShowJobs

preetamjinka

2,325 karma · joined December 28, 2012

Co-founder of FunnelStory.

I’m @preetamjinka on Twitter and @preetam on GitHub.

Email: az___4y @ imap.cc

[ my public key: https://keybase.io/preetam; my proof: https://keybase.io/preetam/sigs/HInV9u7zS2IoOpdvqsXli6QsvLzIYs0gvQpovXe-TUA ]

submissionscomments
preetamjinka··on How do you guys like your coffee?
I like using an espresso machine. I started learning latte art in 2020 so I try to make lattes as often as I can.
preetamjinka··on Useful Old Technologies: ASN.1 (2013)
I worked on a SNMP Go package many years ago [0] and it was really fun learning about ASN.1 and figuring out how to write encoders and decoders for various types.

[0] https://github.com/Cistern/snmp

preetamjinka··on Show HN: Fastest way to create cloud functions. Write and click deploy Button
Neat! How’s it implemented?
preetamjinka··on Postgres is a great pub/sub and job server (2019)
> This is fantastic for relatively low volume queues with intensive work to be done by a small number of workers. For these types of use cases, I'll take this approach over RabbitMQ or Kafka all day long.

That’s what our workload is like for our SaaS code analysis platform. We create a few tasks (~10 max) for every customer submission (usually triggered by a code push). We replaced Kafka with a PostgreSQL table a couple of years ago.

We made the schema, functions, and Grafana dashboard open source [0]. I think it’s slightly out-of-date but mostly the same as what we have now in production, and has been running perfectly.

[0] https://github.com/ShiftLeftSecurity/sql-task-queue

preetamjinka··on Ask HN: How do you manage direct updates to databases in a production system
> The common way I know is the access is given to a small number of trusted people who make the updates.

We have the same approach. A very small number of people have write access to the production databases. If things can’t wait for a schema change release (15-30 min) and can’t be done through the back office API, we do it manually. It’s very rare.

preetamjinka··on I lasted three minutes at Amazon
Same. Do SWE/SDE roles also involve drug tests and orientations?
preetamjinka··on Netlify Drop
Described here https://levels.io/deviance/ (Dec 10, 2020)
preetamjinka··on Zillow just gave us a look at machine learning's future
This seems to be the thread. I’m not sure how to link to the specific reply. https://www.teamblind.com/post/Zillowers-what-happened-fXvbZ...
preetamjinka··on TimescaleDB vs ClickHouse
It might help to think about time-series databases from the requirements they're addressing. "Time-Series Database Requirements" [0] is a good summary of the problem space.

[0] https://www.xaprb.com/blog/2014/06/08/time-series-database-r...

preetamjinka··on How Discord Stores Billions of Messages (2017)
Looks like they migrated (at least partially) to Scylla: "Discord Chooses Scylla as Its Core Storage Layer" (2020)

https://www.scylladb.com/press-release/discord-chooses-scyll...

preetamjinka··on Why I Built Litestream
B2 seems to have an S3 Compatible API now.

https://www.backblaze.com/b2/docs/s3_compatible_api.html

preetamjinka··on Liblfds, a portable, license-free, lock-free data structure library written in C
Related to this is Concurrency Kit [0], which is BSD-licensed, written in C, and provides concurrency primitives and data structures.

[0] http://concurrencykit.org/

preetamjinka··on “Free” as in “we own your IP”
FYI, it looks like it's Datadog.

https://github.com/DataDog/dd-agent/blob/master/packaging/da...

← PreviousPage 2 of 2