SQL Recipes vs TrashBox

200+ SQL queries with explanations, 120+ of them free. Tap Run and see the result table right in the app. An everyday SQL cheat sheet, from your first SELECT to window functions. • 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries. • Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article. • Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown. • Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app. • Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection. • Search covers the queries themselves, not just titles: type a fragment you remember and find the query. • Edit queries and rerun the runnable ones; one tap brings the original back. • Add your own queries; they are saved in the app. • Everything except running queries works offline. No account needed. Queries are curated from professional sources and checked before release: the code works and is easy to follow. FREE VERSION • 12 runs and 12 edits a day • Full keyword and function reference; tap a word in a query for up to 12 articles a day • Up to 5 queries of your own The full version unlocks every query, removes the limits on edits and on your own queries, and raises the daily run limit to 80. One-time purchase, no subscription. Built by a developer for developers. The CodePro project has been in active development since 2015.

Welcome to TrashBox-80 - the microcomputer nobody asked for, from Radio Smack! Step back into the golden age of home computing with a lovingly recreated TRS-80 Model I-style experience built for retro-computing fans, BASIC programmers, and anyone who misses the days when a blinking cursor was an invitation to explore. TrashBox-80 recreates the feel of a classic 48K microcomputer, complete with a green-screen display, block cursor, virtual keyboard, and Level II BASIC-style programming environment. POWER UP. GET A PROMPT. START TYPING. No accounts. No complicated setup. Just a computer, a cursor, and BASIC. PROGRAM IN BASIC Write, edit, run, save, and load BASIC programs directly inside TrashBox-80. Experiment with classic commands, create your own programs, learn old-school programming, or see just how much you can accomplish with a few lines of BASIC. Whether you remember typing programs from magazines or you are discovering classic BASIC for the first time, TrashBox-80 gives you a hands-on way to explore the roots of personal computing. BUILT-IN ARCADE Don't feel like programming? Head over to the Arcade. TrashBox-80 includes a collection of retro-inspired games designed to capture the simple, addictive fun of early home computers. Play Blockdrop, blast through space in Astro Blaster, test your luck at Blackjack and Acey-Ducey, play Hangman, explore text adventures, and more. The intentionally old-school graphics and gameplay are part of the experience. CLASSIC COMPUTER EXPERIENCE * TRS-80 Model I-inspired interface * 48K-era computing experience * Level II BASIC-style programming * Authentic green-screen presentation * Blinking block cursor * Built-in translucent virtual keyboard * External keyboard support * BREAK key support * Write and run your own BASIC programs * Save and load programs locally * Built-in retro Arcade * Quick Guide included * Works without requiring an account * Designed for newcomers and longtime retro-computing fans LEARN. CODE. PLAY. TrashBox-80 isn't just a simulation of an old computer screen. It's an interactive tribute to an era when turning on a computer meant you were immediately ready to program it. Type a BASIC program. RUN it. Break it. Fix it. Save it. Then waste the next hour playing Blockdrop. Just like nature intended. RADIO SMACK TRASHBOX-80 MICRO COMPUTER SYSTEM Modern computers have millions of times more processing power. TrashBox-80 has a blinking green cursor. We know which one is cooler. Ready?