Runestone Text Editor vs SQL Guide

A plain text editor with syntax highlighting, line numbers, search and replace, page guide, and much more. It's like TextEdit but more powerful and optimised for iPhone and iPad. Runestone is made by a single person with a love for text editors and a vision of building the most lightweight text editor for iPhone and iPad that still has the core features for editing code. Features: - Syntax highlighting of many languages including HTML, JavaScript, JSON, Markdown, Swift, Python, PHP, YAML, and many more. - Select one of the twelve standard themes including popular themes like Tomorrow, Dracula, Solarized, and One Dark Pro. - Innovative find and replace for searching and modifying text while still viewing your file. - Choose font and font size, including support for custom fonts imported using another third-party app. - Show the line and column the cursor is located on. - Uses the standard document browser for an experience similar to the Files app. - Quickly navigate to a specific line. - Automatically close opening brackets and quotes. - Multiple windows on the iPad. - Format code using Prettier.js. Supported languages include CSS,HTML, JavaScript, JSON, PHP and more. - Choose text encoding between popular encodings like UTF-8, UTF-16, ISO Latin 1, and many more. - Enable or disable autocorrection, autocapitalization, and smart punctuation. - Set default file extension of new files. - Open files in Runestone from the Share Sheet. - Print documents. Premium features: - Choose between eight app icons. - Show line numbers. - Highlight the selected line. - Increase line height and letter spacing. - Disable line wrapping to allow horizontal scrolling. - Show tabs, spaces, and line breaks using a selected symbol. - Enable page guide at a specific column to easily tell when lines are getting too long. - Add vertical and horizontal overscroll. - Remember the selected language per file. - Save file extensions and filenames that should always be treated as plain text files. - Enable soft tabs and choose the width of the tab character. - Specify whether pressing the tab key should insert a tab or indent the line. - Adjust the scaling of Markdown headings and disable highlighting of code blocks in Markdown. Runestone was built on the open-source framework with the same name. Find more information on the Runestone framework at github.com/simonbs/runestone

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.