JavaScript Recipes Pro vs MagicSQL

A reference of everyday JavaScript, from strings and collections to async work and design patterns. Every example is written out in full and explained. • 23 sections: simple types, arrays and collections, classes, files, serialization, functions and arrow expressions, exceptions, regular expressions, async operations, databases, algorithms, patterns. • Run in the app: the example really executes and the output appears under the code. Needs an internet connection; the daily limit is 30 launches. • What changed in new versions: 10 sections from ES2015 to ES2024, with "before" and "after" code side by side. • Keyword and function reference: 174 articles - browse the list or search by word. • SQL alongside: over 200 queries against a live practice database - JOIN, GROUP BY, subqueries, data types. Queries have their own daily count. • Edit examples and add your own - they stay in the app and are always at hand. • Search runs over the code itself, not just the titles: remember a fragment and you will find the example. • Everything except running works offline: examples, search, favourites. • Comfortable to read: light and dark themes, your own font and size, line numbers, and long lines wrap instead of running off the screen. Examples are drawn from professional sources and verified by running them. Made by a developer for developers. In development since 2015.

Manage your databases on the go — like a pro. MagicSQL is the first mobile SQL client that brings together MySQL, PostgreSQL, MS SQL Server, MariaDB and SQLite with SSH tunneling, a full-featured editor and a multi-tab interface. Not a stripped-down viewer — a real professional tool for your phone and tablet. ▸ FIVE DATABASES, ONE INTERFACE MySQL · MariaDB · PostgreSQL · MS SQL Server · SQLite Switch between servers without leaving the app. ▸ CONNECT SECURELY - SSH tunneling with password OR private key - SSL/TLS encryption - Live status: green dot + ping time in ms show instantly which servers are reachable - Connection test with clear diagnostics: SSH, DB, or network errors are reported separately ▸ MULTI-TAB DATA BROWSER - Open multiple tables simultaneously in tabs — like on the desktop - Split View: compare two tables side by side - Inline cell editing with double-tap - Column filters, full-text search, pagination - Duplicate, delete, or export rows as JSON - Column sorting and adjustable column widths ▸ PRO SQL EDITOR - Syntax highlighting for keywords, strings, numbers, comments - Context-aware autocomplete (knows your tables and columns) - Live error detection with wavy-underline markers - Snippet toolbar for common statements - Query history with copy & re-run ▸ TABLE DESIGNER WITHOUT SQL Create tables visually with every professional property included: - Primary key, Auto-Increment, Unique - UNSIGNED for numeric types (MySQL) - ON UPDATE CURRENT_TIMESTAMP for updated_at columns - Default value with quick picks: NULL, NOW(), 0, '', UUID() - Comment, charset, collation, engine ▸ VIEWS, FUNCTIONS AND TRIGGERS Beginner-friendly builders with templates, or full SQL code control. Create views, stored functions and triggers without spending hours in the docs. ▸ USER MANAGEMENT Create MySQL users and assign privileges through three clear tabs: Account, Privileges, Password. ▸ AUTO-RECONNECT App went to background? No problem. MagicSQL keeps the connection alive with keep-alive pings and reconnects automatically when needed — no data loss, no need to re-enter anything. ▸ DARK THEME, CODING FONT Eye-friendly design with a professional monospaced font built for code. No distracting animations, no ads, no tracking — just tools that work. ▸ WHAT MAKES MAGICSQL DIFFERENT? Other mobile SQL apps often just display data. MagicSQL is a real mobile IDE: SSH tunneling for secure remote connections, multiple tables in tabs at once, an editor with live assistance, a visual designer — and all of it for five database systems. Optimized for fast thumb input, uncompromising on professional features. ▸ PRIVACY Your server credentials stay exclusively on your device. No cloud, no tracking, no ads. MagicSQL talks directly to your servers — nothing goes through third parties. ▸ SETTINGS Adapt to your workflow: connection timeout, keep-alive, auto-reconnect, default row limit, text size, NULL highlighting, syntax highlighting, query history, destructive-action confirmation — everything is respected. For developers, DBAs, DevOps and anyone who wants their databases under control everywhere. Download MagicSQL and work like a pro — from your couch, on the train, or in the server room.