Python Recipes: Code & SQL
Developer ToolsReference

Python Recipes: Code & SQL

Runnable Python cheat sheet

Fedor Obraztsov · released 4 Apr 2018 · Open in App Store ↗

★ 4.64 280 reviews
Unlock the split between the products, the store ranks, and how both moved.See plans
5 one-time purchases, no subscriptions
Revenue %
One-time purchase175$2.73 – $4.5324.8%+18.0%
One-time purchase175$0.69 – $1.5124.8%+18.0%
One-time purchase175$0.69 – $1.5124.8%+18.0%
One-time purchase175$0.69 – $1.5124.8%+18.0%
One-time purchase175$0.69 – $1.5124.8%+18.0%

The store shows a different set in every country

Description

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.

Last collected from the App Store on