Python IDE & Jupyter vs SQL Recipes Pro

Zero-setup Python IDE that runs your code offline, an AI coding assistant, and a developer toolbox — in a first-class citizen app for iPad and iPhone. Juno is designed to cover all your Python coding needs, supporting both Python scripts (.py) and Jupyter notebooks (.ipynb) — a document format focused on applying Python to data analysis and computational science. FREE FEATURES - Navigate and manage files and folders, quickly preview documents and media - Browse and edit Jupyter notebooks in a powerful, customizable notebook editor with beautifully rendered previews — editing is free - Write and edit code sources, scripts, JSON, XML, and other text-based formats — one versatile editor for code and text alike, with syntax highlighting - Add quick access bookmarks for file system locations outside the app's sandbox, or simply open documents in place PRO FEATURES Only one thing in Juno is Pro: running code. Even that is free to try — a generous trial allowance lets you run notebooks, scripts, projects, and the REPL before you buy. After the trial, running code unlocks with a one-time Pro purchase — not a subscription. - Run Jupyter notebooks, Python scripts, and whole projects locally with the built-in Python 3.13 interpreter and a full suite of up-to-date, preinstalled scientific and data packages — entirely offline - Explore interactively in a Python REPL — open a standalone prompt, or drop into it after running a script or project to keep exploring what it defined - Search the variables, functions, and imports in your session with the Object Inspector — no need to print each one - Open any folder as a project: file tree, multiple editor tabs, run any script, with a coding assistant aware of the whole project - Keep side outputs — Preview, Browser, Console, Object Inspector — open as side-by-side tabs in an output sidebar - View local web servers and HTML your code produces in a built-in browser with developer debug tools - Long-running scripts and Jupyter sessions keep going in the background - Automate with Shortcuts and Siri: App Intents run a Python file, run Python code, or open a file — pass arguments and files, capture output, and chain actions - Leverage powerful data analysis, machine learning and developer tools: NumPy, pandas, Polars, DuckDB, Matplotlib, SciPy, Scikit-learn, OpenCV, pygame, and more - Enjoy painless package management: install any pure Python package with an intuitive package manager AI CODING ASSISTANT The assistant runs on your account or your key, not ours: sign in with your account or add your OpenAI, Anthropic, or Gemini API key, and requests go straight from your device to your provider. You control what you spend and share — Juno never takes a cut. GAMES AND EMULATORS pygame is built in: write games with touch controls, sound, and full-screen graphics, and play them on your device. Eight complete games ship as examples, alongside NES, Game Boy, and CHIP-8 emulators written in Python, each with a library of freely licensed homebrew games — play them, then open the code to see how they work. PYTHON MEETS iOS Reach native iOS APIs straight from Python with the built-in juno modules: clipboard, Keychain, device info, location, motion sensors, contacts, reminders, photos, sound, notifications, sharing, and Bluetooth. Show native alerts and pickers, present full-screen image, video, and web previews, or call into UIKit, Foundation, and any Objective-C framework via the Objective-C bridge. SCRIPTS AND NOTEBOOKS Python scripts (.py) get snappy, intelligent code completion, a console with a full terminal emulator, and a built-in media viewer for code-generated images, plots, and web apps. Jupyter notebooks (.ipynb) keep live code, markdown text, plots, images, and LaTeX equations in one file, with every output embedded right in the document — a perfect playground for data analysis and computational science.

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.