And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview,…
The post Petition – Help saving MySQL – II first appeared on Change Is Inevitable.
Often times I find myself having to handle a particular portion
of a SQL statement via a script. I've written a lot of
specialized regular expressions over time to handle these tasks,
but the one that I've had to write the most is a basic
'tokenizer' which understands the quoting semantics of a MySQL
statement. That is, it understands `BackTick`, 'Single Quote' and
"Double Quoted" strings.
#PHP Heredoc syntax $regex = <<< END_OF_REGEX / [^ \"'`(),]*\([^)]*\) #match functions like concat(x,"y",`a`.`z`) or sum(`xyz`); |\([^)]*?\) #match grouped items |"[^"]*?" #match double quoted items |'[^']*?' #match single quoted items |`[A-Za-z0-9_ .'\"()+\\-&^%\$+?%\\/\\\\!`]+` #match backtick mysql names |[^ ,]+ #match keywords, operators and aliases |, /xi END_OF_REGEX;
EDIT: After some comments and further testing, I've …
Let's think about a situation where a counter gets updated very often, for example the view counter on a very popular New York Times post. Every time a user refreshes the page, a SQL query updates the counter. It would look something like this:
UPDATE `posts` SET view_counter = view_counter + 1 WHERE id = 123
Now on a very busy site there can be problems with frequent counter row locks. If
Since the early days of GreenSQL, many people have written us asking why exactly they should implement a database security solution if they have already hardened their web application and are using a web application firewall, like mod_security, or even a professional closed source web application firewall such as Imperva, Breach, or F5.
The answer is not as simple as you may think, and I’m not going to preach to you about the great advantages using GreenSQL in front of your MySQL or PostgreSQL Database.
I’m going to highlight a few obvious current situations which will help you see the full picture of your Database security needs.
What is the core of the company?
When you come right down to it, the Database, eventually, is the core of your company or organization. All the information that the company is built upon is located in the Database. Without it, your company or organization cannot …
[Read more]
A big part of the Internet is built on LAMP (Linux, Apache, MySQL
and PHP/Perl/Python). Now Oracle is trying to buy Sun, which owns
MySQL.
It's not in the Internet users interest that one key piece of the
net would be owned by an entity that has more to gain by severely
limiting and in the long run even killing it as an open source
product than by keeping it alive. If Oracle were allowed to
acquire MySQL, we would be looking at less competition among
databases, which will mean higher license and support prices. In
the end it's always the consumers and the small businesses that
have to pay the bills, in this case to
Oracle.
Thanks for all the help in the first Save mysql effort. The blog got hit by more
than 60,000 users and we where able to generate an approximate
number of 10,000 emails to the EC. New …
I don't feel like it to change my patches with every new release of PHP. In order to give something back to the community and to support my laziness, I publish a few patches for the PHP language. Some are really useful, some are quite okay and others are only to help in a more particular case. But read over the new featureset to make you an own opinion.
It is a glorious day today – Poor Man’s Profiler (previously introduced here) just got its own website. Do visit it at http://poormansprofiler.org/ – and contribute to better tomorrow.
I'm pleased to announce the release of Spider storage engine
version 2.11(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
- Add table link background monitoring feature.
- Add table parameter "monitoring_bg_interval" and
"monitoring_bg_kind".
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy!
While I worked on several web projects I collected a few wishes for MySQL (this collection is more user specific - a MySQL internal wishlist will come later) - which I use in most cases. I still fixed a few things, but don't know if they are good enough for production (because I just started hacking MySQL).
Reminder, mark you callendar:
Wednesday January 27th, Join the Sun Startup Essentials Webinar on Security for Web Applications.
A key success factor for Web startups is to protect their applications and data from different security threats. Join this webinar to learn about security challenges and about key solutions such as encryption, authentication, certificates, secure and fault-tolerant storage, chrooted environments. The Sun Startup Essentials experts will also cover how to implement these solutions at minimal cost by using standard and open components such as Solaris, Apache, MySQL, ZFS and more.
Registration limited to members of the Sun Startup Essentials program.
Your company is less than 6 year and 150 employee: Join Sun Startup Essentials >>