# The Most Popular Pub Names

DevFeed: [The Most Popular Pub Names](<https://devfeed.tech/articles/the-most-popular-pub-names-34515.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/08/the-most-popular-pub-names/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-08-02T08:19:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Open Data](<https://devfeed.tech/topics/open-data.md>), [XML](<https://devfeed.tech/topics/xml.md>), [Python](<https://devfeed.tech/topics/python.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [data](<https://devfeed.tech/tags/data.md>), [format](<https://devfeed.tech/tags/format.md>), [github](<https://devfeed.tech/tags/github.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This technical article compares a MongoDB approach for geographic queries on OpenStreetMap data with a PostgreSQL and SQL-based approach. It describes loading XML data into PostgreSQL, including streaming parsing, and explains how SQL can normalize the data and express complex queries.

## Source excerpt

In his article titled The Most Popular Pub Names Ross Lawley did show us how to perform some quite interesting geographic queries against MongoDB, using some nice Open Data found at the Open Street Map project.