Is the new Raspberry Pi AI Kit better than Google Coral?
135561 Views
Build Your Own AI Assistant Part 1 - Creating the Assistant
121827 Views
Control Arduino with Python using Firmata / PyFirmata
88872 Views
How to Map with LiDAR - using a Raspberry Pi Zero 2W, RPLidar and Rviz
65602 Views
Creating a Supercomputer with a Raspberry Pi 5 Cluster and Docker Swarm!
60799 Views
Node-Red Automation, MQTT, NodeMCU & MicroPython
53953 Views
How to Keep your Raspberry Pi happy
How to Install Pi-Apps on a Raspberry Pi
Pikon II, The Ultimate DIY Raspberry Pi Camera!
Pico Plotter
LEGO Gets Lights & Sound with Tiny FX
Thinkman
DuckDB - Fast, free analytics
1h 36m
Obsidian
1h 0m
Getting Started with C on the Raspberry Pi Pico
0h 50m
Running K3s on Raspberry Pi
1h 28m
From Docker to Podman
1h 2m
MicroPython Robotics Projects with the Raspberry Pi Pico
0h 54m
Learn how to Program in Python, C, Rust, and more.
Learn Linux from the basics to advanced topics.
Learn how to use a Raspberry Pi Pico
Learn MicroPython the best language for MicroControllers
Learn Docker, the leading containerization platform. Docker is used to build, ship, and run applications in a consistent and reliable manner, making it a popular choice for DevOps and cloud-native development.
Learn how to build SMARS robots, starting with the 3D Printing the model, Designing SMARS and Programming SMARS
Learn how to build robots, starting with the basics, then move on to learning Python and MicroPython for microcontrollers, finally learn how to make things with Fusion 360.
Learn Python, the most popular programming language in the world. Python is used in many different areas, including Web Development, Data Science, Machine Learning, Robotics and more.
Learn how to create robots in 3D, using Fusion 360 and FreeCAD. The models can be printed out using a 3d printer and then assembled into a physical robot.
Learn how to create Databases in Python, with SQLite3 and Redis.
KevsRobots Learning Platform
28% Percent Complete
By Kevin McAleer, 2 Minutes
DuckDB runs as a single, embedded binary. Use the CLI for interactive SQL and the Python package for notebooks and scripts.
macOS (Homebrew):
brew install duckdb
Python (any OS):
python -m pip install --upgrade pip python -m pip install duckdb
Windows (CLI):
winget install DuckDB.cli
choco install duckdb
Linux (CLI):
apt install duckdb
CLI:
duckdb --version
Python:
import duckdb print(duckdb.__version__)
Start the shell and run a simple query:
duckdb
-- in the duckdb shell SELECT 1 AS ok;
Create a persistent database file and a table:
-- creates analytics.duckdb in the current folder .open analytics.duckdb CREATE TABLE events(id INTEGER, ts TIMESTAMP, type TEXT); INSERT INTO events VALUES (1, now(), 'start'); SELECT COUNT(*) AS rows FROM events;
Exit with .quit.
.quit
You try it (2 min) Start the CLI, run SELECT 42 AS answer; Create analytics.duckdb, then CREATE TABLE numbers AS SELECT * FROM range(5) AS x; SELECT COUNT(*) FROM numbers; and exit with .quit
You try it (2 min)
SELECT 42 AS answer;
analytics.duckdb
CREATE TABLE numbers AS SELECT * FROM range(5) AS x;
SELECT COUNT(*) FROM numbers;
import duckdb # Connect to an on-disk database (creates file if it doesn't exist) con = duckdb.connect("analytics.duckdb") con.execute("CREATE TABLE IF NOT EXISTS numbers AS SELECT * FROM range(10) AS x;") rows = con.execute("SELECT COUNT(*) FROM numbers").fetchone()[0] print({"rows": rows}) con.close()
You try it (2 min) Change range(10) to range(7) and print the new count Create a new table evens with only even values from numbers
range(10)
range(7)
evens
numbers
.duckdb
Troubleshooting? See Troubleshooting DuckDB for common fixes (exports folder, SSL, Python, S3).
< Previous Next >
You can use the arrows β β on your keyboard to navigate between lessons.
β β