Tag: databases
Better Queries with MySQL, Part 3: The MyISAM Storage Engine
MyISAM is MySQL's default storage engine, and is probably most commonly used by new adopters of MySQL. The objective of this article is to...
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...
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...
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...
Android Application Development: Playing with SQLite Database
In this article, I will focus on building an Android app using an SQLite database; I assume readers are familiar with the basics of...
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...
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...
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...