VirtualTam's bookmarks

1. Analyzing 1.1 Billion NYC Taxi and Uber Trips, with a Vengeance 2022-09-22

   tags: database/clickhouse, database/postgresql, dataset, programming/apache-parquet, programming/r

   [ permalink ]

   An open-source exploration of the city's neighborhoods, nightlife, airport traffic, and more, through the lens of publicly available taxi and Uber data

   • https://github.com/toddwschneider/nyc-taxi-data
   • https://tech.marksblogg.com/billion-nyc-taxi-rides-redshift.html
   • https://tech.marksblogg.com/all-billion-nyc-taxi-rides-redshift.html
   • https://tech.marksblogg.com/billion-taxi-rides-doublecloud-clickhouse.html
2. ClickHouse — open source distributed column-oriented DBMS 2018-09-24

   tags: database, distributed, performance, programming/sql

   [ permalink ]

   • https://github.com/yandex/ClickHouse
   • https://www.percona.com/blog/2017/02/13/clickhouse-new-opensource-columnar-database/
   • https://www.percona.com/blog/2017/03/17/column-store-database-benchmarks-mariadb-columnstore-vs-clickhouse-vs-apache-spark/
   • https://www.reddit.com/r/programming/comments/4o7dhc/clickhouse_highperformance_opensource_distributed/
   • https://github.com/roistat/go-clickhouse
   • https://blog.sentry.io/2019/05/16/introducing-snuba-sentrys-new-search-infrastructure