Viewing profile — mytherin

I agree that the blog post seems to hint at the fact that this functionality is fully baked in in certain places - we've adjusted the blog post to be more explicit on the fact that…

One of the DuckDB maintainers here. To clarify - the UI is not built into the DuckDB release. It is an extension that is downloaded and installed like any other extension. This ext…

You can query the metadata of a Parquet file using DuckDB's parquet_schema and parquet_metadata functions [1] [1] https://duckdb.org/docs/data/parquet/metadata

Thanks for trying it out! Could you perhaps open an issue [1] or share the file with us so we could investigate the problem? [1] https://github.com/duckdb/duckdb/issues

Perhaps have a look at this article [1] [1] https://www.vantage.sh/blog/querying-aws-cost-data-duckdb

Feature were stripped from Google Image Search because of a lawsuit [1]. Yandex, Bing and others can offer a better image search because they are not big/important enough to sue in…

We (the DuckDB team) are very happy working together with MotherDuck in a close partnership [1]. [1] https://duckdblabs.com/news/2022/11/15/motherduck-partnershi...

Again, you are still conflating tables in a relational database with variables in Typescript. While I can understand the confusion - given that SQL makes it so natural to interact …

> Same goes for SQL. Given the previous program, it is impossible to determine what the type of v is until you are ready to execute the SELECT statement. If the CREATE TABLE statem…

Types are static within the context of a query, not necessarily within the context of the lifetime of a database. Types are determined and propagated at query compile time . In a q…

Most implementations of SQL are not dynamically typed - they are statically typed. There is an explicit compilation phase (`PREPARE`) that compiles the entire plan and handles any …

C/C++ code can certainly be compiled down to WASM, but you cannot interface with the operating system as you would in a normal C/C++ program. To get around that restriction postgre…

Because DuckDB uses ACID [1] data is loaded in an all-or-nothing manner. As the load was interrupted due to the system running out of memory, the table is expected to be empty. [1]…

CREATE INDEX currently has the restriction that the index must fit in memory [1]. As the data is already sorted, creating an index is not necessary anyway. The min/max indexes crea…

It is possible to JIT compile Python just fine. There are projects like PyPy that have been doing this for a long time [1]. The reason these alternative projects never take off is …

As a Dutch person hearing people talk about mandatory helmet laws for bikes sounds very strange. Nobody in the Netherlands bikes with a helmet, and it is incredibly safe to bike he…

> I’ve never been in a car accident that required a seat belt either. We should remove them all by your logic. Having a seat belt in a car is far less of an inconvenience than carr…

While I can (unfortunately) see this happening - it seems incredibly futile and pointless to try and fight such an arms race. When AI-supported writing becomes the norm having stud…

Perhaps I am missing something in the spec - but trying this in various compilers, it seems that you *can* assign structs holding arrays to one another, but you *cannot* assign arr…

If your employer expects you to work 50 or 60 hours while only paying you for 40 hours then that is indeed also illegal.

If you are charging two companies for 40 hours per week of work, while only working 20 hours per week for each of them, then that is fraud by any reasonable definition of the word.…

You may also want to have a look at the DuckDB command line client [1]. The shell itself is based on the SQLite client, and DuckDB can be used to natively query CSV and Parquet fil…

The hardest part about optimizing Python is the fact that there are so many packages out there relying on every single documented and undocumented aspect of the C/C++ interface, wh…

We have a PR in the works that is adding support for sum types to DuckDB [1]. Not quite fully dynamic, but perhaps still useful :) [1] https://github.com/duckdb/duckdb/pull/4966

Postgres uses a similar custom implementation of try/catch [1]. [1] https://github.com/postgres/postgres/blob/master/src/include...