ADL Open Source LRS vs SQL LRS

ADL Open Source LRS stores learning data collected through the Experience API, or xAPI. The repository says this version conforms to IEEE 9274.1.1, also known as xAPI 2.0, and describes it as stable but intended for proof-of-concept use with a small number of users. It is free and distributed under the Apache License, Version 2.0.

Docker and Docker Compose are the recommended installation route. The deployment includes a Django web service using uWSGI, an nginx HTTP/HTTPS proxy, PostgreSQL, RabbitMQ, and Redis. OAuth is off by default; the project describes enabling it with the OAUTH_ENABLED setting and registering clients with the LRS. Optional webhooks can filter incoming statements and send matches to a client endpoint, and they are disabled by default. A webhook can include a secret used to send an HMAC hex digest in the X-LRS-Signature header. Celery handles activity metadata retrieval, statement voiding, and LRS hooks asynchronously. Database settings can be changed in settings.ini. The Docker guide describes an included Certbot container for obtaining a certificate for a public domain and restarting nginx to use it.

SQL LRS is a self-hosted Learning Record Store for xAPI statements, attachments, and documents. It supports SQLite, Postgres, MariaDB, and MySQL. Built-in conditional logic can evaluate incoming activity and create internal xAPI statements for validated outcomes. Its SQL data can connect to tools such as Power BI, Tableau, Looker, Apache Superset, and AI stacks that work with structured databases. Authentication options include OpenID and API credentials with keys, secrets, and scopes. The software is available through GitHub, DockerHub, and Platform One’s Iron Bank, but customers host it themselves. It is free under the Apache 2.0 license and may be used in commercial projects; implementation and support services are quoted separately. The maker says it conforms to IEEE 9274.1.1 and that Iron Bank containers have Certification to Field for Platform One IL2 and IL4 environments. SQL LRS is an LRS, not an LMS or content store: it does not produce learning data or host learning content. Described uses include collecting activity from LMS, AR/VR/XR, and simulation systems and exchanging learning data with business and AI systems.