-
How to monitor MySQL / MariaDB query progressThe progress indicator of MySQL or MariaDB long-running commands and queries is extremely extremely and frustratingly coarse. In an index update I’m running now it was stuck in the same state for more than three hours. Thankfully, the pmonitor tool allows us to precisely monitor the progress of many commands. Here’s an example of its application on MariaDB.
Source: blog dds: 2019.11.03 - How to monitor MySQL / MariaDB query progress -
Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL)
In generale va evitato nel modo più assoluto la scrittura di query sql diamiche.Va evitato cioè l’uso lato SQL Server di sp_executesql e EXEC
Di seguito mostriamo come trasformare una query “dinamica” in una “statica”
Read More -
Twitter il gradasso
Aug 25, 2012 · 2 min read ·C’è una cosa fantastica di Internet: se qualsiasi società prova a fare la furba, inserendo delle righe scritte in piccolo quando revisiona la sua API da 1.0 a 1.1, state certi che ci sarà almeno una persona che si leggerà tutto, troverà la fregatura e sputtanerà la summenzionata società.
E’ quello che è successo con Twitter, e Marco Arment analizza nei dettagli le “novità” della nuova Twitter API che passa dalla versione 1.0 alla 1.1.
Vi rimando all’articolo per i dettagli, ma in buona sostanza Twitter sta cercando di fare in modo che “se voi fate qualcosa di interessante con Twitter, bhe ora dovete collaborare con noi…per continuare a farlo….”:
Read More -
XAMPP is a very easy to install Apache Distribution for Linux, Solaris, Windows and Mac OS X. The package includes the Apache web server, MySQL, PHP, Perl, a FTP server and phpMyAdmin.
-
If you're trying to use MySQL with phpMyAdmin, you've set up the phpMyAdmin's config.inc.php, and you're getting an error saying "Client does not support authentication protocol requested by server; consider upgrading MySQL client", you need to set the password on the mysql command line using the OLD_PASSWORD('password') routine.
For example:
Read More -
Slashdot underlines there are too much forks of MySQL on the way.
After leaving MySQL, Michael “Monty” Widenius started its own code fork, backed up with a company.
The nerds think the destiny of MySQL is unclear, but it is still too early to get a clear vision.
Read More -
Oracle buys BEA and Sun buys MySql.
In reply,Migrosoft is hungry and is watching Yahoo :-)
<joking>
Any bets on the next money-based-news?
I'm going for
- Oracle buys Sun: "We need more hardware to run Oracle and WebLogic together! "
- Google buys Oracle: "We have *even* more hardware...come on!"
- Apple buys Google: "So nice LOGO", retrodating a bunch of stock options, I suppose.
- Microsoft buys Apple ("So annoied their are more cool then us!") and shut down all them all so you will end up using their search engine, I hope.
</joking>
Read More - Oracle buys Sun: "We need more hardware to run Oracle and WebLogic together! "