Pages by Tag
Index of pages filed with the "Databases" tag (listing records 1 to 10 of 12):
- As the Dust Settles...
(Date: Sun 27-Mar-2005 | Comments: 1 | Permalink)
Oh boy, the Urban Mainframe server migration certainly didn't go according to plan. In theory it should have been a simple exercise: copy the MySQL database, CMS and web-server file-system from an aging and under-performing Linux 7.3 server to a new RedHat ... (continue reading) - Technical Weblogs
(Date: Tue 25-Jan-2005 | Comments: 10 | Permalink)
I need to feed (pun intended) my hunger for technical weblogs and add a few more feeds to my blogroll. I am particularly interested in weblogs that cover the following topicsSoftware DevelopmentCPerl / mod_perlRuby / RailsApacheDatabases / MySQLUnix ... (continue reading) - MySQL: Search & Replace
(Date: Tue 25-Jan-2005 | Comments: 9 | Permalink)
I've just finished a little housekeeping on the MySQL database that sits behind this website and I was struck by just how useful MySQL's search-and-replace facility is for this task. mysql> update table_name set table_field = replace(table_field,'replace_that ... (continue reading) - Firefox Search Plug-in for Koders.com
(Date: Thu 18-Nov-2004 | Comments: 3 | Permalink)
I have created my first search plug-in(s) for Firefox. The plug-ins add search options for Koders, a search engine for source code. Koders enables developers to easily search and browse source code in thousands of projects hosted at hundreds of open ... (continue reading) - Perl Development Environment
(Date: Tue 17-Aug-2004 | Comments: 10 | Permalink)
"A craftsman is only as good as his tools," claims the familiar adage. Of course, it depends on how you define "good". In the field of computer programming, "good" could refer to the quality of the programmer's code, or it could refer to that same programmer ... (continue reading) - To: My Anonymous Benefactor
(Date: Wed 21-Jul-2004 | Comments: 0 | Permalink)
I would like to say thank you to whomever anonymously purchased Paul Dubois' "MySQL Cookbook" from my Amazon Wish List for me. Quite frankly, I am stunned by your generosity. Thank you.(continue reading) - Latest Addition: The Dynamic Blogroll
(Date: Fri 28-May-2004 | Comments: 8 | Permalink)
We all know that blogs thrive on linkage and mine is no different to any other. Thus, I have added a dynamic blogroll to the weblog ... (continue reading) - The SQL Holy Trinity
(Date: Fri 7-May-2004 | Comments: 0 | Permalink)
If you are creating a database schema that must pass the test of time then I'd like to share with you a little secret ... (continue reading) - Defending Against Comment Spam
(Date: Tue 23-Mar-2004 | Comments: 27 | Permalink)
One of the problems with running a website that allows users to post content (whether "comments", forum posts or even just a "contact us" form) is that the systems that provide the interactivity are also a channel that spammers can use to pass on their ... (continue reading) - The Lazy Man's Guide to MySQL Backups
(Date: Sat 6-Mar-2004 | Comments: 0 | Permalink)
Andy Budd recently published an incredibly useful guide to MySQL backups over on his weblog. I have added several notes to his "Idiots Guide to Backing-up MySQL on OS X" that might be useful to those of you who are running MySQL. Pop over to Blogography ... (continue reading)
W3C VALIDATE XHTML
W3C VALIDATE CSS