How to migrate certain Oracle Database features to the cloud?

The migration of Oracle tables, their data and also PL/SQL code to PostgreSQL is pretty straight forward. Tools help to automate most of the work. But what about features like UTL_FILE , UTL_MAIL, UTL_TCP, Job Control (DBMS_JOB) and Advanced Queueing (DBMS_AQ)? Especially when the migration target database is in the cloud, that can become a challenge.

AWS has the aws_lambda extension for its newer (currently managed) PostgreSQL databases. With Lambda, all relevant AWS resources like messaging can be integrated.

In a new Cloudrunnr demo, this is integration is shown based on a SAM (Serverless Application Model) template.



Comments

Post a Comment

Popular posts from this blog

Prototype for a Serverless Business Application

Image
 There are a lot of great tutorials out there on how to build applications based on AWS and in particular on Amplify. But I wanted to try out by myself how much effort it is, to build an application that is a bit closer to a real business desktop app meeting the following requirements: Serverless architecture Based on an RDBMS (relational database) Performing CRUD operations on entities Authentication and authorization Sound exception handling The result is an application serving currently one entity that can be queried and updated. Here's the architectural diagram: The question may be raised, if serverless and using Amplify , why not going NoSQL with DynamoDB? Here are some points that I find important: The majority of software projects is not greenfield. Complex relational data models exist with three digit numbers of tables, numerous (SQL based) use cases and interfaces that can hardly be migrated to a NoSQL data store For business applications in fields like ERP or financials, ...
Read more

Build a Secure Database Driven Web Application with Amplify and React: Part 1 - Setup

Image
In my recent post I have published a demo CRUD application utilizing React.js, AWS Amplify and PostgreSQL on Aurora. For everyone who did not want to sign up and take a look for any reason, here's a screenshot: In the next posts, I want to document how easy it is to build a secure serverless web application on top of Amplify using React as a frontend. AWS account AWS command line tools including amplify are installed and connected to the account Installed Node.js (version >=17) and React.js (version >=18.2) An IDE of choice like VS code Initialize the Project To set up the project, have a code editor ready and an terminal window with command prompt. First, we initialize the React application and give it a name like ardemo for Amplify-React Demo.      > npx create-react-app ardemo A directory with the project name will be created, we change to that and can run the intial React application right away:   > cd ardemo > npm start  By default, the node ...
Read more
Image
Time Flies - AWS Aurora serverless has grown up Maybe you remember my demo application leveraging AWS Aurora Serverless v1 on Postgres, using the built in data API and a React frontend. AWS has announced v1 deprecated a while ago and after a postponement, the end of v1 is likely coming by end of next month (March 2025). The AWS community was not so amazed about having to migrate to Aurora v2 as it lacked two important features:  Scaling down to zero which is important for low budget organizations or projects. The data API, providing a highly convenient way to communicate with an RDBMS without any hassle in drivers and connection pooling Now here's the good news: AWS has added both features to Aurora v2 in the meantime, and there is even more: The data API request limit of 1000 requests per second does was removed for v2 . Due to the improved architecture, up- and downscaling performs faster. In particular, scaling up from 0 (the wake up scenario) is faster and results in improved...
Read more