BE SHARING

Search results for DynamoDB "secondary index" pachot

DynamoDB / Aurora: sparse and partial indexes

15.04.2021 by Cloud Team

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If(…)

AWS

DynamoDB Scan: the most efficient operation 😉

20.12.2020 by Open source Team

By Franck Pachot . The title is provocative on purpose because you can read in many places that you should avoid scans, and that Scan operations are less efficient than other operations in DynamoDB. I(…)

AWS

DynamoDB PartiQL – part II: SELECT

25.11.2020 by Cloud Team

By Franck Pachot . In the previous post I insertd a few rows in a Demo table using the SQL-like new API on DynamoDB. I checked my items with a SELECT but was limited in(…)

AWS

Amazon DynamoDB: the cost of indexes

13.08.2020 by Cloud Team

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

AWS

Amazon DynamoDB Local: running NoSQL on SQLite

07.08.2020 by Cloud Team

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

AWS

DynamoDB: adding a Local covering index to reduce the cost

16.03.2020 by Cloud Team

By Franck Pachot . This is a continuation on the previous post on DynamoDB: adding a Global Covering Index to reduce the cost. I have a DynamoDB partitioned on “MyKeyPart”,”MyKeySort” and I have many queries(…)

AWS

DynamoDB: adding a Global covering index to reduce the cost

16.03.2020 by Cloud Team

By Franck Pachot . People often think of indexes as a way to optimize row filtering (“get item” faster and cheaper). But indexes are also about columns (“attribute projection”) like some kind of vertical partitioning. In relational (“SQL”) databases(…)

Cloud

Google Spanner – SQL compatibility

05.01.2021 by Cloud Team

By Franck Pachot . I have posted, a long time ago, about Google Spanner (inserting data and no decimal numeric data types) but many things have changed in this area. There(…)