Category Archives: Python
PostgreSQL Database Encryption
For last decade data breaches and data losses of Social Security numbers, credit card numbers, or one of a slew of other pieces of private information, have landed businesses on the front page of major newspapers, and in some instances … Continue reading
Importing XML into a database with Python and SQLAlchemy
Let’s begin by analyzing the XML we want to import into our database, it consists of a book’s ISBN, title, and author. <!– books.xml –> <catalog> <book isbn=”1-880985-26-8″> <title>The Consumer</title> <author>M. Gira</author> </book> <book isbn=”0-679775-43-9″> <title>The Wind-Up Bird Chronicle</title> <author>Haruki … Continue reading
Using Python to Load Binary Files into Postgres
Many times developers may find it desirable to store binary files within a database. For example, an online store may find it easier to store the pictures of their merchandise in the database along side the item description, quantity, price, … Continue reading