Show management

Silas Pradetto

Silas Pradetto

Graduate Student
Jan 11, 2011
2,130
1
0
Land of Steady Habits
www.concertsunlimited.com
I know there have been threads on this before, but I'm wondering again if something exists off-the-shelf to do the following:

  • Have a list of venues in the database, complete with description, pictures, load-in info, venue contacts, etc
  • Have a list of techs in the database, whether they are freelance or employees
  • Have a list of promoters or clients in the database
  • Be able to create a 'show' and link promoters, techs, and venues to the 'show' such that all the information would be readily accessible via basic query
  • I'd like to be able to automatically inform techs if they are scheduled to work that day, and/or populate a show schedule online for the techs to look at and see what's going on for themselves

I can see this being pretty easy with an Access DB, or even a MySQL DB with some basic code online. But why invest the effort if someone has already done this, right?

Or, if I were to build this system, all online, would anyone be interested in subsidizing my time to get a copy of it?
 
Re: Show management

Silas Pradetto said:
I know there have been threads on this before, but I'm wondering again if something exists off-the-shelf to do the following:

  • Have a list of venues in the database, complete with description, pictures, load-in info, venue contacts, etc
  • Have a list of techs in the database, whether they are freelance or employees
  • Have a list of promoters or clients in the database
  • Be able to create a 'show' and link promoters, techs, and venues to the 'show' such that all the information would be readily accessible via basic query
  • I'd like to be able to automatically inform techs if they are scheduled to work that day, and/or populate a show schedule online for the techs to look at and see what's going on for themselves

I can see this being pretty easy with an Access DB, or even a MySQL DB with some basic code online. But why invest the effort if someone has already done this, right?
Click to expand...

Its not easy. Especially by the time you start writing out edge and corner cases, figuring how to authenticate and unauthenticate users, prevent sql injection, XSS attacks, etc. Very quickly you are looking at developing on a full stack framework. There are dozens to chose from. Then there are backups, and databases across multiple machines, etc. Then if you want to charge for it, payment gateways, merchant accounts, PCI compliance and regular PCI compliance audits.

Not trying to discourage, I think there's a market for it, or something similar. Just be warned, from someone who has been investigating these same sorts of things for over a year, that developing SaaS application functionality is almost always easier than managing users, collecting payment, and dealing with redundancy.
 
Re: Show management

As Phil said it isn't as easy as you think. We have built (and still are building) a system for our uses. It is 2 years and going and the thing changes weekly to accommodate new things. Our system goes a few steps further and does everything from inventory, invoicing, labor, trucking, scheduling, tasks, etc... I would say in a year we will have it ready to market to the public!
 
Top Bottom