# OSCON, Portland, and PDXPUG

DevFeed: [OSCON, Portland, and PDXPUG](<https://devfeed.tech/articles/oscon-portland-and-pdxpug-34509.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/07/oscon-portland-and-pdxpug/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-07-29T15:09:00Z

Content type: opinion

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [sharding](<https://devfeed.tech/topics/sharding.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Perl](<https://devfeed.tech/topics/perl.md>), [Python](<https://devfeed.tech/topics/python.md>)

Tags: [databases](<https://devfeed.tech/tags/databases.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [perl](<https://devfeed.tech/tags/perl.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [sharding](<https://devfeed.tech/tags/sharding.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A personal report from OSCON and PDXPUG in Portland, describing a presentation about Fotolog's migration from a 37-database MySQL sharding cluster to PLProxy on PostgreSQL. It also discusses using PostgreSQL for application logic and middleware, including stored procedures implemented in languages such as PL/Python and PL/Perl.

## Source excerpt

After spending an awesome week in San Francisco, CA I'm lucky enough to be spending another week in the USA, in Portand, OR. The main excuse for showing up here has been OSCON where I presented a talk about the fotolog migration from MySQL to PostgreSQL. *[Mark Wong](http://markwkm.blogspot.com/) is doing some serious database crochet work!* Fotolog is a photo sharing website having more than 32 millions of users sharing more than a billion of photos, which made for a very interesting migration use case. In particular switching from a hand-made MySQL sharding cluster of 37 databases to a fully integrated PLProxy setup on 16 servers hosting each 16 shards, in less than 6 months including complete code rewrite, made things... interesting.