Amazon QLDB related information

Important

End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

The following related resources can help you as you work with this service.

Technical documentation

• Amazon QLDB FAQs – Frequently asked questions about the product.

• Amazon QLDB pricing – AWS pricing information and examples.

• AWS re:Post – AWS community forum for questions and answers (Q&A).

• Amazon Ion – Developer guides, user guides, and references for the Amazon Ion data format.

• PartiQL – A specification document and general tutorials for the PartiQL query language.

• QLDB Workshops – Workshops that provide practical, hands-on examples of using Amazon QLDB to build system-of-record applications, including the following labs:

  • Learning QLDB fundamentals

  • Working with Amazon Ion, and converting Ion to and from JSON (Java)

  • Using AWS Glue and Amazon Athena to enable QLDB data for a data lake

  • Streaming QLDB data to an Amazon Aurora MySQL DB instance

• Tamper Proof Quality Data Using Amazon QLDB – An AWS Solutions Implementation that shows how to prevent attackers from tampering with quality data by using QLDB to maintain an accurate history of data changes. AWS Solutions Implementations help you solve common problems and build faster using AWS.

GitHub repositories

Drivers

• .NET driver – A .NET implementation of the QLDB driver.

• Go driver – A Go implementation of the QLDB driver.

• Java driver – A Java implementation of the QLDB driver.

• Node.js driver – A Node.js implementation of the QLDB driver.

• Python driver – A Python implementation of the QLDB driver.

Command line shell

• QLDB shell – A Python and Rust implementation of a command line interface for the QLDB transactional data API.

Sample applications

• Java DMV application – A tutorial application that's based on a department of motor vehicles (DMV) use case. It demonstrates basic operations and best practices for using QLDB and the QLDB driver for Java.

• .NET DMV application – A DMV-based tutorial application that demonstrates basic operations and best practices for using QLDB and the QLDB driver for .NET.

• Node.js DMV application – A DMV-based tutorial application that demonstrates basic operations and best practices for using QLDB and the QLDB driver for Node.js.

• Python DMV application – A DMV-based tutorial application that demonstrates basic operations and best practices for using QLDB and the QLDB driver for Python.

• Ledger loader – A Java framework for asynchronous loading of data into a QLDB ledger at high velocity using a supported delivery channel (AWS DMS, Amazon SQS, Amazon SNS, Kinesis Data Streams, Amazon MSK, or EventBridge).

• Export processor – An extensible Java framework that handles the work of processing QLDB exports in Amazon S3 by reading the export's output and iterating through the exported blocks in sequence.

• QLDB streams sample Lambda in Python – An application that demonstrates how to consume QLDB streams by using an AWS Lambda function to send QLDB data to an Amazon SNS topic, which has an Amazon SQS queue subscribed to it.

• QLDB streams OpenSearch integration sample – A Python application that demonstrates how to integrate Amazon OpenSearch Service with QLDB by using streams.

• Double-entry application – A Java application that demonstrates how to model a double-entry financial ledger application using QLDB.

• QLDB KVS for Node.js – A simple key-value store interface library for QLDB with extra functions for document verification.

Amazon Ion and PartiQL

• Amazon Ion libraries – Ion team supported libraries, tools, and documentation.

• PartiQL implementation – The implementation, specification, and tutorials for PartiQL.

AWS blog posts and articles

• How Earnin built their ledger service using Amazon QLDB (February 16, 2023) – Describes how Earnin.com used QLDB to build a ledger service to provide their users with a modern and fully featured mobile financial application.

• Export and analyze Amazon QLDB journal data using AWS Glue and Amazon Athena (December 19, 2022) – Discusses how you can use the export feature in QLDB with AWS Glue and Athena to provide reporting and analytical capabilities to your ledger-based architectures.

• How Shinsegae International enhances customer experience and prevents counterfeiting with Amazon QLDB (August 3, 2022) – Describes how Shinsegae International built a digital authenticity verification service using Amazon QLDB to inform customers of the authenticity of luxury goods, and provide purchase and distribution history of products.

