You know, along similar lines, I was thinking of writing a program that would have a list of all of my videos and movies, in sort of a database arrangement, then you could search by title ot some sort of tagging, and then have it kick off VLC to play the movie. Any thoughts? Mike
You know, along similar lines, I was thinking of writing a program that would have a list of all of my videos and movies, in sort of a database arrangement, then you could search by title ot some sort of tagging, and then have it kick off VLC to play the movie. Any thoughts? Mike
My apologies to SierraKen and Bplus if this is hijacking your original post. If a new thread is best, I will certainly do it.
My apologies to SierraKen and Bplus if this is hijacking your original post. If a new thread is best, I will certainly do it.
That ain't working
That's the way you do it
You run SCREEN ZERO on QBTV
That ain't working
That's the way you do it
Get your Bit Coin for nothing and your source for free
I want my... I want my... I want my new QB.
But if you really want to be in dire straights, you need FreeBASIC for that.
The second part - how to save this information. Is enough a huge text file, which is full of links to specific files on disk? Or rather a binary file where photos (photos from individual albums or movies) will be stored? Or save it as a database? Some programmers talked about mySQL here, could it be used? (I have no experience with that).This is along the same idea I had for myself with playing music. I was going to store a list of songs in a MySQL database on my computer with all the information in there stored like tags to reference album, artist, year, title, writer, length, etc.... I just never got around to doing it. Too lazy. This, with videos and movies, would be an excellent way to use it. I am pretty good with MySQL database creation and using it with QB64. Just don't use PHPadmin. Use MySQL Workbench for any kind of management of the database. Storing and getting data is super simple with MySQL. It's the best way to get the data you want. Sorting the data is as easy as pie because you can determine the sort in your query. No need for QB64 sorting functions. I'd be happy to help with doing a MySQL part of this.
This is along the same idea I had for myself with playing music. I was going to store a list of songs in a MySQL database on my computer with all the information in there stored like tags to reference album, artist, year, title, writer, length, etc.... I just never got around to doing it. Too lazy. This, with videos and movies, would be an excellent way to use it. I am pretty good with MySQL database creation and using it with QB64. Just don't use PHPadmin. Use MySQL Workbench for any kind of management of the database. Storing and getting data is super simple with MySQL. It's the best way to get the data you want. Sorting the data is as easy as pie because you can determine the sort in your query. No need for QB64 sorting functions. I'd be happy to help with doing a MySQL part of this.
If you start a thread on Getting Started with MySQL, I'd be interested. I see it talked about on several forums and am curious.OK! It will have to be on a weekend or a lunch break probably and I'll more than likely have to bring in @Juanjogomez in on it to give some more tips and tricks. He seems to really know his stuff in MySQL as well.
OK! It will have to be on a weekend or a lunch break probably and I'll more than likely have to bring in @Juanjogomez in on it to give some more tips and tricks. He seems to really know his stuff in MySQL as well.
To Petr's post; I have four folders with video, Home Video, Movies, Video, and YouTube (I have a program that downloads stuff from YouTube). Each of these folders has subdirectories that contain avi, mp4, mpg, and mpeg files. I use VLC to play them.Mike,
As a start, I am thinking of the following tags; name of the video clip, B/W or color, length of clip, type of clip (home movie, war movie, computer tutorial video, etc.). So I believe I will certainly need a search and sort capability (bubble sort - cuz I easily understand that one!).
Mike
Well, I'm am nowhere close to being even a 'database novice"....If you all are thinking of a real database, that would be out of my league. Mike@lawsonm1 Mike, trust me. MySQL is not beyond you. It is super easy to learn. I had to learn it mostly on my own. Now I use it daily in my job. The syntax is simple and I'd be happy to help you get started on it. I'm going to try making a post here all about how to get started in MySQL..... All the way from downloading and installation to schema/table creation and data insertion. I'll also be updating the Wiki for the SQL client found here: http://www.qb64.org/wiki/SQL_Client (http://www.qb64.org/wiki/SQL_Client)