HNHacker News
TopNewBestAskShowJobs

erikcw

671 karma · joined August 10, 2011

erik -at- erikwickstrom -dot- com
submissionscomments
erikcw··on Show HN: Streambed – Stream Postgres to Iceberg on S3, Supports Postgres Wire
Thanks for releasing this! How do you handle DDL queries? Are table changes synchronized to the Iceberg table automatically?

Also, I recently started looking into olake[0] to serve the same purpose. What would you say differentiates Streambed?

[0] https://github.com/datazip-inc/olake

erikcw··on Lakebase architecture delivers faster Postgres writes
How does Lakebase compare to Ducklake[0]?

[0] https://ducklake.select/

erikcw··on DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
I’ve had very good experience with it last year. I used it at large scale with data that had been in iceberg previously and it worked flawlessly. It’s only improved since. Highly recommend.
erikcw··on Run a 1T parameter model on a 32gb Mac by streaming tensors from NVMe
Simon Willison wrote a good post about Dan Woods’ work on “Autoresearching Apple's "LLM in a Flash" to run Qwen 397B locally”.

[0] https://simonwillison.net/2026/Mar/18/llm-in-a-flash/

erikcw··on Why DuckDB is my first choice for data processing
I use them both depending on which feels more natural for the task, often within the same project. The interop is easy and very high performance thanks to Apache Arrow: `df = duckdb.sql(sql).pl()` and `result = duckdb.sql("SELECT * FROM df")`.
erikcw··on Show HN: Play poker with LLMs, or watch them play against each other
Link to the lectures?
erikcw··on 650GB of Data (Delta Lake on S3). Polars vs. DuckDB vs. Daft vs. Spark
Data inlining is also currently limited to only the DuckDB catalog (ie it doesn't work with Postgres cataglogs)[0]. It's improving very quickly though and I'm sure this will be expanded soon.

[0] https://ducklake.select/docs/stable/duckdb/advanced_features...

erikcw··on I built Foyer: a Rust hybrid cache that slashes S3 latency
This looks really useful! Am I correct that there isn’t an S3 compatible API, just the “fetch” API?

Being able to set an S3 client’s endpoint to proxy traffic straight through this would be quite useful.

erikcw··on BlackSheep: Fast ASGI web framework for Python
I’ve started using Granian[0] recently with good results.

[0] https://github.com/emmett-framework/granian

erikcw··on Helium: Lighter Web Automation with Python
I've used SikuliX[0] in the past for similar purposes. Unfortunately the author hasn't had much time to maintain it recently.

[0] https://github.com/RaiMan/SikuliX1

erikcw··on FCC rules AI-generated voices in robocalls illegal
I've always wished that there was an option to whitelist certain area codes. I've had the same number for 20 years, and now live in a different part of the country. I get very little spam from local area codes -- but a ton spoofing my phone number's area code. Sending all calls all those calls to voicemail while continuing to ring for local would be the right balance (kids' school, doctors office, etc...).
erikcw··on As solar capacity grows, duck curves are getting deeper in California
https://www.caiso.com/TodaysOutlook/Pages/default.aspx
erikcw··on My cat water fountain comes with a spicy USB power adapter
I thought my ThermoWorks Signal had a dead/defective battery after trying to charge it on a standard USB power adapter. Device booted up and and functioned fine, except the battery wouldn't charge. Plugged it into the provided adapter and it started charging again.

Thanks for the PSA, I'll be sure to get that adapter off my kitchen counter right away!

erikcw··on Ruff v0.1.0
I’ve been meaning to find time to get ruff-lap working on Doom Emacs side by side with pyright. Is anyone who’s already managed to get it working willing to share their config?
erikcw··on DuckDB 0.9
How about the Relational API[0] or the new PySpark compatible API[1] added in this release?

[0] https://duckdb.org/docs/archive/0.8.1/api/python/relational_... [1] https://github.com/duckdb/duckdb/pull/8083

