Television by Sierraken and B+

[SpriggsySpriggs]

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.

[bplus]

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.

Great! take your time, please don't make this a chore you feel obligated to do but it is fun to share your interests.

[SpriggsySpriggs]

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.

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

Mike,

Here is an example of a start to a database made in MySQL that I can use to accomplish what you are wanting.
 

 

[lawsonm1]

Well, I'm am nowhere close to being even a 'database novice". The last database program I ever did anything with was PC-File running on DOS. Right now I'm trying to figure out the best way to dig through my computer and get a listing of all of the video files I have. Just having a listing, whether or not they are color or B/W, and a category, is a good enough start. Maybe add the year made, and a few actors names? I'm still thinking about the how and what to do so I will be able to understand how to start fleshing out some code. If you all are thinking of a real database, that would be out of my league. Mike

[SpriggsySpriggs]

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
I've got more functions that will be put in there to make all the handling of queries easier and errors more verbose so they can be compared to Oracle's list of errors. I have no problem helping get you a tailor-made database schema to your exact specifications. I can even help you get the data into the database using a CSV file once you get your list together. Trust me, this will be the best way to sort or grab data since it is all handled in the DLL and nothing special needs to be done client side aside from syntax of the query. For instance, say you want any movie starring James Cagney:

Code: QB64: [Select]

1. DB_QUERY "SELECT * FROM videos.Movies WHERE actor = 'James Cagney';"

Or let's say you want any movie with someone named James because you can't remember his last name:

Code: QB64: [Select]

1. DB_QUERY "SELECT * FROM videos.Movies WHERE actor LIKE 'James%';"

Now let's say you wanted to run that query but you want it to appear alphabetically in ascending order:

Code: QB64: [Select]

1. DB_QUERY "SELECT * FROM videos.Movies WHERE actor LIKE 'James%' ORDER BY actor ASC;"

Documentation from Oracle is rather poor but Stack Overflow is any programmer's friend. Give it a thought.