Free Online PostgreSQL 17 + PostGIS WorkShop (ReadOnly) Playground
Current database engine: PostgreSQL 17 + PostGIS WorkShop (ReadOnly) (psql17postgis)
A read-only PostgreSQL 17 (17.10) database with PostGIS 3.6 and the data of the PostGIS workshop: New York City census blocks (38,794), streets (19,091), subway stations (491), neighborhoods (129) and homicides, plus world countries (246) and capitals (192). The tables are in the postgis schema.
Practice spatial joins and functions such as ST_Intersects(), ST_Within(), ST_Area() and ST_Distance(): which neighborhood a station is in, the population near a street, the closest capital. To create your own spatial tables, use the PostgreSQL 17 + PostGIS playground.
NEW Now embed mode is available: put an interactive SQL editor on any web page with one script tag.
SQLize is a browser-based PostgreSQL 17 + PostGIS WorkShop (ReadOnly) SQL editor and query runner for fast testing, debugging, formatting, and sharing. It is useful for interview tasks, migration checks, analytics validation, and learning SQL in a real execution environment.
Developers, students and data analysts from more than 100 countries, most of all India, the United States, Russia, Brazil, Italy, Poland and Vietnam, use SQLize to run PostgreSQL 17 + PostGIS WorkShop (ReadOnly) queries online without installing a database server. A shareable link turns any query into a reproducible example for a colleague, a teacher or a question on Stack Overflow.