[B! JSON] moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

moritata id:moritata

JSONã«é–¢ã™ã‚‹moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

DuckDB ãƒ¡ãƒ¢ v1
è‰²ã€…å¤ããªã£ãŸã®ã§ 1 ã‹ã‚‰æ›¸ãç›´ã—ãŸ DuckDB ãƒ¡ãƒ¢ v2 ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ JSONL ã‚’èªã¿è¾¼ã‚“ã§è§£æžã™ã‚‹ãƒ„ãƒ¼ãƒ«ãŒæ¬²ã—ã‹ã£ãŸ ãƒã‚°ã‚’èªã¿è¾¼ã¾ã›ãŸã„ã®ã§åœ§ç¸®æ©Ÿèƒ½ã¯å¿…é ˆ è‡ªç¤¾ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸è£½å“ãŒå‡ºåŠ›ã™ã‚‹ JSONL ã‚’èªã¿è¾¼ã‚“ã§è§£æžã§ãã‚‹ä»•çµ„ã¿ é¡§å®¢ãŒå•é¡Œè§£æžã‚’æ°—è»½ã«ã§ãã‚‹ã‚ˆã†ã«ã—ãŸã„ é¡§å®¢å‘ã‘ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦æä¾›ã—ãŸã„ ã¤ã¾ã‚Šé¡§å®¢ç’°å¢ƒã§å‹•ã‹ã—ãŸã„ 1 ãƒã‚¤ãƒŠãƒª OSS ã¨ã—ã¦æä¾›ã—ãŸã„ Apache-2.0 ã¨ã—ã¦å…¬é–‹ã—ãŸã„ ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯å¤§ããã¦ã‚‚ 100 GB ã¯è¡Œã‹ãªã„ ã‚‚ã¨ã‚‚ã¨ Go + SQLite + JSONB ã§æ¤œè¨Žã—ã¦ã„ãŸ SQL ã§æ›¸ããŸã„ SQLite ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦æ›¸ãå‡ºã—ãŸã„ SQLite ãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¯ä¿¡é ¼ã§ãã‚‹ S3 ãªã©ã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç½®ã„ã¦ãŠãã ã‘ã«ã—ãŸã„ ã‚¯ãƒ©ã‚¦ãƒ‰ç‰ˆã«çµ„ã¿è¾¼ã¿ãŸã„ é¡§å®¢æ¯Žã« duckdb ãƒ•ã‚¡ã‚¤ãƒ«ä½œã‚Œã°ã„ã„ã®ã§ã¯ï¼Ÿ duckdb ãƒ•ã‚¡
moritata 2024/02/05
api

db

json
ãƒªãƒ³ã‚¯
GPT-3.5-Turbo / GPT-4-Turbo 1106ã®JSONãƒ¢ãƒ¼ãƒ‰ã®ä½¿ã„æ–¹ï½œshi3z
æ—¥æœ¬æ™‚é–“æœªæ˜Ž(åˆå‰ä¸‰æ™‚)ã‚‚ã®ã™ã”ã„ã‚¹ãƒ”ãƒ¼ãƒ‰ã§èªžã‚‰ã‚ŒãŸOpenAIåˆã®é–‹ç™ºè€…å‘ã‘ã‚¤ãƒ™ãƒ³ãƒˆDevDayã§ç™ºè¡¨ã•ã‚ŒãŸGPT-4-Turboã¨GPT-3.5-Turboã«ã‚ˆã‚‹JSONãƒ¢ãƒ¼ãƒ‰ã€‚ ã“ã‚Œã¯ã‚‚ã®ã™ã”ãå¼·åŠ›ãªã‚“ã ã‘ã©ã€Python APIã«ã‚ˆã‚‹ä½¿ã„æ–¹ãŒã©ã“ã«ã‚‚æã„ã¦ãªã„ã®ã§è©¦è¡ŒéŒ¯èª¤ã®æœ«è¦‹ã¤ã‘ã¾ã—ãŸã®ã§å…±æœ‰ã„ãŸã—ã¾ã™ã€‚ from openai import OpenAI import openai import os openai.api_key = "<APIã‚ãƒ¼>" client = OpenAI() def gpt(utterance): #response = openai.chat( response = client.chat.completions.create( #model="gpt-4-1106-preview", model="gpt-3.5-turbo-1106", r
moritata 2023/11/09
api

ai

python

ä»•äº‹

ChatGPT

OpenAI

JSON

æ–‡ç«
ãƒªãƒ³ã‚¯
Kotlinx Json vs Gson
If you have ever implemented any REST API in your mobile app, you should be familiar with JSON format. JSON is an open-standard file format or data interchange format that uses human-readable text to transmit data objects consisting of attribute-value pairs and array data types. The most common way how to parse JSON-format data to java/kotlin objects is by using one of the popular libraries like J
moritata 2020/01/06
data

