Python Recipes vs SQL Guide

Tap Run and the real output appears right under the code, so you know it works before it goes into your project. No IDE, no setup, no account. 370+ short examples, one task each, with comments on the tricky parts. Over 90% run in the app with one tap. Names follow PEP 8, and the output shows every value. You know what you need, but not the exact syntax: • How do I drop duplicates from a list and keep the order? • How do I add a month to a date? • How do I pull a number out of a string with a regex? Each has a working example here. • 22 sections, including strings, dicts, classes, generators, match statements, exceptions, files, and design patterns. • What changed from Python 3.0 to 3.13, with before-and-after code: dict merging with | and |=, f"{x=}", asyncio.run, except*. • Keyword reference, 200+ entries: tap a word in the code to look it up. • 200+ SQL queries: JOIN, GROUP BY, subqueries, window functions; more than half run on a practice database. • Search looks inside the code: type defaultdict to find every example that uses it. • Edit an example and run your version, or write your own. • Works on iPhone, iPad, and Mac. • Everything except running code works offline. Free version: 320+ examples and queries, the full keyword reference, and 12 runs, 12 edits and up to 12 reference entries a day opened by tapping a word in the code (Python and SQL runs share one count). Full version: all examples and queries, unlimited edits and examples of your own, and up to 30 Python and 80 SQL runs a day. One-time purchase, no subscription. Built by a developer for developers. Maintained since 2015. WHAT'S NEW • Improved support for foldable phones and large screens.

SQLGuide — Learn SQL, One Chapter at a Time SQLGuide is a modern, lightweight SQL learning app built around short chapters, interactive quizzes, and a practical reference library. It is designed for beginners who want to learn core SQL concepts clearly and build confidence with real query patterns. Learn by doing SQLGuide combines guided reading with quick practice so you can move from understanding → recall → application: - Read a chapter with focused explanations and examples - Practice with multiple quiz formats - Keep a reference library for fast lookups - Bookmark what matters and come back later Guide (SQL Basics) Progress through a structured curriculum that starts from fundamentals and builds up step by step: - Queries: SELECT, DISTINCT, LIMIT - Filtering: WHERE, AND/OR, IN, BETWEEN, LIKE - Sorting and grouping: ORDER BY, GROUP BY, HAVING - Aggregation: COUNT, SUM, AVG, MIN, MAX - Joins: INNER/LEFT/RIGHT, practical join patterns - Data shaping: CASE, COALESCE, NULL handling - Subqueries, CTEs, UNION - Basic DDL/DML concepts: CREATE TABLE, INSERT, UPDATE, DELETE (concepts and patterns) Quiz (with explanations) Practice with short, focused prompts that reinforce both syntax and reasoning: - Clear explanations after each question to help you learn from mistakes - SQL snippets and realistic scenarios that mirror everyday query work - Smooth “continue” flow to keep you moving without friction - Progress tracking that shows what you have mastered and what is next Reference (quick SQL lookup) A curated reference list for frequently used SQL topics, with concise notes and examples to reduce context switching while you learn. Bookmarks and progress - Bookmark chapters and reference topics - Track course progress and quiz completion - Earn badges as you complete milestones Who this is for - Students learning SQL fundamentals - Developers refreshing core SQL skills - Analysts practicing queries and concepts - Anyone preparing for SQL interviews or assessments Privacy and access No account required. No login. No external sign-in at all. Everything is free. Download and get all content immediately.