Text Editor vs SQL Lens

Text Editor is a fast, modern, and powerful code editor built for developers, students, and creators who want a professional coding experience on iPhone, iPad, Mac, and Vision Pro. Write, edit, and manage code with support for many popular programming, scripting, and markup languages all in one lightweight and easy-to-use editor. Whether you are building websites, editing configuration files, writing scripts, learning programming, or taking technical notes, Text Editor provides a smooth and reliable workspace designed for productivity. Supported Languages: Swift, C, C++, C#, Objective-C, Go, Rust, Java, Kotlin, JavaScript, TypeScript, JSX, TSX, Python, Ruby, PHP, Lua, Perl, Bash, SQL, HTML, CSS, SCSS, JSON, JSON5, YAML, TOML, Markdown, Astro, Regex, Elixir, Haskell, Plain Text, and many more. Features: - Professional code and text editing - Fast and lightweight performance - Tree-sitter powered syntax highlighting - Smart autocomplete and code suggestions - Built-in snippets for popular languages - Context-aware suggestions with fuzzy matching - Auto-close brackets, quotes, and tags - Find and replace - Go to line - Undo and redo support - Duplicate and move lines quickly - Advanced keyboard editing controls - Format code with Prettier - Support for HTML, CSS, JavaScript, TypeScript, JSON, YAML, Markdown, and PHP formatting - Adjustable tab width, line length, quote style, trailing commas, prose wrap, and more - Beautiful built-in light and dark themes - 30+ professionally designed themes included - Popular themes inspired by One Dark Pro, Dracula, Monokai, Solarized, Nord, GitHub Dark, Tokyo Night, Material, Paper, and more - Import and export custom themes - App-wide adaptive color scheme - Fully customizable keyboard accessory bar - Quick access coding symbols and actions - Powerful editing actions including indent, outdent, duplicate lines, move lines, and cursor navigation - Searchable advanced font picker with support for custom fonts - Adjustable font size, line height, and letter spacing - Multiple text encodings with automatic detection - Choose between UTF-8, UTF-16, ISO Latin 1, and many more encodings - Line ending detection and preservation (LF and CRLF) - Enable or disable auto-correction - Enable or disable auto-capitalization - Enable or disable spell-checking - Hardware keyboard shortcuts for save, find, format, comments, and navigation - Auto-save and unsaved changes protection - Native Files app integration - Open, edit, and share files easily - Share Sheet support - Print documents directly from the app - Optimized for iPhone, iPad, Mac, and Vision Pro Built for Productivity: Text Editor is designed to help you stay focused with a clean interface, responsive performance, and powerful developer tools that make coding easier anywhere. Perfect for web development, mobile app development, backend scripting, configuration editing, Markdown writing, learning programming, technical notes, and everyday text editing. Simple enough for beginners. Powerful enough for professional developers.

SQL Lensは、複雑なSELECT文、INSERT文、MERGE文を読み解くためのiPhone用SQL解析ツールです。 SQLを貼り付けるか.sqlファイルを開くだけで、抽出される列や書き込み先カラムが、どのテーブル・どのカラムから来たのかを追跡できます。 主な機能 ・SELECTの最終列から元テーブル／元カラムまでの経路を表示 ・INSERT SELECTの元列から投入先テーブル／カラムまでを順番に対応表示 ・複数行のINSERT VALUESを、書き込まれる表の形で表示 ・MERGEのUSING、ON、更新・追加・削除の分岐と書き込み先を表示 ・CTE、多階層の副問い合わせ、相関副問い合わせ、JOIN、集計式を解析 ・Oracle／SQL Server形式の単一集計PIVOTを解析 ・SELECT結果や書き込みデータの形を、理解用のデータ例で表示 ・JOIN条件からER図を作成し、複数列の結合を1つの複合関係として表示 ・ER図全体をJPGで書き出し ・SQLを句ごとに整形し、折りたたんで読みやすく表示 ・予約語、型、識別子、関数、文字列、数値、コメントを色分け ・文法エラーの行と位置、直し方のヒントを表示 ・ライトモード／ダークモードに対応 対応プロファイル 標準SQL、PostgreSQL、MySQL、SQLite、Oracle Database、Microsoft SQL Server、IBM Db2の7種類を選択できます。各製品のすべての構文を再現する実行エンジンではなく、SELECT、INSERT VALUES、INSERT SELECT、MERGE、CTE、副問い合わせ、JOIN、集計、CASE、ウィンドウ関数など、アプリが明示する解析範囲を対象としています。選択した製品にないMERGE／PIVOT構文は互換性警告を表示します。 プライバシー SQLの解析はすべて端末内で行います。外部AI、広告、分析SDK、アカウント登録、データベース接続、外部サーバへのSQL送信はありません。実データベースへの検索や書き込みも行いません。