Javascript DB Admin 2

Færdiggjort Opslået Jan 7, 2009 Betalt ved levering
Færdiggjort Betalt ved levering

RdbAdmin

Background:

RdbHost provides SQL databases as a web-service. A client can sign up for a account (which includes a database), and then post queries to that database using http POST requests. Any results are returned as XML or JSON.

A very rudimentary interface is at:

[login to view URL] . To try it, use account name 'r000005' and no password. There is one table, 'test'. That account has only 'SELECT' privileges, sorry.

The Project:

Reimplement 'PHPMinAdmin' (NOT PHPMyAdmin) as a javascript application, using the rdbhost API, and 'XMLHttpRequest' to query the database.

PHPMinAdmin is a PHP script (server-side) which acts on the database through a local database connection, and formats results before sending them to the browser. RdbAdmin will be client-side, acting on the database through the RdbHost webservice. The functionality will be page-for-page identical, with the specific differences (mostly feature eliminations) listed below.

PHPMinAdmin is an open-source product, and it can be used as a 'cut-and-paste' source of html templates and javascript. Some parts of its functionality are implemented with javascript already, and those can be copied and adapted.

Use the JQuery library (alternatives such as MochiKit or Dojo can be considered) wherever it applies, in preference to writing new code.

You will have an account on the server to host downloads, but server-side code execution is neither required nor allowed.

There is no documentation at this point, for the RdbHost API, but the above mentioned 'sql_form' page is definition by implementation of how the webservice works.

Changes from PHPMinAdmin:

1) Each account has only one database, and the creation of databases is handled by existing code. The front page of PHPMinAdmin (with the choose/create database, privilege and processlist functions) can be replaced by a simple account-name/password form.

2) The 'dump' options can be eliminated, as that is handled by existing code.

3) The 'alter database' option can be eliminated.

4) Report execution time with all result displays so that users can tell how long queries take.

5) PHPMinAdmin is written for MySQL admin, and RdbHost uses postgresql, so some details of the interface will need to change accordingly. Sequences, for example, would need to be addressed, while 'auto_increment' option is no longer relevant.

6) At RdbHost, table encoding is always 'utf8', so encoding options can be eliminated.

Reference:

[login to view URL]

The code should be documented, in English, as it will become open-source (LGPL), and serve as a reference for anybody writing javascript code for use with rdbhost.com.

AJAX

Projekt ID: #337158

Om projektet

14 bud Remote projekt Aktiv Jan 15, 2009

Tildelt til:

zhukaster

Please feel free to contact mCN I can do this javascript db

$750 USD in 15 dage
(6 bedømmelser)
4.2

14 freelancere byder i gennemsnit $1146 timen for dette job

webexpertz

I am interested. Thanks, Webexpertz

$1500 USD in 25 dage
(10 bedømmelser)
6.8
Arenabpo

Hello, we are web application experts from Shanghai China, i have read your requirements detailly, we can do this job for you and we can start right away. Thank you!

$1000 USD in 15 dage
(39 bedømmelser)
6.5
Georgia

I am interested.

$1400 USD in 40 dage
(11 bedømmelser)
6.6
tisindiadelhi

Please refer to PMB for more details.

$1400 USD in 20 dage
(1 bedømmelse)
4.6
Team21

Hello, Have small questions: In project descrip[tion you set Postgre database? Do you need this system will work only for this database? Or for other also?

$1500 USD in 10 dage
(7 bedømmelser)
4.2
Mousers

Hello, Please check PMB Thanks

$1250 USD in 20 dage
(4 bedømmelser)
3.1
zhuzhaohua

Aha, I am very interested to the project, please check the pmb for detail, thank you very much, and look forward to your reply.

$750 USD in 15 dage
(3 bedømmelser)
0.0
phpguyindia

Hi, I am Exper in JSON, AJAX, already worked on PRoduct based project of healthcare domain that is based on ajax, json, please reply me for more detail. Thanks, Pankaj

$1500 USD på 1 dag
(0 bedømmelser)
0.0
zweistein

I am a developer from Croatia, with previous experience in writing AJAX powered PHP web applications with jQuery. Feel free to contact me for any additional details and inquiries.

$950 USD in 20 dage
(1 bedømmelse)
0.0
fugenx34

Fugenx Technologies is a team of experts dedicated to Web development with updates technologies like Ajax, Ruby on rail, Joomla web 2.0 services. Professionals on php, html, xml, java scripting.

$800 USD in 20 dage
(0 bedømmelser)
0.0
vivanov

Please check PM for details

$1300 USD in 20 dage
(0 bedømmelser)
4.3