Yet Analytics SQL LRS

A SQL-based Learning Record Store.

What is SQL LRS?

A Learning Record Store (LRS) is a persistent store for xAPI statements and associated attachments and documents. The full LRS specification can be found in Part 3 of the xAPI specification. SQL LRS is distinct from other LRSs developed at Yet Analytics for being SQL-based and supporting multiple SQL database management systems (DBMSs) like SQLite and Postgres.

Releases

For releases and release notes, see the Releases page.

Documentation

SQL LRS Overview

FAQ

• General Questions
• Troubleshooting

Basic Configuration

• Getting Started
• Setting up TLS/HTTPS
• Authority Configuration
• Docker Image
• OpenID Connect Support
  • Auth0 Setup Guide

DBMS-specific Information

DB Engine	Supported Versions
SQLite	3.42 (Embedded Engine)
Postgres	14
	15
	16
	17
	18
MariaDB	10.6
	10.11
	11.4
	11.7.2
	11.8
MySQL	8.0.44
	8.4
	9.5.0

Reference

• Configuration Variables
• HTTP Endpoints
• Developer Documentation
• Example AWS Deployment
• Reactions
• JSON Spec
• Sending xAPI statement(s) with Postman
• xAPI Versioning

Demos

• Visualization with Apache Superset
• Additional Configuration Demos

Contribution

Before contributing to this project, please read the Contribution Guidelines and the Code of Conduct.

License

Copyright © 2021-2025 Yet Analytics, Inc.

Distributed under the Apache License version 2.0.