Python Recipes: Code & SQL

An everyday Python reference, from strings and collections to threading and design patterns. Tricky parts of the examples are explained in comments.

You know what you need, but the exact syntax escapes you:
• How do I sort a dict by value?
• How do I serialize an object to JSON and back?
• How do I start a thread and wait for it to finish?
Each has a working example here, ready to adapt to your code.

• 22 sections, including classes, functions and lambdas, files, serialization, exceptions, regular expressions, databases and algorithms.
• Language changes by version, Python 3.0 to 3.13: the walrus operator, match statements, dataclasses, free-threading and more, with before-and-after code.
• Keyword and function reference: over 200 entries. Browse, search, or tap a word in the code to look it up.
• SQL included: JOIN, GROUP BY, subqueries, data types; more than half of the queries run on a real practice database.
• No IDE or local Python needed: over 90% of examples run in the app, with the output right below the code.
• Search covers the code itself, not just titles: type a fragment you remember and find the example.
• Edit examples or add your own; changes are saved in the app.
• Everything except running code works offline. No account needed.

Examples are curated from professional sources and checked before release: the code works and is easy to follow.

FREE VERSION
• 12 runs (examples and SQL combined) and 12 edits a day
• Keyword and function reference with no limits
• Up to 5 examples of your own

The full version unlocks every example and query, removes the limits on edits and on your own examples, and raises the daily run limits to 30 for examples and 80 for SQL. One-time purchase, no subscription.

Built by a developer for developers. The project behind it has been in active development since 2015.