![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/img2.png\")
<\/a><\/p>\nNodeJS:<\/h4>\n
Node.js\u306f\u3001JavaScript\u30b3\u30fc\u30c9\u3092\u5f93\u6765\u306eWeb\u30d6\u30e9\u30a6\u30b6\u306e\u67a0\u306b\u3068\u3089\u308f\u308c\u305a\u306b\u52d5\u4f5c\u3055\u305b\u308b\u30e9\u30f3\u30bf\u30a4\u30e0\u74b0\u5883\u3068\u3057\u3066\u6a5f\u80fd\u3057\u307e\u3059\u3002Chrome\u306eV8 JavaScript\u30a8\u30f3\u30b8\u30f3\u3092\u6d3b\u7528\u3057\u305fNode.js\u306e\u30ce\u30f3\u30d6\u30ed\u30c3\u30ad\u30f3\u30b0\u3001\u30a4\u30d9\u30f3\u30c8\u99c6\u52d5\u8a2d\u8a08\u306b\u3088\u308a\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002Node.js\u306f\u52b9\u7387\u6027\u3068\u5fdc\u7b54\u6027\u306b\u91cd\u70b9\u3092\u7f6e\u3044\u3066\u3044\u307e\u3059\u3002<\/p>\n
GridDB:<\/h4>\n
GridDB\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306e\u30e2\u30ce\u306e\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30fb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3057\u307e\u3059\u3002\u6700\u5c0f\u9650\u306e\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u3067\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u8fc5\u901f\u306a\u30a2\u30af\u30bb\u30b9\u3068\u3001\u52b9\u679c\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u4fdd\u8a3c\u3059\u308b\u3002GridDB\u306f\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u51e6\u7406\u306e\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u30c1\u30e3\u30c3\u30c8\u30a2\u30d7\u30ea\u306e\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u306b\u6700\u9069\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n
Express:<\/h4>\n
Express\u306fNode.js\u306eWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3067\u3001\u30e2\u30d0\u30a4\u30eb\u3084Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306e\u591a\u304f\u306e\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u3002\u30b7\u30f3\u30b0\u30eb\u30da\u30fc\u30b8\u3001\u30de\u30eb\u30c1\u30da\u30fc\u30b8\u3001\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9\u306e\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u69cb\u7bc9\u3059\u308b\u305f\u3081\u306b\u63a1\u7528\u3055\u308c\u3066\u3044\u308b\u3002Node.js\u306e\u30aa\u30fc\u30d0\u30fc\u30ec\u30a4\u3068\u3057\u3066\u3001Express\u306f\u30b5\u30fc\u30d0\u30fc\u3068\u30eb\u30fc\u30c8\u7ba1\u7406\u3092\u5408\u7406\u5316\u3057\u307e\u3059\u3002<\/p>\n
Socket.io:<\/h4>\n
Socket.io\u3068\u547c\u3070\u308c\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u30fc\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306e\u30a4\u30d9\u30f3\u30c8\u99c6\u52d5\u578b\u30a6\u30a7\u30d6\u30fb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5411\u3051\u3067\u3059\u3002\u30a6\u30a7\u30d6\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u30b5\u30fc\u30d0\u30fc\u9593\u306e\u53cc\u65b9\u5411\u901a\u4fe1\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002<\/p>\n
Prerequisites:<\/h2>\n\n- JavaScript\u306e\u57fa\u672c\u7684\u306a\u77e5\u8b58\u304c\u3042\u308b\u3053\u3068\u304c\u4e0d\u53ef\u6b20\u3067\u3059\u3002<\/li>\n
- Node\u3068NPM\u304c\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n
\u30b9\u30c6\u30c3\u30d7\u3054\u3068\u306e\u8a2d\u5b9a<\/h4>\n
![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/img3.png\")
<\/a> Create a folder by using the command:<\/p>\n\nmkdir folder_name<\/code><\/pre>\n<\/div>\n\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066\u73fe\u5728\u306e\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u5909\u66f4\u3057\u307e\u3059\uff1a<\/p>\n
\ncd folder_name<\/code><\/pre>\n<\/div>\n\u305d\u306e\u5f8c\u3001Visual Studio Code\u3067\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304d\u3001\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u8d77\u52d5\u3059\u308b\u305f\u3081\u306b\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n
\nnpm init -y<\/code><\/pre>\n<\/div>\n\u51fa\u529b\u306f\u6b21\u306e\u3088\u3046\u306b\u308a\u307e\u3059\uff1a<\/p>\n
![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/img4.png\")
<\/a><\/p>\n\u3055\u3066\u3001Express\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306b\u306f\u3001\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3044\u307e\u3059<\/p>\n
\nnpm install -save express<\/code><\/pre>\n<\/div>\n\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066socket.io\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff1a<\/p>\n
\nnpm install -save socket.io<\/code><\/pre>\n<\/div>\nGridDB\u306e\u8a2d\u5b9a\uff1a<\/h4>\n
<\/p>\n
\u30b7\u30b9\u30c6\u30e0\u306e\u30bf\u30fc\u30df\u30ca\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
rpm\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n
\u307e\u305a\u3001apt repo\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\uff1a<\/p>\n
\nsudo sh -c 'echo \"deb https:\/\/www.griddb.net\/apt griddb\/5.3 multiverse\" >> \/etc\/apt\/sources.list.d\/griddb.list'<\/code><\/pre>\n<\/div>\n\u6b21\u306b\u3001\u30ad\u30fc\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\uff1a<\/p>\n
\nwget -qO - https:\/\/www.griddb.net\/apt\/griddb.asc | sudo apt-key add -<\/code><\/pre>\n<\/div>\n\u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u65b9\u6cd5\u3067\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u78ba\u8a8d\u3057\u307e\u3059\uff1a<\/p>\n
\nsudo apt update<\/code><\/pre>\n<\/div>\n\u6700\u5f8c\u306b\u3001GridDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff1a<\/p>\n
\nsudo apt install griddb-meta<\/code><\/pre>\n<\/div>\nGridDB\u30b5\u30fc\u30d0\u3092\u8d77\u52d5\u3057\u307e\u3059\uff1a<\/p>\n
\nsudo systemctl start gridstore<\/code><\/pre>\n<\/div>\n\u30b5\u30fc\u30d0\u30fc\u3092\u505c\u6b62\u3057\u307e\u3059\uff1a<\/p>\n
\nsudo systemctl stop gridstore<\/code><\/pre>\n<\/div>\n\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066admin\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3057\u307e\u3059\uff1a<\/p>\n
\nexport GS_HOME=\/var\/lib\/gridstore\/\nexport GS_LOG=\/var\/lib\/gridstore\/log\/\ngs_passwd admin\n<\/code><\/pre>\n<\/div>\nGridDB Community Edition\u306b\u306finit\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u306a\u3044\u305f\u3081\u3001GridDB\u306f\u624b\u52d5\u3067\u8d77\u52d5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u5f8c\u3001\u4ed6\u30ce\u30fc\u30c9\u3068\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u307e\u3059\u3002<\/p>\n
\ngs_startnode -u username\/password\ngs_joincluster -u admin\/admin<\/code><\/pre>\n<\/div>\n![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/start_node.png\")
<\/a> You can verify the status of GridDB by using the command:<\/p>\n\ngs_stat -u admin\/admin<\/code><\/pre>\n<\/div>\nOutput:<\/strong> ![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/gs_stat.png\")
<\/a><\/p>\n<\/p>\n
\u6b21\u306b\u3001Node\u304c\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066\u6a5f\u80fd\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3059\u308bserver.js\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u3092\uff08Visual Studio Code\u3067\uff09\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
\u305d\u3053\u306b\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/strong><\/p>\n\nconst express = require(\"express\");\nconst socketio = require(\"socket.io\");\nconst http = require(\"http\");\nconst app = express();\nconst griddb = require(\"griddb-node-api\");\n\nconst PORT = 3000;\nconst HOST = \"0.0.0.0\";\nconst server = http.createServer(app);\nconst io = socketio(server);\nconst factory = griddb.StoreFactory.getInstance();\nconst store = factory.getStore({\n notificationMember: \"127.0.0.1:10001\",\n clusterName: \"myCluster\",\n username: \"admin\",\n password: \"admin\",\n});\n\n\/\/ Schema\nvar timeConInfo = new griddb.ContainerInfo({\n name: \"Chat\",\n columnInfoList: [\n [\"timestamp\", griddb.Type.TIMESTAMP],\n [\"username\", griddb.Type.STRING],\n [\"message\", griddb.Type.STRING],\n ],\n type: griddb.ContainerType.TIME_SERIES,\n rowKey: true,\n});\n\n\/\/ Function to handle the \"chat_message\" event and store the message in GridDB\nasync function handleChatMessage(data) {\n try {\n let time_series;\n store\n .putContainer(timeConInfo, false)\n .then((ts) => {\n time_series = ts;\n return ts.put([new Date(), data.username, data.message]);\n })\n .then(() => {\n query = time_series.query(\n \"select * where timestamp > TIMESTAMPADD(HOUR, NOW(), -6)\"\n );\n return query.fetch();\n })\n .then((rowset) => {\n while (rowset.hasNext()) {\n var row = rowset.next();\n console.log(\n \"Time =\",\n row[0],\n \"User =\",\n row[1].toString(),\n \"Text =\",\n row[2]\n );\n }\n })\n .catch((err) => {\n if (err.constructor.name == \"GSException\") {\n for (var i = 0; i < err.getErrorStackSize(); i++) {\n console.log(\"[\", i, \"]\");\n console.log(err.getErrorCode(i));\n console.log(err.getMessage(i));\n }\n } else {\n console.log(err);\n }\n });\n\n console.log(\"Chat message stored successfully.\");\n } catch (error) {\n console.error(\"Error storing chat message:\", error);\n }\n}\n\n\/\/ Fetch all data\nconst FetchAll = async function () {\n const container = await store.getContainer(\"Chat\");\n\n const query = container.query(\n \"select * where timestamp > TIMESTAMPADD(HOUR, NOW(), -6)\"\n );\n const rowSet = await query.fetch();\n let res = [];\n while (rowSet.hasNext()) {\n const row = await rowSet.next();\n console.log(\"Name:\", row[1].toString(), \"Message:\", row[2]);\n res.push({ username: row[1].toString(), message: row[2] });\n }\n return res;\n};\n\napp.use(express.static(__dirname + \"\/public\"));\n\napp.get(\"\/\", (req, res) => {\n res.sendFile(__dirname + \"\/public\/index.html\");\n});\n\nio.on(\"connection\", (socket) => {\n console.log(\"A user connected: \", socket.id);\n\n socket.on(\"user_join\", (username) => {\n io.emit(\"user_join\", username);\n });\n\n socket.on(\"chat_message\", (data) => {\n io.emit(\"chat_message\", data);\n handleChatMessage(data);\n });\n\n socket.on(\"disconnect\", () => {\n console.log(\"User disconnected\");\n });\n});\n\napp.get(\"\/\", (req, res) => {\n res.send(\"Hello, World\");\n});\n\napp.get(\"\/api\/messages\", async (req, res) => {\n const response = await FetchAll();\n res.send(response);\n});\n\napp.post(\"\/api\/put\", async (req, res) => {\n const { username, message } = req.query;\n let data = {\n username,\n message,\n };\n handleChatMessage(data);\n\n res.send(\"done\");\n});\n\nserver.listen(PORT, HOST);\nconsole.log(`Running on http:\/\/${HOST}:${PORT}`);<\/code><\/pre>\n<\/div>\n\u30b3\u30fc\u30c9\u306e\u8aac\u660e<\/h3>\n
\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001Express\u3001Socket.io\u3001GridDB\u3092\u4f7f\u3063\u3066\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30fb\u30c1\u30e3\u30c3\u30c8\u30fb\u30b5\u30fc\u30d0\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002GridDB\u306b\u63a5\u7d9a\u3057\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30ab\u30e9\u30e0\u3092\u6301\u3064\u6642\u7cfb\u5217\u30b3\u30f3\u30c6\u30ca\u306b\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u683c\u7d0d\u30fb\u53d6\u5f97\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u306f\u30e6\u30fc\u30b6\u306e\u63a5\u7d9a\u3001\u5207\u65ad\u3001\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8a18\u9332\u3057\u307e\u3059\u3002\u95a2\u6570 handleChatMessage<\/code> \u306f\u975e\u540c\u671f\u306b\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092 GridDB \u306b\u683c\u7d0d\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u306f\u30a6\u30a7\u30d6\u30a4\u30f3\u30bf\u30d5\u30a7\u30fc\u30b9\u306b Express \u3092\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u901a\u4fe1\u306b Socket-io \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u6280\u8853\u3092\u52b9\u679c\u7684\u306b\u7d71\u5408\u3057\u3001\u5305\u62ec\u7684\u306a\u30c1\u30e3\u30c3\u30c8\u30b5\u30fc\u30d0\u3092\u5b9f\u73fe\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\nGridDB Initialization and Configuration<\/h3>\n
GridDB\u30b9\u30c8\u30a2\u306e\u521d\u671f\u5316\uff1a<\/p>\n
\nconst factory = griddb.StoreFactory.getInstance();\nconst store = factory.getStore({...});<\/code><\/pre>\n<\/div>\n\u3053\u308c\u3089\u306e\u884c\u306f GridDB \u30b9\u30c8\u30a2\u3078\u306e\u63a5\u7d9a\u3092\u521d\u671f\u5316\u3057\u307e\u3059\u3002\u305d\u3057\u3066\u3001getStore() \u3092\u4f7f\u7528\u3057\u3066\u3001\u30af\u30e9\u30b9\u30bf\u540d\u3001\u901a\u77e5\u30e1\u30f3\u30d0\uff08\u30b5\u30fc\u30d0\u30a2\u30c9\u30ec\u30b9\uff09\u3001\u8a8d\u8a3c\u60c5\u5831\u306a\u3069\u306e\u8a2d\u5b9a\u60c5\u5831\u3092\u542b\u3080\u30b9\u30c8\u30a2\u63a5\u7d9a\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
\u30c1\u30e3\u30c3\u30c8\u30b3\u30f3\u30c6\u30ca\u30b9\u30ad\u30fc\u30de\u306e\u5b9a\u7fa9\uff1a<\/h4>\n
var timeConInfo = new griddb.ContainerInfo({…});\u3053\u3053\u3067\u306f<\/code>Chat\u3068\u3044\u3046\u540d\u524d\u306e GridDB \u30b3\u30f3\u30c6\u30ca\u306e\u30b9\u30ad\u30fc\u30de\u3092\u5b9a\u7fa9\u3059\u308b\u3002GridDB\u306e\u30b3\u30f3\u30c6\u30ca\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u4f3c\u3066\u3044\u308b\u3002\u30b9\u30ad\u30fc\u30de\u3067\u306f\u3001\u30c1\u30e3\u30c3\u30c8\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u5fc5\u9808\u306e\u30c7\u30fc\u30bf\u30ab\u30e9\u30e0\u3067\u3042\u308b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u30e6\u30fc\u30b6\u540d\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u6307\u5b9a\u3059\u308b\u3002\u30b3\u30f3\u30c6\u30ca\u306e\u30bf\u30a4\u30d7\u306f<\/code>TIME_SERIES` \u306b\u8a2d\u5b9a\u3055\u308c\u3001\u30c7\u30fc\u30bf\u304c\u6642\u7cfb\u5217\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3059\u3002<\/p>\n\u30c1\u30e3\u30c3\u30c8\u30b3\u30f3\u30c6\u30ca\u306e\u4f5c\u6210\/\u30a2\u30af\u30bb\u30b9\u3068\u521d\u671f\u30c7\u30fc\u30bf\u306e\u633f\u5165\uff1a<\/h4>\n
store.putContainer()`\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001\u65b0\u3057\u3044\u30b3\u30f3\u30c6\u30ca\u3092\u4f5c\u6210\u3059\u308b\u304b\u3001\u63d0\u4f9b\u3055\u308c\u305f\u30b9\u30ad\u30fc\u30de\u306b\u57fa\u3065\u3044\u3066\u65e2\u5b58\u306e\u30b3\u30f3\u30c6\u30ca\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u6642\u7cfb\u5217\u30b3\u30f3\u30c6\u30ca\u306b\u30b5\u30f3\u30d7\u30eb\u30ec\u30b3\u30fc\u30c9\u3092\u633f\u5165\u3059\u308b\u3002<\/p>\n
\u30c1\u30e3\u30c3\u30c8\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306e GridDB \u30c7\u30fc\u30bf\u51e6\u7406<\/h4>\n
\u6700\u8fd1\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30af\u30a8\u30ea<\/strong><\/p>\n\u3053\u306e\u30b3\u30fc\u30c9\u306b\u306f\u3001\u904e\u53bb 6 \u6642\u9593\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u53d6\u5f97\u3059\u308b\u30af\u30a8\u30ea\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30af\u30a8\u30ea\u306f time_series.query()<\/code> \u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001GridDB \u304c\u6642\u9593\u30d9\u30fc\u30b9\u306e\u30af\u30a8\u30ea\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3067\u304d\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u633f\u5165<\/strong><\/p>\nhandleChatMessage \u95a2\u6570\u306f\u3001GridDB \u30b3\u30f3\u30c6\u30ca\u3078\u306e\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u683c\u7d0d\u3092\u51e6\u7406\u3059\u308b\u975e\u540c\u671f\u95a2\u6570\u3067\u3059\u3002\u5404\u30e1\u30c3\u30bb\u30fc\u30b8\u306f\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3068\u9001\u4fe1\u8005\u306e\u30e6\u30fc\u30b6\u540d\u3068\u5171\u306b Chat<\/code> \u30b3\u30f3\u30c6\u30ca\u306b\u633f\u5165\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u95a2\u6570\u306f\u3001GridDB \u306b\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u304c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u8ffd\u52a0\u3055\u308c\u308b\u69d8\u5b50\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\u65b0\u898f\u30d5\u30a1\u30a4\u30eb New File.<\/code> \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066 index.html<\/code> \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059<\/strong><\/p>\n\n<!DOCTYPE html>\n<html>\n <head>\n <title>Chat App<\/title>\n <meta\n name=\"viewport\"\n content=\"width=device-width,minimum-scale=1,initial-scale=1\"\n \/>\n <style>\n body {\n margin: 0;\n font-family: sans-serif;\n }\n\n form {\n position: fixed;\n bottom: 0;\n left: 0;\n width: 100%;\n display: flex;\n box-sizing: border-box;\n padding: 0.25rem;\n }\n\n form input {\n border: 0;\n padding: 0.5rem;\n width: 100%;\n outline: 0;\n margin-right: 0.5rem;\n border-radius: 0.25rem;\n background: #ccc;\n }\n\n form button {\n width: 6rem;\n background-color: #1b8c00;\n color: white;\n border: none;\n padding: 0.5rem;\n cursor: pointer;\n border-radius: 0.25rem;\n text-transform: uppercase;\n }\n\n form button:hover {\n background-color: #166d01;\n }\n\n .messages {\n margin: 0;\n padding: 0;\n margin-bottom: 3rem;\n }\n\n .messages li {\n padding: 0.5rem;\n }\n\n .messages li:nth-child(odd) {\n background: #eee;\n }\n <\/style>\n <\/head>\n <body>\n <ul class=\"messages\"><\/ul>\n <form>\n <input type=\"text\" class=\"input\" autocomplete=\"off\" autofocus \/>\n <button>Send<\/button>\n <\/form>\n <!--Client side-->\n <script src=\"\/socket.io\/socket.io.js\"><\/script>\n\n <script>\n const form = document.querySelector(\"form\");\n const input = document.querySelector(\".input\");\n const messages = document.querySelector(\".messages\");\n const username = prompt(\"Please Enter Your Name\");\n const socket = io();\n\n form.addEventListener(\n \"submit\",\n function (event) {\n event.preventDefault();\n\n \/\/ addMessage(username + \": \" + input.value);\n\n socket.emit(\"chat_message\", {\n username: username,\n message: input.value,\n });\n\n input.value = \"\";\n return false;\n },\n false\n );\n\n socket.on(\"chat_message\", function (data) {\n addMessage(data.username + \": \" + data.message);\n });\n\n socket.on(\"user_join\", function (data) {\n addMessage(data + \" Has Joined\");\n fetch(\"\/api\/messages\", {\n method: \"GET\",\n headers: {\n \"Content-Type\": \"application\/json\",\n },\n })\n .then((res) => {\n res\n .json()\n .then((data) => {\n console.log(data);\n data.forEach((message) => {\n addMessage(message.username + \": \" + message.message);\n });\n })\n .catch((err) => {\n console.log(err);\n });\n })\n .catch((err) => {\n console.log(err);\n });\n });\n\n socket.on(\"user_leave\", function (data) {\n addMessage(data + \" Has Left\");\n });\n socket.on(\"disconnect\", function () {\n addMessage(\"You Have Disconnected\");\n });\n\n addMessage(\"You Have Joined As \" + username);\n socket.emit(\"user_join\", username);\n\n function addMessage(message) {\n const li = document.createElement(\"li\");\n li.innerHTML = message;\n messages.appendChild(li);\n window.scrollTo(0, document.body.scrollHeight);\n }\n <\/script>\n <\/body>\n<\/html><\/code><\/pre>\n<\/div>\n\u30b3\u30fc\u30c9\u306e\u8aac\u660e:<\/strong><\/p>\n\u4e0a\u306e\u30b3\u30fc\u30c9\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30fb\u30c1\u30e3\u30c3\u30c8\u30fb\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30fb\u30b5\u30a4\u30c9\u90e8\u5206\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002 \u30bb\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u30b9\u30bf\u30a4\u30ea\u30f3\u30b0\u3092\u7d44\u307f\u8fbc\u307f\u3001\u69cb\u9020\u306f\u5f93\u6765\u306e HTML5 \u3067\u3059\u3002\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u9806\u5e8f\u306a\u3057\u30ea\u30b9\u30c8\u306f\u3001\u5165\u529b\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u30e1\u30c3\u30bb\u30fc\u30b8\u5165\u529b\u306e\u305f\u3081\u306e\u4e0b\u90e8\u306b\u3042\u308b’\u9001\u4fe1’\u30dc\u30bf\u30f3\u3092\u6301\u3064\u56fa\u5b9a\u30d5\u30a9\u30fc\u30e0\u3068\u4e00\u7dd2\u306b\u3001\u30dc\u30c7\u30a3\u306b\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u901a\u4fe1\u306f\u3001\u57cb\u3081\u8fbc\u307e\u308c\u305fJavaScript\u304cSocket.io\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u4f7f\u7528\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u30ed\u30b0\u30a4\u30f3\u306b\u306f\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u304c\u5fc5\u8981\u3067\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u306a\u3069\u4e00\u90e8\u306e\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3067\u306f\u30b5\u30fc\u30d0\u30fc\u304cSocket.io\u30a4\u30d9\u30f3\u30c8\u3092\u53d7\u4fe1\u3057\u307e\u3059\u3002\u3055\u3089\u306b\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u30b5\u30fc\u30d0\u30fc\u304b\u3089\u9001\u4fe1\u3055\u308c\u308b\u3055\u307e\u3056\u307e\u306a\u30a4\u30d9\u30f3\u30c8\u3092\u30ea\u30c3\u30b9\u30f3\u3059\u308b\u3053\u3068\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u52d5\u7684\u306b\u66f4\u65b0\u3057\u307e\u3059\u3002<\/p>\n
Output:<\/strong><\/p>\n![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2024\/02\/ld_lib.png\")
<\/a><\/p>\n\u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n
\nnode server.js<\/code><\/pre>\n<\/div>\n
\u30b9\u30c6\u30c3\u30d7\u3054\u3068\u306e\u8a2d\u5b9a<\/h4>\n
\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066\u73fe\u5728\u306e\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u5909\u66f4\u3057\u307e\u3059\uff1a<\/p>\n \u305d\u306e\u5f8c\u3001Visual Studio Code\u3067\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304d\u3001\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u8d77\u52d5\u3059\u308b\u305f\u3081\u306b\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n \u51fa\u529b\u306f\u6b21\u306e\u3088\u3046\u306b\u308a\u307e\u3059\uff1a<\/p>\n \u3055\u3066\u3001Express\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306b\u306f\u3001\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3044\u307e\u3059<\/p>\n \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066socket.io\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff1a<\/p>\n <\/p>\n \u30b7\u30b9\u30c6\u30e0\u306e\u30bf\u30fc\u30df\u30ca\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n rpm\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n \u307e\u305a\u3001apt repo\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\uff1a<\/p>\n \u6b21\u306b\u3001\u30ad\u30fc\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\uff1a<\/p>\n \u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u65b9\u6cd5\u3067\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u78ba\u8a8d\u3057\u307e\u3059\uff1a<\/p>\n \u6700\u5f8c\u306b\u3001GridDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff1a<\/p>\n GridDB\u30b5\u30fc\u30d0\u3092\u8d77\u52d5\u3057\u307e\u3059\uff1a<\/p>\n \u30b5\u30fc\u30d0\u30fc\u3092\u505c\u6b62\u3057\u307e\u3059\uff1a<\/p>\n \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066admin\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3057\u307e\u3059\uff1a<\/p>\n GridDB Community Edition\u306b\u306finit\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u306a\u3044\u305f\u3081\u3001GridDB\u306f\u624b\u52d5\u3067\u8d77\u52d5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u5f8c\u3001\u4ed6\u30ce\u30fc\u30c9\u3068\u306e\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u307e\u3059\u3002<\/p>\n Output:<\/strong> <\/p>\n \u6b21\u306b\u3001Node\u304c\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066\u6a5f\u80fd\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3059\u308bserver.js\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u3092\uff08Visual Studio Code\u3067\uff09\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n \u305d\u3053\u306b\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/strong><\/p>\n \u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001Express\u3001Socket.io\u3001GridDB\u3092\u4f7f\u3063\u3066\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30fb\u30c1\u30e3\u30c3\u30c8\u30fb\u30b5\u30fc\u30d0\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002GridDB\u306b\u63a5\u7d9a\u3057\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30ab\u30e9\u30e0\u3092\u6301\u3064\u6642\u7cfb\u5217\u30b3\u30f3\u30c6\u30ca\u306b\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u683c\u7d0d\u30fb\u53d6\u5f97\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u306f\u30e6\u30fc\u30b6\u306e\u63a5\u7d9a\u3001\u5207\u65ad\u3001\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8a18\u9332\u3057\u307e\u3059\u3002\u95a2\u6570 GridDB\u30b9\u30c8\u30a2\u306e\u521d\u671f\u5316\uff1a<\/p>\n \u3053\u308c\u3089\u306e\u884c\u306f GridDB \u30b9\u30c8\u30a2\u3078\u306e\u63a5\u7d9a\u3092\u521d\u671f\u5316\u3057\u307e\u3059\u3002\u305d\u3057\u3066\u3001getStore() \u3092\u4f7f\u7528\u3057\u3066\u3001\u30af\u30e9\u30b9\u30bf\u540d\u3001\u901a\u77e5\u30e1\u30f3\u30d0\uff08\u30b5\u30fc\u30d0\u30a2\u30c9\u30ec\u30b9\uff09\u3001\u8a8d\u8a3c\u60c5\u5831\u306a\u3069\u306e\u8a2d\u5b9a\u60c5\u5831\u3092\u542b\u3080\u30b9\u30c8\u30a2\u63a5\u7d9a\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n var timeConInfo = new griddb.ContainerInfo({…}); store.putContainer()`\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001\u65b0\u3057\u3044\u30b3\u30f3\u30c6\u30ca\u3092\u4f5c\u6210\u3059\u308b\u304b\u3001\u63d0\u4f9b\u3055\u308c\u305f\u30b9\u30ad\u30fc\u30de\u306b\u57fa\u3065\u3044\u3066\u65e2\u5b58\u306e\u30b3\u30f3\u30c6\u30ca\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u6642\u7cfb\u5217\u30b3\u30f3\u30c6\u30ca\u306b\u30b5\u30f3\u30d7\u30eb\u30ec\u30b3\u30fc\u30c9\u3092\u633f\u5165\u3059\u308b\u3002<\/p>\n \u6700\u8fd1\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30af\u30a8\u30ea<\/strong><\/p>\n \u3053\u306e\u30b3\u30fc\u30c9\u306b\u306f\u3001\u904e\u53bb 6 \u6642\u9593\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u53d6\u5f97\u3059\u308b\u30af\u30a8\u30ea\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30af\u30a8\u30ea\u306f \u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u633f\u5165<\/strong><\/p>\n handleChatMessage \u95a2\u6570\u306f\u3001GridDB \u30b3\u30f3\u30c6\u30ca\u3078\u306e\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u683c\u7d0d\u3092\u51e6\u7406\u3059\u308b\u975e\u540c\u671f\u95a2\u6570\u3067\u3059\u3002\u5404\u30e1\u30c3\u30bb\u30fc\u30b8\u306f\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3068\u9001\u4fe1\u8005\u306e\u30e6\u30fc\u30b6\u540d\u3068\u5171\u306b \u65b0\u898f\u30d5\u30a1\u30a4\u30eb \u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059<\/strong><\/p>\n \u30b3\u30fc\u30c9\u306e\u8aac\u660e:<\/strong><\/p>\n \u4e0a\u306e\u30b3\u30fc\u30c9\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30fb\u30c1\u30e3\u30c3\u30c8\u30fb\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30fb\u30b5\u30a4\u30c9\u90e8\u5206\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002 \u30bb\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u30b9\u30bf\u30a4\u30ea\u30f3\u30b0\u3092\u7d44\u307f\u8fbc\u307f\u3001\u69cb\u9020\u306f\u5f93\u6765\u306e HTML5 \u3067\u3059\u3002\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u9806\u5e8f\u306a\u3057\u30ea\u30b9\u30c8\u306f\u3001\u5165\u529b\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u30e1\u30c3\u30bb\u30fc\u30b8\u5165\u529b\u306e\u305f\u3081\u306e\u4e0b\u90e8\u306b\u3042\u308b’\u9001\u4fe1’\u30dc\u30bf\u30f3\u3092\u6301\u3064\u56fa\u5b9a\u30d5\u30a9\u30fc\u30e0\u3068\u4e00\u7dd2\u306b\u3001\u30dc\u30c7\u30a3\u306b\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u901a\u4fe1\u306f\u3001\u57cb\u3081\u8fbc\u307e\u308c\u305fJavaScript\u304cSocket.io\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u4f7f\u7528\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u30ed\u30b0\u30a4\u30f3\u306b\u306f\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u304c\u5fc5\u8981\u3067\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u9001\u4fe1\u306a\u3069\u4e00\u90e8\u306e\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3067\u306f\u30b5\u30fc\u30d0\u30fc\u304cSocket.io\u30a4\u30d9\u30f3\u30c8\u3092\u53d7\u4fe1\u3057\u307e\u3059\u3002\u3055\u3089\u306b\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u30b5\u30fc\u30d0\u30fc\u304b\u3089\u9001\u4fe1\u3055\u308c\u308b\u3055\u307e\u3056\u307e\u306a\u30a4\u30d9\u30f3\u30c8\u3092\u30ea\u30c3\u30b9\u30f3\u3059\u308b\u3053\u3068\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u52d5\u7684\u306b\u66f4\u65b0\u3057\u307e\u3059\u3002<\/p>\n Output:<\/strong><\/p>\n \u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u307e\u3059\uff1a<\/p>\n<\/a> Create a folder by using the command:<\/p>\nmkdir folder_name<\/code><\/pre>\n<\/div>\ncd folder_name<\/code><\/pre>\n<\/div>\nnpm init -y<\/code><\/pre>\n<\/div>\n<\/a><\/p>\nnpm install -save express<\/code><\/pre>\n<\/div>\nnpm install -save socket.io<\/code><\/pre>\n<\/div>\nGridDB\u306e\u8a2d\u5b9a\uff1a<\/h4>\n
sudo sh -c 'echo \"deb https:\/\/www.griddb.net\/apt griddb\/5.3 multiverse\" >> \/etc\/apt\/sources.list.d\/griddb.list'<\/code><\/pre>\n<\/div>\nwget -qO - https:\/\/www.griddb.net\/apt\/griddb.asc | sudo apt-key add -<\/code><\/pre>\n<\/div>\nsudo apt update<\/code><\/pre>\n<\/div>\nsudo apt install griddb-meta<\/code><\/pre>\n<\/div>\nsudo systemctl start gridstore<\/code><\/pre>\n<\/div>\nsudo systemctl stop gridstore<\/code><\/pre>\n<\/div>\nexport GS_HOME=\/var\/lib\/gridstore\/\nexport GS_LOG=\/var\/lib\/gridstore\/log\/\ngs_passwd admin\n<\/code><\/pre>\n<\/div>\ngs_startnode -u username\/password\ngs_joincluster -u admin\/admin<\/code><\/pre>\n<\/div>\n<\/a> You can verify the status of GridDB by using the command:<\/p>\ngs_stat -u admin\/admin<\/code><\/pre>\n<\/div>\n<\/a><\/p>\nconst express = require(\"express\");\nconst socketio = require(\"socket.io\");\nconst http = require(\"http\");\nconst app = express();\nconst griddb = require(\"griddb-node-api\");\n\nconst PORT = 3000;\nconst HOST = \"0.0.0.0\";\nconst server = http.createServer(app);\nconst io = socketio(server);\nconst factory = griddb.StoreFactory.getInstance();\nconst store = factory.getStore({\n notificationMember: \"127.0.0.1:10001\",\n clusterName: \"myCluster\",\n username: \"admin\",\n password: \"admin\",\n});\n\n\/\/ Schema\nvar timeConInfo = new griddb.ContainerInfo({\n name: \"Chat\",\n columnInfoList: [\n [\"timestamp\", griddb.Type.TIMESTAMP],\n [\"username\", griddb.Type.STRING],\n [\"message\", griddb.Type.STRING],\n ],\n type: griddb.ContainerType.TIME_SERIES,\n rowKey: true,\n});\n\n\/\/ Function to handle the \"chat_message\" event and store the message in GridDB\nasync function handleChatMessage(data) {\n try {\n let time_series;\n store\n .putContainer(timeConInfo, false)\n .then((ts) => {\n time_series = ts;\n return ts.put([new Date(), data.username, data.message]);\n })\n .then(() => {\n query = time_series.query(\n \"select * where timestamp > TIMESTAMPADD(HOUR, NOW(), -6)\"\n );\n return query.fetch();\n })\n .then((rowset) => {\n while (rowset.hasNext()) {\n var row = rowset.next();\n console.log(\n \"Time =\",\n row[0],\n \"User =\",\n row[1].toString(),\n \"Text =\",\n row[2]\n );\n }\n })\n .catch((err) => {\n if (err.constructor.name == \"GSException\") {\n for (var i = 0; i < err.getErrorStackSize(); i++) {\n console.log(\"[\", i, \"]\");\n console.log(err.getErrorCode(i));\n console.log(err.getMessage(i));\n }\n } else {\n console.log(err);\n }\n });\n\n console.log(\"Chat message stored successfully.\");\n } catch (error) {\n console.error(\"Error storing chat message:\", error);\n }\n}\n\n\/\/ Fetch all data\nconst FetchAll = async function () {\n const container = await store.getContainer(\"Chat\");\n\n const query = container.query(\n \"select * where timestamp > TIMESTAMPADD(HOUR, NOW(), -6)\"\n );\n const rowSet = await query.fetch();\n let res = [];\n while (rowSet.hasNext()) {\n const row = await rowSet.next();\n console.log(\"Name:\", row[1].toString(), \"Message:\", row[2]);\n res.push({ username: row[1].toString(), message: row[2] });\n }\n return res;\n};\n\napp.use(express.static(__dirname + \"\/public\"));\n\napp.get(\"\/\", (req, res) => {\n res.sendFile(__dirname + \"\/public\/index.html\");\n});\n\nio.on(\"connection\", (socket) => {\n console.log(\"A user connected: \", socket.id);\n\n socket.on(\"user_join\", (username) => {\n io.emit(\"user_join\", username);\n });\n\n socket.on(\"chat_message\", (data) => {\n io.emit(\"chat_message\", data);\n handleChatMessage(data);\n });\n\n socket.on(\"disconnect\", () => {\n console.log(\"User disconnected\");\n });\n});\n\napp.get(\"\/\", (req, res) => {\n res.send(\"Hello, World\");\n});\n\napp.get(\"\/api\/messages\", async (req, res) => {\n const response = await FetchAll();\n res.send(response);\n});\n\napp.post(\"\/api\/put\", async (req, res) => {\n const { username, message } = req.query;\n let data = {\n username,\n message,\n };\n handleChatMessage(data);\n\n res.send(\"done\");\n});\n\nserver.listen(PORT, HOST);\nconsole.log(`Running on http:\/\/${HOST}:${PORT}`);<\/code><\/pre>\n<\/div>\n\u30b3\u30fc\u30c9\u306e\u8aac\u660e<\/h3>\n
handleChatMessage<\/code> \u306f\u975e\u540c\u671f\u306b\u30c1\u30e3\u30c3\u30c8\u30e1\u30c3\u30bb\u30fc\u30b8\u3092 GridDB \u306b\u683c\u7d0d\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u306f\u30a6\u30a7\u30d6\u30a4\u30f3\u30bf\u30d5\u30a7\u30fc\u30b9\u306b Express \u3092\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u901a\u4fe1\u306b Socket-io \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u6280\u8853\u3092\u52b9\u679c\u7684\u306b\u7d71\u5408\u3057\u3001\u5305\u62ec\u7684\u306a\u30c1\u30e3\u30c3\u30c8\u30b5\u30fc\u30d0\u3092\u5b9f\u73fe\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\nGridDB Initialization and Configuration<\/h3>\n
const factory = griddb.StoreFactory.getInstance();\nconst store = factory.getStore({...});<\/code><\/pre>\n<\/div>\n\u30c1\u30e3\u30c3\u30c8\u30b3\u30f3\u30c6\u30ca\u30b9\u30ad\u30fc\u30de\u306e\u5b9a\u7fa9\uff1a<\/h4>\n
\u3053\u3053\u3067\u306f<\/code>Chat\u3068\u3044\u3046\u540d\u524d\u306e GridDB \u30b3\u30f3\u30c6\u30ca\u306e\u30b9\u30ad\u30fc\u30de\u3092\u5b9a\u7fa9\u3059\u308b\u3002GridDB\u306e\u30b3\u30f3\u30c6\u30ca\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u4f3c\u3066\u3044\u308b\u3002\u30b9\u30ad\u30fc\u30de\u3067\u306f\u3001\u30c1\u30e3\u30c3\u30c8\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u5fc5\u9808\u306e\u30c7\u30fc\u30bf\u30ab\u30e9\u30e0\u3067\u3042\u308b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u30e6\u30fc\u30b6\u540d\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u6307\u5b9a\u3059\u308b\u3002\u30b3\u30f3\u30c6\u30ca\u306e\u30bf\u30a4\u30d7\u306f<\/code>TIME_SERIES` \u306b\u8a2d\u5b9a\u3055\u308c\u3001\u30c7\u30fc\u30bf\u304c\u6642\u7cfb\u5217\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3059\u3002<\/p>\n\u30c1\u30e3\u30c3\u30c8\u30b3\u30f3\u30c6\u30ca\u306e\u4f5c\u6210\/\u30a2\u30af\u30bb\u30b9\u3068\u521d\u671f\u30c7\u30fc\u30bf\u306e\u633f\u5165\uff1a<\/h4>\n
\u30c1\u30e3\u30c3\u30c8\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306e GridDB \u30c7\u30fc\u30bf\u51e6\u7406<\/h4>\n
time_series.query()<\/code> \u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001GridDB \u304c\u6642\u9593\u30d9\u30fc\u30b9\u306e\u30af\u30a8\u30ea\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3067\u304d\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\nChat<\/code> \u30b3\u30f3\u30c6\u30ca\u306b\u633f\u5165\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u95a2\u6570\u306f\u3001GridDB \u306b\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u304c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u8ffd\u52a0\u3055\u308c\u308b\u69d8\u5b50\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\nNew File.<\/code> \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066 index.html<\/code> \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<!DOCTYPE html>\n<html>\n <head>\n <title>Chat App<\/title>\n <meta\n name=\"viewport\"\n content=\"width=device-width,minimum-scale=1,initial-scale=1\"\n \/>\n <style>\n body {\n margin: 0;\n font-family: sans-serif;\n }\n\n form {\n position: fixed;\n bottom: 0;\n left: 0;\n width: 100%;\n display: flex;\n box-sizing: border-box;\n padding: 0.25rem;\n }\n\n form input {\n border: 0;\n padding: 0.5rem;\n width: 100%;\n outline: 0;\n margin-right: 0.5rem;\n border-radius: 0.25rem;\n background: #ccc;\n }\n\n form button {\n width: 6rem;\n background-color: #1b8c00;\n color: white;\n border: none;\n padding: 0.5rem;\n cursor: pointer;\n border-radius: 0.25rem;\n text-transform: uppercase;\n }\n\n form button:hover {\n background-color: #166d01;\n }\n\n .messages {\n margin: 0;\n padding: 0;\n margin-bottom: 3rem;\n }\n\n .messages li {\n padding: 0.5rem;\n }\n\n .messages li:nth-child(odd) {\n background: #eee;\n }\n <\/style>\n <\/head>\n <body>\n <ul class=\"messages\"><\/ul>\n <form>\n <input type=\"text\" class=\"input\" autocomplete=\"off\" autofocus \/>\n <button>Send<\/button>\n <\/form>\n <!--Client side-->\n <script src=\"\/socket.io\/socket.io.js\"><\/script>\n\n <script>\n const form = document.querySelector(\"form\");\n const input = document.querySelector(\".input\");\n const messages = document.querySelector(\".messages\");\n const username = prompt(\"Please Enter Your Name\");\n const socket = io();\n\n form.addEventListener(\n \"submit\",\n function (event) {\n event.preventDefault();\n\n \/\/ addMessage(username + \": \" + input.value);\n\n socket.emit(\"chat_message\", {\n username: username,\n message: input.value,\n });\n\n input.value = \"\";\n return false;\n },\n false\n );\n\n socket.on(\"chat_message\", function (data) {\n addMessage(data.username + \": \" + data.message);\n });\n\n socket.on(\"user_join\", function (data) {\n addMessage(data + \" Has Joined\");\n fetch(\"\/api\/messages\", {\n method: \"GET\",\n headers: {\n \"Content-Type\": \"application\/json\",\n },\n })\n .then((res) => {\n res\n .json()\n .then((data) => {\n console.log(data);\n data.forEach((message) => {\n addMessage(message.username + \": \" + message.message);\n });\n })\n .catch((err) => {\n console.log(err);\n });\n })\n .catch((err) => {\n console.log(err);\n });\n });\n\n socket.on(\"user_leave\", function (data) {\n addMessage(data + \" Has Left\");\n });\n socket.on(\"disconnect\", function () {\n addMessage(\"You Have Disconnected\");\n });\n\n addMessage(\"You Have Joined As \" + username);\n socket.emit(\"user_join\", username);\n\n function addMessage(message) {\n const li = document.createElement(\"li\");\n li.innerHTML = message;\n messages.appendChild(li);\n window.scrollTo(0, document.body.scrollHeight);\n }\n <\/script>\n <\/body>\n<\/html><\/code><\/pre>\n<\/div>\n<\/a><\/p>\nnode server.js<\/code><\/pre>\n<\/div>\n