|Project Name||Stars||Downloads||Repos Using This||Packages Using This||Most Recent Commit||Total Releases||Latest Release||Open Issues||License||Language|
|Awesome Sqlite||255||5 days ago||cc0-1.0|
|A collection of awesome sqlite tools, scripts, books, etc|
|Mostly Free Resources For Almost Everyone||240||2 years ago||3||unlicense|
|A list of mostly free resources for almost anyone.|
|Bible Database||204||6 days ago||5||C|
|Bible databases as XML, JSON, SQL & SQLITE3 Database format for various languages. Developers can download it freely for their development works. Freely received, freely give.|
|Query Composer||168||6 years ago||1||March 26, 2016||1||mit||Ruby|
|A library for composing complex SQL queries by defining their subcomponents and the dependencies between them.|
|Dapper Samples||150||a year ago||1||apache-2.0||C#|
|Tutorial samples that shows how to use Dapper .NET|
|Effective Sql||146||5 years ago||PLSQL|
|An interactive SQL book|
|Oreilly_getting_started_with_sql||125||4 years ago||3|
|Database files for the O'Reilly book "Getting Started with SQL: A hands on approach for beginners" http://goo.gl/z3zG54|
|Openlibrary Search||91||2 months ago||4||Python|
|Searching Open Library by keywords to return ISBNs|
|The Free Hive Book||88||6 years ago||HTML|
|A free electronic book about Apache Hive. The book is geared towards SQL-knowledgeable business users with some advanced tips for devops.|
This is the repository for selectstarsql.com. It is an interactive book that teaches SQL by conveying a mental model for writing queries.
The structure of the code is pretty standard for a Jekyll-built site. See Jekyll Directory Structure.
All the pages are stored as markdown(.md) files in the top-level directory. Jekyll takes these markdown files and converts them into html files in
/_site. During the conversion, it does all sorts of cool energy-saving things like embedding them in templates with standardized header and footer elements. These templates are stored in
You can serve a local version by running
The main technical complexity lies in the interactive sql exercises. These are implemented as a custom html tag in
/scripts/main.js. Firefox doesn't support custom html elements by default, so we pulled in the
custom-elements.min.js library from unpkg. (See
To contribute, either email me directly at [email protected], or submit a pull request by following these steps:
git clone https://github.com/MYUSERNAME/selectstarsql/
jekyll serveand check your changes on your browser at your localhost address. This will probably be http://127.0.0.1.
The prose of the book is licensed by Zi Chong Kao under a Creative Commons BY-SA 4.0 License which allows sharing and adapting under the same license and with attribution. The code and datasets are released into the public domain under the Creative Commons CC0 License.