Today I’ve been thinking about building a database to keep up with IP address assignments.  In a perfect world I’d have a nice database with a clever interface and would simply start entering data.  In my world I see commercial versions (and I have no budget) and open source versions (which really want Linux distributions, which I don’t really have).  So I’m considering building a database and then using Python and PyQT to build the interfaces.

Most of my limited database experience in recent years has been with MySQL.  Sadly for me, OS X has replaced MySQL with PostgreSQL – so which would be better?  Well, I don’t know yet.  But I have found a resource about PostgreSQL that should be remembered, which can be found here.  It appears that Apple probably moved to PostgreSQL in order to put some distance between themselves and Oracle, who bought the rights to MySQL some time ago.

It appears that Python includes support for PostgreSQL.  More information can be found here.

More research on this topic to come!