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
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
MailCatcher runs a super simple SMTP server (Score: 152+ in 9 hours)
Link: https://readhacker.news/s/6iarh
Comments: https://readhacker.news/c/6iarh
Show HN: Documind – Open-source AI tool to turn documents into structured data (Score: 151+ in 14 hours)
Link: https://readhacker.news/s/6i9v9
Comments: https://readhacker.news/c/6i9v9
Documind is an open-source tool that turns documents into structured data using AI.
What it does:
- Extracts specific data from PDFs based on your custom schema
- Returns clean, structured JSON that's ready to use
- Works with just a PDF link + your schema definition
Just run npm install documind to get started.
Show HN: Zyme – An Evolvable Programming Language (❄️ Score: 150+ in 3 days)
Link: https://readhacker.news/s/6hZLY
Comments: https://readhacker.news/c/6hZLY
Zyme is an esoteric language for genetic programming: creating computer programs by means of natural selection.
Is Chrome the New IE? (2023) (Score: 151+ in 1 day)
Link: https://readhacker.news/s/6i8mx
Comments: https://readhacker.news/c/6i8mx
Finland and Lithuania Report Severed Undersea Data Cables (🔥 Score: 151+ in 2 hours)
Link: https://readhacker.news/s/6iaT6
Comments: https://readhacker.news/c/6iaT6
Against Best Practices (Score: 150+ in 11 hours)
Link: https://readhacker.news/s/6i9fA
Comments: https://readhacker.news/c/6i9fA
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
Air traffic failure caused by two locations 3600nm apart sharing 3-letter code (❄️ Score: 151+ in 4 days)
Link: https://readhacker.news/s/6hWvb
Comments: https://readhacker.news/c/6hWvb
20 years of Google Scholar (Score: 150+ in 6 hours)
Link: https://readhacker.news/s/6iaFr
Comments: https://readhacker.news/c/6iaFr
DOJ will push Google to sell off Chrome (🔥 Score: 174+ in 1 hour)
Link: https://readhacker.news/s/6ibyr
Comments: https://readhacker.news/c/6ibyr
Show HN: Tips.io – A Tailwind playground with AI, page management, and theming (Score: 150+ in 7 hours)
Link: https://readhacker.news/s/6ia5r
Comments: https://readhacker.news/c/6ia5r
Hi HN!
My name is Nick and this is my fun side project. Please lay it on me. HN can think of Tips.io as a cracked out Tailwind Playground that has page management and amazing AI integration.
There are a few core ideas:
1) The HTML is the CMS
There are no fields or restrictions. Just hover, click, and start tweaking any HTML. Also, certain elements you click will have special easy edit abilities:
- <img> auto creates an uploader, stock photo picker (or HTML)
- <video> auto creates an uploader, stock video picker (or HTML)
- <svg> auto creates a big icon picker (or HTML)
- <div class="prose"> auto creates a WYSIWYG Editor (or HTML)
2) Slices
Think of these as just individual HTML sections of a page or lil baby single-file components. They are self-contained and isolated so you drag them around easily. The real power comes from reuse across your pages and linking them (aka, one HTML footer updates globally). You can also use "slices" from any other tips.io project for quickly expanding your site with more design options.
3) AI Elements, Not Pages
Another cool concept is you can select any element on an HTML slice an edit that individually vs re-streaming/rebuilding and entire component every time. We support 5 different AI models right now. Some other really intense/cool AI integration is coming soon.
4) Tailwind Everything, No Build Step, & Theming
We have a custom "themer" to make creating Tailwind config files near instant with real-time font trying, color palettes/preset trying, and more. All our Tailwind is automatic and requires zero config instantly. The same Tailwind that magic runs client-side will run server-side so quick no one knows a build step is happening. Tailwind and AI are also a match made in heaven.
Other features:
- Animations
- Zoomable page tree
- Basic Forms (yes on your static site!)
- Analytics
- Redirects, site passwords, and much more.
Tech:
- 100% Cloudflare Workers
- Svelte
- UnoCSS
Some resources:
- Promo video: https://www.youtube.com/watch?v=s8U2rJJX-rk
- Tutorial & demo video: https://tips.io/tutorial
- Just launch: https://new.tips.io
A BBC navigation bar component broke depending on the external monitor (Score: 150+ in 5 hours)
Link: https://readhacker.news/s/6ia7t
Comments: https://readhacker.news/c/6ia7t
Museum of Bad Art (Score: 150+ in 19 hours)
Link: https://readhacker.news/s/6i8AZ
Comments: https://readhacker.news/c/6i8AZ