Database 2 Go!

Is Your Database Schema Limiting Your Productivity?

Issac — Tue, 30 Dec 2008 20:01:07 +0000

The term database is frightening to many people because it seems all geeky and technical. If you have any organized information pertaining to your business, (even something simple like a leads rolodex,) then you have a database. You could continue to use your physical rolodex; you could put all your data into a spreadsheet; or [...]

Why Java RDBMS?

Issac — Sat, 13 Dec 2008 21:39:58 +0000

It is a well known fact that Java as a programming language set off a new paradigm in the software industry. Suddenly, every software programmer worth his salt was amidst software jargons like ‘Platform-Independence’, ‘Cross-Platform-Deployment’ and ‘The Java Virtual Machine’. In fact, it did not take long for Java to usurp the ‘most sought after [...]

MS Access Databases Don’t Have to Look Unprofessional

Issac — Fri, 05 Dec 2008 18:10:53 +0000

Over the years I have noticed that a large number of MS Access databases lack a professional looking quality. In addition, I have noticed that people get caught up trying to display so much information on one form that its users are easily confused. Be assured that Microsoft Access databases have the ability to look [...]

Desktop vs Server Database Software - Which Database Software is Best?

Issac — Thu, 20 Nov 2008 13:22:45 +0000

When buying database software, it is important that you carefully assess what you’re looking for. You might be surprised that while you were planning on buying a server database, a desktop database might actually suffice. On the contrary, you might also be shocked to find out that you have more needs than what a desktop [...]

Recover Data From Corrupt Access Database

Issac — Mon, 03 Nov 2008 01:01:50 +0000

Microsoft Access is the widely used software to create databases, reports, store information, macros, queries, tables, share information, forms, and modules. A database is created to collect and organize information. This information can be about people, orders, products, employees, budget and so on. As the storage space in the database maximizes, increases the chances of corruptions. [...]

Useful MySQL Commands For PHP Development

Issac — Tue, 28 Oct 2008 00:53:25 +0000

When I’m developing PHP applications I normally have a DOS window open so I can run SQL scripts from the command line. Often, this is so I can check that MySQL database tables are being updated correctly while I am running PHP scripts. There are not that many command line tasks I need to perform, but [...]

MySQL and LAMP Software

Issac — Thu, 16 Oct 2008 01:33:16 +0000

MySQL is the world’s most widely used database management system. You don’t have to be a seasoned programmer to use MySQL on its own or as part of dynamic web sites for a very wide variety of database applications. This article introduces MySQL and the other LAMP components. First we will briefly present the history [...]

SQLite Database System - A Beginners’ Guide

Issac — Thu, 16 Oct 2008 01:23:18 +0000

What is SQLite? It is a self-contained, zero-configuration, and transactional SQL database system that makes your database management simpler and easier than you can ever imagine before. It has mostly all features of SQL92. Not just stopping there, this system also supports transactional feature with the ACID capability, which stands for Atomicity, Consistency, Isolation, and Durability. It [...]

Why Learn MySQL

Issac — Fri, 10 Oct 2008 17:26:25 +0000

MySQL is the most widely used database management language. With MySQL even inexperienced programmers can create and modify databases consisting of multiple tables. For example, a database for a personnel-staffing organization might contain several tables including a table of available jobs, a table of available employers, and a table of staffing consultants. Databases that drive [...]

Advantages and Disadvantages to Using MySQL Vs MS SQL

Issac — Fri, 10 Oct 2008 17:23:48 +0000

Two of the most popular database systems used by web developers today are MySQL and Microsoft’s MS SQL server. Both are similar in regards to being storage and retrieval systems. The two systems support primary keys, along with key indices which allow you to speed up queries and constrain input. Furthermore, both systems offer some [...]