"databases" tag
Pranav Pandya

A FOSS Lover’s Tryst with PostgreSQL

Pranav Pandya, a FOSS enthusiast and winner of the EnterpriseDB PostgreSQL contest, shares with us how he made use of PostgreSQL in projects to deliver customer satisfaction. Pranav Pandya, a software specialist, is…

Better queries with MySQL

Better Queries with MySQL, Part 2

Last month, we created a simple table with an index. The idea was to understand how indexes work in MySQL. For this, we populated the table with 100 rows, and ran EXPLAIN with…

Better queries with MySQL

Better Queries with MySQL, Part 1

This article helps you write high-performance MySQL queries, by pointing out the various pitfalls and dangerous misconceptions that developers have. How many times have you found yourself in a situation where your Web…

Time to play with OOo Base

Working with OpenOffice.org (OOo) Base

Let’s explore the power and usability of Base, a database-management program included in the OpenOffice.org (OOo) suite. To get you familiar with Base, we will develop a small database to store the personal…

MySQL performance problems?

MySQL: Drive Your Performance Problems Away!

Here are some simple steps to tune MySQL for performance and scalability in multi-user environments. Also included are some very effective tools, most of which are packaged along with MySQL. You’ve just heaved…

Steve Shine, EVP, worldwide operations, Ingres Corporation

Ingres’ Steve Shine on the Database Company’s Business Model and Plans

Steve Shine, EVP, worldwide operations, Ingres Corporation, was in Delhi as part of his three-city tour of India. When we met with him, he was not only gung-ho about the prospects of open…

All published articles are released under Creative Commons Attribution-NonCommercial 3.0 Unported License, unless otherwise noted.
LINUX For You is powered by WordPress, which gladly sits on top of a CentOS-based LEMP stack.

Creative Commons License.