An Evening of Python Coding: CrateDB

This repository contains accompanying resources for my talk about CrateDB at the Austin, DC and Northern Virginia Python groups "An Evening of Python Coding" event on January 22nd 2025. You can watch the video of my presentation on YouTube.

Slides

The slides are included here in PDF format.

Get a Free CrateDB Cluster in the Cloud

To try these exercises out for yourself, you'll need a CrateDB cluster. The easiest way to get one is by signing up for a free cloud account at console.cratedb.cloud - no credit card or payment details required.

Jupyter Notebooks

Here are the Jupyter notebooks used in the session:

• Multi-Model Data.
• Search.

These notebooks connect to CrateDB using the SQLAlchemy dialect for CrateDB.

Wind Farms Example Project

The code for the wind farms example Flask project can be found here. This repository also contains a C# implementation.

This project uses the crate-python driver to talk to CrateDB.

MicroPython Examples

Here's the code for the MicroPython part of the demo. These examples use the CrateDB driver for MicroPython.

Datasets

Here are the datasets used in the session:

• City of Chicago open data.
• UK Offshore Wind Farm data.

CrateDB Academy

Want to learn more about CrateDB? Take our free online "CrateDB Fundamentals" course, available now at the CrateDB Academy.