How to Install DBeaver + DuckDB (SQL Playground)
In this video, I show how to quickly set up a SQL environment using DBeaver and DuckDB. This lightweight setup is perfect for practicing SQL queries. In the next video, we’ll use this environment to explore important SQL tricks.
Test script:
CREATE TABLE customers AS
SELECT
i AS customer_id,
'Customer_' || i AS name,
['Kigali','Nairobi','Lagos','Accra'][CAST(floor(random()*4)+1 AS INT)] AS city,
DATE '2024-01-01' + (random()*365)::INT AS signup_date
FROM range(200) t(i);