Python Recipes vs SQLite Mobile Client

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.

DB Compass for SQLite allows you to access your SQLite databases. You can manage your data with a very clean and simple iOS user interface. FEATURES (with in-app purchase): • Table data: add, edit and delete record • Table data: browse, filter, sort, and quick search on fetched data • Assisted table creation • Blob preview and export • Blob update (from iOS Photos or Files) • Export data grid to CSV, HTML, Excel, MSAccess(XML) and SQLite format • Import CSV, MSAccess(MDB/ACCDB) or DBF tables • View ER Diagram (interactive and with PNG/PDF export) • A.I. integration (OpenAI & Ollama) • Siri-Shortcuts actions • Charts & Widgets OpenAI, Gemini and Claude integration requires api key and is only available in allowed regions. Ollama and LM Studio integration requires your server to connect. -- This is a Premium app and some features may require an in-app lifetime unlock -- For feedback or suggestions contact info@dbcompass.net