1 of 10

PyCob

SQL Snippets web app in 244 lines of Python

HOW TO BUILD A

sql-snippets.pycob.app

2 of 10

Agenda

  1. Use cases
  2. App demo
  3. Architecture
  4. Code

3 of 10

Use cases

Data analysts and scientists often need the same or similar versions of complex SQL queries to run against their database or data warehouse. These take a lot of time and effort to write, and writing them each time from scratch is inefficient.

SQL snippets allows data analysts, data scientists, and engineers to view, save and run SQL queries, and have a shared repository for the whole team.

4 of 10

LINK

5 of 10

LINK

6 of 10

7 of 10

LINK

8 of 10

Architecture

Data Model

Pages

9 of 10

Create code

LINK

10 of 10

Run code

LINK