• BungkusIT uses Amazon QLDB and VeriDoc Global's ISV technology to improve the customer and delivery agent experience (April 29, 2022) – Shows how one logistics firm, BungkusIT, used QLDB to implement a centralized, transparent platform for inter-industry communication with an immutable, cryptographically verifiable transaction log.

• Use Amazon QLDB as an immutable key-value store with a REST API and JSON (February 14, 2022) – Introduces a way to work with QLDB as an immutable key-value store and use its audit features through a REST API.

• Building a core banking system with Amazon QLDB (January 21, 2022) – Shows how to use QLDB to build a core banking ledger system. It also shows why QLDB is a good fit-for-purpose database that suits the needs of the financial services industry.

• How Specright uses Amazon QLDB to create a traceable supply chain network (January 21, 2022) – Shows how Specright uses QLDB to create a traceable supply chain network that enables wholesale brands, retailers, and manufacturers to share critical supply chain data and packaging specifications data.

• How fEMR Delivers Cryptographically Secure and Verifiable Medical Data with Amazon QLDB (December 23, 2021) – Explores how Team fEMR used QLDB and other AWS managed services to enable their relief efforts.

• Monitor Amazon QLDB query access patterns (November 8, 2021) – Shows how to associate QLDB transactions and the PartiQL statements that were run in the transactions with the API requests received through Amazon API Gateway.

• Build a simple CRUD operation and data stream on Amazon QLDB using AWS Lambda (September 28, 2021) – Shows how to perform CRUD (create, read, update, and delete) operations on QLDB using AWS Lambda functions.

• Real-world cryptographic verification with Amazon QLDB (August 26, 2021) – Discusses the value of cryptographic verification in a QLDB ledger in the context of a realistic use case.

• Verify delivery conditions with the Accord Project and Amazon QLDB: Part 1, Part 2 (June 28, 2021) – Discusses how to apply smart legal contracts technology to verify delivery conditions with the open-source Accord Project and QLDB.

• Amazon QLDB data streaming via AWS CDK (June 7, 2021) – Shows how to use the AWS Cloud Development Kit (AWS CDK) to set up QLDB, populate the QLDB data using AWS Lambda functions, and set up QLDB streaming to provide data resiliency of the ledger data.

• Demo fine grained access control in QLDB (June 1, 2021) – Shows how to get started with fine-grained AWS Identity and Access Management (IAM) permissions for a QLDB ledger.

• Stream Processing with DynamoDB Streams and QLDB Streams (November 23, 2020) – Provides a brief comparison between DynamoDB streams and QLDB streams, and tips on getting started with them.

• Streaming data from Amazon QLDB to OpenSearch (August 19, 2020) – Describes how to stream data from QLDB to Amazon OpenSearch Service to support rich text search and downstream analytics, such as aggregation or metrics across records.

• How I streamed data from Amazon QLDB to DynamoDB using Nodejs in near-real time (July 7, 2020) – Describes how to stream data from QLDB to DynamoDB to support single-digit latency and infinitely scalable key-value inquiries.

• Building a GraphQL interface to Amazon QLDB with AWS AppSync: Part 1, Part 2 (May 4, 2020) – Discusses how to integrate QLDB and AWS AppSync to provide a versatile, GraphQL-powered API on top of a QLDB ledger.

Media

AWS videos

• AWS Tutorials & Demos: QLDB to Aurora Streaming (March 17, 2023; 21 minutes) – This video explains the fundamental concepts to implement the QLDB streaming capability, and demonstrates how to set up data streaming from QLDB to an Amazon Aurora MySQL downstream DB.

• ArcBlock: Leveraging Amazon QLDB to Build a Decentralized Identity Solution (May 31, 2022; 4 minutes) – ArcBlock walks through the decentralized identity solution that they built by using QLDB.

• AWS re:Invent 2020: Using Amazon QLDB as a system-of-trust database for core business apps (February 5, 2021; 30 minutes) – Learn how early Amazon QLDB users have applied the ledger database's unique properties for data provenance and cryptographic verifiability to implement systems of record with data integrity built in.

