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.2

New Features and Changes

There is a new **Scale** submenu in the **Objects** menu and in the graphics mode Context menu (right click). This allows for easy scaling of a selected object’s size. There is also a statement to scale the selected objects.
New functions: **dayofmonth(**, **dayofquarter(** and **dayofyear(**.
New **binarydatatype(** function, which inspects a binary value and returns the type of data inside (if possible), for example Array, Dictionary or Color.
The Server Admin Sessions panel now correctly shows the Last Activity time for each session. (Note: This fix only works if you update both the server and the client.)

Fixed

Fixed View Organizer menus after bringing the View Organizer to the front.
Fixed default handling of empty selections in procedure code. Panorama is supposed to skip any bulk modification statements after an empty selection, but except for removeselected/removeunselected, it never did. Now all of the fill statements will be skipped after an empty selection.
The **arrayreplacevalue(** function now works even if the value to be replaced appears in multiple consecutive array elements.
Fixed handling of **“”** query parameter in **arraybuild**, **arrayselectedbuild**, **formulasum**, **globaldictionarybuild** and **superarraybuild**. (A parameter of **“”** should have included all records, instead it included none.)
The **arrayrange(** function has been fixed so that it works correctly with out-of-bounds array indexes. (There were significant problems with this function if it was passed indexes that were not within the array boundaries. For text arrays this only affected negative indexes. For data arrays both negative and positive indexes out of bounds were not handled correctly.)
The Text Editor object “Use Field Attributes” option now works in Formula mode (previously this option only worked with variables).
Segmented buttons now work properly with the **info(“clickedobjectid”)** and **info(“clickedobjectname”)** functions.
Clicking on a form in the Web Status Page now works correctly (displays a blank form).
The Error Wizard no longer opens a dialog when you click on the error message. (Instead, it copies the error message to the clipboard, and displays a notification. Also added extra error trapping in the Error Wizard when opening a source procedure.)
The escape key can now be used to close the About, Memory Usage, and Check Software Update windows.

Documentation

Documentation corrections submitted by David Thompson, Peter Newble, Robert Ameeti, Alain Hervé, Thomas Cooper, James Cook.

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.