Stack Overflow
Stack Overflow

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
1
vote
1 answer

AWS QLDB - GDPR support

I am planning for AWS QLDB for audit data. Does QLDB support GDPR? Is there any performance impact to this? There are some fields encrypted using custom encryption key before storing into QLDB. I might change the key down the line when the key gets…
user1578872
  • 7,808
  • 29
  • 108
  • 206
1
vote
1 answer

ion.Timestamp to json time

I saw that if I store QLDB ion.Timestamp, it cannot be converted directly to json time string (YYYY-MM-DDThh:mm:ss.sssZ). for example: // result of querying data object from histories(table, from, to) var val map[string]interface{} err :=…
Kokizzu
  • 24,974
  • 37
  • 137
  • 233
1
vote
1 answer

How to retrieve minimum transaction/update time for all table on QLDB

In the doc, we can retrieve history by date, but how to retrieve minimum date for all tables on that ledger? I tried this: SELECT MIN(h.metadata.txTime) FROM history(Clients) AS h but it gives error: : at line , column :…
Kokizzu
  • 24,974
  • 37
  • 137
  • 233
1
vote
1 answer

Foreign constraints in QLDB table

Is there a way to add foreign constraints in a QLDB table? Suppose I have two open tables, one with and another without, a primary key. Can I add a foreign key constraint referencing those with a primary key? Does the same work with indexes? If I…
Arahant
  • 29
  • 1
1
vote
1 answer

Amazon qldb SELECT query to search specific rows with very less READIo's

I have a table with the following columns UserID (index), SID (index), Cause (index), TimeValue (index), Amount I want to query the cause of a specific user id, Meaning I want some cause which is equal to let's say water but I want this for only one…
Sulman Azhar
  • 977
  • 1
  • 9
  • 26
1
vote
1 answer

How to get latest result set based on the timestamp in amazon qldb?

I have many an IonStruct as follows. { revenueId: "0dcb7eb6-8cec-4af1-babe-7292618b9c69", ownerId: "u102john2021", revenueAddedTime: 2020-06-20T19:31:31.000Z, } I want to write a query to select the latest records set within a given…
Dasun
  • 602
  • 1
  • 11
  • 34
1
vote
1 answer

How to convert Amazon QLDB IonStruct to Json in java?

I have written a QLDB query to fetch a document by document ID So that I want to convert this document to a JSON response and pass it through the rest end point. qldbDriver.QldbDriver().execute(txn ->{ IonSystem ionSys =…
Dasun
  • 602
  • 1
  • 11
  • 34
1
vote
1 answer

How to connect Amazon QLDB database in Spring boot?

I have a ledger-based database "demo" inside AWS qLdB. So I want to connect to that database through the Spring boot web application. First of all, I gave user permissions to QLDB like Then I added the following maven dependencies to pom.