"SQL" tag
Designing a DB

A Simple Guide to Database Design in MySQL

As the title says, this is an introduction to databases, their purpose and features. It deals with how to design and create a simple database in MySQL. Starting off with the concepts of…

Drupal module development

A Quick-Start Practical Guide to Drupal Module Development

In this article, we attempt to build a simple module by learning some basics of the Drupal Module Core. You can extend Drupal by developing your own modules to suit your applications’ needs….

Big data

Databases in the Era of Cloud Computing and Big Data

We take a look at the directions in which databases are evolving, driven by the twin factors of the “Cloud” and “Big Data”. Let’s start with a quick look at cloud computing, and…

Exploring ZODB

Exploring Software: ZODB, a NoSQL Database

Let’s explore how to use ZODB, a NoSQL database, from Python, with an example that stores and retrieves ‘album’ and ‘track’ data from the database. Most of us are accustomed to using a relational…

Getting started with Clojure

Getting Started with Clojure

Clojure is a dynamic, general purpose programming language that targets the Java Virtual Machine (JVM) and the Common Language Runtime (CLR). It is designed for work and play. If you play around with…

lighttpd + SQLite

lighttpd & SQLite: A Lightweight Web Server and Database Platform

This article demonstrates the setting up of a lightweight Web server and database platform, using the lighttpd Web server and the SQLite database management system (DMS) instead of the LAMP stack. These two…

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…

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…

Security measures

Securing Apache, Part 2: XSS Injections

In the previous article in this series, we started our journey to a secured Apache by dissecting its internals. We then looked at various attacks against Web applications via injection flaws, beginning with…

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.