Developing By Me

Project Development and Design


Bass Classes and Inheritance

OOP development has several concepts that are unique to it but are now common place in software development. One of these areas is the concept of inheritance. Every language covers these concepts differently yet they all use it for the same reason. Inheritance is the ability for the developer to extend a current class by […]

, , , , , , , , ,

SQL Update

Added new entries to the expanding SQL section. The new sections separate the Datatypes and Functions into the correct groups. Updates to come will include pages on how to script them within each DBMS through SQL.

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

String/Text Datatypes

    String data types hold a series of readable characters. These strings store values in plain text and should not be used for critical data unless it is encrypted. However, string datatypes can hold as little as a single character or several¬†gigabytes depending on the type that is used.   DATA TYPE SYMPLE TYPE Database DESCRIPTION […]

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

Numeric Datatypes

Numeric datatypes hold any integer or decimal numerical value. Some DBMS have specialized fields that are formatted however in most cases any formatting must be handled through a special command in SQL or in the recipient language.   DATA TYPE SYMPLE TYPE Database DESCRIPTION TINYINT(N) NUMERIC SQL Server, MySQL -128 TO 127 NORMAL. 0 TO […]

, , , , , , , , , , ,

Enumerated Datatypes

    Each DBMS handles enumeration differently. The following datatypes are only available on MySQL. The other systems allow for custom datatypes or require a separate table to handle enumeration. It is important to know that these are there and available on some systems.   DATA TYPE SYMPLE TYPE Database DESCRIPTION ENUM(X,Y,Z,ETC.) ENUMERATED MySQL LET YOU ENTER […]

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

Datetime Datatype

    Datetime datatypes are used to store date or time information within the database. Most types are available on all DBMS however some have more precision then others.   DATA TYPE SYMPLE TYPE Database DESCRIPTION DATE DATETIME SQL Server, MySQL, Oracle, PostgreSQL A DATE. FORMAT: YYYY-MM-DD NOTE: THE SUPPORTED RANGE IS FROM ‘1000-01-01’ TO ‘9999-12-31’ DATETIME […]

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

Binary Datatypes

    Binary Datatypes are used to store binary data such as documents, images, or encrypted data. The most common usage is to store files within the database. This has the benefit of keeping them in a dynamic location without needing to constantly update links or locations. DATA TYPE SYMPLE TYPE Database DESCRIPTION BLOB BINARY MySQL FOR […]

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

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 […]

, , , , , , ,


    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 […]

, , , , , , , , , , ,

Previous Posts