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 new With DuckDB Sql Tools demo info and gif to Visualizations section in docs #38

Closed RandomFractals closed 1 year ago

RandomFractals commented 1 year ago

Use our recently published DuckDB Sql Tools extension for VSCode IDE and demo creating DuckDB instance with CrimeReports table from 1.68GB local crimes.csv data file that contains detailed Chicago crime reports from 2001 through the end of November of 2022.

DuckDB Sql Tools ext.: https://github.com/RandomFractals/duckdb-sql-tools

RandomFractals commented 1 year ago

Demo gif imports large csv data:

create-chicago-crime-reports-duckdb

RandomFractals commented 1 year ago

Better create table gif showing number of records imported:

create-chicago-crime-reports-duckdb-table

RandomFractals commented 1 year ago

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