I was researching simple methods for backing up a basic Linux web server, and I found an excellent script that handles files and databases, and also dumps everything to a remote server. I was looking for something a bit less complicated and overkill than Bacula, but more comprehensive than simply archiving the filesystem, and this [...]
No Comments »
Filed under: Apache, Linux, MySQL, PostgreSQL
I have some basic Django code that attempts to insert a new record into a PostgreSQL database. It’s wrapped in a try/except statement in case a unique constraint is violated, in which case I’ll typically ignore it and move on.
So the general pattern is:
from django.db import IntegrityError
import models
try:
myNewRecord = models.MyTable(data=blah)
[...]
3 Comments »
Filed under: Django, MySQL, PostgreSQL
I’ve been using MySQL for a while with my pet projects, but recently I’ve been writing some more complicated queries, and I’m running into a few obnoxious limitations, mostly involving known view performance problems. I’ve decided to start testing the waters in PostgreSQL, so I tried importing my data into PG by running a MySQL-generated [...]
4 Comments »
Filed under: PostgreSQL