java

library

kotlin

JSON
ãƒªãƒ³ã‚¯
ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§Slackã‚’èªã‚€ - è©©ã¨å‰µä½œãƒ»æ€ç´¢ã®ã²ã‚ã°
Slackã¯ãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒãã‚Œãªã‚Šã«ã€ã‹ãªã‚Šã‚ˆãã§ãã¦ã„ã¦ã€ã“ã‚Œã§ã»ã¨ã‚“ã©å›°ã‚‹ã“ã¨ã¯ãªã„ã‚“ã ã‘ã©ã€ãã†ã¯è¨€ã£ã¦ã‚‚ã‚‚ã†ã¡ã‚‡ã£ã¨ãƒ—ãƒã‚°ãƒ©ãƒžãƒ–ãƒ«ã«å–ã‚Šæ‰±ã„ãŸã„ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ãã†ã„ã†å ´åˆã«ã‚‚ã‚ˆã„APIãŒç”¨æ„ã•ã‚Œã¦ã„ã¦ã€Real Time Messaging API ã£ã¦ã®ãŒã‚ã‚‹ã€‚ã“ã„ã¤ã¯WebSocketã§Slackã®ç™ºè¨€ã‚’ã¯ã˜ã‚ã€ã‚ã‚‰ã‚†ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆã®JSONã‚’é€ã‚Šã¤ã‘ã¦ãã‚Œã‚‹ã‚„ã¤ã€‚ã²ã¨ã¾ãšã“ã‚Œã‚’æ¨™æº–å‡ºåŠ›ã«æµã™ã“ã¨ãŒã§ãã‚Œã°ã€ã‚ã¨ã¯å¥½ãã«æ–™ç†ã§ãã‚‹ã¯ãšã ã€‚ ã¨ã„ã†ã‚ã‘ã§ä½œã£ãŸã®ãŒã“ã¡ã‚‰ã€‚æ›¸ã„ãŸã“ã¨ãªã‹ã£ãŸã®ã§Rustã§ã™ã€‚ã¡ã‚‡ã†ã©ã„ã„ãƒã‚¿ã ã£ãŸã€‚ GitHub - motemen/slack-stream-json slack-stream-json ã¨ã„ã†ãƒã‚¤ãƒŠãƒªãŒã€SLACK_TOKEN ç’°å¢ƒå¤‰æ•°ã‚’è¨å®šã—ãŸä¸Šã§èµ·å‹•ã—ã¦ã‚„ã‚‹ã¨ã€RTM APIã«ã‚ˆã£ã¦å¾—ã‚‰ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã®JSONã‚’ãã®ã¾ã¾æ¨™æº–å‡ºåŠ›
moritata 2019/11/23
slack

JSON

ã‚¿ãƒ¼ãƒŸãƒŠãƒ«

message
ãƒªãƒ³ã‚¯
Fast JSON API serialization with Ruby on Rails
by Shishir Kakaraddi, Srinivas Raghunathan, Adam Gross and Ryan Johnston We are pleased to announce the open source release of the Fast JSON API gem geared towards Ruby on Rails applications. Introduction Fast JSONAPI is aimed at providing all the major functionality that Active Model Serializer (AMS) provides, along with an em phasis on speed and performance by meeting a benchmark requirement of b
moritata 2018/02/01
ã‚ã¨ã§èªã‚€

Ruby

Netflix

performance

JSON

Ruby on Rails

