database, mysql, routines, stored procedures, syntax, technology triggers
Question #2 from the September MySQL User Group was whether or not a TRIGGER can affect a different table. Apparently the documentation (perhaps for an earlier version??) specified this was not possible. Tom Hanlon, MySQL employee, put up this example (modified from the original, special thanks to Ralph Navarro for copying it down):
Basically, this …
[Read more]If you've spent any amount of time on the forums, you probably will have recognized Brian among the forum users who most frequently answer posts -- particularly SQL and performance-related questions. Some time ago, I had a chance to ask Brian a little bit about his experience writing Phorum, about his thoughts on open source and MySQL in particular, and on his vision for Phorum in the future...
Again and again the guys from Apache, MySQL, PHP, phpMyAdmin and finally from OpenSSL surprised us over the last weeks with new releases of their software packages. Now after a very quiet week we are proud to announce our own new version containing all these new releases.
New in this version of XAMPP are: Apache (2.2.3), MySQL (5.0.24a), phpMyAdmin (2.8.2.4), PHP (4.4.4 and 5.1.6) and OpenSSL (0.9.8c).
In case of Windows we also upgraded ADOdb (4.91) and FileZilla FTP Server (0.9.18).
When I loaded GigaBytes of XMLs into mysql database with PHP
script, I was thinking about PHP alternatives. Why do I need that
?
1. PHP is slow - I'm speaking about area of data processing and
implementation of algorithms
2. No good cli debugger - I'm just tired of debugging with 'echo'
and 'var_dump'
3. Unpredictable memory consumption - it's easy in processing of
big files to eat all available memory
4. Need something new - I've been using PHP for almost 10 years,
so I want to try something else to refresh my mind.
List of my requirements:
- Stable binding to MySQL, support of new protocol with prepared
statement is necessary.
- good XML handling
- Fast in terms of performance and development
- multiplatform, at least Linux, Windows, Solaris necessary
- under active development and wide community
- web binding
- not Java (I don't like it, as most PHP-guys, I …
Back in July, we made an Eclipse documentation plug-in of the MySQL manuals available for users to download.
In truth, the Eclipse documentation format is actually just HTML; you have to combine the HTML with a plug-in manifest that details the documentation, version number etc so that the documentation is loaded and identified as a valid plug-in element when Eclipse is started.
On Friday, EU internal market commissioner Charlie McCreevy (whose historical ties with Microsoft and similar companies are mentioned in my book) delivered this speech on his intellectual property rights (IPR) strategy. He flew all the way up to Helsinki for an informal meeting of the ECOFIN (economic & finance) Council of the European Union.
In his speech, he said the European Patent Litigation Agreement (EPLA) “is a goal worth pursuing” and that he wanted to involve the EU in the EPLA negotiations “and bring them to finality”. He falsely claims that the EPLA would “offer valuable cost savings”: even Nokia and pharmaceutical giant GlaxoSmithKline have already pointed out that …
[Read more]I fixed a couple of typos in my book No Lobbyists As Such - The War over Software Patents in the European Union. Thanks to Marco Menardi for having pointed me to those typos.
Continuent Ships uni/cluster for MySQL / PostgreSQL , Continuent (Press Releases)
When open source is not enough, The Register, Nick Kew (Article)
Ludd vs. open source, ZDNet, Dana Blankenhorn (Blog)
On Red Hat and Commercial Open Source, JM’s Good Times, John Mark Walker (Blog)
JRuby Steps Into the Sun, Headius, …
[Read more]I have a number of PHP related speaking gigs coming up: