1egg0myegg0

8 ms·

1.
Agentic SQL for Free: Qwen3.8 27B and DuckDB(motherduck.com)
4 points by 1egg0myegg0 18d ago|0 comments
2.
by 1egg0myegg0 21d ago
This fall, DuckDB will support larger than memory indexes! I'm really excited about it. https://duckdb.org/2026/08/17/duckdb-20-highlights#7-storage...
3.
by 1egg0myegg0 1mo ago
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/
4.
by 1egg0myegg0 1y ago
Whoever gets that magical -2,147,483,648 is going to be really surprised that things keep working
5.
by 1egg0myegg0 1y ago
We support spatial calculations in the UI, but not spatial visualizations just yet. Thanks for the feedback!
6.
by 1egg0myegg0 1y ago
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.
7.
by 1egg0myegg0 1y ago
It is already available in the local DuckDB UI! Let us know what you think! -Customer software engineer at MotherDuck
8.
by 1egg0myegg0 2y ago
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
9.
by 1egg0myegg0 2y ago
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!!
10.
by 1egg0myegg0 2y ago
Are we in the Dune timeline?
11.
by 1egg0myegg0 2y ago
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:/&
12.
by 1egg0myegg0 2y ago
Extension downloads are validated using a signature check to prevent tampering! (I work for DuckDB Labs and MotherDuck)
13.
by 1egg0myegg0 2y ago
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 sli
14.
by 1egg0myegg0 2y ago
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
15.
by 1egg0myegg0 3y ago
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.
16.
by 1egg0myegg0 3y ago
There are many! https://www.thespruce.com/duck-species-list-385436
17.
by 1egg0myegg0 3y ago
No worries! Thanks for reading the docs!
18.
by 1egg0myegg0 3y ago
Howdy! The docs reflect the latest dev branch. For a specific release, you can pick it from the version dropdown in the top right!
19.
by 1egg0myegg0 3y ago
You could definitely run a pivot with the SQLite attach! All of the DuckDB syntax works!
20.
by 1egg0myegg0 3y ago
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 t
21.
by 1egg0myegg0 3y ago
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 rel
22.
by 1egg0myegg0 4y ago
DuckDB uses all of your cores! It just uses threads, not processes!
23.
by 1egg0myegg0 4y ago
Let us know how you would improve our Modern Data Stack in a box!
24.
by 1egg0myegg0 4y ago
Thank you for filing a bug, we will have a look at that I'm sure!
25.
by 1egg0myegg0 4y ago
You can think of the attach operation as creating views in DuckDB with Postgres tables underneath! DuckDB will then query those Postgres rows (using the typical Postgres wire protocol, except in binary mode). No data is persisted in DuckDB
26.
by 1egg0myegg0 4y ago
Yes, DuckDB supports writing lists and structs to Parquet! https://github.com/duckdb/duckdb/pull/2832 Does that help or do you have any other questions?
27.
by 1egg0myegg0 4y ago
You can use the DuckDB FDW (linked in the blog post) for this! https://github.com/alitrack/duckdb_fdw
28.
by 1egg0myegg0 4y ago
We have one of those! :-) And yes it is fast! https://github.com/duckdblabs/sqlite_scanner
29.
by 1egg0myegg0 4y ago
Howdy! What are the rough edges when persisting to a server? What are the gaps relative to something like PouchDB?
30.
DuckDB 0.5.0: Larger than RAM Joins, Persistent Indexes, More Speed(github.com)
5 points by 1egg0myegg0 4y ago|1 comments

More ›