SQLite Mobile Client vs SQL Recipes Pro

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

An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run. • 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection; the practice database allows 80 runs a day. • Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side. • Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately. • The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app. • Edit any query and run it again; one tap brings the original back. • Add your own queries; they stay in the app and are always at hand. • Search by section name or by a fragment of a query. • Everything except running works offline: queries, search, favorites. • Light and dark themes, font and size, line numbers, soft wrapping. Every query example is drawn from trusted sources and thoroughly tested. Built by a developer for developers. In active development since 2015.