![]() ![]() Lest you suspect me of decadence, laziness, or the worst, abject ignorance, I have a defense. TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION mode The reason I decided to start a thread is to ask if you can tell me the magic and to me, secret, method of telling maria db to please put itself into I guess my next step is to start running some of those grep things that mean "search for a string in a bunch of files and let me know where you find them" - why is that called grep?Īnyway, this might not be so bad afterall. I will be damed if I can figure out where it is in phpmyadmin it does this. Somewhere in phpmyadmin, it connects using mysqli, just like the php systems I made. some of this is out of sequence, because something else stopped working and there was no way I was going to have to go through all my code to make everything comply with strict sql_mode, and fortunately God loves me, which I know, because it took only a minute to add a line to the php-sql module I wrote and is used by ALL the sql in my system, which I was sure wouild make me world famous and rich someday, so that right after a connection is made to a database, a simple command sets the sql_mode to the non strict mode and life is good again, even though I have bypassed the protection so generously delivered by mariadb to my ignorant old fashioned and not rich world. it didn't care that every field had a default value applied to it when the php application added records, I could not just add the field and say save. It happened the table I was trying to change, probably add a field. it was because strict mode said it was not good enough to fail to provide explicit default values for every field whereas before that was fine. Ok, it only took a few hours to figure out why I was getting messages instead of data. don't answer that.Īs everyone knows, because everyone got the memo and everyone agreed on the night I went to sleep early, mariadb defaults sql_mode to strict, starting a few versions ago. Mariadb helps me by defaulting to a sql_mode, something I did not know had options, yes I want sql mode.I have to say what kind of sql mode? Why? What kinds are there. I love things that are put into my life against my will, that are mandatory because they help in ways I don't know I need. ![]() I don't know why Debian and LAMP started showing up with Mariadb instead Mysql, but I do know a lot of agony was avoided thanks to MariaDB and MySQL both starting with the third letter in LAMP. Then some people with vision and skills I lack took it upon themselves to develop for the benefit of humanity and cost to themselves a fork from mysql, and I probably have it wrong, I think that is something like how we got MariaDB. I knew that was bad, but all in all, time has proven the fears I had when oracle bought mysql have not materialized. Mysql was FREE, a serious DB, not a toy and not encumbered by any of those intricate iron boxes with weird connectors that Microsoft uses to make their systems interconnect and simultaneously, very difficult to integrate. Microsoft SQL SERVER was dirt cheap and thanks to having most of what it did developed by engineers not at micosoft, from whom Microsoft had bought it, and before Microsoft entombed it inside its layers of technology that simplified it by making it almost impossible to work with, for the low low low price of only a few hundred dollars provided you did not deploy it on too big a system but it wasn't FREE. Some years went by, imagine my surprise to discover mysql FREE, doing everything I ever heard of wanting to do with Oracle, only it was FREE. The only barrier I encounted was the software licence fee, less than $20,000 as I recall, but anything over $1,000 was probably next to impossible for me. When I started out in this line of work, I wanted to get a copy of Oracle, which at that time was a word that meant "serious relational database, not a toy," on my computer so I could see it and someday get paid for being able to run it. Mysql is one of the best things that ever happened to me. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |