SQL Database Development
Create IT develops databases using a number of different systems depending on requirements.
For desktop use with only one or a handful of users we create Microsoft Access applications, however for larger projects we use a combination of Access and Microsoft SQL Server.
Microsoft SQL Server is our preferrred system to deliver scaleable multi-user database solutions both hosted on-premises and in the cloud. We can develop both desktop based SQL Databases using Microsoft Access as a front-end to provide full integration with Microsoft Office, or web based access.
For cloud based data, we use SQL Azure
For cloud based databases we use mySQL for smaller projects or SQL Azure or Postgresql for more complex projects that demand greater scaleability.
We have a considerable amount of experience integrating offline databases with web applications and developing data enabled web applications.
Generally, we charge on a per hour basis, but we will also negotiate a per project rate.
Where the development costs of a project would be prohibitive, but the capabilities of the database application would have multiple uses, we are able develop on a licencing basis. In this case, all rights to the application remain with Create IT, and the end user is licenced to use, but not copy, their version of the software.
- Donations and attendence application for Kindergartens. The system tracks children and enrolled in a number of different kindergartens, and provides reports by term with outstanding fees and payment statements.
- Tracking database for suspicious events with respect to fisheries infringement. Tracks location, events, and the outcome of any prosecution.
- A shipping database for a barge company. The system was designed to track sailings and freight carried, as well as specialised data for a client who operated salmon farms.
- An invoicing and job tracking system used internally by Create IT. This system is able to track products, customers, create invoices, and import data from a variety of suppliers to maintain product prices.