Questions tagged [amazon-qldb]

Amazon Quantum Ledger Database (Amazon QLDB) is a fully managed ledger database owned by a central trusted authority that provides a transparent, immutable, and cryptographically verifiable transaction log of all of your application changes. Amazon QLDB tracks all application data changes and maintains a complete and verifiable history of changes over time.

What Is Amazon QLDB? - Amazon Quantum Ledger Database (Amazon QLDB)

104 questions
2
votes
1 answer

Lambda random long execution while running QLDB query

I have a lambda triggered by a SQS FIFO queue when there are messages on this queue. Basically this lambda is getting the message from the queue and connecting to QLDB through a VPC endpoint in order to run a simple SELECT query and a subsequent…
2
votes
1 answer

how should define a PRIMARY KEY in PartiQL at Amazon QLDB?

I want to define a primary key in QLDB that the query language is PartiQL, how can I define ID as a primary key? CREATE TABLE CarInfo WITH (aws_tags = `{ 'ID': INT, 'Manufacturer': STRING, 'ProductionYear': year, 'Model':STRING, 'VIN':STRING,…
amin
  • 93
  • 8
2
votes
2 answers

Is the QLDB sum() fuction optimized?

We want to query our QLDB Ledger using the SUM() function (with a WHERE clause referring only to indexed fields). e.g., select count(*), sum(NonIndexedField) from myTable where IndexedField1 = "foo" and IndexedField2 = "bar"; Is this a good or bad…
Animesh
  • 1,765
  • 2
  • 22
  • 36
2
votes
1 answer

Guides or Examples for Mocking QLDB operations & transactions

I am currently writing an application that is writing to a QLDB ledger. I have a function like: // Use an interface that matches the QLDB Driver so we can inject / mock type ILedgerDriver interface { Execute(ctx context.Context, fn func(txn…
Chris Sargent
  • 321
  • 2
  • 13
2
votes
1 answer

Laravel Aws\Laravel\AwsServiceProvider::class Not found

I want to use AWS QLDB Client using aws sdk in laravel v7 I have followed all procedures written here. I'm getting this error Aws\Laravel\AwsServiceProvider::class Not found
2
votes
2 answers

BadRequestException: no open transaction, qldb, nodejs driver

I set up my nodejs app with qldb to implement a wallet service. Set up some tests with some success tests and some expected error tests and once in a while this error 'BadRequestException: no open transaction' would happen and cause my tests to…
Kim Luu
  • 91
  • 5
2
votes
2 answers

Optimizing time range filters in Amazon QLDB

I am working on a ledger with a table of Transactions. Each entry has a transaction_id, account_id, timestamp and other metadata. I need to query for all Transactions for a given account_id with a between operator on timestamp My planned approach…
Imtiaz
  • 91
  • 2
  • 4
2
votes
1 answer

How to decode ion_binary of Amazon QLDB in ruby

I was playing with QLDB of Amazon with ruby and used the aws-sdk-qldb and aws-sdk-qldbsession gem. I was getting result as IonBinary. But not able to decode and parse it. Following is the code cred =…
2
votes
1 answer

Finding Commit Digest for Amazon QLDB

I'm trying to connect and execute statements to Amazon QLDB using Node.js. In order to achieve this, I need to complete the final step which is calculating the commit digest. I have no idea how to do this. I've thoroughly researched the QLDB…
Med
  • 31
  • 4
2
votes
1 answer

Data encryption at AWS QLDB

I am currently comparing different solutions for an immutable database, such as Blockchain or AWS QLDB. AWS QLDB looks very interesting for me, but I have a question about how the data is stored at Amazon: Can Amazon see the data, I put on the…
Leslie31
  • 21
  • 2
2
votes
1 answer

How does Amazon Managed Blockchain's QLDB handle permissions for the different orgs?

QLDB seems to be this centralized extension built upon the Fabric orderer service that allows you to query a replication of the blockchain network in an SQL-like manner. With the different orgs on the network, I was wondering how QLDB handles…
1
vote
1 answer

AWS QLDB multi region support

I am working on QLDB from last 3 months on a single region using it as a leisure database. Now, business wants to move applications in multi-region support. I found many of the AWS services support multi-region like DynamoDB, Secrets Manager. But…
1
vote
1 answer

Is there a way to match entries in two AWS QLDB tables if the tables don't have common keys?

I'm building an anonymous polling system using AWS QLDB. I record each vote in a QLDB "votes" table without user's identity and participation info into "participation" table with identity but without answers, because I need to check if a person has…
Slava
  • 11
  • 1
1
vote
1 answer

Get qldb ledger table data in javascript object

So my issue is simple yet challenging. I am trying to transfer data from one ledger to another. Now for that, I am reading a whole table of data then creating an object for every document than inserting these documents one by one into the other…
Sulman Azhar
  • 977
  • 1
  • 9
  • 26
1
vote
1 answer

Transfer all data from one ledger to another in AWS QLDB

I have a QLDB ledger and it's full of tables now. There are a lot of InActive tables and because of these tables, I cannot create more tables because there is a limit of 40 tables per ledger. Now for this, I need to transfer this ledger data to…
Sulman Azhar
  • 977
  • 1
  • 9
  • 26