php with mysql

TO DBAs: Database Administrators and other computer type folks are very hard to buy presents for at this time of year. Please help your family and friends out out by printing this off and notating which of the following items your would find acceptable. TO The Friends and Family of a DBA : Yes, they are a pain in the pa-toot to buy a holiday gift for but hopefully this lest will make things a little easier. There are a lot of t-shirt on this list and this is a change to get that one threadbare relic from a long ago computer conference sent to the Valhalla for mangy cotton blend fabrics. Good luck and hopefully you will see something below that will keep you from just handing over a gift card. o Amazon Need to work on your laptop in bed or a variety of angles? Then this Furinno X7-BK Ergonomics Aluminum Adjustable Cooling Fan Laptop Tray Table is what you want, available in many colors. Zazzle Zazzle.com has a nice collection of DBA centric gifts. And in female styl...

MySQL 8 MySQL 8 is now available for testing. The list of features is impressive and I am sure many PHP developers will be interested in having a true data dictionary, invisible indexes, and more. Right now it is in a milestone release. I am still doing a lot of work with 5.7 and found a great way to have 8 around when I needed by using Docker. Follow the Docker install guide for your platform of choice and then run docker run --name mysql8 -e MYSQL_ROOT_PASSWORD=hidave -d mysql:8.0 Checking to See if it Really Works docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES ae1824fc01b5 mysql:8.0 "docker-entrypoint.sh" About a minute ago Up About a minute 3306/tcp mysql8 Note that our instance of MySQL 8 has the container id of ae1824fc01b5 . And odds are your container id will be anything but ae1824fc01b5 . Connect to the Container docker ...

I will be presenting a short lightening talk on MySQL's JSON Data Type for NomandPHP on Thursday the 13th of October . Chuck Reeves will be doing the main presentation on How the 3rd Normal Form Destroyed a Family . Get your tickets here.

I had an interesting phone call from someone wanting to move from MongoDB to MySQL's new JSON Document Store. The big question was 'How do I export my Mongo data into something I can read into MySQL?" The good news is that the folks at Mongo have given us the tools for the hard part of a simple process. For this example I am going to use some test data create previously in a database creatively named dave . The numbers are made up and I am using my name and the names of the canines residing in my home. So a quick peek at the data: $ mongo MongoDB shell version: 3.2.8 connecting to: test > use dave switched to db dave > db.dave.find() { "_id" : 123, "name" : "Dave" } { "_id" : 456, "name" : "Jack" } { "_id" : 789, "name" : "Dexter" } { "_id" : 787, "name" : "Boo" } > bye Dumping That Data First use mongodump -d dave to write out the data much...

The MySQL Document Store functionality allows developers to use a relation database with or without SQL (structured Query Language), also known as NoSQL. The example in this blog is hopefully a simple look at this new feature of MySQL. The example data used is from JSONStudio.com and is a JSON formatted data set for US zip (postal) codes (656K compressed). So download your copy of this data set and lets get to work. Create a collection Collections are tables and below we create a collection name ' zip ' in the test database in the Python dialect. mysqlsh -u root -p --py test Creating an X Session to root@ localhost:33060/test Enter password: Default schema `test` accessible through db. Welcome to MySQL Shell 1.0.4 Development Preview Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help', '\h...

Is it cheating? Is using MySQL without Structured Query Language (SQL) or putting all your data into one column proper? Impossible a year ago and probably thought as a poor/crazy practice until recently, this is a new type of MySQL usage. NoSQL has had a big impact in the SQL world with several relational products from vendors like MySQL, Microsoft, Postgresql and others offering NoSQL interfaces and JSON data types to their databases. Several old timers have come to me asking if putting lots of data in a JSON column is cheating? After all data normalization is part of relational databases and the way to efficiency and speed is well organized data. This higgledy–piggledy fashion of putting an entire document in a column without breaking it down to its component sections does violate the first rule of data normalization. And that has worked for decades pretty well. But things change. Many new development projects start with no idea what their data is going to look like. Maybe, if t...

Password management is an issue for many. It is not uncommon for an organization to require you to changing your password on a regular basis and many have rules on the length and content of passwords. The length and complexity (that require certain amounts of upper & lower case characters, special characters, and numerals) rules try to prevent users from using ' 12345 ', ' qwerty ', or even the word ' password ' itself as passwords. With MySQL 5.7 you can filter out those bad passwords, obscenities, slurs, or other words you do not want used as or part of a password. If the STRONG password policy is set in the my.cnf file, a validate_password_dictionary_file can be specified and you can use your favorite text editor to add the words or phrases you wish to not be valid in that file. Note that words shorter than four characters are ignored. So create a file with a text editor ( mine was placed in /var/lib/mysql/dit) with the banned words, edit the my.c...