HNHacker News
TopNewBestAskShowJobs

jerrygenser

640 karma · joined February 1, 2022

meet.hn/city/us-Boston
submissionscomments
jerrygenser··on Soul: A SQLite REST and Realtime Server
Realtime seems to mean - in this context - that you can open up a web socket and subscribe to changes to rows. i.e. get changes to rows pushed to you as a client instead of pulling.
jerrygenser··on Finding lead in Stanley's Quencher
There are a lot of naturally occurring elements and compounds that are extremely lethal. That does not make a reason not to be afraid.
jerrygenser··on How Figma's databases team lived to tell the scale
>It is true though that GCP sometimes sunsets specific product functionality, requiring changes on the customers' part. Some of these are unavoidable (eg committing to apply security patches to Python 2.7 given that the rest of the world is mostly not upstreaming these patches anymore), but not all of them.

A good example is probably IoT. I've heard first hand anecdotes of very difficult migrations off this service.

jerrygenser··on How Figma's databases team lived to tell the scale
IoT is one example of a big backbone service that was sunset.
jerrygenser··on How Figma's databases team lived to tell the scale
They mentioned analyzing query logs in Snowflake in this very article. So... at least they use Snowflake for some things?
jerrygenser··on A generalist AI agent for 3D virtual environments
It seems like parent comment is the top comment on this post with a lot of replies and facilitated on topic discussion. Not sure which part of parent topic related another AI playing a game is off topic from the original post of an AI playing a game
jerrygenser··on A generalist AI agent for 3D virtual environments
Upvoted. Not sure why this got downvotes. It's very cool that you were at TI7 as I only watched this on youtube. I also thought this was an important moment.
jerrygenser··on Show HN: Hatchet – Open-source distributed task queue
Looks cool but looks like it's only typescript. If there is a json payload, couldn't any web server handle it?
jerrygenser··on Show HN: Hatchet – Open-source distributed task queue
I think it depends on the http runtime. One of the things with cloud run is that if the server is not handling requests, it doesn't get CPU time. So even if the first request is "wake up", it wouldn't get any CPU to poll outside of the request-response cycle.

