2012/11/22
by admin
11 Comments
PHP MySQL developers are confronted with three PHP MySQL APIs. That is confusing. Since mid 2012 the PHP manual suggests not to use the oldest and original PHP MySQL extension any more to cure the situation. Please, swap out ext/mysql … Continue reading
2012/11/08
by admin
Comments Off on MySQL Plugin development: public API?
The MySQL Plugin API is a neat way to add functionality to the MySQL server. Any user of MySQL is using it: see the storage engine plugins listed by SHOW PLUGINS. There are many types of plugins. For example, the … Continue reading
2012/11/06
by admin
Comments Off on The 2012 edition of ulf-wendel.de
Dear Reader, welcome to the 2012 edition of ulf-wendel.de. Until 2003 I have been working as a web developer focussing on PHP. The 2004 edition of my home page and all its subdomains have reflected this. In the years thereafter … Continue reading
2012/11/06
by admin
Comments Off on MySQL 5.6: SHA256 secure password support for PHP mysqlnd
Pluggable Authentication is one of the many new MySQL 5.6 features. Pluggable authentication adds a capability to use external authentication services (PAM, Windows login IDs, LDAP, Kerberos, …) but also introduces built-in strong SHA-256 hashing for passwords. The SHA-256 Authentication … Continue reading
2012/09/25
by admin
4 Comments
Never trust user input! Injection is a threat . You are the new web developer, aren’t you?. Never trust user input is the first rule I had to learn as a web developer in anchient times. Injection can happen whenever … Continue reading
2012/09/24
by admin
1 Comment
"But 63 slides is too much" has been the initial reply to the draft of tomorrows Top 10 MySQL Tips and Mistakes for PHP Developers web presentation (Tuesday, September 25, 2012: 10:00 CET). SQL injection, security and access control, monitoring … Continue reading
2012/09/24
by admin
2 Comments
A popular NoSQL store claims to have a rich query language. A powerful, portable query language is most important. If not powerful, you have to send multiple commands to fetch the desired data. In the worst case a program must … Continue reading
2012/09/13
by admin
6 Comments
Eine reiche Anfragesprache verspricht ein populäres NoSQL-System auf seiner Startseite. Reicher als SQL? Ist das auffinden von Informationen einfacher, kann ich besser suchen als mit SQL? Das System gehört zur Gruppe der dokumentenbasierten NoSQL-Stores und wirbt mit Schemafreiheit für sich. … Continue reading
2012/09/06
by admin
3 Comments
MySQL and NoSQL go together. In the data center, that’s a known. Inside MySQL, that’s lesser known. MySQL 5.6 is both a puristic key value store and a full-fledged relational database. MySQL could also be developed into a schema free … Continue reading
2012/08/31
by admin
Comments Off on PHP MySQL persistent, cached, pooled connection – for how long?
It is a common question: what is the lifespan of a persistent, pooled, cached, however-you-call-it PHP MySQL connection? What about CGI, FastCGI, web server module? The answer is always the same. Standard I/O file handles, including socket connections, are bound … Continue reading