Bin-Blog logoBin-Blog

Learn about the latest in Web Development – as soon as I do.

Archive for the ‘Database’ Category

Interactive SQL Tutorial

By • Feb 11th, 2009

I have completed a tutorial that I have been working on for a long time. Its the Interactive SQL(Structured Query Language) Tutorial – it teaches you the basics of SQL. SQL, for those of you who are unaware of it, is the language used to access and manipulate data within a database. It is very simple and very powerful.



Mastering phpMyAdmin: A Review

By • Nov 26th, 2008

Some time ago, I was approched by the publisher of the book to write a review of their book ‘Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle[Affliate link]’. This got a bit delayed because of the plugin week. But I managed to finish the book today – so here is the review. Bottom line – most people are using phpMyAdmin for only the most basic operations(editing data, import, export, etc.). If you are one of them, you don’t need the book – you already know all you need to know about phpMyAdmin. But other(like me) use it for advanced purposes – to manage MySQL, create database/tables, run queries, etc. I would recommend you get this book. It covers everything from basic usage(which is a bit boring and should be skipped over) to advanced stuff(like designer view, configuration options, triggers, innoDB relation options etc.)



Remote Database Backup WordPress Plugin

By • Oct 13th, 2008

My second WordPress Plugin – Remote Database Backup. Its is based on the WordPress Database Backup plugin. If you are a regular wordpress user, you might be better off using WordPress Database Backup plugin instead of my version. But if you, like me, have a local server on your system and has a copy of your site on the local server as well as the online server, you will find great use for my plugin.



Installing LAMP(Apache Web Server/PHP/MySQL) in Debian/Ubuntu

By • Sep 16th, 2008

Installing the LAMP environment on a Linux system is easy if you are comfortable with using the native package management software. If you on a Red Hat/Fedora/CentOS system, that will be yum – and for Debian/Ubuntu systems, that will be apt. This tutorial shows you how to install Apache 2, PHP 5 and MySQL 5 in Debian using apt.



Document Formats

By • Apr 3rd, 2008

In FLOSS circles, March 26 is celebrated as the Document Freedom Day. Document Freedom Day (DFD) is a global day for document liberation. It will be a day of grassroots effort to educate the public about the importance of Free Document Formats and Open Standards in general. This is when I realized that people actually […]



3 Simple Steps to create a Web Installer

By • Jul 6th, 2007

Creating a web installer is not hard – as a matter of fact – it is downright easy. You just have to know a few things. Get the database details, create the database, save the details. That’s it! Getting Database Details A simple four field form will suffice. The important thing to remember is that […]