# Aurora Serverless - a migration story

DevFeed: [Aurora Serverless - a migration story](<https://devfeed.tech/articles/aurora-serverless-a-migration-story-19957.md>)

Original publisher: [Read original article](<https://www.theguardian.com/info/2023/aug/16/serverless-postgres-at-the-guardian>)

Author: Philip McMahon

Published: 2023-08-16T08:46:04Z

Content type: article

Language: en

Sources: [Guardian](<https://devfeed.tech/sources/guardian.md>)

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [App](<https://devfeed.tech/topics/app.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [migration](<https://devfeed.tech/tags/migration.md>), [pitfalls](<https://devfeed.tech/tags/pitfalls.md>), [serverless](<https://devfeed.tech/tags/serverless.md>)

## AI overview

The Guardian describes its migration from MongoDB to PostgreSQL and its evaluation of AWS serverless relational databases for Lurch, an internal tool that searches public data sources. The article discusses database selection, read performance, full-text search, indexing, and challenges caused by ingesting large historical datasets.

## Source excerpt

On our team we swapped databases 6 times in a year. We've landed on Aurora Serverless V2 - was it worth it? Since our migration from Mongo to Postgres in 2018, at the Guardian the search for the perfect database hasn't stopped. In the last year on the Investigations and Reporting team we've spent a lot of time trying out AWS's Serverless relational databases. We hope that by sharing our learnings we'll help others avoid the pitfalls we hit along the way. Continue reading...