AWS

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(…)

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(…)

Amazon DynamoDB: the cost of indexes

By Franck Pachot . That’s common to any data structure, whether it is RDBMS or NoSQL, indexes are good to accelerate reads but slow the writes. This post explains the consequences of adding indexes in DynamoDB. Secondary Indexes What(…)

Amazon DynamoDB Local: running NoSQL on SQLite

By Franck Pachot . DynamoDB is a cloud-native, managed, key-value proprietary database designed by AWS to handle massive throughput for large volume and high concurrency with a simple API. simple API: Get, Put, Query, Scan on a table without(…)

RDBMS (vs. NoSQL) scales the algorithm before the hardware

By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access,(…)