Select your font size A A A
about us products & services consulting & support news & events contact us

Database Programming - Canada

print this article

This page is about TCEG's capabilities with respect to databases. To learn about TCEG's capabilities with respect to general custom programming, click here.

Our experience with database programming includes:

  • Designing and developing an N-Tier COM web service application that interfaces with MS SQL Server for a government client
  • Creating an e-commerce site with MySQL database back-end for a financial services client
  • Database extraction from a large DB2 mainframe for data analysis
  • Migrating databases from one application to another
  • Systems integration between databases

TCEG provides database data recovery services as well, such as recovering after system tables have been damaged after a hard drive crash or near crash experience. Databases that we can recover from include:

  • MS Exchange
  • MS SQL Server
  • MySQL
  • Postgresql
  • DB2
  • MaxDB
  • Oracle
  • Access
  • Outlook's email database

Most modern programming involves some sort of interaction with a database, even if the database is as simple as plain text files in a directory structure (yes, even that can be considered a database!). For instance, companies often require the following types of database-enabled applications:

  • Client database - for maintaining a unique identity for people who do business with the company.
  • Transaction database - for keeping track of what transactions have been initiated or completed
  • Subscription database - for allowing current subscribers to have access to certain benefits
  • Support ticket database - this allows companies to see what kinds of issues come up more frequently, and allows technicians to share their knowledge

TCEG offers support for Open Source software, such as the following two popular Open Source databases:

  • MySQL
  • Postgresql

The main difference between MySQL and Postgresql is that MySQL is faster for development, but Postgresql contains more enterprise features such as ACID compliant transactions, the ability to write procedures, support for foreign keys, and more.

Other Open Source databases include:

  • Firebird (not to be confused with FireFox, the web browser)
  • Ingres


Most Recent Website and Regional Updates

PHP Programming
A Commercial, Off-the-Shelf (COTS) product may be sufficient. Otherwise a custom application may be appropriate. TCEG provides experienced professional guidance in COTS product selection and integration, as well as custom PHP application development

Managed Outsourcing Program
Outsourcing is often cited as a miracle cost-saving measure. However, great people are valuable, wherever they may be, so outsourcing should be viewed as a way to find more talent, rather than as a way to cut costs.

Industries - Overview
TCEG's consulting services are useful across a wide number of industries.

TCEG - Consultants
Responsible, Accountable. TCEG Linux Support. We Keep Your Servers Running. TCEG Consultants - we help Canadian and US clients with Software Development to Spec.

PHP Programming Practice
TCEG can assist with the support, management and (if applicable) end-of-life support of custom-made PHP applications.

Incorrect key file for table - Try to repair it
Failed writes, hardware failures, software bugs, modification of table by two programs at the same time, and disk limitations can cause this error of: Incorrect key file for table. TCEG can help to diagnose and resolve this problem.


2003-2019 TCEG.
Standardized Services: Data Recovery Service