(Dathan Pattishall) I believe the future of SQL is to take a lot of primitives that are Computer Science fundamentals and add them as datatypes to expand on the allowed columns today. The idea is of the ilk of a merging of noSQL and SQL for solving problems to make it easier for a new person to dev
Tag: Open Source
MySQL 5.7 : Playing with mysqlpump
(Giuseppe Maxia) MySQL 5.7 comes with a new backup tool, named mysqlpump, which is almost the same as mysqldump with the ability of extracting data in parallel threads.
MySQL 5.7 : Playing with mysqlpump
(Giuseppe Maxia) MySQL 5.7 comes with a new backup tool, named mysqlpump, which is almost the same as mysqldump with the ability of extracting data in parallel threads.
A Few Fundamental Rules for Enlightened Database Monitoring
It’s a pretty fair assumption that if your database is big enough and complex enough to produce metrics that warrant a monitoring system, it’s also complex enough to produce tons of data that are ultimately more distracting than relevant.
A Few Fundamental Rules for Enlightened Database Monitoring
It’s a pretty fair assumption that if your database is big enough and complex enough to produce metrics that warrant a monitoring system, it’s also complex enough to produce tons of data that are ultimately more distracting than relevant.
MariaDB/MySQL: ON REPLACE triggers
(Federico Razzoli) There are several reasons why, generally, in MySQL/MariaDB one should not use REPLACE as a shortcut for SELECT + (UPDATE or INSERT). One of these reasons is the way REPLACE fires triggers.
MariaDB/MySQL: ON REPLACE triggers
(Federico Razzoli) There are several reasons why, generally, in MySQL/MariaDB one should not use REPLACE as a shortcut for SELECT + (UPDATE or INSERT). One of these reasons is the way REPLACE fires triggers.
Using Perl to retrieve direct messages from Twitter, insert messages into a MySQL database and then delete the messages
(Tony Darnell) In two earlier posts, I gave some examples on how to use Perl to send tweets stored in a MySQL database to Twitter, and then how to automatically reply to your retweets with a “thanks”.
Using Perl to retrieve direct messages from Twitter, insert messages into a MySQL database and then delete the messages
(Tony Darnell) In two earlier posts, I gave some examples on how to use Perl to send tweets stored in a MySQL database to Twitter, and then how to automatically reply to your retweets with a “thanks”.
Protecting MySQL Passwords With the sha256_password Plugin
(Todd Farmer) Over the years, MySQL has used three different mechanisms for securing passwords both for storage and for transmission across networks. This blog post aims to provide a brief history of the various mechanisms and highlight reasons to migrate accounts to use the sha256_password mechanis