App Designer vs GizmoSQL

Turn your iPhone, iPad or Mac into a powerful Swift development environment. App Designer lets you write, run, preview, organize, and debug Swift code directly on your device — completely offline and without Xcode. Build SwiftUI, UIKit, and RealityKit projects with live code execution, a built-in canvas preview, professional editing tools, Xcode project import/export, and an integrated AI assistant that can work offline or with your own online provider. Write Swift Anywhere Run Swift code instantly and see real-time output while you build. Preview SwiftUI and UIKit interfaces side by side with your code and bring your ideas to life directly on your device. Professional Code Editor Enjoy syntax highlighting with 89 color themes, smart autocomplete for Swift, SwiftUI, and UIKit, adjustable font size, line wrap, bracket matching, and automatic bracket insertion. Built-in Debugging Tools Set breakpoints, step through your code, highlight the current execution line, and view inline errors and warnings directly in the editor. SwiftUI, UIKit & RealityKit Create modern SwiftUI interfaces with VStack, HStack, NavigationStack, @State, gestures, animations, and more. Build UIKit views with buttons, labels, Auto Layout, and Core Animation. Explore 3D content with RealityKit, including RealityView, MeshResource, and Entity loading. Xcode Project Import & Export Import existing Xcode projects, continue working on the go, and export them back to Xcode when you're ready to keep building on your Mac. Project & Asset Management Manage your growing app gallery with folders, multiple pages, sorting options, Spotlight-style search, and an “Only Active” filter. Browse resources with a built-in file explorer, import images and files, add custom app icons, personalize your gallery with wallpapers, and duplicate, rename, or delete projects with ease. Learn by Example Start quickly with built-in example projects covering SwiftUI animations, UIKit layouts, file handling, image manipulation, and more. 100% Offline No internet connection required. App Designer gives you the tools to build real Swift apps right from your pocket. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

The GizmoSQL app turns your iPhone or iPad into a high-performance SQL database server using the Arrow Flight SQL protocol — the same columnar data transfer standard used in enterprise analytics. START A SERVER IN SECONDS Choose DuckDB or SQLite as your backend, tap Start, and you have a fully functional database server running on your device. Connect from laptops, desktops, or other devices on your network using any Arrow Flight SQL client — including JDBC, ADBC (Go, Python, C++), ODBC, and Node.js drivers. DUCKLAKE COMPATIBLE Access your DuckLake using your GizmoSQL mobile server. The PostgreSQL and httpfs extensions are pre-loaded so you can connect to and query your data lake seamlessly. BUILT-IN SQL CLIENT Write and execute SQL queries directly on your device with a terminal-style interface. Features include syntax highlighting, box-drawing table output, query timing, and automatic result pagination for large datasets. DATA BROWSER Explore your database visually. Navigate catalogs, schemas, and tables. View column names, types, and constraints. Preview data and manage tables — all without writing a query. KEY FEATURES - DuckDB and SQLite database backends - Arrow Flight SQL protocol for high-performance columnar data transfer - Automatic TLS encryption with self-signed certificates - Username/password authentication with JWT session tokens - Configurable query timeout, logging, and init SQL commands - Export database files via the Files app — copy to iCloud Drive, AirDrop, or any sharing method - Real-time server logs with color-coded severity levels - Active session monitoring BUILT FOR ANALYTICS DuckDB is an analytical database engine optimized for complex queries over large datasets. Combined with Arrow Flight SQL's columnar transport, GizmoSQL delivers fast query results whether you're running TPC-H benchmarks or exploring real-world data on the go. CONNECT FROM ANYWHERE ON YOUR NETWORK Once the server is running, any device on the same Wi-Fi network can connect using the displayed connection string. GizmoSQL supports the full Arrow Flight SQL protocol including prepared statements, transactions, catalog metadata, and bulk data ingest. See: https://gizmodata.com/gizmosql for more details. View the source code at: https://github.com/gizmodata/gizmosql