Python Recipes vs SQLite Mobile Client

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.

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