I would agree MySQL my not be the platform you want. It is limited in what it can do. I would give Postgress SQL a go. You have the use the 'pg_lo_???' functions to manipulate your objects. They work quite well.
By the way saving images, mp3 etc as blobs or lobs to a DB is not used in many new systems. It is now a rather dated as it is much cheaper, more efficient and even more secure to save the file up on the cloud someplace (ie Amazon S3) and then use the DB to simply point to that file. Blobs and Lobs where a solution to a problem from 20+ years ago when disk-space was very expensive and ban-with was low. If you had to download a 10mg file you would have to break it up into 10~1 mg blocks and lob/blobs where very good at this. At the time someone with a home line over 128k was quite rare 56k being the morm and 1meg being fantastically expensive. ________________________________ From: Kimar Miller <[email protected]> Sent: September 23, 2018 7:34 PM To: [email protected] Subject: Tim Bunce - RE: DBD-DBI Insert Binary Files and using Perl modules in cPanel environment Hi Tim - How's it going? My name is Kimar and I'm looking to find out how to go about the development of a video application using the database MySQL as I own my own Domain name and am renting web host. This app may extend to greater than just a video but more of a multimedia app. I'm a developer based in Florida; I was trained at Atlantic Technical College Coconut Creek. My instructor Ellen Williams; the hardest nut to crack but a very generous woman. Lots of years experience and lots of students. I graduated July 2017 and I've been doing some serious work on my own until I was approached by some friends of mine that have angel investors interested in a security login I've created. I was recently attacked by someone from In2Cable India. I traced the IP that was logged in the cPanel. The deal is my app is more secure than my cPanel that requires me to have a hardware firewall that much I discovered after the breach that there's little I can do about it unless there's a hardware firewall or an app that is integrated in my browser to encrypt my submission to the login until it hits the server. None the less I have ongoing copyrighting processes occurring. You may or may not know about it but copyright protects you more than patents. Explaining what your thing does in the copyright proves you are the creator based on copyright clause "Works of the Mind". I am particularly interested in having the system input the actual audio and video files such as MP3, or MPEG files to the database. I don't care about memory or resources. CREATE TABLE `video` ( `ID` int(11) NOT NULL PRIMARY KEY , `NAME` varchar(40) DEFAULT NULL, `DESCRIPTION` varchar(100) DEFAULT NULL, `BLOBFILE` varchar(20) ); That's the table I used and the web page below <head> <title> Test submit </title> </head> <body> <h1> Test Perl Programming CGI post</h1> <form action="/cgi-bin/post.pl<http://post.pl>" method="POST"> home.pl: Nr 1 w Polsce. Domeny, Hosting, Serwery WWW, Strony, Sklepy<http://post.pl/> post.pl Domeny internetowe: 1,2 mln | Serwery wirtualne: 150 tys. | Sklepy internetowe: 7 tys. | Działamy niezawodnie od 20 lat. Dołącz do 2 mln użytkowników home.pl! <label for="fileupload"> Select a file to upload</label> Name: <input type="TEXT" name="Name"> Description: <input type="TEXT" name="Description"> <input type="FILE" name="fileupload" name="Video"> <input type="SUBMIT" value="SUBMIT"> </form> </body> </html> My question is how can I get the insert to work. I tried reading the books on this topic and did a global search, I long after exhausted all the links available. I also am interested in using modules, is there a better explanation on using the maker object on CPAN its a hard read as I still am lost to some of the concepts in the manual. I heavily rely on the perl.org<http://perl.org> resources so I decided to ask a professional.
