SQL Recipes Pro vs Melbourne Sandbox

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.

This is a sandbox for you to discover the programming language "Melbourne". This language is rules-based engine inspired by Prolog but with a syntax very close to natural languages and with additional functions. It can solve complex problems based of hundreds of encapsulated rules such as the recognition of 4-notes chords or be an alternative to access non structured knowledge database. The app in divided into two text editors : the one on the top is for entering the knowledges and the rules, the one on the bottom is the console and dedicated for your queries. Three buttons at the top are for saving & loading knowledges and rules and accessing the help section. You will find a detailed introduction of the language in the "Help" section of the App or on the official site www.melbourne-language.org. The version of the language in the Sandbox is 1.0.