I’ve been researching databases for a while now, trying to determine which application is best for my use case. I am a music teacher looking to use a database to help organize the logistics of my program, including demographics and class organization as well as retain and grade student in work in images, PDFs, video and audio.
I’ve narrowed down my choices to Filemaker and Panorama. I’m intrigued by the upcoming release of Panorama X for its programmability and speed. However, I’m concerned about how PanX will handle all I want to “throw at it” in media representing student work.
I believe Filemaker (from my remembrance using it years ago) stored “attachments” in “containers” within records. How does Panorama X handle the storage of media within records?
If PanX has to pull all the media into RAM, I would think that would be a non-starter for the amount of images, video and audio I’d be incorporating. Does it store such attachments in an app container folder on disk? If Panorama X isn’t really suited to this use case, I’m willing to accept that and move on. Any guidance would be appreciated. Thanks!