Hacker News Reader

xiasonghon ClickHouse gets lazier and faster: Introducing lazy materialization

Has anyone compared ClickHouse and StarRocks[0]? Join performance seems a lot better on StarRocks a few months ago but I'm not sure if that still holds true.

[0] https://www.starrocks.io/

xiasonghon Some things to expect in 2025

Didn't people already do that before, copy and pasting code off stack overflow? I don't like it either but this issue has always existed, but perhaps it is more common now

xiasonghon Show HN: I Built an AI Tool That Turns Your Resume into a Job Magnet in Seconds

That's a ridiculous accusation. Swift is not an uncommon adjective.

xiasonghon Small Businesses vs. Corporations: What Tech Tools Are We Missing?

Which Request for Startup is this? I'm not able to find it

xiasonghon Jepsen: Bufstream 0.1.0

Found this on their website https://github.com/bufbuild/buf

xiasonghon New Mac Mini with M4

From the article

> Mac mini with M4 starts at $599 (U.S.) and $499 (U.S.) for education. Additional technical specifications are available at apple.com/mac-mini.

xiasonghon MVCC – the part of PostgreSQL we hate the most (2023)

CMU's Intro to Database Systems course is one of the best resources. Andy Pavlo has his lectures all up on youtube

xiasonghon Pear AI founder: We made two big mistakes

They are new grads

xiasonghon Startup incubator Y Combinator backs its first weapons firm

> Sequoia buying UFC is really strange, too.

I'm having trouble finding sources for this. I do see that Sequoia Capital China invested in ONE Championship, but not Sequoia and UFC

xiasonghon Show HN: Pg_analytica – Speed up queries by exporting tables to columnar format

How does this compare to pg_analytics?

https://github.com/paradedb/pg_analytics

xiasonghon Make your program slower with threads (2014)

There's key parts left out of that quote that changes the tone quite a bit. Here is the full one

"Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered. We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil. Yet we should not pass up our opportunities in that critical 3%." - Donald Knuth

xiasonghon Don't DRY Your Code Prematurely

This might not be a perfect example, but there's a paper by Michael Stonebraker "One size fits all": an idea whose time has come and gone

It might not specifically be DRY, but still related generic vs specialized code/systems.

https://ieeexplore.ieee.org/document/1410100

xiasonghon Chronon, Airbnb's ML feature platform, is now open source

> By mutable data do you mean - change data coming from OLTP databases?

Yes, exactly! I see there is some kind of support, but is it possible to use the OLTP database as an event source?

For example, say I had a table in my OLTP database, `data.returns`, that had columns `ts`, the event time, and `status`, which can be PENDING or COMPLETED. I'd like to generate point-in-time correct training data, where the feature is the count of completed returns. It seems like all the necessary information to calculate this is there

xiasonghon Chronon, Airbnb's ML feature platform, is now open source

How does Chronon handle mutable data when backfilling? Or does it make some assumptions on the underlying data?

xiasonghon Show HN: Add Code Interpreter to Claude 3 Opus

Unfortunately I haven't solved that issue either and the UI could easily break on updates

xiasonghon Show HN: Add Code Interpreter to Claude 3 Opus

I also thought my usage pattern of ChatGPT resembled Jupyter notebooks. I tried to make a chrome extension[0] that adds a code interpreter to ChatGPT, but implemented it in the most naive way, with just pyodide.

I recently learned about Jupyter kernels and realized that was probably what I should've been using to build this out.

I named the extension JPT, combining Jupyter with GPT. I was very proud of myself for that one lol :)

[0] https://chromewebstore.google.com/detail/jpt-chatgpt-code-in...

xiasonghon Show HN: We built the fastest spreadsheet

Are you guys using polars or Data Fusion for any computations?

xiasonghon Proton, a fast and lightweight alternative to Apache Flink

How does this compare to RisingWave and Materialize?

https://github.com/risingwavelabs/risingwave https://github.com/MaterializeInc/materialize

xiasonghon MariaDB ditches products and staff in restructure

What's wrong with MySQL and MariaDB?

xiasonghon HAProxy is not affected by the HTTP/2 Rapid Reset Attack

What about nginx? I'm not too familiar but I was under the impression that it was the safe choice

xiasonghon Ask HN: Tell us about your project that's not done yet but you want feedback on

> If you can make a library to run python code inside a JS project

This is actually exactly what Pyodide does! It's basically the CPython interpreter compiled to wasm. This will allow you to run python code in, say, NextJS.

xiasonghon Ask HN: Tell us about your project that's not done yet but you want feedback on

https://chrome.google.com/webstore/detail/jpt-chatgpt-code-i...

I've been working on a chrome extension that let's you run python code in ChatGPT. You can see the output, see plots with matplotlib, upload and download files, use a bunch of packages, all thanks to Pyodide[0]. Basically ChatGPT's own code interpreter but worse (it's also free, you get what you pay for). It was important to me that it works completely locally and does not save any data.

It is one of my first personal projects and seeing the number of users go up makes me happy and want to keep improving it. I had to make my github repo private because I had an issue with a copycat, but I can make it public if people actually care.

[0] https://pyodide.org/en/stable/

xiasonghon Uses and abuses of cloud data warehouses

Why does bolding words imply adtech?

xiasonghon How to be successful as a research mathematician? Follow your gut

Does this kind of advice apply to all research or specifically mathematics?

xiasonghon Ask HN: How do you look for jobs in 2023?

I'm a new grad and I was extremely scared because of all the doom and gloom on HN and reddit. I also felt like new grads would be hit the hardest.

Come application time... it was totally normal. Had some interviews and some rejections. Ended up getting multiple offers with very competitive compensation.

While I may be the exception rather the norm, there are definitely companies that are still hiring and some that are just getting head count for the upcoming quarter. I would not give up hope.

xiasonghon Data-Oriented Design Principles

I feel that DOD is about performance, not understandability and usability, so it makes sense that the frontend of a framework, where usability is priority, doesn't benefit, and the backend and hot path does.