erikcw··on Why We're Pulling Our Recommendation of Wyze Security Cameras
I'd love something like dd-wrt but for these cloud cameras. I have some Arlo cameras that I'd love to re-flash and run without the cloud service.
erikcw··on Everyday uses for PVC water pipe
After stumbling upon this, I’ve been obsessively looking for an excuse to drill a well[0].

https://drillyourownwell.com/

erikcw··on UBC device uses wood dust to trap up to 99.9 per cent of microplastics in water
Perhaps as a profit center to the tea industry. Most tea bags contain the grades of tea that can't be sold in the more expensive loose leaf form. Basically leaf fragments and dust. That material would otherwise be a waste product.
erikcw··on Things you forgot (or never knew) because of React
I’ve been using it to great effect for the last year or so. It really is a breath of fresh air. In my case, I’m using a Django backend, but there are lots of successful folks using other backend stacks as well so choose what you know best.

The book is a really quick and easy read. It’s pretty eye opening how productive, and effective, htmx can be with so little magic.

https://hypermedia.systems/

erikcw··on BigQuery prices increasing by more than 100% for many users
Ideally you’d used Parquet or ORC if querying from Athena/Trino/Presto. Since they are columnar formats you will enjoy considerably faster queues and lower query costs for most query patterns other than “select *…” since the query engine can just retrieve the columns needed for your query instead of the entire row.
erikcw··on Call GPT-3 from Terminal
I was experimenting with the Warp terminal for the first time last week. It includes a similar feature. I was pretty impressed with how well it worked.

[0] https://docs.warp.dev/features/entry/ai-command-search#

erikcw··on Modern Polars: A comparison of the Polars and Pandas dataframe libraries
I just tried polars for this first time this week. I ported a data pipeline from pandas and I was blown away by the performance yield. Function went from a 60 min runtime with pandas to ~1:30 in polars!

I’ve been using pandas for years and had no issues picking up the syntax. Can’t recommend giving it a try enough.

erikcw··on The first rule of Microsoft Excel: Don’t tell anyone you’re good at it
I recently inherited a codebase that uses Pony ORM[0]. Might be worth taking a look if you want your interactions to look as similar to vanilla python expressions as possible.

[0] https://ponyorm.org/

erikcw··on Sonic: Fast, lightweight and schema-less search backend
One of the features I like in ES that I haven’t seen in alternatives is “Percolate queries” (queries where you feed the service a document and it returns a list of queries that you’ve indexed that would match that document - basically inverting the whole process).

Does anyone know of any alternatives that support this use case?

https://www.elastic.co/guide/en/elasticsearch/reference/mast...

erikcw··on Postgres Full Text Search vs. the Rest
Does anyone have any comparable experience using FTS in DuckDB?

https://duckdb.org/docs/extensions/full_text_search

erikcw··on Show HN: AutoHotkey for Linux
I’ve been using hammerspoon for several years and it has really become integral to my workflow.

You may want to check out the extension package spacehammer[0]. It includes a bunch of workflows and shortcuts that I’ve found extremely useful.

Interestingly (for me at least), it’s authored in Fennel [1], a lisp that compiles to lua. I actually found spacehammer originally when I was working on converting my personal hammerspoon config to Fennel.

[0] https://github.com/agzam/spacehammer

[1] https://fennel-lang.org/

erikcw··on uBlacklist – Block specific sites from appearing in Google search results
According to the README, this also works with DDG and some other search engines.
erikcw··on Open Source Alternative To
RabbitMQ is a more natural alternative to SQS than Kafka I’d say. Redis can also be leveraged as a message broker depending on your needs.
erikcw··on From AWS Lambda and API Gateway to Knative and Kong API Gateway
That’s interesting. Can you go into a little more detail as to how non-tech contributors are participating?
erikcw··on Ask HN: Which book can attract anyone towards your field of study?
I like Ken Forkish’s “Flour Water Salt Yeast: The Fundamentals of Artisan Bread and Pizza”
Page 1 of 6Next →