Hacker News: 1egg0myegg0

New comment by 1egg0myegg0 in "A Preview of DuckDB v2.0"

1egg0myegg0 — Tue, 18 Aug 2026 02:32:12 +0000

Oh, then you might like these DuckDB community extensions that provide stats functions!

https://duckdb.org/community_extensions/extensions/stats_duc...

https://duckdb.org/community_extensions/extensions/stochasti...

New comment by 1egg0myegg0 in "The best worst hack that saved our bacon"

1egg0myegg0 — Sun, 05 Oct 2025 12:30:24 +0000

Whoever gets that magical -2,147,483,648 is going to be really surprised that things keep working

New comment by 1egg0myegg0 in "Instant SQL for results as you type in DuckDB UI"

1egg0myegg0 — Fri, 25 Apr 2025 04:21:26 +0000

We support spatial calculations in the UI, but not spatial visualizations just yet. Thanks for the feedback!

New comment by 1egg0myegg0 in "Instant SQL for results as you type in DuckDB UI"

1egg0myegg0 — Fri, 25 Apr 2025 00:01:15 +0000

Sorry you hit that! This is actually already working on version 1.2.2. Could you install that version? That should get you going for the moment! We will dig into what you ran into.

New comment by 1egg0myegg0 in "Instant SQL for results as you type in DuckDB UI"

1egg0myegg0 — Thu, 24 Apr 2025 14:49:45 +0000

It is already available in the local DuckDB UI! Let us know what you think!

-Customer software engineer at MotherDuck

New comment by 1egg0myegg0 in "Adding concurrent read/write to DuckDB with Arrow Flight"

1egg0myegg0 — Thu, 30 Jan 2025 02:39:12 +0000

IN list filter predicate pushdown is much improved in DuckDB 1.2, coming in about a week! I am not sure if it applies to Arrow yet or not. Disclaimer: I work at MotherDuck and DuckDB Labs

New comment by 1egg0myegg0 in "Databases in 2024: A Year in Review"

1egg0myegg0 — Thu, 02 Jan 2025 03:48:53 +0000

That is very surprising to hear! If you can reproduce it, could you please file a bug report on GitHub? That would be a huge help!!

New comment by 1egg0myegg0 in "Tubeworms live around deep-sea vents"

1egg0myegg0 — Thu, 17 Oct 2024 19:18:15 +0000

Are we in the Dune timeline?

New comment by 1egg0myegg0 in "DuckDB Community Extensions"

1egg0myegg0 — Sat, 06 Jul 2024 12:57:36 +0000

Hello! I would recommend trying out DuckDB's SQLite attach feature! You can read or write data, and even make schema changes, all with DuckDB's engine and syntax. The storage then uses SQLite, which is row oriented!

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

(I work at MotherDuck and DuckDB Labs)

New comment by 1egg0myegg0 in "DuckDB Community Extensions"

1egg0myegg0 — Sat, 06 Jul 2024 02:16:51 +0000

Extension downloads are validated using a signature check to prevent tampering!

(I work for DuckDB Labs and MotherDuck)

New comment by 1egg0myegg0 in "What Happens When You Put a Database in the Browser?"

1egg0myegg0 — Sun, 23 Jun 2024 04:19:17 +0000

Howdy! I work at MotherDuck and DuckDB Labs (part time as a blogger). At MotherDuck, we have both client side and server side compute! So the initial reduction from PB/TB to GB/MB can happen server side, and the results can be sliced and diced at top speed in your browser!

New comment by 1egg0myegg0 in "DuckDB 1.0.0"

1egg0myegg0 — Mon, 03 Jun 2024 16:07:13 +0000

Howdy! Thanks for your benchmarking!

Your blog does a great job contrasting the two use cases. I don't think too much has changed on your main use case, however here are a few ideas to test out!

DuckDB can read SQLite files now! So if you like DuckDB syntax or query optimization, but want to use the SQLite format / indexes, that may work well.

Since DuckDB is columnar (and compressed), it frequently needs to read a big chunk of rows (~100K) just to get 1 row out and decompressed. Mind trying to store your data uncompressed? Might help in your case! (PRAGMA force_compression='uncompressed')

Links: https://duckdb.org/docs/extensions/sqlite

New comment by 1egg0myegg0 in "Perf Is Not Enough"

1egg0myegg0 — Mon, 11 Mar 2024 00:45:31 +0000

We heard your feedback! Backward compatibility was just implemented! Version 0.9 is actually fully readable by 0.10. With version 1.0 coming in a few months, this will be readable for several years' worth of version updates.

New comment by 1egg0myegg0 in "DuckDB 0.9"

1egg0myegg0 — Tue, 26 Sep 2023 15:21:24 +0000

There are many! https://www.thespruce.com/duck-species-list-385436

New comment by 1egg0myegg0 in "DuckDB 0.8"

1egg0myegg0 — Thu, 18 May 2023 04:22:33 +0000

No worries! Thanks for reading the docs!

New comment by 1egg0myegg0 in "DuckDB 0.8"

1egg0myegg0 — Thu, 18 May 2023 04:19:37 +0000

Howdy! The docs reflect the latest dev branch. For a specific release, you can pick it from the version dropdown in the top right!

New comment by 1egg0myegg0 in "DuckDB 0.8"

1egg0myegg0 — Thu, 18 May 2023 04:14:18 +0000

You could definitely run a pivot with the SQLite attach! All of the DuckDB syntax works!

New comment by 1egg0myegg0 in "DuckDB 0.8"

1egg0myegg0 — Thu, 18 May 2023 03:52:07 +0000

Great question! For analytical queries, DuckDB is ~100x faster than SQLite. It also has great connectivity with Parquet, Pandas, Arrow, Postgres, and more! Plus, the syntax follows Postgres closely, so you have strong data typing and true timestamps, etc.

All that said - SQLite is still faster for transactions. Now DuckDB can actually read and write from/to SQLite, so you can use SQLite for OLTP and DuckDB for OLAP.

https://duckdb.org/docs/sql/statements/attach

New comment by 1egg0myegg0 in "DuckDB 0.8"

1egg0myegg0 — Thu, 18 May 2023 03:48:04 +0000

Sorry to hear that!

(I work on docs for the DuckDB Foundation)

Starting in this release, the DuckDB team invested significantly in adding memory safety throughout catalog operations. There is more on the roadmap, but I would expect this release and all following to have improved stability!

That said, at my primary company, we have used it in production for years now with great success!

New comment by 1egg0myegg0 in "DuckDB 0.7.0"

1egg0myegg0 — Tue, 14 Feb 2023 05:02:11 +0000

DuckDB uses all of your cores! It just uses threads, not processes!