Data Analysis with Python
Python is a very popular tool for data extraction, clean up, analysis and visualisation. I’ve recently done some work in this area, and would love to do some more. I particularly enjoy using my...
Category: Databases
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 step 4 – PostgreSQL, SQLAlchemy and Flask-SQLAlchemy
(This is part of the namepy project. Start at Namepy – on the shoulders of giants) I’ve used PostgreSQL for a number of different projects. It is the database of choice for Django developers,...
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
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
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...
Administrate Project – Technical Project Manager
The client, a highly respected training company, was using an in-house developed system to manage the courses, bookings, delegates, and sales and marketing processes. When the business outgrew the system they asked me to...
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
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
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...
