perbedaan SQL dan NoSQL di couchDB

1. INSERT
a. SQL (" INSERT INTO 'nama_tabel'(nama field) ")
b. couchdb (" $ curl -X PUT 127.0.0.1:5984/nama_DB/”no_id” -d ‘{“nama_field” : “value”}' ")
2. SELECT
a. SQL (" SELECT * FROM 'nama_tabel' WHERE 'id'=no_id ")
b. couchDB (" $ curl -X GET 127.0.0.1:5984/nama_DB/”no_id” ")
3. UPDATE
a. SQL (" UPDATE 'nama_tabel' SET 'nama_field' = 'value' ")
b. couchDB (" $ curl -X PUT 127.0.0.1:5984/nama_DB/no_id/ -d '{"_rev" : "no_rev","nama_field" : "value"}' ")
4. DELETE
a. SQL (" DELETE FROM 'nm_tabel' WHERE id=id ")

1. INSERT
a. SQL (" INSERT INTO 'nama_tabel'(nama field) ")
b. couchdb (" $ curl -X PUT 127.0.0.1:5984/nama_DB/”no_id” -d ‘{“nama_field” : “value”}' ")
2. SELECT
a. SQL (" SELECT * FROM 'nama_tabel' WHERE 'id'=no_id ")
b. couchDB (" $ curl -X GET 127.0.0.1:5984/nama_DB/”no_id” ")
3. UPDATE
a. SQL (" UPDATE 'nama_tabel' SET 'nama_field' = 'value' ")
b. couchDB (" $ curl -X PUT 127.0.0.1:5984/nama_DB/no_id/ -d '{"_rev" : "no_rev","nama_field" : "value"}' ")
4. DELETE
a. SQL (" DELETE FROM 'nm_tabel' WHERE id=id ")
b. couchDB (" $ curl -X DELETE
127.0.0.1:5984/nm_DB/id?rev=no_rev ")
Komentar
Posting Komentar