{"id":1,"date":"2021-11-27T18:59:33","date_gmt":"2021-11-27T18:59:33","guid":{"rendered":"http:\/\/localhost\/wordpress\/?p=1"},"modified":"2023-05-03T21:57:38","modified_gmt":"2023-05-03T21:57:38","slug":"hello-world","status":"publish","type":"post","link":"http:\/\/localhost\/wordpress\/2021\/11\/27\/hello-world\/","title":{"rendered":"Did you just say Babefish?"},"content":{"rendered":"\n

Yes. Babelfish. Nothing fishy about it. An open-source tool supported by Amazon to ease your integration between legacy applications and Aurora PostgreSQL. Let’s conquer the field of database migration and why Babelfish is our greatest companion in those adventures.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\n\n\n\n

<\/p>\n\n\n\n

In our life of databases we are running with a large choices of databases, MS SQL,
MongoDB, GraphQL and much more. Making that decision is tough, but an even tougher decision
may be to migrate your database to the cloud. So you went with Aurora on AWS. Aurora is an awesome high-performance scalable relational database.<\/a> But it does only support MySQL and PostgreSQL. A bit less than you might have thought. Now you might be up for a challenge as your existing application are integrating to an MS SQL database. Amazon have great guides on how this can be handled through AWS Database Migration Service<\/a>. I will not cover this here as im sure you will overcome that challenge.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Now that you have migrated all that is left is to modify any existing integration to that data going from your application. When I say integration it is not only the endpoint to what database we talk to. We need to rewrite ALL of our queries to fit into that. You are spending weeks to rewrite all your SQL-queries in configuration files and code, performing integration tests, debugging and all you wanted was a new toy in the cloud.<\/p>\n","protected":false},"excerpt":{"rendered":"

Yes. Babelfish. Nothing fishy about it. An open-source tool supported by Amazon to ease your integration between legacy applications and Aurora PostgreSQL. Let’s conquer the field of database migration and why Babelfish is our greatest companion in those adventures. In our life of databases we are running with a large choices of databases, MS SQL,MongoDB,… Read More »Did you just say Babefish?<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":474,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"_ti_tpc_template_sync":false,"_ti_tpc_template_id":""},"categories":[5],"tags":[3,4],"_links":{"self":[{"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/posts\/1"}],"collection":[{"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":5,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":30,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/posts\/1\/revisions\/30"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/media\/474"}],"wp:attachment":[{"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/localhost\/wordpress\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}