Category: Databases

Grafana, InfluxDB and Python, simple sample

Grafana, InfluxDB and Python, simple sample

I recently came across an interesting contract position which uses Grafana and InfluxDB. I’d had a play with ElasticSearch before, and done some work with KairosDB, so was already familiar with time series and...

Namepy – on the shoulders of giants

Namepy – on the shoulders of giants

Whilst my core skill/tool is Python, I’m always learning new things, either inside or outside the Python ecosystem. I recently had the pleasure of working with Angular and Python/Flask. Here is a playful application...

Investment Tracking System – Django/Python

Investment Tracking System – Django/Python

My client, a start up with a lot of experience in their field, had identified an important gap in the market. Large sums of money were being invested, with very long payback periods, without...

Flask and Angular on Heroku

Flask and Angular on Heroku

I am working my way through this excellent tutorial, covering Python3, Flask, Angular, Heroku, SQLAlchemy, Alembic, requests, Beautiful Soup, NLTK, Redis and D3. Here are some extra notes To stop me from blindly copying/pasting...

Django Migrations

Django Migrations

Django has a great system for maintaining your database structure, for keeping your RDMS (typically MySQL, PostgreSQL or SQLite) in line with your Django-defined Models, and within your version control system. I recently hit...

Using PostgreSQL with Django

Using PostgreSQL with Django

Here is how go set up Django to work with PostgreSQL Install necessary libraries, etc sudo apt-get install libpq-dev sudo apt-get install python-dev sudo apt-get install postgresql-contrib Create a new database and user sudo...

Installing PostgreSQL

Installing PostgreSQL

PostgreSQL seems to be the most popular DBMS (database management system) with Django developers, although MySQL is also used a lot To install PostgreSQL, I used Linux Mint’s Software Manager (search for “postgresql”) I also...

Django – making changes to a model

Django – making changes to a model

Unless you get your model/database structure spot on first time, you’ll want to change it. Here is how to keep the database in line with your Django models Make a change to your model....