4 ms·

Do you plan to write more about the migration, like a blog post? That would be very interesting to read.

unixhero 9y ago
This needs to become a thing. Where people produce writeups on Oracle To Postgres, and how much better it is; under something like #RunsMuchBetterWithPostgres ... It is strange that there aren't more writeups on Postgresql migrations. Yandex had a good one. Posted here a long while ago: https://news.ycombinator.com/item?id=12489055 https://news.ycombinator.com/item?id=12489055
- sharninder 9y ago
  Another one here: https://www.youtube.com/watch?v=qyc5ohv0RLY https://www.youtube.com/watch?v=qyc5ohv0RLY
- KingMob 9y ago
  > It is strange that there aren't more writeups on Postgresql migrations. It's probably because switching databases is very painful and rare.
  - unixhero 9y ago
    I would think that not having to pay the Oracle/MS/Sybase/Teradata licenses are a good enough incentive... Speaking of economic incentives. That could be a thesis topic for my hereto unwritten PhD in Behavioral Economics: "Choosing to pay" What are the behavioral aspects of top leadership - Why do people still chose proprietary" A quantitative case study."
    - Ygg2 9y ago
      If I had to wager, it's support. Oracle/MS generally provide much better support that open source software.
      - jeltz 9y ago
        Oracle is definitely not known for their good support, and there are plenty of companies which provide really good PostgreSQL support.
  - irrational 9y ago
    This. It was worth it, but it still took us the better part of a year.
thorin 9y ago
I'd be very interested in this after years of working with Oracle (and SQLServer), I know a little Postgres and would like to learn more.
irrational 9y ago
It would take a lot more than a single blog post. It would probably take dozens of blog posts (or a book). It took us the better part of a year. There are just so many things that have to be taken into consideration and learned.
gigatexal 9y ago
+1 to this.

This needs to become a thing. Where people produce writeups on Oracle To Postgres, and how much better it is; under something like #RunsMuchBetterWithPostgres ... It is strange that there aren't more writeups on Postgresql migrations. Yandex had a good one. Posted here a long while ago: https://news.ycombinator.com/item?id=12489055 https://news.ycombinator.com/item?id=12489055

sharninder 9y ago
Another one here: https://www.youtube.com/watch?v=qyc5ohv0RLY https://www.youtube.com/watch?v=qyc5ohv0RLY
KingMob 9y ago
> It is strange that there aren't more writeups on Postgresql migrations. It's probably because switching databases is very painful and rare.
- unixhero 9y ago
  I would think that not having to pay the Oracle/MS/Sybase/Teradata licenses are a good enough incentive... Speaking of economic incentives. That could be a thesis topic for my hereto unwritten PhD in Behavioral Economics: "Choosing to pay" What are the behavioral aspects of top leadership - Why do people still chose proprietary" A quantitative case study."
  - Ygg2 9y ago
    If I had to wager, it's support. Oracle/MS generally provide much better support that open source software.
    - jeltz 9y ago
      Oracle is definitely not known for their good support, and there are plenty of companies which provide really good PostgreSQL support.
- irrational 9y ago
  This. It was worth it, but it still took us the better part of a year.

thorin 9y ago

I'd be very interested in this after years of working with Oracle (and SQLServer), I know a little Postgres and would like to learn more.

irrational 9y ago

It would take a lot more than a single blog post. It would probably take dozens of blog posts (or a book). It took us the better part of a year. There are just so many things that have to be taken into consideration and learned.

gigatexal 9y ago

+1 to this.