RandomFractals / chicago-crimes

Exploring Chicago crimes dataset with Jupyter notebooks, DuckDB, Malloy and new Panel/PyScript data and dashboard tools.
GNU Affero General Public License v3.0
38 stars 4 forks source link

Add DuckDB database and parquet data export/import demos to new DuckDB Sql Tools doc section #39

Closed RandomFractals closed 1 year ago

RandomFractals commented 1 year ago

see sql scripts added in #38

and use these demo gifs:

Database export:

export-chicago-crime-reports-duckdb

Parquet data export/import:

chicago-crime-reports-parquet-data-export-import

RandomFractals commented 1 year ago

See updated DuckDB Sql Tools demo section in docs: https://github.com/RandomFractals/chicago-crimes#with-duckdb-sql-tools