"databases" tag
Installing and using PostgreSQL modules

Installing and Using PostgreSQL Modules

In this article, we will learn how to install and use the PostgreSQL modules chkpass, fuzzystrmatch, isn and hstore. Modules add different capabilities to a database, like admin and monitoring tools, new data…

Speed up your cloud

Speed up Your Cloud with Memcached

Is your website running into performance bottlenecks? Does the database or backend feel like a really expensive resource, even though you’ve got a huge cluster set up to improve parallel processing? Read on…

dbShards

NewSQL — The New Way to Handle Big Data

Big data, big data, big data! This term has been dominating information management for a while, leading to enhancements in systems, primarily databases, to handle this revolution. Though there are many alternative information…

A rant on DBAs

FOSS is __FUN__: Get the Basics Right

A few thoughts about databases in general… and some rants about the good old ways. There are a plethora of free/open source databases around, from the good old Berkeley DB, SQLite, MySQL, PostgreSQL,…

PostgreSQL

IT Service Provider Turns to PostgreSQL for Scalability

A S Kumaresan, an Enterprise DB contest winner, tells LINUX For You why PostgreSQL was an obvious choice for an ICT provider. When a client entrusts its database to an IT service provider,…

Testing with DbUnit

Testing Your Databases with DbUnit

DbUnit is ideal as an add-on testing framework when developing applications in Java-based languages, which rely heavily on databases. This article assumes that the reader is aware of basic testing concepts, and tries…

Better queries with MySQL

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 discuss how the MyISAM storage engine works, to enable…

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…

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

Creative Commons License.