Categories
Database

How to get data from tables in mysql database into a postgres schema?

I’ve had to do a bit of learning and tinkering to figure out how to do this. I now understand why ETL tools and consultants for data migrations and translations are in demand. I’ll even allow use of proprietary GUI based ETL tools. Anyway the backstory is I created a django project initially for MySQL […]

Categories
Database DevOps django

Deploying a django app with dedicated web and db servers

One of the many architectural decisions that will start to impact you when you get to a level where you need to scale is splitting you db and app. Typically we start on a budget and have to share resources but ideally you want to start out separate. The reasons is that the db server […]

Categories
django Multi-tenancy

Functional Tests with Django Tenant Schemas and Selenium

On my journey of adding multi-tenancy to my app, I have used django-tenant-schemas and the testing utilities it provides to make my unit tests work with the tenants or main site. However the functional tests is another kettle of fish as there is not utility to use for them. Functional Tests From the django docs […]

Categories
postgres

Postgres and Django Case Sensitivity

Postgres queries are CaSeSensitivE unlike in MySQL. When a simple Model.objects.get(field=’hello’) would get the record. Using a postgres db you would need to use field__iexact=’hello’ Even unique doesn’t work with different cases with standard postgres. That is why django has the CIText Mixin and postgres has the citext extension. Could be a feature not a […]

Categories
django

Converting a Single Serving Django Application into Saas

I built a time tracking, leave application and billing application with django, called crowdminder. The product was created in partnership with a consulting company, they paid me and I developed it for them while retaining co-ownership. I have seen that they have benefited from this simple application and know that many other consulting companies in […]