Questions tagged with Amazon Quantum Ledger Database

Hi everyone, When I use the `SELECT` command, I see my table with no order (i.e., not ordered by ID), would you please guide me on how I can see my table in order? Thanks,

Hi. I try to build simple transaction system with transactionRequest registry. I store all transactionRequests in separate table. Some other module processes this transactions in batch. Batch process registers all id's of transactionRequest that has been processed. In each subsequent runs, I need to query for all new transactionRequests, registered (inserted) after last processed one (I know id of that request). Currently I query ledger for metadata of transactionRequest with given ID and use `metadata.txTime` timestamp to query all transactionRequests registered after. That's my approach to get all newest documents starting from some timestamp or documentId but, to be honest, I don't like it. I've red in documentation that it's not good approach to query with *inequality *conditions like: `SELECT data.* FROM _ql_committed_transaction_requests WHERE metadata.txTime > 'some_timestamp'` Is there some better solution for that? How can I query for all documents that appeared after some document?

A customer is using QLDB. I have seen that you can export journal data from QLDB directly to S3 by submitting the journal export request: https://docs.aws.amazon.com/qldb/latest/developerguide/export-journal.html Can this be seen as a traditional DB backup? Secondly, is there an option of 'importing' that QLDB backup into an existing ledger or into a new ledger? Thirdly, are there any plans to incorporate automatic QLDB backups into the AWS Backup service? I know QLDB is relatively new, but knowing this would calm customers already using QLDB that backups are also thing with QLDB. Thank you in advance.

A customer is looking at using QLDB. They have a concern that this ties them into AWS. What are the options of 'migrating out' of QLDB into another ledger, if they so needed to? Apologies, I realise this is bit of a woolly question. I believe you could replay transactions into the destination system (with quite a few considerations needed). Thank you in advance.