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.