Panorama X overview

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. Panorama provides incredible performance when sorting, searching, performing analysis, and even when doing complete data restructuring. 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 mis-formatted 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!

Features

64-bit RAM-based database engine
Flexible searching and sorting
Interactive data analysis and summaries
Universal multi-level undo
Graphical layout tools
Styled text display
JPEG, GIF, PNG, PDF, TIFF image display
Custom reports and labels
Relational
Fully programmable and recordable
Regular expressions
Customizable menus, alerts, and dialogs
Merge and split fields
Import CSV, TSV, and JSON
Export CSV, TSV, JSON, HTML, and PDF

What's new in version 10.2.3

Toolbar icons are now positioned correctly when using macOS 26 Tahoe. (Since this is the second time a new macOS version has messed up the icon positions, a new internal tool has been built that should make it super quick to make this fix again if Apple does this again.)
The duplicate record and paste record operations can now be customized with Implicitly Triggered Procedures (.DuplicateRecord, .DuplicateSummaryRecord, and .PasteRecord]
The PrintToPDF statement now erases the PDF file if it exists (instead of throwing an error).
The Dialog Workshop now correctly generates variable declarations if the form contains Text Editor objects that use a prefix on the field name
The htmldatatable statement now uses regular selection when running on a client copy of Panorama X.
The copyfolder statement has been fixed. (Previously, it simply didn't work at all!)
The documentation for selectrelated has been clarified. 1) A section has been added describing how to handle selection failures (use IF ERROR instead of info("empty"). 2) Clarified that this statement will ALWAYS bring a window forward - this cannot be suppressed.
The SelectRelated and SelectRecordsRelatedTo statements would fail if the mode was specified in anything other than lower case, now upper case is also allowed.
The SelectRecordsRelatedTo statement now works properly when the case normalization option is enabled.
Pressing the RETURN key in a form with no active editor no longer inserts a carriage return into the current cell,
Pressing the DELETE key in a form with no active editor no longer inserts an 0x7F character into the current cell.
The servervariable(, servervariablenames( and servervariables( function now report a specific helpful error if the requested database is not open, instead of a generic error.
The serverlookuapall(, serverlookup(, servervariablenames( and servervariables( now have improved error message if used on a single user database. (Also, these functions now return errors as errors, and not as goofed up data values.)
The servervariable( function now explicitly checks to make sure that a shared database has been specified. If a single user database has been specified, the function now returns a more helpful specific error message, instead of a generic error message that was difficult to interpret. Also, the generic error is now returned as an error, instead of as a garbled variable value.
Web Form Converter conversion errors are now copyable.
Fixed the 11 forms (out of 438) that had 1 line high Text Editor objects but did NOT have the Return key set as a terminator. (Otherwise, you could wind up with multiple blinking insertion points if you pressed the Return key.)
Documentation corrections submitted by James Cook, Chris Watts, Robert Ameeti, Robert McGarey, Kevin Shantz, David Thompson, Peter Newble

4.3

(11 Reviews of Panorama X)

Comments
User Ratings

kenneth-r

Mar 13, 2019

10.1.2

0.0

Version: 10.1.2

What is the difference between Panorama X and DevonThink Pro Office?

Big E

Nov 3, 2018

10.1.1

5.0

Version: 10.1.1

Panorama X is, simply stated, incredible software: super-fast (RAM-based), powerful, programmable, and compatible. It is ready for any task to be thrown it's way, including meshing with iOS applications as well as scaling to millions of records. It is logical to work with and readily programmable. Form generation is straightforward. The documentation is outstanding. Video tutorials, available for purchase, are quite useful. It is now compatible with Mojave and also very stable. The software model is subscription based with the most expensive option being $15/month and the cheapest, $5/month ... for a 5 year subscription. If you don't use the license for a month, then there is no charge. I'm not aware of similar subscription pricing for such a powerful product anywhere else.

xcoxco

Jun 7, 2018

10.0.01

Version: 10.0.01

Is Panorama X still being developed and supported??

Not entirely clear.

There's nothing else like it in the Mac world that I know of. Filemaker Pro is disk based and has very slow I/O. Panorama is RAM based and very fast.

The speed is useful for manipulating large data sets (>5 million records per table).

But further enhancements to Panorama X are still needed.

Levelbest

Jan 9, 2018

Panorama X is now only offered from a subscription based model. Those who do not mind such practices will argue that it is certainly the fairest possible offering of such a model. Perhaps it is, as it will go dormant, for the months that you do not open it during your subscription period. Theoretically, this could extend the subscription period indefinitely if you are not actually using the software. This seems to be a red-herring type argument. If you are not using it, then why try to justify it's cost? Panorama is a very powerful workhorse if you are looking for a database tool. It is amazingly fast, flexible, customizable, and accurate. As others have commented here, Panorama will do things you never thought of and do them extremely quickly. When I was first introduced to Panorama it was as a tool to take a large database in a different program, dump the data into a huge text file, and then use Panorama to reorganize that data for import into a completely different database build. Panorama made short work of that task as it works in RAM memory and loads very small text based files in it’s code. I assume this has largely been continued with Panorama X but I have not actually tested Panorama X as it is now subscription only. I am happy to continue to purchase upgrades from good developers - and Provue is certainly one of them. I strongly dislike subscription based models. I will pass when it comes to monthly payments for anything other than car insurance, mortgages, phone and internet services, and health care. Software development should stand on it’s own. In an economy of free choices, I will vote with my dollars. Sorry Panorama - and sorry for me too. I really liked that program.

james cook

Oct 23, 2017

10.0.0

Version: 10.0.0

For people who know and use other databases I've always gotten a kick out of showing them some of Panorama's basic capabilities. For instance, easily correcting capitalization on thousands of city names; San FRancisco, san francisco, SAN FRANCISCO to San Francisco with a simple Upperword( formula. Panorama has always been full of simple solutions for what one would assume are common capabilities, but they're not common. Panorama is one of those products you can pick up and be productive with almost immediately. If you're not experienced at database design, no problem. Adding, deleting or combining fields on an existing database is a quick task and doesn't stop or slow down use of the database. As an advanced user, Panorama is nothing less than a complete programming environment for me. It's built in compiler allows me to write very advanced processes for my demanding commercial clients. From within Panorama I'm able to run shell scripts or generate and run AppleScript , Python, PHP, Ruby and Perl. My Panorama programs can receive JSON and respond in kind making firm connections with iOS and Android apps. Panorama X blows away its predecessors. It's incredibly modern and sophisticated with a low minimum threshold for the user's skill but boundless capabilities for those who are ambitious to craft complete database systems.