dantetheinferno

Joined 11 years ago

Karma
41
Submissions
24
Member since
Oct 27
View on Hacker News

Recent submissions

Comment · 3 months ago
Comment · 1 year ago
Apple M4 Pro w/ 48GB running the smaller version. I'm getting 43.7t/s
Comment · 1 year ago
I expose my jellyfin to 80 via nginx. Other services stay not exposed, and only available on my local network. I don't bother with tailscale.
Comment · 3 years ago
Fixed! Thank you!
Comment · 3 years ago
Hey hey, post author here.

This is a really good point that wasn't fully clear to me - this post definitely focuses on the \COPY from psql, rather than the CopyFrom backend.

I've gone ahead updated the post in the introduction to highlight that this post is about `psql`. My goal here is to try and understand Postgres better - so thank you for pointing this out :). I think writing a future post going into the backend code you mentioned is necessary. My goal is to have solid reasoning on why `COPY` is faster, and I'll need to keep writing these posts to get there.

Let me know if you think it's still unclear - I don't want to leave up any article that's potentially confusing.

I've also cleaned up the language a bit around `libpq`, I mistakenly restated the description of `libpq` from the Postgres , which is stated as "libpq is the C application programmer's interface to PostgreSQL. libpq is a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries.", but you two are correct, my statement was confusing.

Comment · 3 years ago
One wonders if ChatGPT could self-replicate - using these API keys as a bootstrap. Lots of individual users computes would certainly lower the threshold for being cut off for billing reasons.
Comment · 3 years ago
One wonders if eventually - historians will plug all the content from a person's personal notes, their diary, their chat logs, into an LLM, and perform research by talking to the AI about the person's life?

If you trained an LLM against all the recorded discussions of Einstein - is it that different from talking to Einstein himself?

Comment · 3 years ago
Only illegal to not accept cash for debts. A merchant can refuse to do business with you in cash since you're not in debt at the checkout counter (as no transaction has occured)
Comment · 3 years ago
Pretty cool - wonder how it compares to Postgrest (https://postgrest.org/).

Generally been a fan of these sorts of models - SQL data is very malleable - and treating the tables as movable from the start really helps move faster as a developer - database migrations become easier as you don't need to do a lot of work with API.

I can see how this would cause problems if you always used this in production after finding a fit for the data model - but for rapid prototyping and development - big fan.

Comment · 3 years ago
I find that this will wipe out a lot of Software Developers who are doing something that isn't really unique - and people will move on to more interesting work.

The internet wiped out travel agencies - but opened a new, more interesting world of better products (Expedia, Google flights, etc.) that made travel more accessible to everyone. Instead of travel agents - we hire software developers to benefit everyone

Comment · 4 years ago
I'm pretty anti-TikTok - but shouldn't we have some evidence - or any knowledge of who this material came from - before trusting a reporter from Forbes?

I read through the article - but I couldn't find any details on the source this reporter is citing. Worryingly - the author "held policy positions at Facebook and Spotify." Instagram is a major competitor to TikTok - so conflict of interest is pretty strong.

As other posters pointed out - every major company tracks people. We've known about this type of behaviour for decades from big tech.

Comment · 4 years ago
Why is this better than Airflow, or Prefect, or Dagster?
Comment · 4 years ago
Wouldn't you want to not give the client any information about the correct answer? I would think you would want to have a `POST` command that gives you the encoding guesses if you truly want to keep it out of the browser.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton