HNHacker News
TopNewBestAskShowJobs

JaggerFoo

198 karma · joined April 20, 2016

submissionscomments
JaggerFoo··on PostgreSQL for Everything
Use case matters.

I use a SQL databases as needed. I've used Postgres, Sqlite, Duckdb, Json files with AWS Athena, Oracle enterprise for ERP systems (a multitude of schemas and objects with interoperability), and others.

I'm currently, deploying Duckdb with AWS S3 Tables (Iceberg) to see how it fits for a use case I have.

IT is great and always changing. Keep trying new things.

Cheers

JaggerFoo··on Qwen3.6-35B-A3B on my laptop drew me a better pelican than Claude Opus 4.7
FYI, using a 128GB M5 MacBook Pro, sourced from another article by the author.
JaggerFoo··on Microsoft suspects some PCs might not boot after Windows 11 January 2026 Update
You mean the one I just downloaded and updated my laptop with? It installed OK.

I usually use MacOS and Linux, it's just that some software is Windows only, and I run MacOS on Apple Silicon - the windows program I needed only uses x86-64 architecture, so I can't use parallels (AFAIK).

I'm kind of hoping I get an update that bricks my laptop so I can install Debian over this MS Windows hellscape and run windows on a VM when needed. I may do it anyways after I get fed up with nagging MS messages and workarounds.

JaggerFoo··on Against SQL (2021)
SQL is great. I've used it to implement knapsack optimization for Daily Fantasy Sports at scale. I use it in Big Data tools and RDBMS. It's pervasive in data tech.

Feel free to innovate and bring forth other RDBMS/Data query languages and tools, perhaps something may succeed and stick as long as SQL has.

Cheers

JaggerFoo··on Superpowers: How I'm using coding agents in October 2025
I don't see any code. Where are the examples of use on real code?
JaggerFoo··on A small number of samples can poison LLMs of any size
Interesting. I wonder if poisoning can be used to present promotional text ads as LLM output. Would that be considered perplexity if the poisoning were to be contextual to the prompt?

Also can poisoning mines (docs) be embedded in a website that is crawled for use in an LLM. Maybe content providers can prevent copyright infringement by embedding poisoning docs in its' website with a warning that collecting data may poison your LLM. Making poisoning the new junkyard dog.

Cheers

JaggerFoo··on Litestream v0.5.0
Interesting information that they chose modernc.org/sqlite over mattn/go-sqlite3 as a Quality-of-Life improvement. Going forward I guess I'll do the same for new projects.

The NATS Jetstream use case is something I'm curious about.

Cheers and keep up the great work on Litestream.

JaggerFoo··on Frying Eggs and Air Quality Tests
I wonder if there are any studies of professional chefs and their long-term health. I see video after video of chefs cooking in close proximity to oil cooked food, wood burning setups (BBQ), waiting for cooking oil to smoke, even smoking while cooking, etc.

If there should be a cohort that would be the canary in the coal mine, it would be professional chefs, who day-in and day-out cook for a living over several hours per day. Yet, I have not heard of any studies raising alarms for the profession.

Cheers

JaggerFoo··on AI is ushering in a 'tiny team' era
Some excellent ideas presented in the article. It doesn't matter if they all pan out, just that they expand our thinking into the realm of AI and its role in the future of business startups and operations.

Revenue per employee, to me, is an aside that distracts from the ideas presented.

JaggerFoo··on Google Cloud Incident Report – 2025-06-13
I would be interested in seeing the elapsed time to recovery for each location up to us-central-1.

Is this information available anywhere?

JaggerFoo··on Reinforcement Learning: An Overview
Uses the acronym MDP several times before defining it. So perhaps not an introductory paper, but geared to those already immersed in the field.
JaggerFoo··on Oracle Cloud deleting active user accounts without possibility for data recovery
This happened to me when Oracle first started in the cloud business. I actively avoid doing business with their cloud services.
JaggerFoo··on I got OpenAI o1 to play the boardgame Codenames and it's super good
I did this with Claude over the holidays. Putting Claude in the role as a guesser and comparing the guess to another experience human player. It turns out they both matched each other.
JaggerFoo··on AI could create 78M more jobs than it eliminates by 2030
Monkeys can be trained by AI to eliminate 100M jobs in 2035, world economy embraces bananas as the global reserve currency.

