Feed aggregator

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.

Article URL: https://offsec.tools/tool/reverse-shell-generator

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

Points: 1

# Comments: 0

Article URL: https://jennyjams.net/blog/cpp-mixin/

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

Points: 1

# Comments: 0

Article URL: https://read.perspectiveship.com/p/socratic-questioning

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

Points: 1

# Comments: 0

A new toaster oven could be the next best addition to your kitchen or a good end-of-year gift. Find out which ones are worth your money with our expert-tested picks.