Category Archives: Postgres
Implementing Zip Code Proximity Functions in MySQL and PostgreSQL
On most retail and social networking websites (along with many others), you’ll have the capability to search for people, businesses, store locations, etc within a given distance of your location. This can be implemented in a number of ways both … Continue reading
Exploring Stored Procedures in MySQL and PostgreSQL
The PostgreSQL PL/pgSQL procedural language is well documented here and the MySQL Reference Manual is available here. The MySQL documentation is, in my opinion, lacking, however the MySQL Stored Procedure Forum helps a great deal in making up for the … 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