Panorama
Panorama 6.0.0
Your rating: Now say why...

(3) 4.166666666666667

Database and spreadsheet technology for information analysis.   Demo ($299.95)
Add to my Watch List
Email me when discounted
Panorama 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 is RAM based for speed and flexibility, but with all of the data processing power of a full blown database application. Since 1988 Panorama's unique combination of database and spreadsheet technology has been in use all over the world for everything from custom accounting to medical research, from huge college track meets to blockbuster Hollywood productions. Key features include: -
What's New
Version 6.0.0:
  • Updated user interface
  • 5x faster on Intel processors
  • Live preview for searching and data manipulation
  • Drag to change field order
  • Temporarily hide specified fields
  • Find similar to current selection
  • Easily split/merge adjacent fields
  • Drag to/from Numbers or Excel
  • Favorite searches/manipulations
  • Total Recall crash protection for instant, complete recovery after any kind of interruption (power failure, system crash, etc).
  • Time Lapse allows user to move back and forth thru database history
Version 6.0.0:
  • Updated user interface
  • 5x faster on Intel processors
  • Live preview for searching and data manipulation
  • Drag to change field order
  • Temporarily hide specified fields
  • Find similar to current selection
  • Easily split/merge adjacent fields
  • Drag to/from Numbers or Excel
  • Favorite more...
Requirements
Intel/PPC, Mac OS X 10.4.1 or later



MacUpdate - Panorama




  • Symphytum
    +2

  • Organise
    +1

  • 4D
    +1

  • Valentina Stud...
    +1
Panorama User Discussion (Write a Review)
ver. 6.x:
(3)
Your rating: Now say why...
Overall:
(3)

sort: smiles | time
burypromote

+5

Levelbest reviewed on 27 Aug 2013
I have been a Pan Fan since version 3. Others, much longer. I am just a mid level database user. I was using FM v3 and then v4 before moving over to Panorama. I am not a programer and it has taken me quite a while to ask questions, read the manual, ask more questions and finally to tweak Panorama on my own.

I left FM because even though FM is prettier and easier for the very basics to understand than Panorama is, I soon discovered that most of the tweaks I wanted to do in FM involved working with little scripts which seemed tucked into FM in ways that I just had a hard time seeing. In Panorama since it is really all about learning a very simple scripting language there seems to be no limit to what It can do. Pan will interface with AppleScript, Ruby, Pearl and many if not most other languages.

For the record I do not find AppleScript or 4D easy in the least - but I find Panorama language easy to use.

Example:
local lvthearray
arraybuild lvthearray,¶,"",?(TagRecord contains "ON",Organization,"")
Select TagRecord contains "ON"

Variables can be defined for temp use in a procedure (local), permanent or steps in between. Here I define a variable called lvthearray, then I build an array set as lvthearray. Then I use a simple formula to see if another field used to hold marked records (marked with "on") contains the “on” value and if it does then that record is added to the array and if not, nothing is added ( “” ) for that particular record. And finally, I use select to look at only the records in my database that I have just selected. Of course all of this takes place in milliseconds, especially transparent to the user. You have to put in a couple other lines for the form to display if you want to pretty it up (and yes, you can pretty it up - it just takes more effort) Even so, it still works at ram (light) speed.
[Version 6.0.0]


burypromote

KarlOlinde8956 reviewed on 01 Apr 2013
I've not used Filemaker in several years, but when I last tried, it felt clunky and slow to me... and I didn't like it's modal views. By comparison, I have used Panorama from its beginnings as OverVUE. Even then, it was an incredible database; lightning fast (sorting 10,000 records in 2 secs!) and customizable with user-procedures and forms. Now as Pan 6, I am still enamored with its speed and data-handling prowess. It now sports an abundance of Wizards to automate the construction of a database, or import data from other files. However, as a Mac consultant, I cannot say it is for the feint of heart nor the typical casual user. You will need a bit of computer savvy to learn your way around Panorama. The basics are not that difficult, but I find the average user has very little database understanding - and for them, Pan may not be cookie cutter enough. This is where Filemaker may have a leg up on Panorama. My impression of FM is that may be a bit more ready out-of-the-box. But I've never liked being boxed in anyway. So, for the programmer or those who want to handle massive amounts of data with raw RAM speed, customize its output, and compose custom routines (including custom menus and the ability to limit user access by level), you just can't beat Panorama.
[Version 6.0.0]


burypromote
+1

+43

Psychiatry reviewed on 25 Oct 2012
This is a great database. But it is not a modern database.

The GUI is straight out of Mac OS 9. It hasn't been upgraded to take advantage of features in Mac OS X. The appearance of databases is just plain butt ugly and not user friendly and look like they came from Windows 3.0 and the 1980s. Even the fonts on screen are pixelated, not drawn smoothly. You don't get lickably beautiful databases with this app.

Of concern is that it has only one author. If he dies (and he already is elderly), Panorama will cease to be supported and developed.

Of concern is that it isn't actively being updated. The latest version was released in October 8, 2010 - two years ago. It was built for Mac OS X 10.6. But we are already at Mac OS X 10.8.2.

It is suppose to be a relational database. But this is not obvious how to do. Relations appears to be kludged on as a feature, unlike Filemaker or 4th Dimension.

Since it started as a spreadsheet which was morphed into a database, it handles text and numbers best. It has to store graphics objects such as photos, outside of the database. It is a kludge to handle other non-alphanumeric objects.

I wish it is as easy to use and as beautiful as Filemaker Pro and 4D, but it simply is not.
[Version 6.0.0]


burypromote
+2

+306
Tim27 commented on 16 Mar 2011
I would not pay $300 for an app with an interface that looks like that no matter what it can do. What year is this?
[Version 6.0.0]

2 Replies

burypromote

+39
Michael-Vilain replied on 07 Jan 2012
Panorama hasn't changed since I used it on MacOS 9. I left it behind when I wanted more widely used DBMS so I went with Filemaker which costs the same at the time. It may be faster but the relational stuff made the difference. YMMV.
burypromote

+43
Psychiatry replied on 28 Nov 2013
Under some circumstances, Panorama is slower since it doesn't use indexes and thus has to do a brute force search.
There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.

There are currently no ratings. Write a comment or review now.

Downloads:1,583
Version Downloads:1,582
Type:Business : Spreadsheets
License:Demo
Date:26 Sep 2010
Platform:PPC 32 / Intel 32 / OS X
Price: $299.95
Overall (Version 6.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-4 of 4
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
Panorama 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 is RAM based for speed and flexibility, but with all of the data processing power of a full blown database application. Since 1988 Panorama's unique combination of database and spreadsheet technology has been in use all over the world for everything from custom accounting to medical research, from huge college track meets to blockbuster Hollywood productions. Key features include: - Incredible RAM based speed - Easy to learn and use - Instant searching & sorting - Fully relational - Interactive data analysis - Powerful data manipulation - Flexible database design - Custom forms and reports - Comprehensive import/export - Programmable - Total Recall crash protection Watch demo screencasts at YouTube/provuedevelopment, then try the 15 day no risk trial.


- -