AWS

AWS burstable EC2 and CloudWatch metrics

By Franck Pachot . Your application workload is usually not constant and maybe not predictable. If you undersize the capacity, you will save money but in case of peak of activity you will have severe performance issues. Thus, you(…)

AWS DynamoDB -> S3 -> OCI Autonomous Database

By Franck Pachot . I contribute to multiple technologies communities. I’m an Oracle ACE Director for many years, and I also became an AWS Data Hero recently 🎉. I got asked(…)

Loading data from S3 to AWS RDS for PostgreSQL

AWS RDS for PostgreSQL comes with an extension that allows you to fetch data from AWS S3 and to write back data to AWS(…)

PostgreSQL in AWS: clearing the doubts

By Franck Pachot . I’ve heard and read people saying that the PostgreSQL managed service is not the true open-source PostgreSQL from the community. This is wrong and I’m writing this post to clarify it. PostgreSQL on EC2(…)

NoSQL and SQL: key-value access always scale

By Franck Pachot . I have written about some NoSQL myths in previous posts (here and here) and I got some feedback from people mentioning that the test case was on(…)

Getting started with Exasol – Distribution keys

After the previous posts about Exasol, which have been more around installation, administration, backup & restore, loading data and general notes around transactions and sessions we'll now go into more details how Exasol manages data. Here is the list of(…)

Getting started with Exasol – A multi node cluster in AWS

As of now, all the previous posts worked with the Community Edition of Exasol. While that is great for getting started quickly (the Community Edition comes with all the features, except multi node support and a(…)

Amazon Aurora Serverless (PostgreSQL compatibility)

By Franck Pachot . I’ve written a blog post about serverless databases and here is an example of Amazon RDS Aurora PostgreSQL in serverless mode: When I’ve created the instance (15:55 –(…)

Amazon or AWS services?

By Franck Pachot . When I'm writing about a product I like to be precise about the name, the upper and lower case, and even more: do you know that was taking special care of writing Oracle 12cR2 before then(…)

What is Object Storage?

By Franck Pachot . I’ve always been working with databases. Before the cloud era, the most abstract term was “data”. A variable in memory is data. A file is data. A block of disk contains data.