Does anyone see a problem with this

douglasjn · 2005-06-17, 09:20 AM

I am about to start on a project to build an application which records short video clips, it then stores information about the video clip and prints out a ticket with a unique id no which identifies the video via a thermal printer.

I am intending to use flashcomm server to record the video and store the information in a local mySQL database which I intend accessing via php. I need to use SWF studio to stop the windows printer dialogue popping up when I print the ticket from flash.

Have any of you used flashcomm server to record video locally through swf studio?

Also if anyone has a suggestion for an alternative approach I would be grateful.

It seems a bit strange to me to have to use a webserver running locally just so I can record video and connect to mySQL. I know I can use the ADO pluggin, but I am unfamiliar with this whereas I use php mysql combo every day.

Anyone know of an alternative way to capture the video ? I know that this is a recurring question

Any help or advice / warnings would be gratefully received.

Cheers,
Douglas

northcode · 2005-06-18, 12:47 AM

Do you care what format the video is created in?

What kind of distribution are you looking at? If this is a custom "one off" and you have complete control of the environment then setting up Apache, PHP and MySQL isn't such a big deal. It's a pain and a clunky work around, but it will work.

If you're going to try and roll this out to customers then I'd suggest investing some time in learning how to use the ADO plugin or even creating a custom database in text files or XML (depending on how large the database is going to get).

douglasjn · 2005-06-20, 05:32 AM

Thanks for the reply.

No, I don't care what format the video is created in - to give you a bit more info, this is a two part project - The first bit is housed in a photobooth similar to the sort that you get passport photos done in. The application in the booth allows a member of the public to select a choreographer to work with and then, after having a practice to the music, a video is recorded of them dancing in the booth! At the end of the dance session a ticket is printed with a number on it which they can use to access their video on the projects website.

The second bit is the website where people can view the videos made in the booth.

This is in part why i was going to take the apache php mysql route just so we could connect to the booth and then take a backup of the information in the database as sql and then use that to quickly insert the data into the web database.

The problem which i anticipate is the quality of the video with people moving quickly.

I would rather put another couple of hard disks into the computer and save the videos as avi's or something and then compress them using squeeze so the quality on the site is as high as possible.

Cheers,
Douglas.

2005-06-17, 09:20 AM	#1
douglasjn more time please Join Date: Apr 2003 Location: Scotland Posts: 69	Does anyone see a problem with this I am about to start on a project to build an application which records short video clips, it then stores information about the video clip and prints out a ticket with a unique id no which identifies the video via a thermal printer. I am intending to use flashcomm server to record the video and store the information in a local mySQL database which I intend accessing via php. I need to use SWF studio to stop the windows printer dialogue popping up when I print the ticket from flash. Have any of you used flashcomm server to record video locally through swf studio? Also if anyone has a suggestion for an alternative approach I would be grateful. It seems a bit strange to me to have to use a webserver running locally just so I can record video and connect to mySQL. I know I can use the ADO pluggin, but I am unfamiliar with this whereas I use php mysql combo every day. Anyone know of an alternative way to capture the video ? I know that this is a recurring question Any help or advice / warnings would be gratefully received. Cheers, Douglas

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

2005-06-18, 12:47 AM	#2
northcode Tim Join Date: May 2001 Location: Ottawa Posts: 10,833	Do you care what format the video is created in? What kind of distribution are you looking at? If this is a custom "one off" and you have complete control of the environment then setting up Apache, PHP and MySQL isn't such a big deal. It's a pain and a clunky work around, but it will work. If you're going to try and roll this out to customers then I'd suggest investing some time in learning how to use the ADO plugin or even creating a custom database in text files or XML (depending on how large the database is going to get).

2005-06-20, 05:32 AM	#3
douglasjn more time please Join Date: Apr 2003 Location: Scotland Posts: 69	Thanks for the reply. No, I don't care what format the video is created in - to give you a bit more info, this is a two part project - The first bit is housed in a photobooth similar to the sort that you get passport photos done in. The application in the booth allows a member of the public to select a choreographer to work with and then, after having a practice to the music, a video is recorded of them dancing in the booth! At the end of the dance session a ticket is printed with a number on it which they can use to access their video on the projects website. The second bit is the website where people can view the videos made in the booth. This is in part why i was going to take the apache php mysql route just so we could connect to the booth and then take a backup of the information in the database as sql and then use that to quickly insert the data into the web database. The problem which i anticipate is the quality of the video with people moving quickly. I would rather put another couple of hard disks into the computer and save the videos as avi's or something and then compress them using squeeze so the quality on the site is as high as possible. Cheers, Douglas.