Downloaded 36 times
![CREATE TABLE ORDERS ( id SERIAL PRIMARY KEY, total INTEGER NOT NULL, { ... no: integer, ); total: integer, items: [ CREATE TABLE ORDER_ITEMS ( { price: integer, ...}, id SERIAL PRIMARY KEY, ] order_id INTEGER ... REFERS TO ORDERS, } price INTEGER NOT NULL, ... );](https://image.slidesharecdn.com/pgsql2mongo-101212194411-phpapp01/75/PostgreSQL-MongoDB-22-2048.jpg)
Uploaded byBasuke Suzuki
PostgreSQLからMongoDBへ
This document discusses using MongoDB as an alternative to PostgreSQL. It provides examples of using MongoDB with PHP and Lithium frameworks. Key points include: - MongoDB can be used instead of PostgreSQL for applications with dynamic schemas and large amounts of data. - The document shows examples of basic CRUD operations in MongoDB using PHP drivers and comparisons to PostgreSQL queries. - Importing and exporting data from MongoDB in JSON or extended JSON formats is covered, including date handling differences from traditional RDBMS. - Server-side programming in MongoDB using JavaScript is mentioned as an advantage over traditional databases.
PostgreSQLからMongoDBへ
- 1. PostgreSQL MongoDB CTO @basuke
- 2.
- 4. http://www.assiston.co.jp/ • • ~1000 • 30~80 PV
- 5.
- 6.
- 7.
- 9. • PostgreSQL 7.4 => 8.1 • PHP 4.3 => 4.4 => 5.1 •
- 10. • MongoDB 1.6.3 • PHP 5.3 • Lithium • •
- 12. Lithium • http://lithify.me/ • 5.3 • CakePHP • MongoDB / CouchDB • ↑ RDB w
- 13. PHP MongoDB • Lithium • pecl mongo •
- 14. Item::find('all', array( 'conditions' => array( 'category' => $tag, 'visible' => true, ), 'order' => array( 'position'=>'DESC', 'id' => 'DESC'), ));
- 15. $item_collection->find(array( 'category' => $tag, 'visible' => true, )).sort(array( 'position'=>-1, 'id' => -1), ));
- 16. • mongoimport / mongoexport • JSON • JSON • PHP • •
- 17. • mongoimport -d assiston -c items --drop --file items.dump {"no" : 123456, "items" : [{"at" : 1285679232000}}
- 18. Mongo Extended JSON • http://www.mongodb.org/display/DOCS/Mongo +Extended+JSON • $binary, $date, $oid • $date milliseconds • PHP 32bit int
- 19. • • PHP JSON • TIMESTAMP json_encode • '2010-12-10 17:20:21' => 1291969221 • 1291969221 sec => "||date:1291969221000||" • JSON • "||date:1291969221000||" => Date(1291969221000)
- 20. • PHP w • Python OK • pgmongo
- 21. 1: atomic • • • •
- 22. CREATE TABLE ORDERS( id SERIAL PRIMARY KEY, total INTEGER NOT NULL, { ... no: integer, ); total: integer, items: [ CREATE TABLE ORDER_ITEMS ( { price: integer, ...}, id SERIAL PRIMARY KEY, ] order_id INTEGER ... REFERS TO ORDERS, } price INTEGER NOT NULL, ... );
- 23. 2: • ObjectID • • function(seqname) { return db.sequences.findAndModify({ query:{_id:seqname}, update: {$inc: {val:1}}, upsert: true, 'new': true}).val; } • db.system.js • db.eval("return sequence('abc')")
- 24. 3: mongo ongithub • https://github.com/mongodb/mongo/tree/ master/jstests • MongoDB JavaScript
- 25.