BackWPup: The All-in-one WordPress Files and DB Backup Utility
Your Web server is somehow nuked — could be anything from an attack to a silly mistake from the webmaster. Maybe the only way to get back on track is to restore the…
Dealing with WordPress Post Revisions
Did you know WordPress, like a good boy, saves all post/page revisions in your DB — by default — for those just-in-case situations where you might need to revert to an old version?…
Impact of Big Data on Enterprise Integration
This article explains the new challenges in enterprise integration caused by the advent of big data, and presents some approaches to overcome them. Big data is the latest buzz-word in the industry. At…
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 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…
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…
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,…
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 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, 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…




