News for hackers. Stuff that matters.

nattaylor

Re:How we made our MMDB files a 33% smaller on Wednesday October 28, 2026 @09:21PM (#50283310)
These are widely deployed [citation needed] so nice chance to save some ram!

I wonder - if the number of nodes goes down enough then they could reduce the number of bits for the record_size and save another 12-25%

Re:Postgres SELECT DISTINCT Does Not Scale on Friday September 25, 2026 @11:10PM (#49852837)
Re:Ramp Launches a Model Router on Wednesday August 19, 2026 @05:24PM (#49367401)
Muse Spark, Gemini, mistral and something from cohere would be nice

That said the current models ain't bad!

I'm drawn to this but it has several foot guns like INSERTs will fail for late arriving data if the constraints have been updated etc
Reminds me a little of htmz

htmz is a minimalist HTML microframework for creating interactive and modular web user interfaces with the familiar simplicity of plain HTML.

Re:Ask HN: What are you working on? (September 2025) on Monday September 29, 2025 @06:56PM (#45419875)
Building an email-to-calendar-feed service for all the mails from the multitude of services and attachments that I get related to my kindergartener.
Re:AP to end its weekly book reviews on Monday August 11, 2025 @02:46PM (#44867896)
My read is that no customers will leave since they are much more interested in news coverage -- and this helps the AP focus more on news.

This is a tangent, but I wonder if they feel that they are just creating LLM training data and that few readers (even of Sunday papers) will actually read their reviews.

The base model is Qwen2.5-VL-3B and the announcement says a limitation is "Model can suffer from hallucination"
I wish there were some explain plans in either post, since I don't get what's going on.

If the query uses the index, then the on the fly tsvector rechecks are only on the matches and the benchmark queries have LIMIT 10, so few rechecks right?

Edit: yes but the query predicates have conditions on 2 gin indexes, so I guess the planner chooses to recheck all the matches for one index first even though it could avoid lots of work by rechecking row-wise

Re:The Llama 4 herd on Saturday April 05, 2025 @03:02PM (#43595930)
Is pre-training in FP8 new?

Also, 10M input token context is insane!

EDIT: https://huggingface.co/meta-llama/Llama-3.1-405B is BF16 so yes, it seems training in FP8 is new.

Re:Preview: Amazon S3 Tables and Lakehouse in DuckDB on Tuesday March 18, 2025 @02:01PM (#43402588)
S3 Tables is designed for storing and optimizing tabular data in S3 using Apache Iceberg, offering features like automatic optimization and fast query performance. SimpleDB is a NoSQL database service focused on providing simple indexing and querying capabilities without requiring a schema.
This is very cool. Kuzu has a ton of great blog content on all the ways they make Kuzu light and fast. WebLMM (or in the future chrome.ai.* etc) + embedded graph could make for some great UXes

At one time I thought I read that there was a project to embed Kuzu into DuckDB, but bringing a vector store natively into kuzu sounds even better.

Re:Facebook is down on Wednesday February 26, 2025 @10:07PM (#43190899)
500 errors for me
Doesn't compression make any minification gains negligible?
Re:TinyJS – Shorten JavaScript QuerySelect with $ and $$ on Wednesday October 02, 2024 @05:52PM (#41725309)
Sorry, I didn't mean to suggest your solution was brittle -- I actually quite like it and want to adopt it!

But I do think the legacy browser behavior with the ID attribute as window properties is very brittle for the reasons you suggest

Re:TinyJS – Shorten JavaScript QuerySelect with $ and $$ on Wednesday October 02, 2024 @05:38PM (#41725207)
If you like brittle things, the id attribute is already made into an attribute on the window for legacy reasons

Edit: My tone may have indicated that parent's solution was brittle. It's not!

Re:Pivotal Tracker will shut down on Thursday September 19, 2024 @10:37AM (#41592391)
https://we.phorge.it/ is a community fork that appears pretty active.

I was also very fond of Phabricator (all though my team preferred GitHub style pull requests) but I haven't had a need for it recently, so I haven't tried phorge myself.

On Chrome, I solve my too-many-tab issues with an extension [0] that closes the LRU tab once a threshold is reached (10 for me). I find the tabs I need are open and wide enough, and the tabs that autoclose were not useful anymore. About once a month I'm doing a research task where I actually want many tabs and I turn it off temporarily.

[0] - https://chromewebstore.google.com/detail/max-tabs/ghhcibaghj...

Re:SQLite vector search extension that runs anywhere on Friday August 02, 2024 @07:11PM (#41143439)
I have a use case for this that I'm excited to try. I'm glad AlexG has put so much effort into this. Even the docs are pretty good!

My pyenv python3.12.2's sqlite won't load extensions even after installing with what I think are the correct command line flags. Argh!

My brew installed python3.12's sqlite will load extensions though, so I can proceed.

Re:Show HN: ControlFlow – open-source AI workflows on Tuesday June 25, 2024 @07:29PM (#40794877)
I was checking this out on my train ride home and I'm pretty excited to take it where it's been tonight. Well done team!
Yes, speed. 1,000,000+ QPS and 1,000s of ads to evaluate is common. At that scale it's very distributed, so replication is another challenge.

In a way, its a search problem where bid≈relevance and targeting_match≈recall, so I've seen Solr used here too.

A friend built a system where the ad campaigns with all their targeting rules were Lua scripts and it was also fast and simple in a glorious way!
Re:Snowflake, Cloud Storage Giant, Suffers Breach on Friday May 31, 2024 @12:29PM (#40537137)
In my experience with Snowflake support about a year ago, an administrator of the customer's account had to explicitly grant access to Snowflake in order for the Snowflake team to see or do anything -- and if I recall correctly the access had an expiry.
Re: on Monday March 25, 2024 @10:14PM (#39823643)
Boring things like running the proxy while I did manual QA / ran automated tests.

I quickly realized that if I wanted an up to date spec then I should do it properly in the application

Re: on Monday March 25, 2024 @03:16PM (#39820239)
Reminds me of https://github.com/alufers/mitmproxy2swagger which I discovered from this thread https://news.ycombinator.com/item?id=31354130

I generated some specs from that!

I ran into trouble keeping them up to date.

Re:Show HN: Stanchion – Column-oriented tables in SQLite on Thursday February 01, 2024 @02:15PM (#39219927)
This is particularly interesting to me for Android/iOS. I can't even picture the use case where there'd be enough data on the device for the row-based format to b a bottleneck, but maybe some case that involves many, many aggregations
Re:Multi-Database Support in DuckDB on Sunday January 28, 2024 @09:23PM (#39172051)
Re:Ollama releases Python and JavaScript Libraries on Thursday January 25, 2024 @07:25AM (#39128797)
https://pypi.org/project/languagemodels/ can load some small models but forming JSON-reliably seems to require a larger-ish model (or fine tuning)

Aside: I expect Apple will do exactly what you're proposing and that's why they're exposing more APIs for system apps

In my experience it excels at the stated use case of OLAP in the cloud with compute separate from storage and claim it's unambiguously good for this.

For OLTP it would be unambiguously bad (although maybe there's hope with Unistore, which I haven't tried.)

Many workloads are a mix and so it can become ambiguous whether it's a great fit / great value / whatever you're defining good/bad-ness by

Older »