create javascript database abstraction class

已取消 已发布的 Aug 4, 2010 货到付款
已取消 货到付款

I'd like someone to create a Javascript class to provide functions to abstract client-side sqlite databases (an HTML5 feature). For Webkit-based browsers (Safari), client-side databases are built-in: [url removed, login to view] For Firefox, you'll need Google Gears: [url removed, login to view] [url removed, login to view] I only care about Webkit-based browsers and Firefox for this project. You may ignore Internet Explorer. The idea is that I would be able to call a function like: var db = dbOpen( dbName, version, description, size ); [url removed, login to view]( 'CREATE TABLE entries (id integer not null primary key autoincrement, some_data TEXT NOT NULL);' ); [url removed, login to view]( 'INSERT INTO entries ( some_data, 'just testing!' );' ); [url removed, login to view]( 'INSERT INTO entries ( some_data, 'more data!' );' ); var result = [url removed, login to view]( 'SELECT * FROM entries where some_data = ?', [some_data] ); for ( var i = 0; i < [url removed, login to view]; i++ ) { [url removed, login to view]( result[i]['id'] + ' = ' + result[i]['some_data'] ); } The second parameter to the "execute" function should be an (optional) array. The idea is to call a single function, and the javascript class would detect the browser and determine how to correctly execute the SQL, or open the database, or return a result set that is in the form of some object or array that I can easily loop through and get specific row & field data from. Please ensure that the javascript class is optimized for Webkit-based browsers. If it's slower in Firefox, that's OK (for example, when returning the result set, I'd prefer that Firefox conforms to the WebKit result set format). For example, Webkit result sets look something like: [url removed, login to view](i).field Firefox (using Google Gears) should return its result in this format, too, so that the return result formats are consistent. In addition to your Javascript class, please provide a clear example showing how it works, and how to loop through the result set.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Employer's environment--Deliverables must be installed by the Worker in ready-to-run condition in the Employer's environment.

b) For all others including desktop software or software the employer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project.

## Platform

html5, webkit-based browsers (Safari, Chrome), Google Gears, javascript

JavaScript PHP XML

项目ID: #3625308

关于项目

3个方案 远程项目 活跃的Aug 6, 2010

有3名威客正在参与此工作的竞标,均价$85/小时

customizedata

See private message.

$85 USD 在5天内
(100条评论)
5.6
erpoojasharma

See private message.

$85 USD 在5天内
(1条评论)
0.0
radhecoders

See private message.

$85 USD 在5天内
(1条评论)
0.0