SQL Recipes vs Fabula for SwiftUI

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.

The formalism used the concepts of fabula and syuzhet as a way to develop narrative construction or classified materials and compositions into fabula and syuzhet, respectively. The totality of microscopic events listed in causality was called a fabula, and the narrative arrangement of these motifs in an artistic way was called a syuzhet. This app is a personal project to learn the technical ingredients of SwiftUI and derive creative results. SwiftUI is a user interface toolkit that can develop applications in a declarative manner. This is a modern development method that communicates to iOS how you want the user interface to behave and finds out how users perform when interacting with the interface. In addition, SwiftUI can develop macOS, watchOS, and tvOS with the same code as well as iOS development. The most appealing thing for me personally is that it is easy to learn and that the code is concise, making it easy for beginners to understand. I hope this project will help everyone, including myself, to understand SwiftUI. The code of this project will be updated regularly. You can share and communicate with developers around the world through the Fabula app. We always look forward to the participation of developers.