dantetheinferno
Joined 11 years ago
Joined 11 years ago
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.
If you trained an LLM against all the recorded discussions of Einstein - is it that different from talking to Einstein himself?
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.
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
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.
Best of luck to the folks leaving. Supporting OSS isn't easy.