TechRepublic : A ZDNet Tech Community

300 Technical articles for

mysql

  • Subscribe to this listing via:
  • RSS
  • Email
Related Tags: MySQL (717 results), MySQL 5.0 (17 results), MySQL AB (7 results)
Simplify your code with MySQL transactions and prepared queries, and the Perl DBI
This article is also available as a TechRepublic download, which includes the code listings in a more manageable text file format.The behind-the-scenes logic of many Web applications ofteninvolves repeatedly running the same database query with different arguments,or executing a set of related queries as an all-for-nothing block. To supportthese requirements,...
Tags: Software engineering/development, database, Contributor Melonfire, MySQL, Perl DBI, Perl
Technical articles 2006-11-29
SolutionBase: Supercharge your Web site with XOOPS
Building a dynamic Web site needn't be a chore of tedious programming. Using a tool like XOOPS, you can get a powerful site up and running without a lot of effort. Jack Wallen shows how it works.This article is also available as a TechRepublic download.Recently I wrote a series of...
Tags: Web site development, Channel management, Web technology, OPEN SOURCE, Databases, Content management, Jack Wallen, Web, Web site, XOOPS
Technical articles 2006-11-14
Manipulate dates and time with these 10 Perl CPAN modules
This article is also available as a TechRepublic download.The ability to manipulate dates and times is fundamental tomost programming languages, and Perl is no exception. However, when it comes to moreadvanced temporal processing, the bare-bones capabilities built into Perl mayoften seem insufficient. In such situations, it's a good idea to...
Tags: Contributor Melonfire, Perl
Technical articles 2006-11-03
Collax Business Server offers appliance-like simplicity but limited flexibility
Collax Business Server is a Linux-based system designed toact as a "server in a box" solution. The free basic version contains all of theessentials for a simple server in a Windows environment. For an additional fee,Collax offers Exchange-compatible e-mail servers, virus scanning, and more.Collax is based on the PyNIXgeneric distribution...
Tags: Collax, Justin James, password, server
Technical articles 2006-10-17
MODx shines as an open source CMS for content-based Web sites
MODx is an open sourcecontent management system CMS written in PHP, ready for use on any platformthat supports PHP. Although the project describes itself as a "ContentManagement Framework," MODx functions superbly out of the box as a CMS as well.The project is current at version 0.9.2, but don't let that...
Tags: content management system, Justin James, MODx, MODx team, open source, Web, Web site
Technical articles 2006-10-12
Protect sensitive Web site data by encrypting information with MySQL
If you're running a Web application using MySQL, chances aregood that it has passwords or other sensitive data stored somewhere within it.Securing this data from hackers or snoopers is a critical concern, both toavoid unauthorized use or damage to your application and to retain yourcompetitive advantage. Fortunately, MySQL comes with...
Tags: Contributor Melonfire, Decode, encryption, MySQL, password, SELECT DECODE, Web, Web site
Technical articles 2006-10-09
How do I? Install, configure and integrate PHP and MySQL on Windows?
PHP and MySQLare a powerful combination when it comes to providing dynamic content to youruser base. Over the years, these two products have grown well beyond theirinitial niche and now power some of the world's busiest sites. While bothproducts are open source and initially ran on UNIX/Linux, for quite some...
Tags: Application Server role, Microsoft Windows, MySQL, PHP, Scott Lowe MCSE, server
Technical articles 2006-10-03
Build a quick and inexpensive content management system with phpWebSite
I've been creating and running content management sites atvarious levels and sizes for nearly a decade now. I've rolled out sites withmany different tools from Adaptive Website Framework to Zope. Every tool seemsto have its pluses and minuses (with most leaning toward the minuses.) Butabout five years ago I happened...
Tags: content management system, Jack Wallen, phpWebSite, tool
Technical articles 2006-10-03
Right Tool For the Job: Nessus
The NeedVulnerability assessments are one of the key tools thatinformation security professionals use to learn about their networkenvironment. With the increasing quantity of threat agents and governmentregulations that carry harsh penalties, businesses have to know where theirsecurity vulnerabilities exist and now to mitigate them. I had an opportunity a little...
Tags: job, Nessus, Nessus 3, Shannon Snowden, tool
Technical articles 2006-09-28
Build your own RSS client with PHP and the PEAR XML_RSS package
RSS, also known as Really Simple Syndication or RDF SiteSummary, is a file format which allows Web sites to publish and syndicate thelatest content on their site to their users. An RSS "feed" isexpressed in XML; and as a result, it can be read by any client capable ofparsing an...
Tags: Â Â Â Â Â Â Â Â Â Â Â, Contributor Melonfire, PEAR XML_RSS, PHP, RSS, RSS feed
Technical articles 2006-08-28
Ease database management and automate functions with triggers in MySQL
In SQL terms, a triggeris "procedural code that is automatically executed in response to certainevents on a particular table in a database" Wikipedia. More simply, it is a stub of code that isautomatically activated when a particular database event, such as an INSERT or DELETE,occurs. Triggers are handy for logging,...
Tags: Contributor Melonfire, database, database management, MySQL, Query OK, trigger
Technical articles 2006-08-23
Automate your network monitoring process
As your network starts to grow, you need a way to automate the tedious process of monitoring your servers and network. Luckily, there are plenty of solutions out there, from freeware to commercial enterprise packages. Monitoring the health and status of network components is a big part of...
Tags: Servers, Deb Shinder, NETWORKING, Performance management, network monitoring, network, monitoring, server, monitor, performance, SMB Strategies Newsletter, Disk, Monitors & Displays, Hardware, Components
Technical articles 2006-08-14
Easily integrate PostgreSQL with .NET
The open source software community has had a huge impact onthe software industry. The quality and type of applications available via opensource licenses are impressive.While MySQL has garnered most of the attention withrespect to open source database solutions, there are plenty of other options,such as PostgreSQL. This week I take...
Tags: Microsoft .NET, Npgsql, PostgreSQL, Tony Patton
Technical articles 2006-08-08
Easily integrate PostgreSQL with .NET
The PostgreSQL database server provides a reliable, robust database solution at no cost. Tony Patton walks you through the steps of using PostgreSQL as the backend for .NET applications. The open source software community has had a huge impact on the software industry. The quality and type of...
Tags: Microsoft .NET, PostgreSQL, Npgsql, Databases, Tony Patton, .NET, open source software community, .NET Newsletter, Database, Difference, Listing B, PostgreSQL Database Server, Open-source Software Community, PL/pgSQL, PL/sgSQL, Npgsql Data Provider, Listing C, Listing E, Enterprise Software, Software, Data Management
Technical articles 2006-08-08
Take these six steps to secure valuable and sensitive data in MySQL
The most valuable asset for technology-based organizationsis usually the customer or product information in their databases. And so, acritical part of database administration in such organizations consists ofsecuring these databases against outside attack and hardware/software failures.In most cases, hardware and software failures are handledthrough a data backup regimen. Most databases...
Tags: Contributor Melonfire, database, MySQL, password
Technical articles 2006-08-02
10 Perl CPAN modules for manipulating specific file formats
In your Perl development, it's quite likely that you willencounter files in different formats -- XML, PDF, CSV, RSS-- and different binary data formats. Your Perl application may need tomanipulate these files, either reading from them or writing to them. You can simplify this task by turning to the ComprehensivePerl...
Tags: Contributor Melonfire, database, Perl, TAR
Technical articles 2006-07-24
A product review of the Drupal Content Management System, does it make the grade?
I havespent the last few years looking for the right CMS system. Drupal has been getting a lotof attention lately. For example, SpikeSource pushes it in conjunction with MySQL. I last tried to useDrupal (note the word "tried") about eighteen months ago. With therelease of version 4.7, I decided that...
Tags: content management system, Drupal, Justin James
Technical articles 2006-07-07
Implement MySQL-based transactions with a new set of PHP extensions
Transactional support has long been on the wish list of mostMySQLdevelopers and, with the release of MySQL 4.0, this wish was finally granted.Not long after MySQL 4.0, PHP 5.x was released with a new MySQL extension, MySQL Improved, which allowed PHPdevelopers to access these new transactional capabilities using native PHPfunctions....
Tags: Scripting languages, Databases, Contributor Melonfire, PHP, MySQL
Technical articles 2006-06-20
Performing common Access tasks in OpenOffice.org 2.0's Base
While OpenOffice.org has always provided database front endtools it never really contained its own database application. With 2.0,OpenOffice.org now comes with Base, which still provides an easy-to-usedatabase manager but also provides fully integrated HSQL database engine, whichstores data in XML files. Now you can create and modify tables, forms, queries,and...
Tags: Base, database, Greg Shultz, Microsoft Access, OpenOffice.org
Technical articles 2006-06-12
Beefing up SQL Server 2005 Express Edition
Get the full benefits of SQL Server 2005 Express Edition by downloading the extended versions from Microsoft's site. If you're still hemming and hawing about whether you need the Express Edition, find out when it may come in handy. SQL Server 2005 Express Edition is a freely available ...
Tags: Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, SQL Server 2005 Express Edition, Databases, Arthur Fuller, Express Edition, Management Studio, SQL Server Newsletter, TechRepublic Inc., Enterprise Software, Software, Data Management
Technical articles 2006-06-12


Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now
IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now

SmartPlanet

Click Here