Home / Companies / Yugabyte / Blog / Post Details
Content Deep Dive

PostgreSQL How-to: SportsDB Running on a Distributed SQL Database

Blog post from Yugabyte

Post Details
Company
Date Published
Author
Jimmy Guerrero
Word Count
952
Language
English
Hacker News Points
-
Summary

** The SportsDB dataset is a sample dataset for sports data applications that can be used with PostgreSQL-compatible databases like YugabyteDB. It has over 100 tables and 80k rows of data, and has been ported to multiple platforms including MySQL, SQL Server, and PostgreSQL. To use the dataset on YugabyteDB, you need to download and install YugabyteDB, configure loopback addresses, create a 3-node cluster with a replication factor of 3, enter the YSQL shell, build the SportsDB database by downloading and installing the database scripts, and then explore the database by executing SQL queries. The SportsDB dataset can be used for exploring distributed SQL databases like YugabyteDB and PostgreSQL.