Discover exoplanets with PostgreSQL® sample data

In this post, Lorna Mitchell demonstrates how to populate an empty PostgreSQL database with data about exoplanets from the Kepler mission using Aiven's cloud platform. The process involves creating a new PostgreSQL service on Aiven, generating a table structure from a CSV file using ddlgenerator, and importing the CSV data into the newly created table. Once the data is imported, users can explore and analyze it using SQL queries or connect it to other tools for further analysis.