Developing By Me

Project Development and Design

technology

SDLC Part 1, Overview

Overview      Designing complex systems is always important for any company. The smaller organizations tend to let some aspects relax too far in order to maintain timelines and profitability. The problem with this is that there is a significant lack of quality, durability and stability in the product’s first few versions. In a similar […]

, , , , ,

Consulting Services

We are currently accepting clients for consulting services. Our services include Software Design and Development Review, Documentation Review, Project Management Assistance and code level analysis and review. In addition we are planning to release several new articles in our Quest and Mission series in addition to general software development articles. Stanley Handschuh

, , , , , , , , , , , ,

Software Design

Welcome to Software Design and Programming!     In previous articles more complex concepts were examined in brief. However, this section of the game development process will be taken into specific areas required to produce a fully formed game concept. The software development process is long but through these pages it should be fairly easy to understand […]

, , , , , , ,

Data Types

There are different data types for the RDBMS and the following lists most of them. It is also important to understand that if a database does not have a specified type it will try to CAST it dynamically to the correct field time. Binary Datatypes Datetime Datatypes Enumerated Datatypes Numeric Datatypes String Datatypes

, , , , , , , , , , , , , ,

DROP Statement

    The DROP statement will remove a table from the schema. Just like other table alterations, this needs to be handled with the greatest of care. The problem is once a table is dropped the data is lost. It is commonly used for temporary tables and should not be applied to permanent tables unless the DBA […]

, , , , , , ,

RENAME TABLE

    The last option to MODIFY a table is the ability to rename the table. Like other modifications this requires FOREIGN KEY constraints to be removed prior to the action. After this has been done any constraints can be reapplied and the database will have no performance changes. However, it is important to understand that changing […]

, , , , , , , , , , ,

ALTER Statement

    The ALTER statement is used when a table needs to be updated. After the creation of the initial table there may be a need to add, update or remove different fields without rebuilding the whole table. The ALTER statement allows this to happen and it has three options ADD, MODIFY, and DROP.   ALTER TABLE […]

, , , , , , , , , , ,

CHECK

    The CHECK constraint is a bit different than the others. This constraint allows the DBA to limit what information can be inserted into the field. For example if it is a number for a lottery drawing then the numbers must be between 1 and 46. If the number is outside of this range SQL will […]

, , , , , , , , , , ,

UNIQUE INDEX

    Most databases use a standardized format for building UNIQUE keys. The standard syntax does work on most databases. The following table displays how to create a UNIQUE key in the different database engines.   SQL Syntax Description SQL Database CREATE TABLE table_name (id INT NOT NULL,UNIQUE (id))   Creates a UNIQUE index when the table […]

, , , , , , ,

INDEX

    Indexes are easy to create but they are not always easy to manage but they speed up the search results. There are three types of indexes. The first is the PRIMARY KEY which is indexed by default and must be UNIQUE. The PRIMARY KEY can be either a single column or multiple columns as long […]

, , , , , , , , , , ,

Previous Posts