SQL Play vs FMS Detective

Learning and Practicing SQL couldn't be Easier! Presenting you with a beautiful SQL Runner App for all your devices - SQL Play. Say goodbye to installing heavy software like MySQL or Microsoft SQL Server on your computers, just to get SQL running. You don't have to spend hours figuring out what commands to type: - Just to write a simple SELECT query - How to use the WHERE clause - Group data using HAVING clause - What are the data types to be used - And many more Guess what? You don't even need to make your own tables and insert bunch of data by yourself just to test your queries. We already have 10+ inbuilt tables just for you to get your hands dirty with SQL faster than ever. It includes: Albums, Artists, Customers, Employees, Genres, Invoices and more. You get 45+ syntaxes along with their description and easy-to-follow examples in order of their execution, which will guide you firsthand. You don't have to keep scrolling for the commands, you can simply start typing your command and the desired command with syntax will show up. It covers DDL (Data definition language), DML (Data manipulation language) and DQL (Data query language) If you prefer dark mode we have got you covered, SQL Play theme matches your system theme. So that your eyes get the deserved rest. You are not tied to our app with your data, you can export any of your tables into CSV (Comma separated values) using the Export Data feature. Your data goes with you, whether it be Excel, Google Sheets or any other spreadsheet editor or the database of your choice. /// Go down the memory lane Every time you run your query, it gets saved locally in your device which can be accessed by pressing the Up and Down arrow button. You also get auto-complete from history as you type your query, so that you don't have to keep repeating yourself. TLDR; Saves you a lot of time Popular SQL supported databases: • IBM DB2 • MySQL • Oracle DB • PostgreSQL • SQLite • SQL Server • Sybase • OpenEdge SQL • Snowflake

FMS Detective for iOS is a free admin companion for FileMaker Server. Check on your server, message and disconnect users, and manage your hosted databases from anywhere your phone has signal. Pair it with FMS Detective for Mac (fmsdetective.com) to get the full picture — the Mac app goes deep into your log files; the iOS app is what you reach for when you're away from your desk and need to act now. Everything happens between your phone and the FileMaker Server you administer. No accounts, no analytics, no telemetry, no third-party SDKs. Your credentials live in iOS Keychain on your device only. WHAT YOU CAN DO Server overview • Live status of your FileMaker Server with name, version, and IP • Activity counts: databases hosted, clients connected, schedules, plugins • License type, certificate expiration, backup configuration • Service status for Data API, OData, WebDirect, and ODBC/JDBC Databases • Searchable list with status, encryption, client count, and size at a glance • Tap a database to see who's connected, their privilege set, and how long they've been in • Operational actions: pause, resume, open, close, flush • Encryption key entry for encrypted-at-rest databases Clients • Searchable list of every connected FileMaker Pro, Go, WebDirect, Data API, and OData client • Tap a client to see open files, account name, and privilege set • Send a message to one client (Pro / Go / WebDirect only) • Broadcast a message to every connected client at once • Disconnect a client with optional grace period and warning message Schedules • Searchable list with enabled / disabled state, status, and last error code • Run any schedule on demand with one tap • Abort a running schedule with confirmation PRIVACY The app never sends data anywhere except to the FileMaker Server you connect it to. No analytics, no tracking, no advertising. Read the full privacy policy at https://www.fmsdetective.com/ios-privacy.html. REQUIREMENTS • iOS 17 or later • A FileMaker Server you administer (Admin API access) ABOUT FMS Detective for iOS is built and maintained by the same developer behind FMS Detective for Mac. Visit fmsdetective.com for the desktop version.