Rails
ãƒªãƒ³ã‚¯
JSONã§ç–²å¼Šã—ãŸã‚‰è©¦ã—ãŸã„ã€ã‚¢ãƒ—ãƒªã®ãƒ‡ãƒ¼ã‚¿ã‚’SQLiteã§å—ã‘æ¸¡ã™ã¨ã„ã†é¸æŠžè‚¢ - ã‚¢ãƒ‹ãƒžãƒé–‹ç™ºæ—¥èªŒ
ã‚¢ãƒ‹ãƒžãƒã®å†…éƒ¨ã§ã¯ã‚¢ãƒ—ãƒªã¨ã‚µãƒ¼ãƒãƒ¼é–“ã§ã©ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’å—ã‘æ¸¡ã—ã—ã¦ã„ã‚‹ã‹ã¨ã„ã†è©±ã‚’ã—ã¦ã¿ã¾ã™ã€‚ ä¸€èˆ¬çš„ã«ã‚¢ãƒ—ãƒªã¨ã‚µãƒ¼ãƒãƒ¼é–“ã®ãƒ‡ãƒ¼ã‚¿ã®å—ã‘æ¸¡ã—ã ã¨JSONã‚„XMLã€YAMLãªã©ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã“ã«SQLiteã¨ã„ã†é¸æŠžè‚¢ã‚’å…¥ã‚Œã‚‹ã¨è‰²ã€…å¹¸ã›ã«ãªã‚Œã‚‹ã¨ã„ã†è©±ã§ã™ã€‚ ã‚‚ã¯ã‚„ä½•ã§ä»Šã¾ã§JSONã¨ã„ã†å›ºå®šè¦³å¿µãŒæ¨ã¦ã‚‰ã‚Œãªã‹ã£ãŸã®ã‹ã¨ã„ã†ãã‚‰ã„ã€å€‹äººçš„ã«ã¯ã‚³ãƒãƒ³ãƒ–ã‚¹ã®åµã§ã—ãŸã€‚ ã‚ã¾ã‚Šäº‹ä¾‹ã¯ãªã•ãã†ãªã®ã§ã€ã“ã“ã§ç´¹ä»‹ã—ã¦ã¿ã¾ã™ã€‚ ã‚¢ãƒ‹ãƒžãƒã§ã®å•é¡Œç‚¹ ã‚¢ãƒ‹ãƒ¡ã‚¢ãƒ—ãƒªã®ã‚¢ãƒ‹ãƒžãƒã§ã¯ä¸»ã«ã‚¢ãƒ‹ãƒ¡ã®ç•ªçµ„è¡¨ã‚„ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰å—ã‘å–ã£ã¦è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ éƒ½é“åºœçœŒã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒã€ä¸€ã¤ã®éƒ½é“åºœçœŒã®1é€±é–“åˆ†ã®ç•ªçµ„è¡¨ï¼ˆã‚¢ãƒ‹ãƒ¡ã ã‘ï¼‰ã‚’JSONã«ã™ã‚‹ã¨å¤§ä½“750KBãã‚‰ã„ã«ãªã‚‹ã‚“ã§ã™ãã€‚ ã“ã‚Œã‚’é–‹ç™ºåˆæœŸã§ã¯MessagePackã«ç½®ãæ›ãˆã¦ã¾ã—ãŸã€‚ è©±ã®æœ¬ç‹ã¨ã¯é–¢ä¿‚ãªã„ã§ã™ãŒã€JSONã‚ˆã‚Šã¯MessagePackã®æ–¹
moritata 2015/10/10
sqlite

json

é–‹ç™º

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
JSONå‡¦ç†ã‚³ãƒžãƒ³ãƒ‰ jq ã‚’ä½¿ã£ã¦ã¿ãŸ
æœ€è¿‘AWS Management Consoleã‹ã‚‰EC2ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’èµ·å‹•ã™ã‚‹ã‚ˆã‚Šã‚‚ã€APIã‹ã‚‰èµ·å‹•ã™ã‚‹ã»ã†ãŒæ…£ã‚ŒãŸã‚‰æ‰‹è»½ãªã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ ãã“ã§awscliã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ãŸã ã€ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã€JSONã‚’å‡ºåŠ›ã™ã‚‹ã®ã§ã™ãŒå‡ºåŠ›ãŒã¨ã¦ã‚‚é•·ã„ã®ã§ã™ã€‚ ãã“ã§å‡ºåŠ›ã•ã‚ŒãŸJSONã‹ã‚‰ã»ã—ã„æƒ…å ±ã ã‘ã‚’æŠ½å‡ºã™ã‚‹ã®ã«ã‚ˆãjqã¨ã„ã†sedã‚„grepã«ä¼¼ãŸã‚¹ãƒˆãƒªãƒ¼ãƒ ã‚¨ãƒ‡ã‚£ã‚¿çš„ãªã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã‚‰ã—ã„ã¨ã„ã†ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ãã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¨ç°¡å˜ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ã€‚ ï¼ˆ2017-12-21 è¿½è¨˜ï¼‰ æœ€è¿‘ã§ã¯ AWS CLI ã§ã‚‚æ¨™æº–ã§å‡ºåŠ›ãƒ•ã‚£ãƒ«ã‚¿ã‚’ã‹ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ã§ã€ãã¡ã‚‰ã‚’ä½¿ã†ã®ãŒç‹ã®ã‚ˆã†ã§ã™ã€‚ ãã‚Œä»¥å¤–ã® REST Web API ã‚’å©ãå ´åˆã«ä½¿ã†ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ KONG ã¨ã‹ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒãƒ¼ã‚¿ãƒ–ãƒ«Cã§æ›¸ã‹ã‚Œã¦ã„ã‚‹ã‹ã‚‰ä»–ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ä¾å˜ã—ã¦ã„ãªã„ã®
moritata 2014/09/24
console

curl

aws

json
ãƒªãƒ³ã‚¯
1