14849
Top stories from https://news.ycombinator.com (with 100+ score) Contribute to the development here: https://github.com/phil-r/hackernewsbot Also check https://t.me/designer_news Contacts: @philr
Blender 4.3 (Score: 155+ in 5 hours)
Link: https://readhacker.news/s/6ifJh
Comments: https://readhacker.news/c/6ifJh
Bottles of OOP now available in Python (❄️ Score: 150+ in 4 days)
Link: https://readhacker.news/s/6i22n
Comments: https://readhacker.news/c/6i22n
Epic Allows Internet Archive to Distribute Unreal and Unreal Tournament Forever (🔥 Score: 159+ in 2 hours)
Link: https://readhacker.news/s/6ifCx
Comments: https://readhacker.news/c/6ifCx
Open Riak – open, modern Riak fork (Score: 150+ in 9 hours)
Link: https://readhacker.news/s/6ieJY
Comments: https://readhacker.news/c/6ieJY
SpaceX Super Heavy splashes down in the gulf, canceling chopsticks landing (Score: 155+ in 6 hours)
Link: https://readhacker.news/s/6if3r
Comments: https://readhacker.news/c/6if3r
Hand Tracking for Mouse Input (Score: 150+ in 10 hours)
Link: https://readhacker.news/s/6ie8C
Comments: https://readhacker.news/c/6ie8C
Using Erlang hot code updates (Score: 151+ in 6 hours)
Link: https://readhacker.news/s/6ieJT
Comments: https://readhacker.news/c/6ieJT
Show HN: Embed an SQLite database in your PostgreSQL table (Score: 150+ in 11 hours)
Link: https://readhacker.news/s/6icWC
Comments: https://readhacker.news/c/6icWC
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<u8>`. When a query is made, this `Vec<u8>` 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
Ask HN: How do you communicate in a remote startup? (❄️ Score: 152+ in 4 days)
Link: https://readhacker.news/c/6i2Fu
We are a remote company. Everything is going well. No plans to be in person, but I’d say we can do a better job at communicating. Any tips or articles to read?
OpenStreetMap's New Vector Tiles (🔥 Score: 152+ in 3 hours)
Link: https://readhacker.news/s/6id5h
Comments: https://readhacker.news/c/6id5h
Hyperfine: A command-line benchmarking tool (Score: 152+ in 15 hours)
Link: https://readhacker.news/s/6ibsY
Comments: https://readhacker.news/c/6ibsY
Maslow 4: Large format CNC routing made accessible (Score: 150+ in 10 hours)
Link: https://readhacker.news/s/6ic6M
Comments: https://readhacker.news/c/6ic6M
Rats Learned to Drive–and They Love It (Score: 150+ in 5 hours)
Link: https://readhacker.news/s/6iccg
Comments: https://readhacker.news/c/6iccg
Llama 3.1 405B now runs at 969 tokens/s on Cerebras Inference (Score: 151+ in 4 hours)
Link: https://readhacker.news/s/6ibSb
Comments: https://readhacker.news/c/6ibSb
The Skyline algorithm for packing 2D rectangles (Score: 150+ in 12 hours)
Link: https://readhacker.news/s/6ia5k
Comments: https://readhacker.news/c/6ia5k
The Data Engineering Handbook (Score: 152+ in 16 hours)
Link: https://readhacker.news/s/6iebJ
Comments: https://readhacker.news/c/6iebJ
Let's Encrypt is 10 years old now (🔥 Score: 152+ in 2 hours)
Link: https://readhacker.news/s/6ifQN
Comments: https://readhacker.news/c/6ifQN
Apple Confirms Zero-Day Attacks Hitting macOS Systems (Score: 153+ in 5 hours)
Link: https://readhacker.news/s/6ifjp
Comments: https://readhacker.news/c/6ifjp
Tiny Glade 'built' its way to >600k sold in a month (🔥 Score: 151+ in 3 hours)
Link: https://readhacker.news/s/6ifu3
Comments: https://readhacker.news/c/6ifu3
Why I hate the index finger (1980) (Score: 150+ in 1 day)
Link: https://readhacker.news/s/6ibUW
Comments: https://readhacker.news/c/6ibUW
Rim/Blackberry tales – reply all (❄️ Score: 150+ in 1 week)
Link: https://readhacker.news/s/6hRWx
Comments: https://readhacker.news/c/6hRWx
When did estimates turn into deadlines? (Score: 155+ in 5 hours)
Link: https://readhacker.news/s/6ieEk
Comments: https://readhacker.news/c/6ieEk
Show HN: Physically accurate black hole simulation using your iPhone camera (🔥 Score: 151+ in 3 hours)
Link: https://readhacker.news/s/6ie5w
Comments: https://readhacker.news/c/6ie5w
Fair coins tend to land on the side they started: Evidence from 350,757 flips (Score: 166+ in 8 hours)
Link: https://readhacker.news/s/6icGj
Comments: https://readhacker.news/c/6icGj
The tragedy of running an old Node project (Score: 151+ in 20 hours)
Link: https://readhacker.news/s/6iaLE
Comments: https://readhacker.news/c/6iaLE
Scientific American's departing editor and the politicization of science (Score: 154+ in 14 hours)
Link: https://readhacker.news/s/6ibvM
Comments: https://readhacker.news/c/6ibvM
$8k Suzuki from India received a 5-star crash test rating (❄️ Score: 151+ in 6 days)
Link: https://readhacker.news/s/6hR35
Comments: https://readhacker.news/c/6hR35
LLaVA-O1: Let Vision Language Models Reason Step-by-Step (Score: 150+ in 19 hours)
Link: https://readhacker.news/s/6i9qm
Comments: https://readhacker.news/c/6i9qm
AMD now has more compute on the top 500 than Nvidia (Score: 151+ in 9 hours)
Link: https://readhacker.news/s/6iaSa
Comments: https://readhacker.news/c/6iaSa
Two undersea cables in Baltic Sea disrupted (Score: 150+ in 12 hours)
Link: https://readhacker.news/s/6i9Tx
Comments: https://readhacker.news/c/6i9Tx