Redis + 몽고DB와 카우치베이스 비교: 성능 벤치마크 비교

> SQL

// Redis lacks scope and collection capability
const redisClient = redis.createClient({ ... });
redisClient.connect();
const value = await redisClient.get('key');

> SQL

/* equivalent to the Mongo example */
SELECT SUM(value * volume) AS val, symbol
FROM   db.stocks
WHERE  symbol IN ( "AAPL", "GOOG" ) AND value > 0
GROUP  BY symbol
ORDER  BY val DESC, symbol ASC

> SQL

// equivalent to the SQL++ example
db.stocks.aggregate([
	 { "$match": {
	 	 "$and": [
	 	 	 {"symbol": {
	 	 	 	 "$in": [
	 	 	 	 "AAPL",
	 	 	 	 "GOOG"]}},
	 	 	 { "value": {
	 	 	 "$gt": 0 }}]}},
	 { "$group": {
	 	 "_id": {
	 	 	 "symbol": "$symbol" },
	 	 "sum(value * volume)": {
	 	 	 "$sum": {
	 	 	 	 "$multiply": [
	 	 	 	 	 "$value",
	 	 	 	 	 "$volume"]}}}},
	 { "$project": {
	 	 "_id": 0,
	 	 "sum(value * volume)": "$sum(value * volume)",
	 	 "symbol": "$_id.symbol"}}
	 { "$sort": {
	 	 "sum(value * volume)": -1,
	 	 "symbol": 1 }}]})

> SQL

// Redis lacks a complex query language like SQL