Python Recipes: Code & SQL

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.