Отменен

SQL Table Editor/Calculation

Attached is a mock-up of the UI.

The aim is to create a GUI for creating new fields in an SQL database based off existing ones through mathematical calculations. These calculations would be scheduled to run regularly so that new data entered would have this calculation applied.

Two main functions:

- Find and replace. Create a set of rules to recode into a new field.

o This should support four kinds of rules

♣ Simple numeric swap (eg. 2=3)

♣ Through to lowest (eg. If less then 1 = 2)

♣ Through to highest (eg. If greater than 1 = 3)

♣ All other values (eg. any value not changed by an existing rule = 4)

- Calculations. Create a set of rules that mathematically alters an existing field and inserts into a new field. This may pull use multiple existing fields and multiple mathematical operations (eg. Var1+Var2/2)

o These calculations should include:

♣ Add, subtract, divide, multiply, minimum, maximum, mean, frequency, mode, variance, standard deviation, range, absolute value & log10

Features:

- Each rule should be run at scheduled intervals

- Each rule should be capable of being re-loaded

- GUI to connect to multiple SQL databases

- Can add new tables & save newly generated fields to a table of the users choice.

- The ability to save them and reload rules for editing

- Lists recent fields used for quick selection

- Autocomplete & suggest variable names in search boxes

- A preview window to see the active table, with the ability to search in any field

Навыки: MySQL, PHP

Показать больше: import text file existing table sql server 2005, save images table sql, stored procedure copy data table sql 2005, table sql queries join, association causation potato chip bags standard deviation, mediawiki text editor table, child count tree structure table sql server, access table sql, save image table sql server 2005 using parameter, import csv table sql, remote entry table sql, save xml table sql database, aspnet move profile table sql server, job status table sql 2000

О работодателе:
( 8 отзыв(-а, -ов) ) Sydney, Australia

ID проекта: #12021390

9 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $189

rinsadsl

Hello Good Day I am a graduate of Mathematics and Computer Science. I just went through your requirements and it is pretty clear for me. I had a look at the mockup too. I can do this project for you . Looking forwar Больше

$250 USD за 5 дней(-я)
(743 отзывов(-а))
8.2
RockStone435

Hello.. I have seen the details and I understand most of the detials/rules you have defined. However, I am not sure if you are referring to SQL SERVER or MYSQL. I think you have chosen PHP and MYSQL, so the database wi Больше

$200 USD за 3 дней(-я)
(449 отзывов(-а))
8.5
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 USD за 10 дней(-я)
(343 отзывов(-а))
8.1
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [url removed, login to view] Больше

$222 USD за 7 дней(-я)
(220 отзывов(-а))
7.8
clevery

Hello, I am so glad to bid your project. I fully understood your requirement and all features are well known for me I have full experiences of developing php apps for sql. I would like to discuss about more details Больше

$255 USD за 3 дней(-я)
(4 отзывов(-а))
5.5
ITbeckham7

Hi,bro? Thank you for taking the time to review our Bid. In my opinion "Quality is never an accident." . My first aim to provide u quality and professional task. It will really be a great opportunity for us in Больше

$277 USD за 3 дней(-я)
(15 отзывов(-а))
4.4
kartickkoley1995

Greetings! I’m an expert, having very magnificent expertise on WordPress and Search Engine Optimization, various kinds of Administrative support, Graphics Design like Logo, Banner, Brochure, Business Cards and so on re Больше

$111 USD за 3 дней(-я)
(13 отзывов(-а))
4.1
bestit4u

Hi, I am very interested in your job. I just saw your job description and got sure. I am a developer with over 4 years of experiences in sql. If you hire me, you will get satisfied result in time. Please send pm to Больше

$222 USD за 3 дней(-я)
(2 отзывов(-а))
4.2
dominikgyecsek

Hi, I'm a UK based Full Stack Developer with over 3 years of experience. After I have got a better understanding of the full scope and the exact requirements of the project there is definitely a room for negotiation on Больше

$200 USD за 12 дней(-я)
(1 отзыв)
3.7
BillyPons

Dear Sir I have read your job description carefully and I can mange your job perfectly. I am talent in php, mysql database and I am good in database processing. Hope to discuss more. Thanks

$222 USD за 3 дней(-я)
(2 отзывов(-а))
4.0
blueblokers

We are experienced in PHP, HTML, JAVA, WORD PRESS, BOOTSTRAP, WEBSITE DESIGN, JAVASCRIPT, DOT NET, MYSQL, C# PROGRAMMING, AND ANDROID… So we can able to provide good and quality work. You guys don’t afraid about your Больше

$183 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
$200 USD за 6 дней(-я)
(0 отзывов(-а))
0.0
joybigj

sir, I provide you exact things what you actually need with minimum cost.

$30 USD за 1 день
(0 отзывов(-а))
0.0