SQL Recipes vs Portico SSH

200+ SQL queries with explanations, 120+ of them free. Tap Run and see the result table right in the app. An everyday SQL cheat sheet, from your first SELECT to window functions. • 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries. • Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article. • Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown. • Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app. • Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection. • Search covers the queries themselves, not just titles: type a fragment you remember and find the query. • Edit queries and rerun the runnable ones; one tap brings the original back. • Add your own queries; they are saved in the app. • Everything except running queries works offline. No account needed. Queries are curated from professional sources and checked before release: the code works and is easy to follow. FREE VERSION • 12 runs and 12 edits a day • Full keyword and function reference; tap a word in a query for up to 12 articles a day • Up to 5 queries of your own The full version unlocks every query, removes the limits on edits and on your own queries, and raises the daily run limit to 80. One-time purchase, no subscription. Built by a developer for developers. The CodePro project has been in active development since 2015.

A modern SSH terminal that travels with you. Whether you're managing a Raspberry Pi from your couch, restarting a service in the airport, or jumping into a production server during an outage — Portico keeps your shell one tap away. WHAT YOU GET, FREE • Full SSH client with native NIOSSH performance • 1 saved connection and 1 saved identity • Built-in shortcut row (Esc, Tab, arrows, Ctrl-C, and more) • 14 beautiful terminal themes • System Mono font, adjustable size UNLOCK PORTICO PRO — 7 DAYS FREE • Unlimited saved connections and identities • Custom keys for one-tap commands you actually use • Per-connection startup scripts that run automatically when you connect • Priority support DESIGNED FOR REAL WORK • Persistent terminal sessions survive backgrounding • Public key authentication with secure on-device key storage • Support for password and key-based auth • Automatic terminal resizing and rich xterm-256color rendering • Carefully tuned shortcut row that puts the keys you need where your thumbs are PRIVACY FIRST • Connection details and SSH keys stored only on your device, never on our servers • No analytics, no tracking, no advertising • Your shell is yours PRICING • Monthly: $4.99/month after 7-day free trial • Yearly: $29.99/year after 7-day free trial — save 50% • Cancel anytime in Settings Built by developers, for developers. Connect, debug, ship — wherever you are. TERMS • Privacy Policy: https://thealphastack.app/portico/privacy • Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/