SQL Recipes vs Go Programming Compiler

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. • 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. No account needed. WHAT THE FREE VERSION INCLUDES 12 runs and 12 edits a day; the limit resets every morning. The keyword reference is unlocked, with no limits. Up to 5 queries of your own. The full version unlocks every section, lifts the daily limits and raises the run limit to 80 a day. One purchase, no subscription. Built by a developer for developers. In active development since 2015.

Write Go code directly on your iPhone, iPad and iPod Touch! This app is ideal for learning and testing code snippets! Go (incorrectly known as Golang) is a statically typed, compiled programming language designed at Google. Go is syntactically similar to C, but with memory safety, garbage collection, structural typing and CSP-style concurrency. Features: - Compile and run your program - View program output or detailed error - Custom keyboard for easy input of frequently used characters - Optimized for connecting with external physical/bluetooth keyboard - Advanced source code editor with syntax highlighting, bracket completion and line numbers - Open, save, import and share Go files. Supports File Sharing with iTunes Connect, AIrDrop and iCloud. - Language reference Limitations: - Internet connection is required for compilation - Maximum program running time is 20s - One file can be run at a time - Some file system, network and graphics functions may be limited - This is a batch compiler; interactive programs are not supported. For example, if your program provides an input prompt, enter the input in the Input tab prior to compilation.