MySQL The Worst Software Ever … And Best
If you choose WordPress as the CMS (Content Management System) that your Website is designed around, you choose wisely. Sometimes I think back on my decision to use WordPress as being one of the only things that I have ever done right from the beginning, as an Internet Marketer.
However, WordPress takes two (2) software packages to work. That of the WordPress software itself and the relational database management system , MySQL or (RDBMS). These two packages make up the dynamic duo.
The best part of this duo is that both software packages are “Open Source”. Outside of Linux, Open Source can spell trouble pretty quickly. While open source software is free to use, trust me on this, someone pays for it. With WordPress there are “Angel Investors”, with most others, there are empty bank accounts; leaving the software to eventually fall into disrepair.
Most of this stuff lurks around the web until some poor unsuspecting soul happens by and downloads the misery.
MySQL is one of those Open Source software’s that has a pretty good support system, as it is owned by Oracle.
MySQL stands for “Structured Query Language”. And while support is pretty good, it comes at a price if you have issues. Standard will set you back $2000.00 and the Enterprise Edition is $5000.00. They have a $10,000 package if you should need someone to hold your hand.
If you decide to go it alone, expect some of that “misery” I mentioned above. Relational Database; that’s pretty good. I’ve never be able to relate to it.
MySQL is where all of your Websites information is stored. And if you can find it, you are ahead of the game! I’ve never seen such a mess in my life!!!
MySQL is pure pain! That is all there is to it. When you talk about storing your Websites information, in its most basic terms, you are talking about storing your WordPress Blogs Post or Written Text. That’s about a basic as things get and MySQL can store that “basic” stuff in a blue million ways. “What ???”
OK, I write the post, MySQL should store the text …… ain’t going to happen! Instead of taking the written text and storing it, MySQL has to be commanded through PHP on how to store the text. “What ???”
Consider the following:
A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB. These differ only in the maximum length of the values they can hold. The four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. See Section 11.2, “Data Type Storage Requirements”.
“What???”, “Just store the Goddamn Text!” The above is just the beginning of this happy horseshit. The Reference Manual is in 14 sections and 25 categories and is labeled with the “Subtitle”, as “Abstract” at the beginning. “Yeah, I’ll bet!”
The good part about MySQL is that it will work right out of the box with WordPress. No Muss; No Fuss! How cool is that?
However, if you have to make a change somewhere down the line, look out …… ain’t going to happen. You can’t even change the freakin’ name of the database. They say it’s for security reasons, “Whatever !!!”
If you follow this Blog, you know that I try to keep things simple and motivate you to learn a little HTML, CSS and PHP. I don’t even mention MySQL; I’m scared to! However, you will have to develop this skill set as well; and I wish you the very best of luck with that.
And hey, if you should ever run into a derelict script that gives you tons of error messages in the MySQL terminal upon installation or import, simply change the “TYPE=MyISAM” To “ENGINE=MyISAM”, or go ahead and switch to the InnoDB engine to ensure referential integrity constraints, and higher concurrency. “What???” ……