You can configure cloud run to always allocate CPU but it's a lot more expensive. I don't think it would be a good autoscaling story since autoscaling is based on http requests being processed. (maybe can be done via CPU but that's may not be what you want, it may not even be cpu bound)

jerrygenser··on Show HN: Hatchet – Open-source distributed task queue
Something I really like about some pub/sub systems is Push subscriptions. For example in GCP pub/sub you can have a "subscriber" that is not pulling events off the queue but instead is an http endpoint where events are pushed to.

The nice thing about this is that you can use a runtime like cloud run or lambda and allow that runtime to scale based on http requests and also scale to zero.

Setting up autoscaling for workers can be a little bit more finicky, e.g. in kubernetes you might set up KEDA autoscaling based on some queue depth metrics but these might need to be exported from rabbit.

I suppose you could have a setup where your daemon worker is making http requests and in that sense "push" to the place where jobs are actually running but this adds another level of complexity.

Is there any plan to support a push model where you can push jobs into http and some daemons that are holding the http connections opened?

jerrygenser··on The end of Airplane.dev
> - By 2023, with slowing growth, it's likely that Airtable was no longer able to raise additional funding. Best case was likely a down-round.

The author stated they had millions if not 10s of millions in the bank and a bit of runway. And they had already done layoffs. Based on this, they were not under pressure to raise or do a down-round.

Separately and related to a sibling comment, the fact that Thrive Capital invested in Airplane and Airtable means they can now have a positive "tombstone" for Airplane by saying it was an "exit" while receiving a bunch of their original investment back.

jerrygenser··on Show HN: Daytona – Open-source dev env manager from a 15-year journey
Very cool project. I'm looking forward to trying it. One note that's hindering me now is that it's very difficult to read the documentation, e.g. on this page: https://www.daytona.io/docs/installation/single-node/

There is very light gray font against a white background.

jerrygenser··on Better PC cooling with Python and Grafana
Another thing I've had great success with on my AMD 7700X is to use AMD Ryzen Master to reduce the TDP.

The chip comes to consumers overclocked by default with a TDP of 105W. I suspect this is the case so that it can beat Intel on benchmarks on "default" settings.

You can set it to "eco mode" and have it run at 65W or 45W TDP. Under load, this only results in like a 5% reduction in performance for a dramatic reduction in electricity consumption, fan speed, heat, etc.

Not sure if the 5500x series chips are overclocked but using eco mode could be a good approach.

jerrygenser··on Pql, a pipelined query language that compiles to SQL
This seems really cool. This is not meant to be a negative comment - why does it matter that it's written in Go? It's stated multiple times but could this be written in multiple other languages and still be functionally the same?
jerrygenser··on Testcontainers
If you have a dependency like a third party API (or even internal code), and you write an API client, then depend on that client, would it be considered couple code?

In such cases, if I am using dependency injection and creating a (stub?) versions of that client which returns a hardcoded or configured output, would that be considered a mock? OR would this be OK and not "coupled"?

jerrygenser··on Apache Superset
They were also more specifically authored by the same individual!
jerrygenser··on Readyset: A MySQL and Postgres wire-compatible caching layer
I'm answering the comment above mine that is asking for a user case. I'm saying that my use case is an example where json/html caching is not sufficient. 100% agree with you.
jerrygenser··on Gemma: New Open Models
Looking forward to Gemma 7bx8 moe
jerrygenser··on Readyset: A MySQL and Postgres wire-compatible caching layer
What if it's a backend service that is not exposed to a frontend that receives html or Json. E.g a task that takes an id and a operation name and needs to fetch from the database a bunch of data to process.
jerrygenser··on Interview with Andreas Kling of Serenity OS (2022)
Isn't that how z/os from IBM works? The API is a SQL api into files I think
jerrygenser··on PostgreSQL is enough
If the purpose is to do database specific things then pg cron can be useful for e.g. periodic vacuums. However for running application logic, maybe less so.
jerrygenser··on OLMo: Accelerating the Science of Language Models [pdf]
Yes I meant AMD.
jerrygenser··on Stories removed from the Hacker News Front Page, updated in real time
Only saw one Gary tan link removed. I thought I'd see more. Maybe it was only removed because it was a dupe? I'm referring to the "Gary tan tupac lyrics" one.
jerrygenser··on OLMo: Accelerating the Science of Language Models [pdf]
Pretty cool that it runs on and and Nvidia
jerrygenser··on Google's Bard shows big leap on LLM performance leaderboard
Does not completely answer the question, all aspects of a question, or has a response otherwise cut off. This was common for gpt4 and coding questions it would simply stop responding in the middl
jerrygenser··on AMD Publishes XDNA Linux Driver: Support for Ryzen AI on Linux
It's more that Linux is a better dev environment than windows in general. I develop in docker so it's not platform dependent.

I am doing UI,backend API services, ML research, ML services

jerrygenser··on AMD Publishes XDNA Linux Driver: Support for Ryzen AI on Linux
I primarily develop on Linux.

I used to use Linux as a primary OS and sometimes dual boot in Windows. However, I have since transitioned to using Windows directly and WSL2. It is seamless overall.

There are a few edge cases, e.g. it was as little annoying to set up LUKS encryption and it's a lot easier to just use BitLocker. Other minor edge cases with permission of volumes that are mounted from Windows into Linux.

Further, there are some nuances around networking, especially if you are running docker in WSL2.

Once you get over these hiccups, it's quite comfortable.

jerrygenser··on Ask HN: Are height adjustable desks worth it?
Costco was selling a decent quality one for not too much
jerrygenser··on AWS cancels serverless Postgres service that scales to zero
reposting Neon ceo twitter post: https://twitter.com/nikitabase/status/1725394843285766463
jerrygenser··on Polars
More like in memory transformations you would do in pandas
← PreviousPage 5 of 11Next →