Email Alerts
-
Backing up databases without a GUI
MySQL expert Mike Hillyer recommends server volume-specific utilities for backing up a database on a Red Hat enterpise without using a GUI. Ask the Expert
-
Connecting to a remote database from a local VB app
MySQL expert Mike Hillyer recommends checking for firewalls before trying to connect a remote database from a local VB application. Ask the Expert
-
Choosing between MySQL 4.0 and MySQL 5.0 for client server app development
MySQL expert Mike Hillyer explains why sometimes IT shops should be aggressive with newer versions of MySQL. Ask the Expert
-
E-mail notification for database record additions
MySQL expert Mike Hillyer recommends using a combination of a trigger and a user-defined function in order to setup automatic e-mail notification of record additions. Ask the Expert
-
Faster, more efficient searches for large quantities of data
MySQL expert Mike Hillyer describes the pitfalls involved in performing text searches with mulitple tables versus a single table. Ask the Expert
-
Finding an OS solution for parsing MySQL databases
MySQL expert Mike Hillyer recommends two open source programs that deal with the export, scanning, searching and sorting od data. Ask the Expert
-
Running PostgreSQL in a cross-platform environment
PostgreSQL is a great open source database management tool that's compatible across platforms. This article by Robert Treat explains how PostgreSQL facilitates cross-platform development and points out various tools within PostgreSQL that help databa... Tip
-
PostgreSQL experts: Why are you still using a big bucks database
Learn how PostgreSQL matches up to other commercial database systems, why it's suitable for large- and small-scale enterprises and how it offers admins and users more control. Article
-
Why PostgreSQL can best SQLServer, Oracle
Authors Robert Treat and Jason Gilmore explain why the PostgreSQL open source database management system can take on heavy-duty enterprise jobs. Tip
-
Bug tracking, remote databases and workarounds in MySQL
In this tip, an expert explains how to connect to backup remote databases without using GUIs, recommends an open source solution database management solution for companies interested in superior parsing of MySQL databases and describes a workaround ... Tip