Panorama X 10.2

Panorama X combines the best elements of database and spreadsheet technology into a single package, making it an unparalleled tool for working with and analyzing any kind of information. Like a spreadsheet, Panorama X is RAM based for speed and flexibility, but with all of the data processing power of a full-blown database application and more.

RAM Based Performance

There's one key difference between Panorama X and every other database program out there: Panorama X is RAM-based, not disk-based. You read that correctly — Panorama X performs all database operations completely in your computer's high speed RAM, never touching the much slower mechanical disk or SSD drive (of course changes are regularly auto-saved for safety). You'll see incredible performance when sorting, searching, performing analysis, and even when doing complete data restructuring. Massive tasks that would be impossibly slow when using other database software become routine.

Even if a database already contains tens of thousand of records, Panorama X can quickly conquer tasks like shifting misaligned data, splitting or merging fields, correcting misformatted or improperly capitalized data, search and replace, phonetic searches or even searching with a formula or regular expression. It's like a Swiss Army knife for your data!

Modern User Interface

Panorama 1.0 first shipped back in 1988, but if you've seen Panorama before, it's time to look again. Panorama X has been completely rebuilt as a Mac-only app, all new from the ground up with a timeless new design, delightful, easy-to-use and consistent interactions, all wrapped up with the latest UI goodness from Apple.

Even with a million record database, scrolling is smooth and responsive. Graphics are crisp, sharp and retina-ready, and all the hallmarks of a modern macOS application are included: 64-bit, customizable toolbars, inspector panels, full-screen mode, complete Unicode support, even multi-level undo!

Get Started Fast

Panorama X makes simple tasks easy and difficult tasks possible. With Panorama's intuitive, spreadsheet-like data sheet view, you can get your first database up and running in less than a minute. You can start from scratch or import existing data in comma-separated (csv), tab-separated (tsv), or json format. As your needs and abilities grow, you can add custom layouts and programming to create database applications tailor-made to your exact specifications. Take your personalized Panorama experience as far as you want to go. You'll be guided every step of the way by the detailed documentation and quick start video training guides.

Multi-Level Undo

Panorama X is the first database program ever to support universal, multi-level undo. You can feel free to work quickly with no worries about making mistakes, because Panorama X always keeps a safety net there for you. Multi-level undo isn't restricted to small changes — any operation you perform in Panorama X can be instantly reversed, including:

• Data entry
• Inserting and deleting records
• Inserting, deleting, merging and splitting fields
• Sorting, searching & bulk data modification
• Graphics and code modifications

If you need to reverse changes over a longer period, Panorama also supports Revert to Saved (not just the most recently saved version, but any previously saved version using the standard Time Machine interface).

Deep Searching

Panorama X can easily search all fields in a database or any combination of specific fields. Text fields can be searched for complete or partial matches, or even searched phonetically or using a regular expression. Fields can be compared to each other as well as to fixed values. Multiple searches can be combined for very specific results, and for advanced searching boolean formulas can be used. Search results are updated live, as you type, even for the most complex and advanced searches.

Interactive Data Analysis

Data outlines are a unique feature that summarize raw data in a multi-level outline, with each higher level corresponding to higher level categorizations of the data. The outline is interactive, so it can be collapsed to show overall trends or selectively expanded to reveal specific details at lower levels. Summary levels in the outline can be further processed by sorting or selection, making it easy to answer questions like who were the top five sales associates in each region last quarter? or which sectors are growing the fastest internationally?