Python IDE & Jupyter vs SQL Guide

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, Matplotlib, SciPy, Scikit-learn, OpenCV, LXML, and more - Enjoy painless package management: install any pure Python package with an intuitive package manager AI CODING ASSISTANT The assistant runs on your key, not ours: 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. 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. PYTHON SCRIPTS Python scripts are plain-text Python source code files with a .py extension. Juno lets you work on these with snappy, intelligent code completion, a console with full terminal emulator support, and a built-in media viewer for code-generated images, plots, web apps, and more — executed by the embedded Python interpreter, locally on your iPhone or iPad and completely offline. JUPYTER NOTEBOOKS A Jupyter notebook is a versatile document format that stores live code, markdown text, plots, images, and LaTeX equations in a single .ipynb file. Notebooks keep a record of every input and output of an interactive session, embedding rich output (HTML, images, video, plots) right in the document — a perfect playground for data analysis, machine learning, and computational science, and Juno makes working with them a breeze!

SQLGuide — Learn SQL, One Chapter at a Time SQLGuide is a modern, lightweight SQL learning app built around short chapters, interactive quizzes, and a practical reference library. It is designed for beginners who want to learn core SQL concepts clearly and build confidence with real query patterns. Learn by doing SQLGuide combines guided reading with quick practice so you can move from understanding → recall → application: - Read a chapter with focused explanations and examples - Practice with multiple quiz formats - Keep a reference library for fast lookups - Bookmark what matters and come back later Guide (SQL Basics) Progress through a structured curriculum that starts from fundamentals and builds up step by step: - Queries: SELECT, DISTINCT, LIMIT - Filtering: WHERE, AND/OR, IN, BETWEEN, LIKE - Sorting and grouping: ORDER BY, GROUP BY, HAVING - Aggregation: COUNT, SUM, AVG, MIN, MAX - Joins: INNER/LEFT/RIGHT, practical join patterns - Data shaping: CASE, COALESCE, NULL handling - Subqueries, CTEs, UNION - Basic DDL/DML concepts: CREATE TABLE, INSERT, UPDATE, DELETE (concepts and patterns) Quiz (with explanations) Practice with short, focused prompts that reinforce both syntax and reasoning: - Clear explanations after each question to help you learn from mistakes - SQL snippets and realistic scenarios that mirror everyday query work - Smooth “continue” flow to keep you moving without friction - Progress tracking that shows what you have mastered and what is next Reference (quick SQL lookup) A curated reference list for frequently used SQL topics, with concise notes and examples to reduce context switching while you learn. Bookmarks and progress - Bookmark chapters and reference topics - Track course progress and quiz completion - Earn badges as you complete milestones Who this is for - Students learning SQL fundamentals - Developers refreshing core SQL skills - Analysts practicing queries and concepts - Anyone preparing for SQL interviews or assessments Privacy and access No account required. No login. No external sign-in at all. Everything is free. Download and get all content immediately.