• AWS re:Invent 2020: Building out a serverless application with Amazon QLDB (February 5, 2021; 28 minutes) – Learn how to build, test, and optimize a fully functional serverless application by combining Amazon QLDB with services like AWS Lambda, Amazon Kinesis, and Amazon DynamoDB.

• AWS re:Invent 2020: Building audit-based apps that maintain data integrity with Amazon QLDB (February 5, 2021; 18 minutes) – This session dives into the problems that Amazon QLDB can solve, answers your questions about when and why you would use a ledger database, and shares use cases from customers such as Osano.

• How to Centrally Store Immutable Logs using Amazon QLDB with .NET Applications (December 7, 2020; 10 minutes) – A demonstration of how to use QLDB with .NET applications to centrally store immutable logs.

• Virtual Workshop: Building Ledger-Based Systems of Record with QLDB and Java - AWS Online Tech Talks (July 29, 2020; 87 minutes) – An instructor-led workshop that walks through the Working With Ion Immersion Day lab to build a data loader program using the Amazon Ion library and the QLDB driver for Java.

• Developer Workshop: Using AWS's Immutable Ledger Database QLDB on ABT Node (June 22, 2020; 34 minutes) – A step-by-step guide on how to set up and configure QLDB on ABT Node. It also explains how to install and configure ArcBlock's Blockchain Explorer and Boarding Gate Blocklets to connect to QLDB.

• AWS Tech Talk: A Customer's Perspective on Building an Event-Triggered System-of-Record Application with Amazon QLDB (March 31, 2020; 29 minutes) – A tech talk by Matt Lewis—AWS Data Hero and Chief Architect of the Driver and Vehicle Licensing Agency (DVLA) in the UK—that explains DVLA's use case for QLDB and their application's event-driven architecture.

• AWS re:Invent 2019: Why you need a ledger database: BMW, DVLA, & Sage discuss use cases (December 5, 2019; 47 minutes) – A presentation by customers BMW, the UK government organization DVLA, and Sage that discusses reasons to use a ledger database and shares their use cases for QLDB.

• AWS re:Invent 2019: Amazon QLDB: An engineer's deep dive on why this is a game changer (December 5, 2019; 50 minutes) – A presentation by Andrew Certain (AWS Distinguished Engineer) that discusses the unique, journal-first architecture of QLDB, along with its various innovations. It includes cryptographic hashing, Merkle trees, multiple Availability Zone replication, and PartiQL support.

• Building Applications with Amazon QLDB, a First-of-Its-Kind Ledger Database - AWS Online Tech Talks (November 19, 2019; 51 minutes) – A deep-dive tech talk that describes the unique features of QLDB and specifics about how to use the core functionality. It includes querying your data's complete history, cryptographically verifying documents, and designing a data model.

Podcasts

• Why are customers choosing Amazon QLDB? (July 5, 2020; 33 minutes) – A discussion that explains the definition of a ledger database, how it's different from a blockchain, and how customers are using it today.

General AWS resources

• Classes & Workshops – Links to role-based and specialty courses, in addition to self-paced labs to help sharpen your AWS skills and gain practical experience.

• AWS Developer Center – Explore tutorials, download tools, and learn about AWS developer events.

• AWS Developer Tools – Links to developer tools, SDKs, IDE toolkits, and command line tools for developing and managing AWS applications.

• Getting Started Resource Center – Learn how to set up your AWS account, join the AWS community, and launch your first application.

• Hands-On Tutorials – Follow step-by-step tutorials to launch your first application on AWS.

• AWS Whitepapers – Links to a comprehensive list of technical AWS whitepapers, covering topics such as architecture, security, and economics and authored by AWS Solutions Architects or other technical experts.

• AWS Support Center – The hub for creating and managing your AWS Support cases. Also includes links to other helpful resources, such as forums, technical FAQs, service health status, and AWS Trusted Advisor.

• AWS Support – The primary webpage for information about AWS Support, a one-on-one, fast-response support channel to help you build and run applications in the cloud.

• Contact Us – A central contact point for inquiries concerning AWS billing, account, events, abuse, and other issues.

• AWS Site Terms – Detailed information about our copyright and trademark; your account, license, and site access; and other topics.