Feed aggregator

Article URL: https://www.youtube.com/watch?v=wU4yPEFXzo0

Comments URL: https://news.ycombinator.com/item?id=42182407

Points: 1

# Comments: 0

Article URL: https://artofproblemsolving.com/blog/articles/avoid-the-calculus-trap

Comments URL: https://news.ycombinator.com/item?id=42182398

Points: 2

# Comments: 0

Article URL: https://chinesecookingdemystified.substack.com/p/63-chinese-cuisines-the-complete

Comments URL: https://news.ycombinator.com/item?id=42182384

Points: 1

# Comments: 0

As an applicant, I've personally had a mixed experience with take-homes. We're designing the technical interviews right now, and I thought I'd ask for some stories on exciting take-home tasks. We're looking for something that resembles the actual job, so we'll allow any tool (including AI and debuggers).

Also curious to hear about any bad ones you've done.

Comments URL: https://news.ycombinator.com/item?id=42182365

Points: 2

# Comments: 0

Several benchmark refinance rates were higher this week, so it might be worth waiting.

The new ROG phone adds some personality alongside its brawny spec sheet.

Price vs. coverage, reliability vs. customer satisfaction—CNET connectivity experts have dug into the stats to determine which ISPs are the best across several categories in Murfreesboro.

Article URL: https://www.youtube.com/watch?v=GZ5XN_mJE8Y

Comments URL: https://news.ycombinator.com/item?id=42182201

Points: 1

# Comments: 0

Article URL: https://www.theregister.com/2024/11/18/infosys_workaholic_founder/

Comments URL: https://news.ycombinator.com/item?id=42182184

Points: 2

# Comments: 0

Planning to travel for the holidays? Or maybe you're already planning ahead for summer travel? Here are some tips for scoring the cheapest airfare.

Article URL: https://www.prisma.io/docs/orm/overview/introduction/should-you-use-prisma

Comments URL: https://news.ycombinator.com/item?id=42182162

Points: 3

# Comments: 0

Article URL: https://paragraph.xyz/@rm/from-identity-to-identifying

Comments URL: https://news.ycombinator.com/item?id=42182156

Points: 1

# Comments: 0

Article URL: https://twitter.com/eyeslasho/status/1857853402308337719

Comments URL: https://news.ycombinator.com/item?id=42182149

Points: 1

# Comments: 1

pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database.

In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README.

The pglite-fusion extension is written in Rust using the pgrx framework [1].

----

Implementation Details

The PostgreSQL `SQLITE` type is stored as a CBOR-encoded `Vec`. When a query is made, this `Vec` is written to a random file in the `/tmp` directory. SQLite then loads the file, performs the query, and returns the result as a table containing a single row with an array of JSON-encoded values.

The `execute_sqlite` function follows a similar process. However, instead of returning query results, it returns the contents of the SQLite file (stored in `/tmp`) as a new `SQLITE` instance.

[1] https://github.com/pgcentralfoundation/pgrx

Comments URL: https://news.ycombinator.com/item?id=42182146

Points: 1

# Comments: 0

Article URL: https://futo.org/blog/the_future_of_software_distribution/

Comments URL: https://news.ycombinator.com/item?id=42182138

Points: 1

# Comments: 0

Article URL: https://en.wikipedia.org/wiki/Bursera_graveolens

Comments URL: https://news.ycombinator.com/item?id=42182134

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/news/articles/c1wj43vqdlpo

Comments URL: https://news.ycombinator.com/item?id=42182127

Points: 1

# Comments: 0

Commentary: I'm a tech reporter who's watched parents play the screen time shame game for years. Here's where our family landed.

It's another sign that wearables are getting serious about tracking more than just steps and exercise.