Description of some processes
Web Sites and Pages
Desktop Apps DataBase
Web Sites With Database
|Suffice it to say, a database is defined as anthing that holds data. A pad and pencil can get that done.
Most people associate a database as one to any number of tables on a computer that holds the necessary data for them or their business. They are here and have been for many years. Even the lowly spreadsheet is really a database.
Creating a real live database application is really not for the faint of heart. I have been studying and practicing this for over 25 years.
Our windows Desktop databases are built with an application where several tables can be connected and do math, concatenation, reports, input forms, letters, and much, much more.
We build the database container with the right tables to hold the data first.
Then comes the input forms so information can be placed and viewed in several different ways.
After the Forms, we build the reports so you can print your results to paper, email, pdf, or just about any other need you have.
We make it all look right with the correct functionality and easy work flow for the user.
The ide that I use for this is $999.00 a year minimum. It uses Xbasic programming as it's back end, so any scripts, code, functions and other I need has to be hand coded.
These applications can be a small one user for recipes or for a hundred or more users with thousands of entries. Size and complexity not the numbers of users determines the cost of development.
Small desktop image of an application that was generated. This one has over 30,000 lines of code and 35 tables involved with 40 users all day long everyday. Cost to develope from scratch was $11,500. Not all are that large, but I have developed some where this would be like a Mini-App.
|Let's Take a php application on the web as an example. It could be Java, PHP, c#, c++ and some other ones
PHP is a backend for mostly data control. Backend generally means it is not the part you see a lot of on your browser.
First thing is to design the database and tables as always. Of course, this is almost an art in itself anymore because a small part of the program is imbedded in the databases.
We utilize forms, panels, ux, grids and a few other things that form the basis for the application. They are used for input and showing data.
Then we build the reports. Usually pdf format, but can be any form necessary. We make sure there is ajax involved to help with speed.
I use a php generator for the initial development. It helps me for the basis for the project and all the parts needed. Once done, it is time to modify the generated code one line at a time.
The idea is for someone to click a website, read what they need, input data, save it, view it and print a report.
Speed is important or they lose interest.
I spend over $2000.00 a year on just php related tools to keep my work at the highest standards.
There are 2 types of these to be considered.
Sounds like a lot, and it is unless you are able to sell the use of the applet for 1.99 each times a few million copies.
Look at this from cnn and tell me? www.cnn.com/