Python Recipes vs SQLiteFlow

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 of these has a ready, working example here; just adapt it to your code. • 22 sections, including basic types, arrays and collections, classes, files, serialization, functions and lambdas, exceptions, regular expressions, threading, databases, algorithms, design patterns. • Language changes by version: 8 sections from Python 3.0 to 3.13, with before-and-after code. • Keyword and function reference: over 200 articles. Browse, search, or tap a word in the code to open its article. • SQL included: over 200 queries (JOIN, GROUP BY, subqueries, data types); more than half run on a real practice database. • Run in the app: the output appears directly below the code, no IDE or local Python needed. More than 90% of examples run. Requires an internet connection. • Search covers the code itself, not just titles: type a fragment you remember and find the example. • Edit examples or add your own; your changes and additions 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 • Full keyword and function reference, 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 CodePro project has been in active development since 2015.

Two-week free trial! So you can purchase SQLiteFlow after you know you like it! SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use. It contains features as described below: Browse • Manage files. Supports add, remove, duplicate, rename folders, SQLite databases, SQL files, CSV files, etc. • Supports import database from iCloud Drive by the file picker. • Supports open external SQL files, CSV files and Filter files. • Supports open external folders. Requires iOS 13.0 or iPadOS 13.0. • Supports show recents files. Query Editor • Multi-query execution. • Syntax highlighting. • SQL auto-completion. • Format query. Data Editor • View, edit or add table data. • Multiple cells/rows/columns selection. • View table data with a convenient filter. • Sort records by tapping on column title. • Edit blob data as hex or show it as preview if possible. Alter Table • View, edit or add table fields, indexes, foreign keys, checks. • View triggers. • View DDL. Table List • Supports display each table's name and records count. Connect • Supports let SQLiteFlow(macOS) connect databases in this app. One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac. Drag and Drop • Supports drag and drop to import or export SQLite databases and SQL files in iPad. Database Statistics • Supports show records count of each table. • Supports show total size of each table • Supports show size of each table's content. • Supports show size of each table's index. This feature may help you get more insight about your SQLite databases' data storage information, which may let you see if there're any chances to let SQLite working in a more effective way in your device. ER Diagram • Supports display ER diagram. • Supports toggle field type hide or show. • Supports Relationship Guessing. • Supports copy as Mermaid markdown. Database Diff • Supports generate SQL text that can let you transform a database content into another. • Supports show a summary of the differences between two databases. Import • Supports import CSV data. • Supports import JSON data. Export • In Data Editor or Query Results, supports export data to CSV, JSON, Markdown or List. • In Data Editor, supports export data to Insert Statement or Update Statement if possible. Multiple Windows • Supports multiple windows for iPadOS 13 or later. Dark Mode • Supports dark mode. visionOS • Supports visionOS. Shortcuts • Supports "Run Query" action. • Supports "Import CSV" action. • Supports "Import JSON" action. Create Function • Supports create scalar function using a simple JavaScript routine. Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/