EPISODE 107 #meteor
Meteor Cloud Is a Full Service Hosting Solution for Meteor Apps
with Filipe Névola
EPISODE 106 #rails
CompanyCam Helps Contractors Document Their Job
with Chad Wilken
EPISODE 105 #flask
TinyPilotKVM Lets You Remote Control Your Server from Your Browser
with Michael Lynch
EPISODE 104 #rails
uscreen Is a Platform That Helps Content Creators Build a Business
with Nick Savrov
EPISODE 103 #rails
Great Question Makes It Easy for Teams to Perform Customer Research
with PJ Murray
EPISODE 102 #rails
Robot Accounts AI Provides a System to Let You Categorize Invoices
with Josh Kinabrew
EPISODE 101 #rails
Fundraze Is a Flexible Fund Raising and Campaign Management Service
with CJ Avilla
EPISODE 100 #jekyll
Running in Production Is a Podcast Where Devs Chat about Tech Stacks
with Nick Janetakis
EPISODE 099 #rails
A Custom Electronic Medical Record System for an Ophthalmology Clinic
with Jason Swett
EPISODE 098 #rails
Games Directory Lets You Sync Your Games and Achievements in 1 Place
with Vlad Radulescu
EPISODE 097 #rails
School Bus Hero Helps School Bus Drivers and Aides Find a Job
with Dieter Lunn
EPISODE 096 #rails
Hitobito Helps You Manage Communities with Complex Group Hierarchies
with Matthias Viehweger
EPISODE 095 #koa
Submotion Helps You Manage Access Control for Your SAAS Subscriptions
with Kristian Dupont
EPISODE 094 #django
HorseRecords Lets You Record Everything about Your Horses
with Andy Ide
EPISODE 093 #rails
Politico Europe Is a Business to Business News and Data Service
with Karl Roos
EPISODE 092 #akka
Couchmate Is a Social Chat Platform for Viewers of Live TV
with Matt Oliver
EPISODE 091 #ansible
Managing 40+ Servers in a Data Center at a Medical University
with Maciej Delmanowski
EPISODE 090 #rails
Avo Is a Framework for Creating Ruby on Rails Admin Panels
with Adrian Marin
EPISODE 089 #express
Optidash Is an Image Processing and Optimization API
with Przemek Matylla
EPISODE 088 #fastapi
CourseMaker Is an Online Course Builder for Technical Makers
with Chris Samiullah
EPISODE 087 #phoenix
Statuspal Is a Service for Hosted Status Pages and Monitoring
with Eduardo Messuti
EPISODE 086 #node
QA Wolf Helps You Create Automated Browser Tests as You Use Your Site
with Jon Perl
EPISODE 085 #rails
ListenAddict Lets You Subscribe to a Person Like You Would to a Show
with David Parker
EPISODE 084 #phoenix
PriceTable Mixes in Sales Automation, Project Management and Invoicing
with Ege Ersoz
EPISODE 083 #express
SongRender Lets You Create Audio Visualizer Videos from Audio Clips
with Jake Lazaroff
EPISODE 082 #pylons
Dropbox Gives You Secure Access to All of Your Files
with Utsav Shah
EPISODE 081 #jupyter
Mito Is a JupyterLab Extension to Make Python Data Analysis Easy
with Nate Rush
EPISODE 080 #laravel
10Web Is an Automated WordPress Hosting Platform
with Tigran Nazaryan
EPISODE 079 #golang
NanoVMs Let You Run Your Apps Faster and Safer with Unikernels
with Ian Eyberg
EPISODE 078 #flask
AbstractCRE Helps Extract Key Data from Real Estate Property Documents
with Cole Simmons
EPISODE 077 #rails
Podia Has Everything You Need to Sell Online Courses
with Jason Charnes
EPISODE 076 #django
Building an Internal App to Track 1,200+ VMs and Servers at REI
with Sean Callaway
EPISODE 075 #django
Password Space Is a Password Manager for Families
with Nick Hnatiw
EPISODE 074 #laravel
Pod Hunt Helps You Find Great Podcast Episodes to Listen To
with Mubashar Iqbal
EPISODE 073 #django
Joyful Gifts Is an Automated Gift Giving Service
with Jonathan Adly
EPISODE 072
This Episode Was Removed Because It's under Review
with Anders Hovmöller
EPISODE 071 #rails
DNSimple Is a Simple and Secure Domain Management Service
with Anthony Eden
EPISODE 070 #django
Buttondown Lets You Build, Grow and Launch Your Email Newsletter
with Justin Duke
EPISODE 069 #django
An Internal Financial Planning Service for Season Ticket Holders
with Denis Stepanenko
EPISODE 068 #phoenix
TextDB Is a Simple Way to Share Small Amounts of Data
with Ian Davidson
EPISODE 067 #django
Muze Is a Freeform iOS Chat Application
with Dash Winterson
EPISODE 066 #flask
MixedCRM Is a Sales and CRM Tool for Real Estate Property Developers
with Nidal Alhariri
EPISODE 065 #django
CareerVillage Is a Community Where Students Can Get Career Advice
with Jared Chung
EPISODE 064 #phoenix
Stacker Is an Internal Tool to Stitch Together Microservices Responses
with Sascha Wolf
EPISODE 063 #phoenix
Changelog.com Is a News and Podcast Platform for Developers
with Jerod Santo & Gerhard Lazu
EPISODE 062 #express
Browserless Gives You Fast, Scalable and Reliable Browser Automation
with Joel Griffith
EPISODE 061 #phoenix
Monitor Oban Jobs in Real Time with Oban Web Pro
with Parker Selbert
EPISODE 060 #flask
Fantasy Football Data Pros Teaches You Python through Fantasy Football
with Ben Dominguez
EPISODE 059 #django
Creative Hire Helps Match Designers and Companies to Various Jobs
with Kshitij Sinha
EPISODE 058 #django
Brightpath Is a Formative School Assessment Tool
with Kye Russell
EPISODE 057 #django
Crowdbotics Is a React Native + Django App Builder / Deployer
with Anand Kulkarni
EPISODE 056 #django
Divio Is a Cloud Platform for Managing Web Applications
with Daniele Procida
EPISODE 055 #django
Daughterly Care Is a CRM to Help Care for the Elderly
with Barton Ip
EPISODE 054 #django
Paparazzi Accessories Is an E-commerce Store That Sells Jewelry
with Dan Purcell
EPISODE 053 #django
An Inventory Management System for an E-commerce Platform
with Galen Rice
EPISODE 052 #express
A Video Course Platform Built for a Course Called Modern DevTools
with Umar Hansa
EPISODE 051 #django
An E-commerce Site That Lets Folks Buy Online Courses
with Dalton Polhill
EPISODE 050 #django
Tracking Games Played on a Flight Simulator
with Paul Cappaert
EPISODE 049 #django
Collecting and Processing Genomic Data to Help Cure Rare Diseases
with Dan Kolbman
EPISODE 048 #django
Social Hiring Platform for the Food and Beverage Industry
with Colin McFaul
EPISODE 047 #django
A Platform to Buy Gift Cards for Eco-Friendly Products
with Antonin Grêlé
EPISODE 046 #flask
Custom Hardware to Provide Affordable Email to the African Congo
with Clemens Wolff & Shaun Bathgate
EPISODE 045 #django
Skillwell Is a Video Platform That Helps You Unlock Physical Skills
with John Debs
EPISODE 044 #django
An Internal Employee Management App Focused on Schools
with Chris Goodwin
EPISODE 043 #django
DataWellness Helps Organizations Stay Safe and Compliant
with Dave Merwin
EPISODE 042 #golang
Creating a Video Course Hosting Platform to Learn Go
with Jon Calhoun
EPISODE 041 #django
Litt NYC Lets You Easily Find Friends and Things to Do
with Harry Moreno
EPISODE 040 #django
A Site to View 3D Scans of Cars with Twinner
with Jesse Hunt
EPISODE 039 #django
Place Card Me Lets You Create Printable Place Cards Online
with Cory Zue
EPISODE 038 #django
The CMS Front End for Lionel Trains' Products
with Mark Miscavage
EPISODE 037 #django
A Real Estate Order and Appraisal System for a Small Business
with Austin Lewis
EPISODE 036 #django
Passiv Is a Portfolio Management and Automation Platform
with Brendan Wood
EPISODE 035 #static-site
Determine What Your Toilet Paper Supply Is Based on Your Usage
with Ben Sassoon
EPISODE 034 #django
Confectionery Connect Is an E-commerce Video Course Marketplace
with Sean Parsons
EPISODE 033 #django
Zego Lets You Easily Buy Insurance by the Hour
with Stuart Kelly
EPISODE 032 #django
Building a Site Around Thousands of Diary Entries from Samuel Pepys
with Phil Gyford
EPISODE 031 #phoenix
Mux Is an API Based Platform That Lets You Process and Stream Videos
with Dylan Jhaveri
EPISODE 030 #flask
TradeRev Is a Machine Learning Vehicle Appraisal / Auctioning System
with Amit Jain
EPISODE 029 #flask
Cover Tuner Uses NLP to Help Improve Your Cover Letters
with Saad Malik
EPISODE 028 #dotnet
Easily Find, Reproduce and Track Your JavaScript Errors with TrackJS
with Todd Gardner
EPISODE 027 #python
A College Professor Self Hosts Jupyter Hub for His Students
with Peter Kazarinoff
EPISODE 026 #flask
Contextualise Is a Tool That Lets You Easily Organize Information
with Brett Kromkamp
EPISODE 025 #flask
A Cryptocurrency Powered E-commerce Store Called Strmline
with Ty Cooper
EPISODE 024 #rails
CovidNearMe Tracks Cases and Has Info for Citizens / Health Workers
with Scott Johnson
EPISODE 023 #flask
Taleas Is a Cute, Quirky, Random and Slightly Weird Webcomic
with Seth Black
EPISODE 022 #flask
Creating a Non-profit Food Ordering Service for Inner City Kids In LA
with Francisco Barcena
EPISODE 021 #phoenix
Get to Know Your Coworkers through Simple QA with This Slack App
with Adam Conrad
EPISODE 020 #flask
A Weather Analysis Service for Regular People and Meteorologists
with Nick Gregory
EPISODE 019 #phoenix
Hex.pm Is Elixir's Official Package Manager
with Eric Meadows-Jönsson
EPISODE 018 #phoenix
6DOS Helps You Explore Your Personal Network
with Henry Popp
EPISODE 017 #rails
Smart Music Helps Musicians Practice More Efficiently
with Julien Blanchard
EPISODE 016 #rails
VA.gov Provides an API to Get Information about Veterans
with Charley Stran
EPISODE 015 #express
Kernl.us Helps WordPress Plugin and Theme Developers Manage Updates
with Jack Slingerland
EPISODE 014 #phoenix
ScrollKeeper Is a Collaboration Tool for Researchers
with Ian Butler
EPISODE 013 #phoenix
Remote.com Helps You Find Remote Jobs Anywhere
with Marcelo Lebre
EPISODE 012 #rails
Learn Ruby on Rails through Screencast Tutorials on GoRails
with Chris Oliver
EPISODE 011 #phoenix
Logflare Is a Log Management and Event Analytics Platform
with Chase Granberry
EPISODE 010 #flask
ScholarPack Runs 10% of the UK's Primary Schools and Gets Huge Traffic
with Gareth Thomas
EPISODE 009 #golang
Load Balance, Secure and Observe Your Web Applications with Nova ADC
with Dave Blakey
EPISODE 008 #koa
Openship Is a Shopify App for Drop Shipping and Order Fulfillment
with Junaid Kabani
EPISODE 007 #dotnet-core
Discworld Disorganizer Is a Discworld Book Series Search Engine
with Jamie Taylor
EPISODE 006 #golang
Qvault Is an Open Source Tool to Manage Passwords and Crypto Keys
with Lane Wagner
EPISODE 005 #flask
EarlyBrd Alerts You of New Job Board Postings So You Can Bid Faster
with Stetson Blake
EPISODE 004 #django
Real Python Is One of the Largest Python Learning Platforms Around
with Dan Bader
EPISODE 003 #phoenix
Learn Elixir and Phoenix by Building Things Over at Alchemist Camp
with Mark
EPISODE 002 #rails
A Video Based AWS Certificate Training Platform Called Exam Pro
with Andrew Brown
EPISODE 001 #phoenix
Serving Medical University Employees, Health Officials and Students
with Gabriel "OvermindDL1" Robertson
EPISODE 000
Preview of What's to Come
Are you running a site in production? I'd love to hear your story, become a guest.
Contextualise Is a Tool That Lets You Easily Organize Information
Brett Kromkamp
https://contextualise.dev/
In this episode of Running in Production, Brett Kromkamp talks about building an open source knowledge management tool with Flask and Python. It’s running on a single $10 / month Linode server and has been up and running since February 2020. It already has 200+ users.
Brett goes over how a graph database model fits perfectly for modeling knowledge, an open source Topic map library he wrote in Python, the power and simplicity of Flask, the value of keeping an eye on your external dependencies and a whole lot more.
Topics Include
- 1:37 – Contextualise is a side project that scratches Brett’s own itch
- 3:01 – It uses a Topic map which is a type of graph model to model a lot of things
- 3:56 – A Topic map is a perfect fit for modeling any type of knowledge
- 6:04 – You can visualize a graph model by thinking about having circles connected by lines
- 6:50 – Graph databases can help you naturally model very complicated relationships
- 10:15 – Topic maps very much align with how you likely think about modeling data in real life
- 12:15 – Brett used a Topic map to build a CMS back in ~2006
- 13:14 – The current Topic map engine Brett built for this project came about in ~2016
- 14:43 – Both Topic DB and Contextualise are open source on GitHub
- 15:46 – Motivation for choosing Flask over Pyramid and Django
- 21:07 – Contextualise has been up and running since February 2020
- 22:10 – Google Analytics is used for very basic traffic metrics, not personalized tracking
- 24:39 – Handling file uploads using the code supplied in Flask’s documentation
- 28:43 – When files are written to disk, they go into a specific directory
- 29:14 – The application uses server side rendered Jinja templates with a bit of JavaScript
- 32:13 – Drawing out the graph map using the vis.js charting library
- 34:15 – There’s a few more visualization features coming to Contextualise soon
- 36:25 – Motivation for choosing Gunicorn and nginx over other app / web servers
- 38:54 – Brett doesn’t use Docker, but folks have contributed Docker support in his project
- 40:36 – It’s hosted on Linode using Ubuntu 18.04 with PostgreSQL and nginx w/ Let’s Encrypt
- 41:10 – Topic DB is an abstraction on top of PostgreSQL, not a dedicated graph database
- 42:46 – Topic DB uses the Psycopg2 library to connect to PostgreSQL
- 43:12 – The biggest problem with Psycopg2 was getting it running on MacOS
- 45:09 – On Windows you can use WSL, but ideally Docker solves this problem all together
- 45:47 – Let’s Encrypt’s Certbot tool was used to configure SSL certificates
- 46:53 – Everything is running on a single server with 2 GB of memory, 1 CPU core a 50 GB SSD
- 48:15 – Hearing stories about deploying everything to a single server is great
- 49:19 – About 200 users are signed up with 80+ active weekly users, the server is fine
- 50:27 – Linode makes it easy to vertically scale up if needed
- 51:21 – The server was set up by hand while following a bunch of DigitalOcean guides
- 52:38 – You can restart Gunicorn in about 500 milliseconds when not using Docker
- 53:18 – Brett breaks down a custom Python script he uses to deploy things
- 55:23 – Besides handling SSL certificates, nginx also serves static files
- 56:10 – Dealing with secrets using an INI file that’s not commit to version control
- 57:53 – An environment file would be pretty similar
- 59:20 – Flask-Security-Too is used because the original Flask-Security was abandoned
- 59:20 – His app sends email out but he uses his ISP’s SMTP servers to send it
- 1:04:16 – Logging is done with Flask’s logger, along with periodic manual lookups for errors
- 1:05:43 – Nick chimes in with a way to get notified by email if a Flask error occurs
- 1:06:57 – Topic DB is well tested but the Flask app has no tests at the moment
- 1:07:55 – Backups are handled with Linode’s automated server backups
- 1:09:22 – Brett really likes Linode
- 1:11:07 – Linode has alarms you can set up to get notified if your server gets too busy
- 1:11:45 – There’s currently nothing hooked up to do a healthcheck on the site itself
- 1:12:40 – Best tips? Use tools you can be productive with & be mindful of your dependencies
- 1:15:57 – There’s only a handful of external dependencies in Contextualise
- 1:17:17 – 21 Python files and about 4,200 lines of code make up the Flask app
- 1:18:00 – The Topic DB project has 27 Python files with 3,000+ lines of code
- 1:18:49 – Python allows you to write fewer lines of code compared to some other languages
- 1:21:07 – You can find Brett on GitHub, Twitter and he has his own site too
Links
📄 References
- https://cerpus.com (the company Brett works for)
- https://en.wikipedia.org/wiki/Database_model#Graph_model
- https://en.wikipedia.org/wiki/Topic_map
- https://flask.palletsprojects.com/en/1.1.x/patterns/fileuploads/
- https://timeline.knightlab.com/
- https://www.digitalocean.com/community/tutorials/how-to-serve-flask-applications-with-gunicorn-and-nginx-on-ubuntu-18-04
- https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04
- https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-with-ufw-on-ubuntu-18-04
- https://www.digitalocean.com/community/tutorials/how-to-install-nginx-on-ubuntu-18-04
⚙️ Tech Stack
🛠 Libraries Used
- https://github.com/un33k/python-slugify
- https://visjs.org/
- https://gunicorn.org/
- https://www.psycopg.org/
- https://github.com/jwag956/flask-security
- https://github.com/sqlalchemy/sqlalchemy
Support the Show
This episode does not have a sponsor and this podcast is a labor of love. If you want to support the show, the best way to do it is to purchase one of my courses or suggest one to a friend.
- Dive into Docker is a video course that takes you from not knowing what Docker is to being able to confidently use Docker and Docker Compose for your own apps. Long gone are the days of "but it works on my machine!". A bunch of follow along labs are included.
- Build a SAAS App with Flask is a video course where we build a real world SAAS app that accepts payments, has a custom admin, includes high test coverage and goes over how to implement and apply 50+ common web app features. There's over 20+ hours of video.
Questions
- Want to discuss this episode on Twitter? Tag @nickjanetakis or @brettkromkamp
Apr 13, 2020
✏️ Edit on GitHub