hfmuehleisen's comments

On: DuckDB 0.7.0

[hfmuehleisen]

Yes we are working on it

[krishadi → hfmuehleisen]

Is there a roadmap on handling geographic data?

[maxxen → krishadi]

Yes! I'm working hard on it, I've been distracted with other work for some of our clients but hopefully have something to show soon.

On: Friendlier SQL with DuckDB

[hfmuehleisen]

It does, DuckDB supports recursive CTEs

On: Parallel Grouped Aggregation in DuckDB

[hfmuehleisen]

DuckDB also works fine with R data frames so there is really no downside to using R in this case

On: DuckDB quacks Arrow: A zero-copy data integration ...

[hfmuehleisen]

DuckDB has its own Parquet reader

On: Hosting SQLite databases on GitHub Pages or any st...

[hfmuehleisen]

DuckDB can directly & selectively query Parquet files over HTTP/S3 as well. See here for examples: https://github.com/duckdb/duckdb/blob/6c7c9805fdf1604039ebed...

On: What's New in SQLite 3.35

[hfmuehleisen]

One of the DuckDB authors here. Can you open an issue wrt the import problem? Should not happen. Try setting a database file and a memory limit.

On: DuckDB – An embeddable SQL database like SQLite, b...

[hfmuehleisen]

Yes, DuckDB has strict typing.

On: DuckDB – An embeddable SQL database like SQLite, b...

[hfmuehleisen]

One of the DuckDB authors here. The answer is yes, but only in read-only mode at the same time.

[davidgaleano → hfmuehleisen]

What about one single client writing and multiple clients in read-only mode? Any problems with storing the file on network storage? Basically, how far can you push it before it is better to just use PostgreSQL?

On: DuckDB – An embeddable SQL database like SQLite, b...

[hfmuehleisen]

Another DuckDB developer here, we support reading table data from Parquet files directly.

On: DuckDB: SQLite for Analytics

[hfmuehleisen]

Hi, one of the authors of DuckDB here.

ad 1) An index is an additional data structure that takes space and needs maintenance when the data changes. This is especially problematic for realtime data. DuckDBs main data structure and implementation is designed for efficient scanning without needing an additional index ("vectorised columnar").

ad 2) We support STDDEV_SAMP and STDDEV_POP. There is also an interface to define your own functions. We are very aware of how SQLite is doing things and even support their client API. But we also might eventually add their way of adding UDFs from Python.