Email Alerts
-
Open source databases place pressure on Oracle, SQL Server
Open source RDBMS PostgreSQL is making its way into business' software portfolios. Find out where PostgreSQL is best put to use and why businesses prefer a big name product. Tip
-
Bringing data into OpenOffice 2.0's database
Getting data into OpenOffice Base isn't an intuitive process, but it is an easy one, says expert Solveig Haugland. Learn how to format data for Base, create a database for that data and bring it into Base. Tip
-
Mastering MySQL: Drivers, clustering and remote access
MySQL expert Scott Noyes describes the tricky aspects of clustering with MySQL and upgrading from MySQL 4.0 to MySQL 5.0. Tip
-
Chapter 2, Relational database principles, of 'Beginning Databases with PostgreSQL'
Delve into database architectures, data types, commands for multiple tables and how data is stored in this excerpt from "Beginning Databases with PostgreSQL." Tip
-
Finding the bottlenecks, Chapter 6, of 'Beginning MySQL Database Design and Optimization'
Chapter 6 -- Finding the bottlenecks -- of "Beginning MySQL Database Design and Optimization: From Novice to Professional" covers how to use and alter commands for reading system and configuration variables. Tip
-
Chapter 15 -- Handling file uploads -- of 'Beginning PHP and MySQL 5'
Chapter 15 -- Handling file uploads -- of 'Beginning PHP and MySQL 5' describes role of PHP's file-upload functions
-
Chapter 3 -- Databases with Perl -- of 'Beginning Perl Web Development'
Chapter 3 -- Databases and Perl -- of 'Beginning Perl Web Development' examines the use of open source database MySQL with Perl and connecting to relational databases. Tip
-
Enlarging your Sybase database
In this tip, Dr. Talebzadeh gives helpful examples of removing unwanted transactions and code for boosting your master database capacity. Tip
-
Sybase: Views vs. stored procedures
Sybase expert Mich Talebzadeh describes the similarities between views and stored procedures that can lead to differences in the speed of compilation. Tip
-
Sybase ASE on Linux: Getting rid of database deadlocks
Avoid hot spots and heap tables in Sybase ASE, says Sybase expert Mich Talebzadeh. Find out more solutions for detonating your database deadlocks in this tip. Tip