Today's entry, provided by Terry Chay, is entitled Filter Input; Escape Output: Security Principles and Practice.
We are just passed the time of year when we give thanks (in the US anyway) and we are coming up on the time when we all try and be giving. I feel like my last few blog posts have been a little too negative and want to make up for that. So, I want to say thank you to some people for what I have in my professional world.
Daniel deGrandpre and Richard Moss,
dealnews.com
I have known both these guys since I was a kid. I was so
excited when they offered me a full time job working on the
internet. I was in a Dilbert world and they rescued
me. Richard gave me the best recommendation I have ever
heard. I listed Richard as a reference for the job I had
before dealnews.com. The interviewer told me that when she
asked Richard why she should hire me, he said “Because if I had
the money, he would be working for me.” A year later, when
I told her I was leaving …
I like driving. It relaxes me. I especially like driving in the Carolinas versus driving the freeways in Los Angeles. In LA, you have to intentionally calm yourself down before going to the on ramp of the 101, 5 or the 10. Here, in South Carolina, it is possible to drive highway speeds on the highways (in LA, it is possible, but only at night time or early in the morning).When I heard that
Today I received the "MySQL 5.1 Cluster Certification Study
Guide".
I will compare this book to the "MySQL 5.0 Certification Study
Guide" from MySQL Press. This is the book I used to study for the
MCDEV (Certified Developer) and MCDBA (Certified DBA)
exams.
The MySQL study guide was published by MySQL Press which is a
cooperation with a n old-school publisher.
The MySQL cluster study guide is published by Lulu.com
which is an online on-demand publisher.
Lulu.com Cons:
1. The print quality is worse.
2. The paper is less white.
3. The layout is more compact. The margins are really
small.
Lulu.com Pros:
1. On-demand print. This will make updated versions
possible.
2. The book is smaller (small margins) and is very easy to carry
with you (handy if your …
Firstly, I have to apologize. I have been busy with some personal
things and also been looking for a new job, so I haven't had a
lot of time to update my blog.
I have read something on Coding Horror (which is a really good blog, by the
way) about whats called "analysis paralysis".
I myself, often get stuck in this stage. Especially in a
paradigm-rich environment like java, which gives you many
philosophies about how to do things more effectively, when I
myself have to admit that it would take less time to just start
to do some code and make corrections later. For the people, that
have been following my blog, I do talk a lot about theory and not
a lot about action. This is something I would very much like to
change. So I plan to take my idea for " …
mysql connector/odbc 5.1.1-beta is
available.
we didn?t implement all of the features in our original plan, but
we decided to close out 5.1 to new features so that we could work
on getting it to a production (GA) release as soon as
possible.
5.1 has it?s share of bugs still, but we have tackled
the most serious ones, and now that we are done with features
(for the time being) we can focus on making the GA release
shine.
now the race is on to see who gets out a 5.1 GA release first ?
the server or connector/odbc!
Today to debug one of the issue related to InnoDB where the INSERT INTO .. SELECT simply bails with an error as “ERROR 1105 (HY000): Unknown error”; I simply started loading the data onto 5.1 server as it was consistent in 4.1 version (even though it was noted as fixed). So, LOAD DATA INFILE suddenly pops with an error as ..
| [Copy to clipboard][-]View Code | |
1 2 3 4 5 6 7 8 9 |
mysql> LOAD DATA LOCAL INFILE 'venudata-all.txt' INTO TABLE DOCUMENT_DESC FIELDS TERMINATED BY ',';
ERROR 1148 (42000): The used command IS NOT allowed with this MySQL version
mysql> SHOW variables LIKE '%infile%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| … |
In summary this was the longest project that I worked on, other
then rebuilding the backend for Flickr when I first came on. The
inner workings are very complex to achieve real-time
collection-while not affecting page load times of a photo page.
Most of my time was spent on creating a distributed lock once my
DB design was solid.
Things that would really make life easier:
MYSQL AB gets rid of MYISAM and makes PBXT its replacement. I
don't need all the great features of INNODB but I would like
some. I'll go more into this later.
…
Wohoo! Jon Stephens just published an excellent article on the possibilities for
working with XML and MySQL on the MySQL devzone!
I'm very proud that he chose to highlight the lib_mysqludf_xql library of MySQL User Defined
functions authored by Arnold Daniels. Some time ago, Arnold joined the
MySQL UDF Repository and so far he's been the
most active member of the group.
Arnold also took the …
I’ve written an article highlighting some recent developments with XML support in MySQL 5.1 and MySQL 6.0. Topics include:
You can read it at the MySQL Developer Zone.
Alexander Barkov contributed a nifty stored procedure and a very helpful pre-publication review. Thanks, Bar!