There, I can make predictions too and it did not require prompt engineering or a analytic budget or economists.

Cheers

JaggerFoo··on Google Year in Search 2024: The Breakout searches of the year
Only a brief nod to Girmay's breakout performance at the Tour de France.

He must've barely beat out Hawk Tuah Girl.

Cheers

JaggerFoo··on I made a free Figma library packed with components for fast prototyping
I like that Figma is not required. Can it dynamically model horizontal scrolling, such as album art and info?
JaggerFoo··on SQLiteStudio: Create, edit, browse SQLite databases
I use it all the time on Sonoma OS with no problems. I have yet to upgrade to Sequoia due to the numerous reported problems on Reddit.
JaggerFoo··on SQLiteStudio: Create, edit, browse SQLite databases
Excellent product that behaves as expected and adheres to Sqlite's unique requirements when updating schema objects.
JaggerFoo··on SQLite: Outlandish Recursive Query Examples
Years ago I came across a Knapsack problem solution written in Oracle SQL, that I adapted to Daily Fantasy Golf.

Here's the source: https://aprogrammerwrites.eu/?p=878

Cheers

JaggerFoo··on The Unreasonable Effectiveness of Monte Carlo Simulations in A/B Testing
I really enjoyed the introduction. Hopefully I can bring myself to read the rest of the paper, or as far as is reasonable for someone unfamiliar with the subject.

Cheers

JaggerFoo··on GnuCash 5.9
I use GnuCash for business accounting and it does what I need. I don't use QuickBooks as VC's recommend in blog posts. QB has some convenient features, but that is not enough for me to pay the price QB is asking. I don't need VC money or a CPA.

I haven't tried using GnuCash with Sqlite, but I would like to experiment when I get the time. Is it reliable?

I used to be a technical/functional engineer for Oracle EBS, so I dealt with very complex schemas that interlinked with each other especially in the sub-ledgers.

I've always toyed with the idea of adding Revenue Recognition functionality to GnuCash but am too busy to do so. Perhaps after seeing the schema in Sqlite I can take a shot at it.

Cheers

JaggerFoo··on Scientists discover a cause of lupus, possible way to reverse it
Nick Cannon, host of "The Masked Singer" America, would be glad to hear this. He has Lupus.

Now all he needs is a cure for poor "Pull-Out" game syndrome.

Cheers

JaggerFoo··on Three ways to think about Go channels
Timely article for me, since I'm thinking of using channels in a real-world application for the first time.
JaggerFoo··on Why you should not apply to YC
Points for using the term "Non-Ergodic". I wish it were used more often.

The post is well written, mostly cohesive, and with a willingness to express ideas counter to the status quo.

JaggerFoo··on Impostor Syndrome vs. the Dunning-Kruger Effect
Chicks dig the Dunning-Kruger Effect.
JaggerFoo··on Why Postgres RDS didn't work for us
I did't get the article at first. Was the solution self-managed PostgreSQL on EC2 and EBS, it's not stated explicitly, but implied with the WAL-G reference?

Why not use K-V if your looking for performance?

JaggerFoo··on Police raid Worldcoin warehouse in Nairobi
Well, another ideas used for identity in the crypto world was having a twitter account for more than a specific time period, and a number of followers. So I was considered unidentifiable as a person because I had a Twitter account that did not have the requisite number of followers - so I couldn't get test network tokens for development work. SMH.

Limited partners (pension funds) are paying for this aspirational idea (less any funds from selling tokens perhaps) while a16z will pocket a Venture Capital fee.

Lots of money sitting around might as well roll the dice.

JaggerFoo··on Countries that will suffer the most temperature change from global warming
I notice that Mexico and Australia are not included on the extended list, I'm not sure what that says about the study or the two countries.
JaggerFoo··on Probability and Markets [pdf]
When was this published? There is no publication or revision dates in the pdf. Maybe 1999 when Jane Street started?
JaggerFoo··on The Mullvad Browser
Anyone else unable to gpg verify the browser download. When I downloaded the VPN gpg verify was OK.

Nevermind, I had to follow instructions from the github page to download the TOR Browser Signing Key and verify.

Page 1 of 5Next →