Credits

db.l3.ai is free and open source. Code is MIT. Our lessons, exercises and datasets are CC BY 4.0. Pages adapted from other work carry that work's license and say so at the bottom.

Inspiration and adapted work

• Select Star SQL by Zi Chong Kao. An interactive book that teaches SQL through a mental model of queries. Prose is CC BY-SA 4.0; code and data are CC0. Pages adapted from it are marked. selectstarsql.com
• PostgreSQL Exercises by Alisdair Owens. A long-running set of graded exercises on one small club database. Questions are CC BY-SA 3.0. Pages adapted from them are marked. pgexercises.com
• Learn Postgres by Xata (xataio/learn-postgres), Apache-2.0. Short, hands-on lessons in disposable databases. Some of our code and lessons are adapted from it and say so. learn.database.tech
• Crunchy Data tutorials by Crunchy Data. Browser-based Postgres tutorials. They inspired our in-browser terminal style. Not licensed for reuse; we wrote our own. www.crunchydata.com/developers/tutorials
• Use The Index, Luke by Markus Winand. The reference for how indexes work and why queries are slow. Copyright Markus Winand; we link and do not copy. use-the-index-luke.com
• PostgreSQL Internals by Egor Rogov (translated by Liudmila Mantrova), Postgres Professional. A free book on how PostgreSQL works inside. Copyright Postgres Professional; we link and do not copy. postgrespro.com/community/books/internals

Built with

• PostgreSQL by PostgreSQL Global Development Group and the Regents of the University of California. PostgreSQL and its documentation, under the PostgreSQL License. www.postgresql.org
• PGlite by ElectricSQL. PostgreSQL in WebAssembly. Apache-2.0. github.com/electric-sql/pglite
• psql-describe by Neon. PostgreSQL License. github.com/neondatabase/psql-describe
• CodeMirror by Marijn Haverbeke and contributors. MIT. codemirror.net

License texts

The full texts are in the LICENSES/ folder of the repository: MIT, CC BY 4.0, CC BY-SA 4.0, CC BY-SA 3.0, CC0 1.0, Apache-2.0 (Learn Postgres and PGlite), the PostgreSQL License, psql-describe, CodeMirror.

Notes

PostgreSQL is a trademark of the PostgreSQL Community Association of Canada. This site is not affiliated with or endorsed by any project or company named here. Spot an error in a credit or a license? Open an issue on the repository.