Setup Your own Postgres Database and Analytics Playground
Learn how to analyze play store apps data in Postgres by running your own Analytics playground with Docker
postgresql
Playstore Apps Data Analysis with SQL (free SQL ebook included)
Set up your own Postgres database and Analytics playground. Learn end-to-end SQL Analytics with our 30+ questions on the Playstore apps dataset.
Postgres text similarity with commoncrawl domains
Commoncrawl [https://commoncrawl.org/] is a public repository of web crawl data
made available for analysis. In this post I want to extract the list of domains
crawled, stick them into a Postgres database and play with text similarity
functions provided by pg_similarity extension.
The basic steps to be
Learn SQL in a browser with PostgreSQL and pgweb
PostgreSQL is a very versatile database. If you want to learn SQL, then a quick
way to start is to 1) grab some data you want to analyze 2) insert into a
PostgreSQL table and 3) use a SQL client such as pgweb and get started analyzing
data. You can
