ืืขืื, ืคืจืืื ื. ืืืืืขืจ ืืืจ ืืืื ืคึฟืึทืจ ืื ืจืืข ืืืื ืคืื ืื ืืืึท ืืึธืืืืืึทืก, ืืืจ ืืืืื ืืื ืืืจ ืืขื ืืึทืืขืจืืึทื ืืืึธืก ืืืจ ืืืืขืจืืขืืขืฆื ืืื ืึทื ืืืกืึทืคึผืืืฉืึทื ืคืื ืื ืงืึทืืขืจ ืคืื ืึท ื ืืึท ืืืึทื ืืืืฃ ืืขื ืงืืจืก .
ืึทืคึผืคึผืืืงืึทืืืึธื ืืขืืืขืืึธืคึผืขืจืก ืคืึทืจืืจืขื ืืขื ืึท ืคึผืืึทืฅ ืคืื ืฆืืื ืฆื ืคืึทืจืืืืึทืื ืงืืืคื ืึทืคึผืขืจืืืฉืึทื ืึทื ืืึทืืึทืืืืกืื ืฆื ืกืขืืขืงืืืจื ืืขื ืืืึธืก ืืื ืืขืกืืขืจ ืคึผืึทืกืืง ืคึฟืึทืจ ืื ืืืขื ืืืขืจืงืืึธืื. ืืืืขืจืคืขื ืืฉื ืงืขื ืขื ืึทืจืืึทื ื ืขืืขื ืกืืืคึผืืึทืคืืื ืืึทืื ืืึธืืขืืื ื, ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืขืจืึทื ืืื, ืืืืขื ืขื / ืฉืจืืึทืื ืคืึธืจืฉืืขืืื ื, ืืึธืจืืืึธื ืืึทื ืกืงืืืืื ื ืืื ืฉืืื ืืึธืืขืจืึทื ืฅ. ืืจืึทืืืฉืึทื ืึทืื, ืื ืืจืืจื ืืืืื ืืื ืืื ืื ืืึทืืึทืืืืก ืงืึทืืขืืึธืจืืข, SQL ืึธืืขืจ NoSQL, ืืืืึทื ืืขืืขืจ ืงืึทืืขืืึธืจืืข ืืื ืึท ืงืืึธืจ ืืึทื ื ืคืื ืืึทื ืื-ืึธืคืก. ืืืื ืคืึธืจืฉืืขืืื ื ืืื ืืขืจืืื ืขื ืคืื ื ืืืขืจืืง ืืืืืึทื ืกื ืืื ืืืื ืืจืืคึผืื ืืื ืืืื ืืขืืขื ืืื ืึท ื ืื-ืืึทื ืื-ืึทืืืขืง ืคืึธืืขืจืื ื ืืื ืืื ืืขืจืืืขืจ ืืงืขืจืืืง ืคึฟืึทืจ ืงืืื ืืืกืืขืจ ืืึทืืึทืืืืก.
ืืขืจ ืฆืื ืคืื ืืขื ืึทืจืืืงื ืืื ืฆื ืืขืืคึฟื ืึทืคึผืืึทืงืืืฉืึทื ืืขืืืขืืึธืคึผืขืจืก ืืึทืื ืื ืจืขืื ืืจืืจื ืฆืืืืฉื SQL ืืื NoSQL ืืื ืืขื ืงืึธื ืืขืงืกื ืคืื ืึทืคึผืืึทืงืืืฉืึทื ืืึทืื ืืึธืืขืืื ื. ืืืจ ืืืขืื ืงืืงื ืืื ืืืื SQL ืืึทืืึทืืืืก, ื ืืืืื PostgreSQL, ืืื ืฆืืืื NoSQL ืืึทืืึทืืืืกืื, Cassandra ืืื MongoDB, ืฆื ืืขืงื ืื ืืึทืกืืงืก ืคืื ืืึทืืึทืืืืก ืคึผืืึทื, ืึทืืึท ืืื ืงืจืืืืืื ื ืืืฉื, ืคึผืึทืคึผืืึทืืืืืื ื ืืื, ืืืืขื ืขื ืืึทืื ืคืื ืึท ืืืฉ ืืื ืืืกืืขืงื ืขืก. ืืื ืืขืจ ืืืืึทืืขืจ ืึทืจืืืงื, ืืืจ ืืืขืื ืืืื ืืืืขืจ ืฆื ืงืืงื ืืื ืื ืืขืงืกืื, ืืจืึทื ืืึทืงืฉืึทื ื, JOINs, TTL ืืืืจืขืงืืืืื ืืื JSON-ืืืืืจื ืืึทืืึทืืืืก ืคึผืืึทื.
ืืืึธืก ืืื ืื ืืืืืง ืฆืืืืฉื SQL ืืื NoSQL?
SQL ืืึทืืึทืืืืกืื ืคืึทืจืืจืขืกืขืจื ืึทืคึผืืึทืงืืืฉืึทื ืืืืืืงืืื ืืืจื ืึทืกืื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืขืจืึทื ืืื, ืืื ืืขืืื ื ืืื ืืืืขืจ ืคืืืืงืืื ืฆื ืึธื ืคืจืขื ืืึทืื ื ืืฆื JOINs ืืื ืืืืืขืจืืื ืืืขืื ืืืืฃ ืฉืคึผืืฅ ืคืื ืืืืืกืืื ื ื ืึธืจืืึทืืืืขื ืจืืืืืฉืึทื ืึทื ืืึทืืึทืืืืก ืืึธืืขืืก.
ืืขืืขืื ืืืืขืจ ืืึทื ืึทืืืืืง / ืืืื-ื ืึธืืข ืึทืจืงืึทืืขืงืืฉืขืจ ืืื ื ืืฆื ืคืื ืึท ืืขื-ืฉืงืืึทืฃ ืจืขืคึผืืึทืงืืืฉืึทื ืืึธืืขื ืคึฟืึทืจ ืืืขืจืืงืืึทื, ืืขืงืึทืืึธืืขืืืง ืกืงื ืืึทืืึทืืืืกืื ืคืขืื ืฆืืืื ืืืืืืืง ืคึฟืขืึดืงืืืื - ืืื ืขืึทืจ ืฉืจืืึทืื ืกืงืึทืืึทืืืืืื (ื"ื ืึธืืึทืืึทืืืง ืคึผืึทืจืืืฉืึทื ืื ื ืึทืจืืืขืจ ืงืืืคื ื ืึธืืื) ืืื ืึธืืึทืืึทืืืง / ื ืื ืืึทืื ืึธื ืืืขืจ. ืืขื ืืืื ืึทื ืื ืกืืืข ืคืื โโืืึทืื ืืืงืืืขื ืงืขื ื ืืฉื ืืงืกืื ืื ืืึทืงืกืืืื ืฉืจืืึทืื ืืจืืคึผืื ืคืื ืึท ืืืื ื ืึธืืข. ืืื ืึทืืืฉืึทื, ืขืืืขืืข ืฆืืืืืืืืืืืข ืืึทืื ืึธื ืืืขืจ ืืืื ืืืื ืืขื ืืืขื ืืื ืืฉืืื ืืื ืฉืืื ืืึธืืขืจืึทื ืฅ (ืืื ืึท ืฉืขืจื-ืืึธืจื ืืฉื ืึทืจืงืึทืืขืงืืฉืขืจ). ืืึธ ืืืจ ืืึทืจืคึฟื ืฆื ืืึทืืื ืืื ืืื ืขื ืึทื ืื ืืขืฆืืข ืงืึทืืืฅ ืืึธืื ื ืืฉื ื ืึธื ืืขืืืขื ืฉืคืืืื ืืื ืื ืฉืงืืึทืฃ ืงืึธืคึผืืข. ื ืื-ืืึทืื ืืืื ืืขืจืืืึทื ืืืงืื ืืขื ืืขื ืขื ืืืื ืฉืืืขืจ ืฆื ืืขืจืืจืืืื ืืื SQL ืืึทืืึทืืืืกืื.
NoSQL ืืึทืืึทืืืืกืื ืืขื ืขื ืืืืฉืึทืืืึทืื ืคืื ืื ืืขืจืืขืืืืื ืืืจื ื ืึทืืืจ, ื"ื. ืืื ืืื, ืืึทืื ืืขื ืขื ืฆืขืืืืื ืืื ืกืขืงืฉืึทื ื ืืื ืฆืขืฉืืงื ืืืืฃ ืขืืืขืืข ื ืึธืืื. ืืื ืืึทืจืคื ืืื ืึธืจืืึทืืืืืืฉืึทื. ืืขื ืืืื ืึทื ืื ืึทืจืืึทื ืืขืฉืืงื ืืึทืื ืืืื ืืืื ืืืื ืงืึทืคึผืื ืขืืืขืืข ืืึธื ืฆื ืจืืกืคึผืึทื ื ืฆื ืื ืกืคึผืขืฆืืคืืฉ ืจืืงืืืขืก ืืืจ ืฉืืงื. ืืขืจ ืงืืืืขืืืืง ืฆืื ืืื ืฆื ืืึทืงืืืขื ืืืื ืคืึธืจืฉืืขืืื ื ืืืจื ืจืืืืกืื ื ืื ื ืืืขืจ ืคืื ืฉืึทืจืื ืื ืืืฆื ืืขืฉืึทืก ืืืืขื ืขื. ืืึธืก ืืืคึผืืืื ืึทื NoSQL ืจืืงืืืืืขืจื ืืืจ ืฆื ืืึธืืขื ืืืื ืคึฟืจืืื, ืืฉืขืช SQL ืจืืงืืืืืขืจื ืืืจ ืฆื ืืึธืืขื ืืืื ืืึทืื.
NoSQL ืคืึธืืงืืกืื ืืืืฃ ืืขืจืืจืืืื ืืืื ืคืึธืจืฉืืขืืื ื ืืื ืึท ืคืื ืื ืืขืจืืขืืืืื ืงื ืืื ืืื ืืึธืก ืืื ืื ืึทื ืืขืจืืืืื ื ืกืืืื ืคึฟืึทืจ ืคืืืข ืืืืืึทืืืืก ืคึผืืึทื ืืจืืืืึธืคืคืก ืืืึธืก ืึทืจืืึทื ื ืขืืขื ืึทืกืื ืืจืึทื ืกืึทืงืืืึธื ืึธื ืืืขืจ, JOINs ืืื ืงืึธื ืกืืกืืขื ื ืืืืืืืข ืฆืืืืืืืง ืื ืืขืงืกืื.
ืขืก ืืื ืึทื ืึทืจืืืืขื ื ืึทื ืืึธืืฉ NoSQL ืืึทืืึทืืืืกืื ืฆืืฉืืขืื ืืื ืขืึทืจ ืฉืจืืึทืื ืกืงืึทืืึทืืืืืื ืืื ืืืื ืฉืืื ืืึธืืขืจืึทื ืฅ, ืื ืึธื ืืืขืจ ืคืื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืขืจืึทื ืืื ืืืื ืืื ืืืคึผืึทืกืืง ืคึฟืึทืจ ืืืกืืข-ืงืจืืืืฉ ืืึทืื.
ืื ืคืืืืขื ืืข ืืืฉ ืืืืืื ืืื ืืึทืื ืืึธืืขืืื ื ืืื NoSQL ืืื ืึทื ืืขืจืฉ ืคืื SQL.
SQL ืืื NoSQL: ืคืืจืืืืก ืืขื ืขื ืืืืืข ืืืจืฃ?
ืคืึทืงืืืฉ-ืืืขืื ืึทืคึผืืึทืงืืืฉืึทื ื ืืื ืืจืืืก ื ืืืขืจ ืคืื ื ืืฆืขืจืก, ืึทืืึท ืืื Amazon.com, Netflix, Uber ืืื Airbnb, ืืขื ืขื ืืึทืกืงื ืฆื ืืืจืืคืืจื ืงืึธืืคึผืืขืงืก, ืืึทืืื-ืคืึทืกืึทืืื ืืึทืกืงืก. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืึทื E- ืืึทื ืื ืึทืคึผืืึทืงืืืฉืึทื ืืื Amazon.com ืืึทืจืฃ ืงืจืึธื ืืืืืืืืื, ืืืื-ืงืจืืืืฉ ืืึทืื ืึทืืึท ืืื ืืึทื ืืฆืขืจ ืืื ืคึฟืึธืจืืึทืฆืืข, ืคึผืจืึธืืืงืื, ืึธืจืืขืจืก, ืื ืืืืืกืื, ืฆืืืึทืืขื ืืื ืฉืืืขืจ, ืืืืื ืืงืขืจ ืฉืคึผืืจืขืืืืืง ืืึทืื ืึทืืึท ืืื ืคึผืจืึธืืืงื ืืืจืืืื, ืฉืืืฆื ืึทืจืืืงืืขื, ืืึทื ืืฆืขืจ ืืขืืืงืืื, ืืึทื ืืฆืขืจ ืืืจืืืื ืืื ืจืขืงืึทืืึทื ืืืืฉืึทื ื. ืืขืืืืื ืืืขื, ืื ืึทืคึผืืึทืงืืืฉืึทื ื ืคืึทืจืืึธืื ืืื ืืืึท ืืื ืืกืืขืจ ืืืื SQL ืืึทืืึทืืืืก ืฆืืืืืขื ืืื ืืืึท ืืื ืืกืืขืจ ืืืื NoSQL ืืึทืืึทืืืืก. ืืื ืงืจืืึทื-ืจืขืืืึธื ืึทื ืืื ืืืืืืืข ืกืืกืืขืืขื, ืึท NoSQL ืืึทืืึทืืืืก ืึทืคึผืขืจืืืฅ ืืื ืึท ืืขืึธ-ืคืึทืจืฉืคึผืจืืืื ืงืึทืฉ ืคึฟืึทืจ ืืึทืื ืกืืึธืจื ืืื ืึท ืืจืึทืกืืื ืืงืืจ ืกืงื ืืึทืืึทืืืืก ืคืืืกื ืืืง ืืื ืึท ืืึทืืื ืืขืจ ืืขืื ื.
ืืื ืงืขื YugaByte DB ืคืึทืจืืื ืื SQL ืืื NoSQL?
ืืขืืืื ืืืืฃ ืึท ืืึธื-ืึธืจืืขื ืืื ืืขืืืฉื ืกืืึธืจืืืืฉ ืืึธืืึธืจ, ืึทืืืึธ-ืฉืึทืจืืื ื, ืฉืขืจื ืคืื ืื ืืขืจืืขืืืืื ืงืึธื ืกืขื ืกืืก ืจืขืคึผืืึทืงืืืฉืึทื ืืื ืึทืกืื ืคืื ืื ืืขืจืืขืืืืื ืืจืึทื ืืึทืงืฉืึทื ื (ืื ืกืคึผืืืขืจื ืืืจื Google Spanner), YugaByte DB ืืื ืื ืืืขืื 'ืก ืขืจืฉืืขืจ ืึธืคึฟื ืืงืืจ ืืึทืืึทืืืืก ืืืึธืก ืืื ืกืืืืึทืืืืื ืืึทืกืื ืงืึทืืคึผืึทืืึทืืึทื ืืื NoSQL (Cassandra & Redis) ืืื SQL (PostgreSQL). ืืื ืืขืืืืื ืืื ืื ืืืฉ ืืื ืื, YCQL, ืื YugaByte DB API ืงืึทืืคึผืึทืืึทืืึทื ืืื Cassandra, ืืืกืืฃ ืื ืงืึทื ืกืขืคึผืก ืคืื ืืืื ืืื ืืึทืืื-ืฉืืืกื ืึทืกืื ืืจืึทื ืืึทืงืฉืึทื ื ืืื ืืืืืืืข ืฆืืืืืืืง ืื ืืขืงืกืื ืฆื ืื NoSQL API, ืืื ืืขืจืืื ืื ืฉืืจืื ื ืื ืชืงืืคื ืคืื ืืจืึทื ืกืึทืงืืืึธื ืึทื NoSQL ืืึทืืึทืืืืกืื. ืึทืืืืืืึธื ืึทืืื, YCQL, ืื YugaByte DB API ืงืึทืืคึผืึทืืึทืืึทื ืืื PostgreSQL, ืืืกืืฃ ืื ืงืึทื ืกืขืคึผืก ืคืื ืืื ืขืึทืจ ืฉืจืืึทืื ืกืงืืืืื ื ืืื ืึธืืึทืืึทืืืง ืฉืืื ืืึธืืขืจืึทื ืฅ ืฆื ืื SQL API, ืืืึธืก ืืจืขื ืื ืคืื ืื ืืขืจืืขืืืืื SQL ืืึทืืึทืืืืกืื ืฆื ืืขืจ ืืืขืื. ืืืืึทื YugaByte DB ืืื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืื ื ืึทืืืจ, ืื NoSQL API ืงืขื ืขื ืืืฆื ืืืื ืืขืืืืื ื ืืื ืืขื ืงืึธื ืืขืงืกื ืคืื ืืืกืืข-ืงืจืืืืฉ ืืึทืื.
ืืื ืคืจืืขืจ ืกืืืืืื ืืื ืืขื ืึทืจืืืงื , ืื ืืจืืจื ืฆืืืืฉื SQL ืึธืืขืจ NoSQL ืืื YugaByte DB ืืขืคึผืขื ืืก ืืขืืึทืืจืข ืืืืฃ ืื ืงืขืจืึทืงืืขืจืืกืืืงืก ืคืื ืื ืึทื ืืขืจืืืืื ื ืืืขืจืงืืึธืื:
- ืืืื ืืืื ืขืจืฉืืืง ืืืขืจืงืืึธืื ืืื ืืึทืืื-ืฉืืืกื JOIN ืึทืคึผืขืจืืืฉืึทื ื, ืืืขื ืืฉืืืื ื YSQL, ืคึฟืึทืจืฉืืืื ืึทื ืืืื ืฉืืืกืืขื ืงืขื ืืืื ืคืื ืื ืืขืจืืขืืืืื ืืืืขืจ ืงืืืคื ื ืึธืืื, ืจืืืึทืืืื ื ืืื ืืขืืขืจ ืืืืืึทื ืกื ืืื / ืึธืืขืจ ื ืืืขืจืืงืขืจ ืืจืืคึผืื ืืื NoSQL.
- ืึทื ืืขืจืฉ, ืงืืืึทืื ืืืื ืขืจ ืคืื ืื ืฆืืืื NoSQL APIs, ืืื ืืึทืืื ืืื ืืืื ืื ื ืึทื ืืืจ ืืืขื ืืึทืงืืืขื ืืขืกืขืจ ืคืึธืจืฉืืขืืื ื ืืื ืึท ืจืขืืืืืึทื ืคืื ืคึฟืจืืื ืืขืืื ื ืคึฟืื ืืืื ื ืึธืืข ืืื ืึท ืฆืืื. YugaByte DB ืงืขื ืขื ืืื ืขื ืืื ืึท ืืืื ืึทืคึผืขืจืืืฉืึทื ืึทื ืืึทืืึทืืืืก ืคึฟืึทืจ ืคืึทืงืืืฉ-ืืืขืื, ืงืึธืืคึผืืขืงืก ืึทืคึผืืึทืงืืืฉืึทื ื ืืืึธืก ืืึทืจืคึฟื ืฆื ืคืืจื ืงืืืคื ืืืขืจืงืืึธืืื ืกืืืืึทืืืืื ืืึทืกืื.
ืื ืืึทืืึท ืืึธืืขืืื ื ืืึทื ืืื ืืขืจ ืืืืึทืืขืจ ืึธืคึผืืืืืื ื ืืื ืืืืืจื ืืืืฃ PostgreSQL ืืื Cassandra API ืงืึทืืคึผืึทืืึทืืึทื YugaByte DB ืืึทืืึทืืืืกืื, ืืื ืงืขืื ืฆื ืืขืืืืจื ืืึทืืึทืืืืกืื. ืืขืจ ืฆืืืึทื ื ืขืืคืึทืกืืืืื ืื ืื ืคืื ืื ืืขืจืึทืงืืื ื ืืื ืฆืืืื ืคืึทืจืฉืืืขื ืข ืึทืคึผืืก (ืืืืฃ ืฆืืืื ืคืึทืจืฉืืืขื ืข ืคึผืึธืจืฅ) ืคืื ืืขืจ ืืขืืืืงืขืจ ืืึทืืึทืืืืก ืงื ืืื, ืืื ืงืขืื ืฆื ื ืืฆื ืืึธืจ ืคืจืืึท ืงืืึทืกืืขืจื ืคืื ืฆืืืื ืคืึทืจืฉืืืขื ืข ืืึทืืึทืืืืกืื.
ืืื ืื ืคืืืืขื ืืข ืกืขืงืฉืึทื ื, ืืืจ ืืืขืื ื ืขืืขื ืึท ืงืืง ืืื ืื ืืึทืื ืืึธืืขืืื ื ืืึทื ืฆื ืืืืืกืืจืืจื ืื ืืืคืขืจืึทื ืกืื ืืื ืขืืืขืืข ืงืึทืืึทื ืึทืืึทืืื ืคืื ืื ืืึทืืึทืืืืกืื ืืืืขืงื.
ืืึทืืึท ืืึธืืขืืื ื ืืึทืืึธืจืึทืืึธืจืืข
ืืึทืืึทืืึทืกืข ืื ืกืืึทืืืจืื ื
ืืขืืขืื ืืขื ืืจืึธืคึผ ืืืืฃ ืืึทืื ืืึธืืขื ืคึผืืึทื (ืืื ืืื ืงืึธืืคึผืืขืงืก ืืืคึผืืืืืึทื ื ืึทืจืงืึทืืขืงืืฉืขืจื), ืืืจ ืืืขืื ืื ืกืืึทืืืจื ืืึทืืึทืืืืกืื ืืื ืืึธืงืงืขืจ ืงืึทื ืืืื ืขืจื ืืืืฃ ืื ืืืืข ืืึทืฉืื ืืื ืืขืจื ืึธื ืื ืืขืจืึทืงื ืืื ืืื ืืื ืืืืขืจ ืจืืกืคึผืขืงืืืื ืืึทืคึฟืขืื ืฉืืจื ืฉืขืื.
PostgreSQL & Cassandra ืงืึทืืคึผืึทืืึทืืึทื YugaByte DB ืืึทืืึทืืืืก
mkdir ~/yugabyte && cd ~/yugabyte
wget https://downloads.yugabyte.com/yb-docker-ctl && chmod +x yb-docker-ctl
docker pull yugabytedb/yugabyte
./yb-docker-ctl create --enable_postgresืืึธื ืืึธืื
docker run --name my-mongo -d mongo:latestืืึทืคึฟืขืื ืฉืืจื ืึทืงืกืขืก
ืืึธืืืจ ืคืึทืจืืื ืื ืฆื ืื ืืึทืืึทืืืืกืื ืืื ืื ืืึทืคึฟืขืื ืฉืืจื ืฉืึธื ืคึฟืึทืจ ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืึทืคึผืืก.
ืคึผืึธืกืืืจืขืกืงื
ืืื ืึท ืืึทืคึฟืขื ืฉืืจื ืฉืึธื ืคึฟืึทืจ ืื ืืขืจืึทืงืืื ื ืืื PostgreSQL. ืคึฟืึทืจ ืื ืคืื ื ืืฆื, YugaByte DB ืงืืื ืืื psql ืจืขืื ืืื ืื bin ืืขืงืข.
docker exec -it yb-postgres-n1 /home/yugabyte/postgres/bin/psql -p 5433 -U postgresืงืึทืกืกืึทื ืืจืึท
ืืื ืึท ืืึทืคึฟืขื ืฉืืจื ืฉืึธื ืคึฟืึทืจ ืื ืืขืจืึทืงืืื ื ืืื Cassandra ืืื ืืืื ืงืึทืืคึผืึทืืึทืืึทื ืืึทืืึทืืืืกืื ืืืจื CQL (Cassandra Query Language). ืคึฟืึทืจ ืื ืคืื ื ืืฆื, YugaByte DB ืงืืื ืืื cqlsh ืืื ืืขื ืงืึทืืึทืืึธื bin.
ืืึทืืขืจืงืื ื ืึทื CQL ืืื ืื ืกืคึผืืืขืจื ืืืจื SQL ืืื ืืื ืขื ืืขื ืงืึทื ืกืขืคึผืก ืคืื ืืืฉื, ืจืึธืื, ืฉืคืืืื ืืื ืื ืืขืงืกืื. ืึธืืขืจ, ืืื ืึท NoSQL ืฉืคึผืจืึทื, ืขืก ืืืกืืฃ ืึท ืืืืขืจ ืืึทื ื ืคืื ืืืืืืืืฉืึทื ื, ืจืืึฟ ืคืื ืืืึธืก ืืืจ ืืืขืื ืืืื ืืขืงื ืืื ืื ืืขืจืข ืึทืจืืืงืืขื.
docker exec -it yb-tserver-n1 /home/yugabyte/bin/cqlshืืึธื ืืึธืื
ืืื ืึท ืืึทืคึฟืขื ืฉืืจื ืฉืึธื ืคึฟืึทืจ ืื ืืขืจืึทืงืืื ื ืืื MongoDB. ืขืก ืงืขื ืขื ืืืื ืืขืคึฟืื ืขื ืืื ืื bin Directory ืคืื ืื MongoDB ืื ืกืืึทืืืจืื ื.
docker exec -it my-mongo bash
cd bin
mongoืฉืืคื ื ืืืฉ
ืืืฆื ืืืจ ืงืขื ืขื ืื ืืขืจืึทืงื ืืื ืื ืืึทืืึทืืืืก ืฆื ืืืจืืคืืจื ืคืึทืจืฉืืื ืึทืคึผืขืจืืืฉืึทื ื ื ืืฆื ืื ืืึทืคึฟืขืื ืฉืืจื. ืืึธืืืจ ืึธื ืืืืื ืืื ืฉืึทืคึฟื ืึท ืืืฉ ืืืึธืก ืกืืึธืจื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ืืืืขืจ ืืขืฉืจืืื ืืืจื ืคืึทืจืฉืืืขื ืข ืึทืจืืืก. ืื ืืืืขืจ ืงืขื ืืืื ืืืื ืคืื ืึทื ืืืืื. ืืืื ืึทืคึผืฉืึทื ืึทื ืึทืืจืืืืืฅ ืคึฟืึทืจ ืึท ืืื ืืขื ืขื ืืึธืจ ืคืื ืืขืืืื ื, ืคึผืจืืึทื, ืืฉืึทื ืจืึท ืืื ืฉืึทืฅ. ืืืจ ืืึทืจืคึฟื ืฆื ืจืขืืขื ืขื ื ืึธื ืึทืืจืืืืืฅ ืืืึธืก ืงืขื ืืืื ืืืจืฃ ืืื ืืขืจ ืฆืืงืื ืคึฟื ืืืจื ืื "ืืึทืืก" ืคืขืื. ืขืก ืงืขื ืขื ืงืจืึธื ืืึทืื-ืกืืจืึทืงืืฉืขืจื ืืึทืื ืืื ืื ืคืึธืจืขื ืคืื ืฉืืืกื-ืืืขืจื ืคึผืขืจื.
ืคึผืึธืกืืืจืขืกืงื
CREATE TABLE Music (
Artist VARCHAR(20) NOT NULL,
SongTitle VARCHAR(30) NOT NULL,
AlbumTitle VARCHAR(25),
Year INT,
Price FLOAT,
Genre VARCHAR(10),
CriticRating FLOAT,
Tags TEXT,
PRIMARY KEY(Artist, SongTitle)
); ืงืึทืกืกืึทื ืืจืึท
ืงืจืืืืืื ื ืึท ืืืฉ ืืื Cassandra ืืื ืืืืขืจ ืขื ืืขื ืฆื PostgreSQL. ืืืื ืขืจ ืคืื ืื ืืืืคึผื ืืืคืขืจืึทื ืกืื ืืื ืื ืคืขืื ืคืื ืึธืจื ืืืขืืงืืึทื ืงืึทื ืกืืจืืื ืฅ (ืืืฉื ื ืืฉื NULL), ืึธืืขืจ ืืึธืก ืืื ืื ืคึฟืึทืจืึทื ืืืืึธืจืืืขืืงืืื ืคืื ืื ืึทืคึผืืึทืงืืืฉืึทื, ื ืืฉื ืื NoSQL ืืึทืืึทืืืืก. ืืขืจ ืขืจืฉืืืง ืฉืืืกื ืืืฉืืืื ืคืื ืึท ืฆืขืืืืืื ื ืฉืืืกื (ืืขืจ ืงืื ืกืืืขืจ ืืืึทื ืืื ืืขื ืืืึทืฉืคึผืื ืืื ืื) ืืื ืึท ืกืืื ืคืื ืงืืึทืกืืขืจืื ื ืฉืคืืืื (ืื SongTitle ืืืึทื ืืื ืืขื ืืืึทืฉืคึผืื ืืื ืื). ืืขืจ ืฆืขืืืืืื ื ืฉืืืกื ืืืืขืจืืึทื ื ืืื ืืืึธืก ืฆืขืืืืืื ื / ืฉืึทืจื ืื ืจืืืขืจื ืืึธื ืืืื ืืขืฉืืขืื ืืื, ืืื ืื ืงืืึทืกืืขืจืื ื ืฉืคืืืื ืึธื ืืืืึทืื ืืื ืื ืืึทืื ืืึธื ืืืื ืึธืจืืึทื ืืืืจื ืืื ืืขื ืงืจืึทื ื ืฉืึทืจื.
CREATE KEYSPACE myapp;
USE myapp;
CREATE TABLE Music (
Artist TEXT,
SongTitle TEXT,
AlbumTitle TEXT,
Year INT,
Price FLOAT,
Genre TEXT,
CriticRating FLOAT,
Tags TEXT,
PRIMARY KEY(Artist, SongTitle)
);ืืึธื ืืึธืื
MongoDB ืึธืจืืึทื ืืืืจื ืืึทืื ืืื ืืึทืืึทืืืืกืื (ืืึทืืึทืืึทืกืข) (ืขื ืืขื ืฆื Keyspace ืืื Cassandra), ืืื ืขืก ืืขื ืขื ืืึทืืืื ืืขื (ืขื ืืขื ืฆื ืืืฉื) ืืืึธืก ืึทื ืืืึทืืื ืืึธืงืืืขื ืื (ืขื ืืขื ืฆื ืจืึธืื ืืื ืึท ืืืฉ). ืืื MongoDB, ืขืก ืืื ืืืืกืืงืื ื ืื ืืึทืจืคึฟื ืฆื ืืขืคืื ืืจื ืึทื ืขืจืฉื ืกืืฉืขืืึท. ืืึทื ืฉืึทืคึฟื "ื ืืฆื ืืึทืืึทืืึทืกืข", ืืขืืืืื ืืื ืื, ืื ืกืืึทื ืืืึทืืขืก ืื ืืึทืืึทืืืืก ืืืืฃ ืืขืจ ืขืจืฉืืขืจ ืจืืคื ืืื ืขื ืืขืจืื ืืขื ืื ืงืึธื ืืขืงืกื ืคึฟืึทืจ ืื ื ืื ืืืฉืืคื ืืึทืืึทืืืืก. ืืคืืื ืืึทืืืื ืืขื ืืึธื ื ืื ืืึทืจืคึฟื ืฆื ืืืื ืืืฉืืคื ืืคืืจืืฉ; ืืื ืืขื ืขื ืืืฉืืคื ืืืืืึธืืึทืืืฉ, ื ืึธืจ ืืืขื ืืืจ ืืืืื ืืขื ืขืจืฉืืขืจ ืืึธืงืืืขื ื ืฆื ืึท ื ืืึทืข ืืึทืืืื ื. ืืึทืืขืจืงืื ื ืึทื MongoDB ื ืืฆื ืื ืคึผืจืึธืืข ืืึทืืึทืืืืก ืืืจื ืคืขืืืงืืึทื, ืึทืืื ืงืืื ืืึทืืืื ื-ืืืจืื ืึธืคึผืขืจืึทืฆืืข ืึธื ืกืคึผืขืฆืืคืืฆืืจื ืึท ืกืคึผืขืฆืืคืืฉ ืืึทืืึทืืืืก ืืืขื ืืืืคื ืืืืฃ ืขืก ืืืจื ืคืขืืืงืืึทื.
use myNewDatabase;ืืึทืงืืืขื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ืึท ืืืฉ
ืคึผืึธืกืืืจืขืกืงื
d Music
Table "public.music"
Column | Type | Collation | Nullable | Default
--------------+-----------------------+-----------+----------+--------
artist | character varying(20) | | not null |
songtitle | character varying(30) | | not null |
albumtitle | character varying(25) | | |
year | integer | | |
price | double precision | | |
genre | character varying(10) | | |
criticrating | double precision | | |
tags | text | | |
Indexes:
"music_pkey" PRIMARY KEY, btree (artist, songtitle)ืงืึทืกืกืึทื ืืจืึท
DESCRIBE TABLE MUSIC;
CREATE TABLE myapp.music (
artist text,
songtitle text,
albumtitle text,
year int,
price float,
genre text,
tags text,
PRIMARY KEY (artist, songtitle)
) WITH CLUSTERING ORDER BY (songtitle ASC)
AND default_time_to_live = 0
AND transactions = {'enabled': 'false'};ืืึธื ืืึธืื
use myNewDatabase;
show collections;ืึทืจืืึทื ืืึทืื ืืื ืึท ืืืฉ
ืคึผืึธืกืืืจืขืกืงื
INSERT INTO Music
(Artist, SongTitle, AlbumTitle,
Year, Price, Genre, CriticRating,
Tags)
VALUES(
'No One You Know', 'Call Me Today', 'Somewhat Famous',
2015, 2.14, 'Country', 7.8,
'{"Composers": ["Smith", "Jones", "Davis"],"LengthInSeconds": 214}'
);
INSERT INTO Music
(Artist, SongTitle, AlbumTitle,
Price, Genre, CriticRating)
VALUES(
'No One You Know', 'My Dog Spot', 'Hey Now',
1.98, 'Country', 8.4
);
INSERT INTO Music
(Artist, SongTitle, AlbumTitle,
Price, Genre)
VALUES(
'The Acme Band', 'Look Out, World', 'The Buck Starts Here',
0.99, 'Rock'
);
INSERT INTO Music
(Artist, SongTitle, AlbumTitle,
Price, Genre,
Tags)
VALUES(
'The Acme Band', 'Still In Love', 'The Buck Starts Here',
2.47, 'Rock',
'{"radioStationsPlaying": ["KHCR", "KBQX", "WTNR", "WJJH"], "tourDates": { "Seattle": "20150625", "Cleveland": "20150630"}, "rotation": Heavy}'
);ืงืึทืกืกืึทื ืืจืึท
ืงืืืืขืืืืง ืืืืกืืจืืง INSERT ืืื Cassandra ืงืืงื ืืืืขืจ ืขื ืืขื ืฆื PostgreSQL. ืึธืืขืจ, ืขืก ืืื ืืืื ืืจืืืก ืืืืืง ืืื ืกืขืืึทื ืืืงืก. ืืื ืงืึทืกืึทื ืืจืึท INSERT ืืื ืคืืงืืืฉ ืึทื ืึธืคึผืขืจืึทืฆืืข UPSERT, ืืื ืื ืืขืฆืืข ืืืึทืืืขืก ืืขื ืขื ืืืกืืฃ ืฆื ืื ืจืืืขืจื ืืืื ืื ืจืืืขืจื ืฉืืื ืืืืืกืฅ.
ืืึทืืึท ืคึผืึธืืืฆืืข ืืื ืขื ืืขื ืฆื PostgreSQL
INSERTืืขืืขืจ
.
ืืึธื ืืึธืื
ืืึธืืฉ MongoDB ืืื ืึท NoSQL ืืึทืืึทืืืืก ืืื Cassandra, ืืืื ืื ืกืขืจืฉืึทื ืึธืคึผืขืจืึทืฆืืข ืืื ืืึธืจื ืืฉื ืืื ืคึผืจืึธืกื ืืื ืื ืกืขืืึทื ืืืง ื ืึทืืืจ ืคืื Cassandra. ืืื MongoDB ืืื ืงืืื ืึทืคึผืขืจืืื ืึทืืื UPSERT, ืืืึธืก ืืืื ืขืก ืขื ืืขื ืฆื PostgreSQL. ืึทืืื ื ืคืขืืืงืืึทื ืืึทืื ืึธื _idspecified ืืืขื ืคืึทืจืฉืึทืคื ืึท ื ืืึทืข ืืึธืงืืืขื ื ืฆื ืืืื ืฆืืืขืืืืื ืฆื ืืขืจ ืืึทืืืื ื.
db.music.insert( {
artist: "No One You Know",
songTitle: "Call Me Today",
albumTitle: "Somewhat Famous",
year: 2015,
price: 2.14,
genre: "Country",
tags: {
Composers: ["Smith", "Jones", "Davis"],
LengthInSeconds: 214
}
}
);
db.music.insert( {
artist: "No One You Know",
songTitle: "My Dog Spot",
albumTitle: "Hey Now",
price: 1.98,
genre: "Country",
criticRating: 8.4
}
);
db.music.insert( {
artist: "The Acme Band",
songTitle: "Look Out, World",
albumTitle:"The Buck Starts Here",
price: 0.99,
genre: "Rock"
}
);
db.music.insert( {
artist: "The Acme Band",
songTitle: "Still In Love",
albumTitle:"The Buck Starts Here",
price: 2.47,
genre: "Rock",
tags: {
radioStationsPlaying:["KHCR", "KBQX", "WTNR", "WJJH"],
tourDates: {
Seattle: "20150625",
Cleveland: "20150630"
},
rotation: "Heavy"
}
}
);
ืืืฉ ืึธื ืคึฟืจืขื
ืืึธืืขืจ ืื ืืขืจืกื ืืึทืืืึทืืืง ืืืืืง ืฆืืืืฉื SQL ืืื NoSQL ืืื ืืขืจืืื ืขื ืคืื ืึธื ืคึฟืจืขื ืงืึทื ืกืืจืึทืงืฉืึทื ืืื ืื ืฉืคึผืจืึทื ืืขื ืืฆื FROM ะธ WHERE. ืกืงื ืึทืืึทืื ื ืึธื ืืืืกืืจืืง FROM ืืืืกืงืืืึทืื ืงืืืคื ืืืฉื, ืืื ืืืืกืืจืืง ืืื WHERE ืงืขื ืขื ืืืื ืคืื ืงืืื ืงืึทืืคึผืืขืงืกืืื (ืึทืจืืึทื ืืขืจืขืื ื ืึทืคึผืขืจืืืฉืึทื ื JOIN ืฆืืืืฉื ืืืฉื). ืึธืืขืจ, NoSQL ืืขื ืื ืฆื ืึธื ืืึธื ืึท ืฉืืจืขื ื ืืึทืืจืขื ืขืฆืื ื FROM, ืืื ืึทืจืืขื ืืืืื ืืื ืืืื ืกืคึผืขืกืืคืืขื ืืืฉ, ืืื ืืื WHERE, ืืขืจ ืขืจืฉืืืง ืฉืืืกื ืืืื ืฉืืขื ืืืง ืืืื ืกืคึผืขืกืืคืืขื. ืืขื ืืืื ืืื ืื NoSQL ืคืึธืจืฉืืขืืื ื ืฉืืืคึผื ืืืจ ืืขืจืขืื ืืืขืื ืคืจืืขืจ. ืืขืจ ืคืึทืจืืึทื ื ืคืืจื ืฆื ืืขืืขืจ ืืขืืืขื ืจืขืืืงืฆืืข ืืื ืงืืื ืงืจืืึทื-ืืึทืืืืึทืจ ืืื ืงืจืืึทื-ืฉืืืกื ืื ืืขืจืึทืงืฉืึทื. ืขืก ืงืขื ืคืึธืจืฉืืขืื ืึท ืืจืืืก ืคืึทืจืืึทืืื ืืื ืื ืืขืจ-ื ืึธืืข ืงืึธืืื ืืงืึทืฆืืข ืืืขื ืจืืกืคึผืึทื ืืื ื ืฆื ืึท ืืงืฉื ืืื ืืื ืืขืจืืืขืจ ืืขืกืืขืจ ืึทืืืืืืื ืืื ืึทืืืขืืืื. ืคึฟืึทืจ ืืืึทืฉืคึผืื, Cassandra ืจืืงืืืืืขืจื ืคึฟืจืืื ืฆื ืืืื ืืืืืืขื ืฆื ืืืืขืจ ืึธืคึผืขืจืืืืขืจื (ืืืืื =, IN, <, >, =>, <=) ืืืืฃ ืฆืขืืืืืื ื ืฉืืืกืืขื, ืึทืืืฅ ืืืขื ืืืจ ืืขืื ืึท ืฆืืืืืืืง ืืื ืืขืงืก (ืืืืื ืืขืจ = ืึธืคึผืขืจืึทืืึธืจ ืืื ืขืจืืืืื ืืึธ).
ืคึผืึธืกืืืจืขืกืงื
ืื ืืขืจ ืืขื ืขื ืืจืื ืืืืฉืคืืื ืคืื ืงืืืืจืื ืืืึธืก ืงืขื ืขื ืืืืื ืืืื ืขืงืกืึทืงืืืืึทื ืืืจื ืึท SQL ืืึทืืึทืืืืก.
- ืืืืึทื ืึทืืข ืืืืขืจ ืคืื ืึท ืงืื ืกืืืขืจ;
- ืืืืึทื ืึทืืข ืืืืขืจ ืคืื ืืขื ืงืื ืกืืืขืจ ืืืึธืก ืืืืึทืื ืืขื ืขืจืฉืืขืจ ืืืื ืคืื ืืขื ืืืื;
- ืืืืึทื ืึทืืข ืืืืขืจ ืคืื ืึท ืงืื ืกืืืขืจ ืืืึธืก ืืึธืื ืึท ืืืืขืจ ืืืึธืจื ืืื ืืขื ืืืื ืืื ืืึธืื ืึท ืคึผืจืืึทื ืืืืื ืืงืขืจ ืืื 1.00.
SELECT * FROM Music
WHERE Artist='No One You Know';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle LIKE 'Call%';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle LIKE '%Today%'
AND Price > 1.00;ืงืึทืกืกืึทื ืืจืึท
ืคืื ืื PostgreSQL ืงืืืืจืื ืืืกืืขื ืืืืื, ืืืืื ืืขืจ ืขืจืฉืืขืจ ืืืื ืขืจ ืืืขื ืึทืจืืขืื ืึทื ืืฉืืื ืืืฉื ืืื Cassandra, ืืื ื ืืขืจ ืึธืคึผืขืจืึทืืึธืจ LIKE ืงืขื ืขื ื ืื ืืืื ืืขืืืขื ืื ืฆื ืงืืึทืกืืขืจืื ื ืฉืคืืืื ืึทืืึท ืืื SongTitle. ืืื ืืขื ืคืึทื, ืืืืื ืึธืคึผืขืจืืืืขืจื ืืขื ืขื ืขืจืืืืื = ะธ IN.
SELECT * FROM Music
WHERE Artist='No One You Know';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle IN ('Call Me Today', 'My Dog Spot')
AND Price > 1.00;ืืึธื ืืึธืื
ืืื ืืขืืืืื ืืื ืื ืคืจืืขืจืืืงืข ืืืืฉืคืืื, ืืขืจ ืืืืคึผื ืืืคึฟื ืคึฟืึทืจ ืงืจืืืืืื ื ืงืืืืจืื ืืื MongoDB ืืื . ืืขืจ ืืืคึฟื ืึผืืื ืืคืืจืืฉ ืื ื ืึธืืขื ืคืื ืื ืืึทืืืื ื (music ืืื ืืขื ืืืืฉืคึผืื ืืื ืื), ืึทืืื ืฆื ืคืจืขืื ืงืืืคื ืืึทืืืื ืืขื ืืื ืคึผืจืึธืืืืืึทืืึทื.
db.music.find( {
artist: "No One You Know"
}
);
db.music.find( {
artist: "No One You Know",
songTitle: /Call/
}
);ืืืืขื ืขื ืึทืืข ืจืึธืื ืคืื ืึท ืืืฉ
ืืืืขื ืขื ืึทืืข ืจืึธืื ืืื ืคืฉืื ืึท ืกืคึผืขืฆืืขื ืคืึทื ืคืื ืื ืึธื ืคึฟืจืขื ืืืกืืขืจ ืืืจ ืืขืงืืงื ืืื ืคืจืืขืจ.
ืคึผืึธืกืืืจืขืกืงื
SELECT *
FROM Music;ืงืึทืกืกืึทื ืืจืึท
ืขื ืืขื ืฆื ืื PostgreSQL ืืืืฉืคึผืื ืืืืื.
ืืึธื ืืึธืื
db.music.find( {} );ืขืืืืื ื ืืึทืื ืืื ืึท ืืืฉ
ืคึผืึธืกืืืจืขืกืงื
PostgreSQL ืืื ืื ืกืืจืึทืงืฉืึทื ื UPDATE ืฆื ืืืืฉื ืืึทืื. ืื ืืื ื ืื ืงืืื ืืขืืขืื ืืืื UPSERT, ืึทืืื ืืขื ืืืกืืึธืืื ื ืืืขื ืคืึทืจืืึธืื ืืืื ืื ืจืืืขืจื ืืื ื ืื ืืขืจ ืืื ืื ืืึทืืึทืืืืก.
UPDATE Music
SET Genre = 'Disco'
WHERE Artist = 'The Acme Band' AND SongTitle = 'Still In Love';ืงืึทืกืกืึทื ืืจืึท
ืงืึทืกืึทื ืืจืึท ืืื UPDATE ืขื ืืขื ืฆื PostgreSQL. UPDATE ืืื ืื ืืขืืืข ืกืขืืึทื ืืืง UPSERT, ืขื ืืขื INSERT.
ืขื ืืขื ืฆื ืื PostgreSQL ืืืืฉืคึผืื ืืืืื.
ืืึธื ืืึธืื
ืึธืคึผืขืจืึทืฆืืข ืืื MongoDB ืงืขื ืขื ืืึธืจ ืืขืจืืืึทื ืืืงื ืึทื ืืืืืกืืื ื ืืึธืงืืืขื ื ืึธืืขืจ ืืขืจืืืึทื ืืืงื ืืืืื ืืืืขืจ ืคืขืืืขืจ. ืืืจื ืคืขืืืงืืึทื, ืขืก ืืขืจืืืึทื ืืืงื ืืืืื ืืืื ืืึธืงืืืขื ื ืืื ืกืขืืึทื ืืืงืก ืคืึทืจืงืจืืคึผืื UPSERT. ืึทืคึผืืืืืื ื ืงืืืคื ืืึธืงืืืขื ืื ืืื ืขื ืืขื ื ืึทืืืจ UPSERT ืงืขื ืขื ืืืื ืืขืืืขื ืื ืืืจื ืืึทืฉืืขืืืงื ื ืึธื ืคืืึทืืก ืคึฟืึทืจ ืื ืึธืคึผืขืจืึทืฆืืข. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืื ืืขื ืืืึทืฉืคึผืื ืืื ืื, ืื ืืฉืึทื ืจืึท ืคืื ืึท ืกืคึผืขืฆืืคืืฉ ืงืื ืกืืืขืจ ืืื ืืขืจืืืึทื ืืืงื ืืืืืจื ืืืืฃ ืืืื ืืื.
db.music.update(
{"artist": "The Acme Band"},
{
$set: {
"genre": "Disco"
}
},
{"multi": true, "upsert": true}
);ืจืืืืืืื ื ืืึทืื ืคืื ืึท ืืืฉ
ืคึผืึธืกืืืจืขืกืงื
DELETE FROM Music
WHERE Artist = 'The Acme Band' AND SongTitle = 'Look Out, World';ืงืึทืกืกืึทื ืืจืึท
ืขื ืืขื ืฆื ืื PostgreSQL ืืืืฉืคึผืื ืืืืื.
ืืึธื ืืึธืื
MongoDB ืืื ืฆืืืื ืืืืคึผืก ืคืื ืึทืคึผืขืจืืืฉืึทื ื ืฆื ืืืกืืขืงื ืืึธืงืืืขื ืื - ะธ . ืืืืืข ืืืืคึผืก ืืืกืืขืงื ืืึธืงืืืขื ืื ืึธืืขืจ ืฆืืจืืงืงืืืขื ืคืึทืจืฉืืืขื ืข ืจืขืืืืืึทืื.
db.music.deleteMany( {
artist: "The Acme Band"
}
);
ืืืกืืขืงื ืึท ืืืฉ
ืคึผืึธืกืืืจืขืกืงื
DROP TABLE Music;ืงืึทืกืกืึทื ืืจืึท
ืขื ืืขื ืฆื ืื PostgreSQL ืืืืฉืคึผืื ืืืืื.
ืืึธื ืืึธืื
db.music.drop();ืกืึธืฃ
ืื ืืขืืึทืืข ืืืขืื ืืฉืืืื ื ืฆืืืืฉื SQL ืืื NoSQL ืืื ืจืืืืืฉืื ื ืคึฟืึทืจ ืืขืจ ืืื 10 ืืึธืจ. ืขืก ืืขื ืขื ืฆืืืื ืืืืคึผื ืึทืกืคึผืขืงืฅ ืคืื ืืขื ืืขืืึทืืข: ืืึทืืึทืืืืก ืืึธืืึธืจ ืึทืจืงืึทืืขืงืืฉืขืจ (ืืึธื ืึธืืืืืืง, ืืจืึทื ืกืึทืงืืืึธื ืึทื ืกืงื ืืืก ืคืื ืื ืืขืจืืขืืืืื, ื ืื-ืืจืึทื ืืึทืงืฉืึทื ืึทื ื ืึธืกืงืงื) ืืื ืืึทืืึทืืืืก ืคึผืืึทื ืฆืืืึทื ื (ืืึธืืขืืื ื ืืืื ืืึทืื ืืื SQL ืืืก ืืึธืืขืืื ื ืืืื ืคึฟืจืืื ืืื NoSQL).
ืืื ืึท ืคืื ืื ืืขืจืืขืืืืื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืึทืืึทืืืืก ืืื YugaByte DB, ืื ืืขืืึทืืข ืืืขืื ืืึทืืึทืืืืก ืึทืจืงืึทืืขืงืืฉืขืจ ืงืขื ืขื ืืืื ืืืืื ืฉืืขืื ืฆื ืจื. ืืื ืืึทืื ืืืึทืืืืื ืืืขืจื ืืจืขืกืขืจืข ืืื ืืืึธืก ืงืขื ืขื ืืืื ืืขืฉืจืืื ืฆื ืึท ืืืื ื ืึธืืข, ืึท ืืึธืจ ืคืื ืื ืืขืจืืขืืืืื ืึทืจืงืึทืืขืงืืฉืขืจ ืืืึธืก ืฉืืืฆื ืืื ืขืึทืจ ืฉืจืืึทืื ืกืงืึทืืึทืืืืืื ืืื ืึธืืึทืืึทืืืง ืฉืึทืจืืื ื / ืจืืืึทืืึทื ืกืื ื ืืืขืจื ื ืืืืืง.
ืืืืกืขืจืืขื, ืืื ืขืก ืฉืืืื ืืื ืืืื ืขื ืคืื ืื ืืจืืืงืืขื ,ืืจืึทื ืกืึทืงืืืึธื ืึทื, ืฉืืืจืง ืงืึธื ืกืืกืืขื ื ืึทืจืงืึทืืขืงืืฉืขืจื ืืขื ืขื ืืืฆื ืืขืจ, ืืขื ืืฆื ืฆื ืฆืืฉืืขืื ืืขืกืขืจ ืึทื ืืืืืงืืื ื ืคืืื ืงืืึทื ืืื ื ืื-ืืจืึทื ืืึทืงืฉืึทื ืึทื, ืืืืขื ืืฉืึทืืืึทืื ืงืึธื ืกืืกืืขื ื ืึทืจืงืึทืืขืงืืฉืขืจื.
ืฆืืจืืง ืฆื ืื ืืืกืงืืกืืข ืคืื โโืื ืืึทืืึทืืืืก ืคึผืืึทื, ืขืก ืืื ืฉืืื ืฆื ืืึธืื ืึทื ืืืืืข ืคึผืืึทื ืึทืคึผืจืึธืืืฉืื (SQL ืืื NoSQL) ืืขื ืขื ื ืืืืืง ืคึฟืึทืจ ืงืืื ืงืึธืืคึผืืขืงืก ืคืึทืงืืืฉ-ืืืขืื ืึทืคึผืืึทืงืืืฉืึทื. ืื ืกืงื "ืืึทืืึท ืืึธืืขืืื ื" ืฆืืืึทื ื ืึทืืึทืื ืืขืืืขืืึธืคึผืขืจืก ืฆื ืืขืจ ืืืืื ืืจืขืคื ืืฉืึทื ืืื ื ืืขืฉืขืคื ืจืขืงืืืืจืขืืขื ืฅ, ืืฉืขืช ืื NoSQL "ืึธื ืคึฟืจืขื ืืึธืืขืืื ื" ืฆืืืึทื ื ืึทืืึทืื ืื ืืขืืืข ืืขืืืขืืึธืคึผืขืจืก ืฆื ืึทืจืืขืื ืืืืฃ ืืจืืืก ืืืึทืืืืื ืคืื ืืึทืื ืืื ื ืืืขืจืืง ืืืืืึทื ืกื ืืื ืืืื ืืจืืคึผืื. ืขืก ืืื ืคึฟืึทืจ ืืขื ืกืืื ืึทื YugaByte DB ืืื SQL ืืื NoSQL APIs ืืื ืึท ืคึผืจืึธืกื ืืึทืจืฅ, ืืื ืืื ืคึผืจืึทืืึธืืืื ื ืืืื ืขืจ ืคืื ืื ืึทืคึผืจืึธืืืฉืื. ืึทืืืืืืึธื ืึทืืื, ืืืจื ืคึผืจืึทืืืืืืื ื ืงืึทืืคึผืึทืืึทืืืืึทืื ืืื ืคืึธืืงืก ืืึทืืึทืืืืก ืฉืคึผืจืึทืื ืึทืจืืึทื ืืขืจืขืื ื PostgreSQL ืืื Cassandra, YugaByte DB ืื ืฉืืจื ืึทื ืืขืืืขืืึธืคึผืขืจืก ืืึธื ื ืื ืืึธืื ืฆื ืืขืจื ืขื ืื ืื ืืขืจ ืฉืคึผืจืึทื ืฆื ืึทืจืืขืื ืืื ืึท ืคืื ืื ืืขืจืืขืืืืื, ืืขืืกื ืงืึธื ืกืืกืืขื ื ืืึทืืึทืืืืก ืืึธืืึธืจ.
ืืื ืืขื ืึทืจืืืงื, ืืืจ ืืขืงืืงื ืืืืฃ ืืื ืื ืคืึทื ืืึทืืขื ืืึทืื ืคืื ืื ืืึทืืึทืืืืก ืคึผืืึทื ืืขื ืขื ืึทื ืืขืจืฉ ืฆืืืืฉื PostgreSQL, Cassandra ืืื MongoDB. ืืื ืฆืืงืื ืคึฟื ืึทืจืืืงืืขื, ืืืจ ืื ืืขืจืืืงื ืืื ืืื ืึทืืืึทื ืกืืจืืข ืคึผืืึทื ืงืึทื ืกืขืคึผืก ืึทืืึท ืืื ืื ืืขืงืกืื, ืืจืึทื ืืึทืงืฉืึทื ื, JOINs, TTL ืืืืจืขืงืืืืื ืืื JSON ืืึธืงืืืขื ืื.
ืืืจ ืืืื ืืฉื ืืืจ ืึท ืืจืืืก ืื ืืื ืคืื ืื ืึธืคึผืจืืืขื ืืื ืืึทืื ืืืจ ืฆื , ืืืืก ืืืขื ืคืืจืงืืืขื ืืขื 14ืื ืืื.
ืืงืืจ: www.habr.com