Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Querying Parquet with Precision Using DuckDB. Parent comment
Some more notes that might be of use:
* We also have a command line interface (with syntax highlighting) [1]
* You can use .df() instead of .fetchall() to retrieve the results as a Pandas DataFrame. This is faster for larger result sets.
* You can also use DuckDB to run SQL on Pandas DataFrames directly [2]
[1] https://duckdb.org/docs/installation/
[2] https://duckdb.org/2021/05/14/sql-on-pandas.html
Some more notes that might be of use:
* We also have a command line interface (with syntax highlighting) [1]
* You can use .df() instead of .fetchall() to retrieve the results as a Pandas DataFrame. This is faster for larger result sets.
* You can also use DuckDB to run SQL on Pandas DataFrames directly [2]
[1] https://duckdb.org/docs/installation/
[2] https://duckdb.org/2021/05/14/sql-on-pandas.html