[B! DB] shigiryouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shigiryou id:shigiryou

DBã«é–¢ã™ã‚‹shigiryouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

${{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}}

auspice
shigiryou 2022/01/30
SARS-cov-2

COVID-19

DB

Nextstrain

Japan

ç³»çµ±æ¨¹
ãƒªãƒ³ã‚¯
https://nextstrain.org/sars-cov-2
shigiryou 2022/01/30
SARS-cov-2

COVID-19

DB

Nextstrain

ç³»çµ±æ¨¹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®éš›ã«æ°—ã‚’ã¤ã‘ã¦ã„ã‚‹ã“ã¨ - é£Ÿã¹ãƒãƒ§ã‚¯é–‹ç™ºè€…ãƒ–ãƒã‚°
çš†ã•ã‚“ã“ã‚“ã«ã¡ã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è¥¿å°¾ã§ã™ã€‚ æ–°ã—ã„æ©Ÿèƒ½ãƒ»ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã™ã‚‹éš›ã€ç§ã¯ç‰¹ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«æ°—ã‚’ã¤ã‹ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚·ã‚¹ãƒ†ãƒ ã®åœŸå°ã§ã™ã€‚ åœŸå°ãŒä¸å®‰å®šã ã¨ã€ãã®ä¸Šã«ç©ã¿ä¸Šã’ã¦ã„ãã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ãŒã„ã³ã¤ãªã‚‚ã®ã«ãªã‚Šã€ã¤ã‚‰ã„æ€ã„ã‚’ã—ã¾ã™ã€‚ ã¾ãŸã€ä¸€åº¦å‹•ãå‡ºã—ã¦ã—ã¾ã£ãŸã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’å¤‰ãˆã‚‹ã®ã¯ã€å®¹æ˜“ãªã“ã¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ã¯â€ã“ã‚Œã ï¼â€ã¨ã„ã†æ£è§£ã¯ãªã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã®ç‰¹å¾´ã€ã‚·ã‚¹ãƒ†ãƒ ã®æ€§è³ªã€toBå‘ã‘/toCå‘ã‘ã€ReadãŒå¤šã„ãƒ»å°‘ãªã„ã€WriteãŒå¤šã„ãƒ»å°‘ãªã„ã€‚ ãã®ä»–ã‚‚ã‚ã‚‚ã‚ã®èƒŒæ™¯ã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ä»•æ–¹ã‚‚å¤‰ã‚ã£ã¦ãã¾ã™ã€‚ ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯æ£è¦åŒ–ã—ã¦ã„ãªã„ã‹ã‚‰é§„ç›®ã ã€ã“ã®è¨è¨ˆã¯ã„ã‚ã‚†ã‚‹ãƒãƒªãƒ¢ãƒ¼ãƒ•ã‚£ãƒƒã‚¯é–¢é€£ã ã‹ã‚‰ä½¿ã£ã¦ã¯ã„ã‘ãªã„ã€ãªã©ã¨ã„ã†ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã‚‚æ™‚ã¨å ´åˆã«ã‚ˆã£ã¦ã¯æ£è§£ã«ãªã‚Šã¾ã™ã€‚
shigiryou 2020/06/15
ã‚ã¨ã§èªã‚€

database

DB
ãƒªãƒ³ã‚¯
DBeaver - Community Edition 24.2.1
shigiryou 2019/11/16
DB

database
ãƒªãƒ³ã‚¯
DBeaver Community | Free Universal Database Tool
Basic support for relational databases: MySQL, SQL Server, PostgreSQL and others Data Editor SQL Editor Database schema editor DDL Basic ER Diagrams Basic charts Data export/import Task management Database maintenance tools All DBeaver Community featuresAdvanced securityAdvanced support for relational databasesConnection through ODBC driversNoSQL databases support: Mongo DB, Cassandra, Redis, Couch
shigiryou 2019/11/16
DB

database
ãƒªãƒ³ã‚¯
SQL Database Hyperscale ã®æ§‹æˆã‚„ç‰¹å¾´ã‚’å¦ç¿’ã™ã‚‹ at SE ã®é›‘è¨˜
æœ€çµ‚æ›´æ–°æ—¥ : 2019/12/20 SQL Database ã® Hyperscale ãŒ Build 2019 ã§ GA ã•ã‚Œã€SLA ä»˜ãã§ä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ç¾åœ¨å…¬é–‹ã•ã‚Œã¦ã„ã‚‹æƒ…å ±ã‚’è¦‹ãªãŒã‚‰å¦ç¿’ã—ã¦ã¿ã¾ã—ãŸã€‚ å…¬å¼ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯æ¬¡ã®æƒ…å ±ã¨ãªã‚Šã¾ã™ã€‚ æœ€å¤§ 100 TB ã® Hyperscale ã‚µãƒ¼ãƒ“ã‚¹ ãƒ¬ãƒ™ãƒ« Azure SQL ãƒã‚¤ãƒ‘ãƒ¼ã‚¹ã‚±ãƒ¼ãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹ FAQ ãƒã‚¤ãƒ‘ãƒ¼ã‚¹ã‚±ãƒ¼ãƒ« ã‚µãƒ¼ãƒ“ã‚¹ ãƒ¬ãƒ™ãƒ« SQL Hyperscale ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°è¨ºæ– ã‚ˆã‚Šè©³ã—ã„æƒ…å ±ã«ã¤ã„ã¦ã¯ã€æ¬¡ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰ç¢ºèªã§ãã¾ã™ã€‚ Socrates: The New SQL Server in the Cloud Develop data application on a no-limits SQL data platform Introducing
shigiryou 2019/06/02
DB
ãƒªãƒ³ã‚¯
Introducing InfluxDB 3.0 | InfluxData
Real-Time Analytics Collect, analyze, and predict in real time
shigiryou 2018/03/24
DB
ãƒªãƒ³ã‚¯
OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€Œç¯€ç›®ã€ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç™»å ´ã€€2017å¹´å‰åŠã®æ–°ãƒªãƒªãƒ¼ã‚¹ã¨2017å¹´å¾ŒåŠã®ãƒªãƒªãƒ¼ã‚¹äºˆå®šè£½å“ã¾ã¨ã‚
é€£è¼‰ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ 2017å¹´å¾ŒåŠã¯ã€PostgreSQL 10ã€MySQL 8.0ã€SQL Server 2017ãŒãƒªãƒªãƒ¼ã‚¹äºˆå®š OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯2017å¹´å¾ŒåŠã€ã€Œç¯€ç›®ã€ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç™»å ´ã—ã¾ã™ã€‚ä»Šå›žã¯ã€2017å¹´å‰åŠã«ç™»å ´ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ è£½å“ã€ãã—ã¦2017å¹´å¾ŒåŠä»¥é™ã«æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç™»å ´ã—ãã†ãªè£½å“ã‚’ãƒã‚§ãƒƒã‚¯ã—ã¾ã—ã‚‡ã†ã€‚ ã¾ãšPostgreSQLã¯ã€æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ŒPostgreSQL 10ã€ãŒãƒªãƒªãƒ¼ã‚¹äºˆå®šã§ã™ã€‚2017å¹´7æœˆ13æ—¥ã«ã¯ã“ã®Beta 2ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã¾ã™ã€‚ PostgreSQL 10ã§ã¯ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„è«–ç†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã®â€œã•ã‚‰ã«å¤§è¦æ¨¡ãªç’°å¢ƒâ€ã‚’æƒ³å®šã—ãŸæ©Ÿèƒ½ã‚’è»¸ã«ã€ãƒ‘ãƒ©ãƒ¬ãƒ«ã‚¯ã‚¨ãƒªã®å¤§å¹…æ”¹å–„ã®ã‚ˆã†ãªã€Œä¿¡é ¼æ€§ã€ã€Œé‹ç”¨æ€§ã€ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æ©Ÿèƒ½ãŒãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã‚‹äºˆå®šã§ã™ã€‚æ–°æ©Ÿèƒ½ã®æ•°ã¯100ä»¥ä¸Šã¨ã‚‚è¨€ã‚ã‚Œã¦ãŠã‚Šã€ã‹ãªã‚Šãƒœãƒªãƒ¥ãƒ¼ãƒ ã®ã‚ã‚‹ãƒ
shigiryou 2017/08/17
DB
ãƒªãƒ³ã‚¯
Database Expert : ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã‚’å¿—ã™ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®æƒ…å ±ãƒ•ã‚©ãƒ¼ãƒ©ãƒ - ï¼ IT
IPAã¯ã€Œãƒ‡ãƒ¼ã‚¿åˆ©æ´»ç”¨ãƒ»ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒšãƒ¼ã‚¹ã‚¬ã‚¤ãƒ‰ãƒ–ãƒƒã‚¯ç¬¬1.0ç‰ˆã€ã‚’å…¬é–‹ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ã‚µãƒ¼ãƒ“ã‚¹å±•é–‹ãªã©ã®äº‹æ¥ã«æ´»ç”¨ã—ãŸã„ä¼æ¥ã®çµŒå–¶å±¤ã‚„CDOãªã©ã‚’å¯¾è±¡ã«ã€ç•°ãªã‚‹çµ„ç¹”ã€ç•°æ¥ç¨®é–“ã§ãƒ‡ãƒ¼ã‚¿ã‚’å…±æœ‰ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒšãƒ¼ã‚¹ã®åˆ©ç”¨æ‰‹é †ã‚„ãã®å†…å®¹ã‚’è§£èª¬ã—ã¦ã„ã‚‹ã€‚ï¼ˆ2024å¹´11æœˆ19æ—¥ï¼‰
shigiryou 2017/05/30
DB

database
ãƒªãƒ³ã‚¯
IaaSã®èªã¿æ–¹ã¯? | GIOã‚ã
ã‚µã‚¤ãƒˆãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã®ãŠçŸ¥ã‚‰ã› å½“ç¤¾ã‚µã‚¤ãƒˆã‚’ã”è¦§ã„ãŸã ãã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€ŒIIJ GIOã€ã®å…¬å¼ãƒ–ãƒã‚°ã€ŒGIOã‚ãï¼ˆhttps://giolog.iij.ad.jp/ï¼‰ã€ã¯ã€å½“ã‚µã‚¤ãƒˆã€Œã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºIT "COLUMNS"ã€ã¸ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ æ³•äººå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã‚’ä¸å¿ƒã«ã€ITæ‹…å½“è€…ã«å½¹ç«‹ã¤æƒ…å ±ã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã«é–¢ã™ã‚‹è¨˜äº‹ä¸€è¦§ã¸ å…¨ã‚«ãƒ†ã‚´ãƒªã®æœ€æ–°ã®è¨˜äº‹ä¸€è¦§ã¸ ã“ã®ã‚µã‚¤ãƒˆã«ã¤ã„ã¦
shigiryou 2017/05/19
DB
ãƒªãƒ³ã‚¯
ã€ŒANSI/SPARC 3å±¤ã‚¹ã‚ãƒ¼ãƒžã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã‚’ç†è§£ã™ã‚‹
ã€ŒANSI/SPARC 3å±¤ã‚¹ã‚ãƒ¼ãƒžã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã‚’ç†è§£ã™ã‚‹ï¼šã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆè©¦é¨“ã€æˆ¦ç•¥çš„å¦ç¿’ã®ã‚¹ã‚¹ãƒ¡ï¼ˆ4ï¼‰ ã‚ã®é€ƒã’æ¥ãƒ»æ´¥å´Žã•ã‚“ã‚‚ä¿æœ‰ã™ã‚‹é›£é–¢è³‡æ ¼ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã€ã€‚æœ¬ä¼ç”»ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆè©¦é¨“ åˆå‰ï¼åˆå¾Œè©¦é¨“å¯¾ç–ã®ãŸã‚ã®ã€ŒåŸºç¤ŽçŸ¥è˜ã€ã‚’æŠœç²‹ã—ã¦ãŠå±Šã‘ã—ã¾ã™ã€‚ä»Šå›žã¯ã€ã€ŒANSI/SPARC 3å±¤ã‚¹ã‚ãƒ¼ãƒžã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®åŸºç¤Žã€ã‚’è§£èª¬ã—ã¾ã™ã€‚
shigiryou 2017/05/16
DB

schema
ãƒªãƒ³ã‚¯
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã¨ãã®ã¾ã¨ã‚ - Qiita
ã€2021/10/15 è¿½è¨˜ã€‘ ã“ã®è¨˜äº‹ã¯æ›´æ–°ãŒåœæ¢ã•ã‚Œã¦ã„ã¾ã™ã€‚ç¾åœ¨ã§ã¯ç†è€…ã®æ€æƒ³ãŒå¤‰åŒ–ã—ã¦ã„ã‚‹é¢ã‚‚ã‚ã‚Šã¾ã™ã®ã§ï¼ŒéŽåŽ»ã®è¨˜äº‹ã¨ã—ã¦å‚è€ƒç¨‹åº¦ã«ã”è¦§ãã ã•ã„ã€‚PDO ã«é–¢ã—ã¦ã¯å¤§ããå¤‰ã‚ã£ã¦ã„ãªã„éƒ¨åˆ†ãŒå¤šã„ã¨ã¯æ€ã„ã¾ã™ãŒï¼Œ PHP 8.x ä»¥é™ã§ã®å‹•ä½œä¿è¨¼ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚ã‚‰ã‹ã˜ã‚èªã‚“ã§ãŠããŸã„è¨˜äº‹ Qiita - ã€PHPè¶…å…¥é–€ã€‘ã‚¯ãƒ©ã‚¹ï½žä¾‹å¤–å‡¦ç†ï½žPDOã®åŸºç¤Ž by @7968 åˆå¿ƒè€…ãŒã‚„ã‚ŠãŒã¡ãªãƒŸã‚¹ ä»¥ä¸‹ã®ã©ã‚Œã‹ã«1ã¤ã§ã‚‚å½“ã¦ã¯ã¾ã‚‹ã‚³ãƒ¼ãƒ‰ã¯è¦‹ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Žä»˜éŒ²ã«ãƒªãƒ³ã‚¯ã‚’è²¼ã£ã¦ãŠãã¾ã—ãŸã®ã§ï¼Œã€Œè©²å½“ã™ã‚‹ã‹ã‚‚ï¼Ÿã€ã¨ã„ã†äººã¯ã‚¯ãƒªãƒƒã‚¯ã—ã¦é£›ã‚“ã§èªã‚“ã§ãã ã•ã„ï¼Žå¤ªå—ã«ã—ã¦ã‚ã‚‹ã‚‚ã®ã¯è„†å¼±æ€§ã«ç›´çµã™ã‚‹å±é™ºåº¦ã®é«˜ã„ã‚‚ã®ã§ã™ï¼Ž mysql_query ãªã©ã®éžæŽ¨å¥¨é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ SET NAMES ã‚ã‚‹ã„ã¯ SET CHARACTER SET ãªã©ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ã„ã‚‹ ãã‚‚ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
shigiryou 2016/10/24
MySQL

Re

ã‚¼ãƒã‹ã‚‰å§‹ã‚ã‚‹

PHP

DBç”Ÿæ´»
ãƒªãƒ³ã‚¯
è‹¥æ‰‹ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼å¿…èªï¼ï¼•åˆ†ã§ç†è§£ã§ãã‚‹ERå›³ã®æ›¸ãæ–¹ï¼•ã‚¹ãƒ†ãƒƒãƒ—
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ERå›³ã€‚ERå›³ã‚’æ›¸ããŸã„ã‘ã©ã€ã€Œè¨˜æ³•ãŒåˆ†ã‹ã‚‰ãªã„ã€ã€Œã©ã†ã„ã†ã‚¹ãƒ†ãƒƒãƒ—ã§æ›¸ã‘ã°è‰¯ã„ã‹åˆ†ã‹ã‚‰ãªã„ã€ã¨ã„ã†è‹¥æ‰‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ERå›³ã¯ï¼‘ï¼ç¨®é¡žè¿‘ãã‚ã‚Šã€ç¨®é¡žã«ã‚ˆã£ã¦è¨˜æ³•ãŒç•°ãªã‚Šã¾ã™ã€‚ã“ã®ã“ã¨ãŒé›£ã—ã„ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä¸Žãˆã¦ã„ã¾ã™ãŒã€å®Ÿã¯ãã‚Œã»ã©é›£ã—ã„ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚è¦šãˆã‚Œã°è‰¯ã„ERå›³ã¯ï¼’ç¨®é¡žã ã‘ã§ã™ã€‚ ã—ã‹ã‚‚ã€ã“ã®è¨˜äº‹ã§è§£èª¬ã—ã¦ã„ã‚‹åŸºç¤ŽçŸ¥è˜ã‚’æŠ¼ãˆã‚Œã°ã€ãŸã£ãŸï¼•ã¤ã®ã‚¹ãƒ†ãƒƒãƒ—ã§ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ERå›³ã®åŸºç¤ŽçŸ¥è˜ã‹ã‚‰ERå›³ã®æ›¸ãæ–¹ã¾ã§ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæŠ‘ãˆã¦ãŠãã¹ãERå›³ã®å…¨çŸ¥è˜ã‚’ã©ã“ã‚ˆã‚Šã‚‚åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã‚’èªã¿çµ‚ãˆãŸã¨ãã€è‹¥æ‰‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚ERå›³ã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ ã“ã®è¨˜äº‹ã‚’å‚è€ƒã«æœ€é©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’é€²ã‚ã¦ä¸‹ã•ã„ã€‚ ï¼‘ï¼ŽERå›³ã¨ã¯ ERå›³ã¨ã¯ã€ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ï¼‰ã§ä½¿ã†è¨è¨ˆ
shigiryou 2016/10/04
ERå›³

db

è¨è¨ˆ

ã‚‚ãã‚‚ã
ãƒªãƒ³ã‚¯
Microsoft - AIã€ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç”Ÿç”£æ€§å‘ä¸Šã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€ã‚²ãƒ¼ãƒ ã€ã‚¢ãƒ—ãƒª
ã™ã¹ã¦ã® Microsoft è£½å“ Global Microsoft 365 Teams Copilot Windows Surface Xbox ã‚»ãƒ¼ãƒ« æ³•äººå‘ã‘ ã‚µãƒãƒ¼ãƒˆ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ Windows ã‚¢ãƒ—ãƒª AI OneDrive Outlook Skype OneNote Microsoft Teams PC ã¨ãƒ‡ãƒã‚¤ã‚¹ Xbox ã‚’è³¼å…¥ã™ã‚‹ ã‚¢ã‚¯ã‚»ã‚µãƒª VR & è¤‡åˆç¾å®Ÿ ã‚¨ãƒ³ã‚¿ãƒ¡ Xbox Game Pass Ultimate Xbox ã¨ã‚²ãƒ¼ãƒ PC ã‚²ãƒ¼ãƒ Windows ã‚²ãƒ¼ãƒ æ˜ ç”»ã¨ãƒ†ãƒ¬ãƒ“ç•ªçµ„ æ³•äººå‘ã‘ Microsoft Cloud Microsoft Security Azure Dynamics 365 ä¸€èˆ¬æ³•äººå‘ã‘ Microsoft 365 Microsoft Industry Microsoft Power Platform Windows 365 é–‹ç™ºè€…
shigiryou 2015/12/06
DB

Database

Example
ãƒªãƒ³ã‚¯
30åˆ†é–“ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚° ã€œERå›³ã‚’æã“ã†ï¼ã€œï¼ˆ1/4ï¼‰ â€• ï¼ IT
30åˆ†é–“ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚° ï½žERå›³ã‚’æã“ã†ï¼ï½žï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®é“ï¼ˆ2ï¼‰ï¼ˆ1/4 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã¯ã€ITã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ç¾å ´ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚„SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨è€…ï¼‰ãŒã€ãƒ‡ãƒ¼ã‚¿ç®¡ç†è€…ï¼ˆDAï¼‰ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ï¼ˆDBAï¼‰ã¸ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ—ã™ã‚‹ãŸã‚ã®ç¬¬ä¸€æ©ã¨ã—ã¦æœ‰åŠ¹ãªåŸºç¤ŽçŸ¥è˜ã‚’ç´¹ä»‹ã™ã‚‹ï¼ˆç·¨é›†å±€ï¼‰
shigiryou 2015/09/18
ERå›³

DB

database
ãƒªãƒ³ã‚¯
é€£è¼‰ï¼šADO.NET Entity Frameworkå…¥é–€ - ï¼ IT
ç¬¬2å›žã€€ç°¡æ½”ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ãŸã‚ã« ï¼ˆ2017/7/26ï¼‰ ãƒ©ãƒ ãƒ€å¼ã§è¨˜è¿°ã§ãã‚‹ãƒ¡ãƒ³ãƒã®å¢—åŠ ã€throwå¼ã€outå¤‰æ•°ã€ã‚¿ãƒ—ãƒ«ãªã©ã€C# 7ã«ã¯ä»¥å‰ã‚ˆã‚Šã‚‚ã‚³ãƒ¼ãƒ‰ã‚’ç°¡æ½”ã«è¨˜è¿°ã§ãã‚‹ã‚ˆã†ãªæ©Ÿèƒ½ãŒå°Žå…¥ã•ã‚Œã¦ã„ã‚‹ ç¬¬1å›žã€€Visual Studio Codeãƒ‡ãƒãƒƒã‚°ã®åŸºç¤ŽçŸ¥è˜ ï¼ˆ2017/7/21ï¼‰ Node.jsãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ãƒ‡ãƒãƒƒã‚°ã—ãªãŒã‚‰ã€Visual Studio Codeã«çµ±åˆã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒãƒƒã‚°æ©Ÿèƒ½ã®åŸºæœ¬ã®ã€Œã‚ã€ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã‚ˆã† ç¬¬1å›žã€€æ˜Žçžãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ãŸã‚ã« ï¼ˆ2017/7/19ï¼‰ C# 7ã§è¿½åŠ ã•ã‚ŒãŸæ–°æ©Ÿèƒ½ã®ä¸ã‹ã‚‰ã€ã€Œæ•°å€¤ãƒªãƒ†ãƒ©ãƒ«æ§‹æ–‡ã®æ”¹å–„ã€ã¨ã€Œãƒãƒ¼ã‚«ãƒ«é–¢æ•°ã€ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ã“ã‚Œã‚‰ã¯åˆ†ã‹ã‚Šã‚„ã™ã„ã‚³ãƒ¼ãƒ‰ã‚’è¨˜è¿°ã™ã‚‹ã®ã«ä½¿ãˆã‚‹ Presentation Translator ï¼ˆ2017/7/18ï¼‰ Presentation Translatorã¯PowerPointç”¨ã®ã‚¢ãƒ‰ã‚¤ãƒ³ã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼
shigiryou 2015/08/23
ADO.NET

EntityFramework

EF

DB
ãƒªãƒ³ã‚¯
ä»Šã™ã Entity Framework 6 ã§ä½¿ãˆã‚‹æ©Ÿèƒ½ã¨ Entity Framework 7 ã«ã¤ã„ã¦ã¾ã¨ã‚ãŸ - ã—ã°ã‚„ã‚“é›‘è¨˜
å¯Œå±±ã§æŸ O æ±Ÿã•ã‚“ãŒ Entity Framework 4 ã§åˆ‡ã‚Šæ¨ã¦ãŸã¨è¨€ã£ã¦ãŸã®ã§ã€æœ€æ–°ã® Entity Framework 6.1.2 ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚å‰²ã¨é ‘å¼µã£ã¦ã„ã‚‹ã—ã€Entity Framework 7 ãŒæœŸå¾…å‡ºæ¥ãã†ã§ã™ã€‚ EF6.1.2 RTM Available - ADO.NET Blog - Site Home - MSDN Blogs Entity Framework 6 ã«é–¢ã—ã¦ã¯ä»Šå¾Œã¯ãƒã‚°ä¿®æ£ãƒ¬ãƒ™ãƒ«ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã«ãªã‚Šãã†ã§ã™ã€‚ASP.NET 5 ã¨åŒã˜ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ Entity Framework 7 ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãªã„ã¨ã„ã‘ãªã„ã®ã§å¤§å¤‰ãªã®ã§ã—ã‚‡ã†ã€‚ ãã‚Œã§ã¯ä½¿ãˆãªã„ã¨æ€ã‚ã‚ŒãŒã¡ãªæ©Ÿèƒ½ã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆã®ãƒ¢ãƒ‡ãƒ«ã‚¯ãƒ©ã‚¹ã‚’ DB ã‹ã‚‰è‡ªå‹•ç”Ÿæˆã™ã‚‹ ã‚³ãƒ¼ãƒ‰ãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆã®ãƒ¢ãƒ‡ãƒ«ã‚¯ãƒ©ã‚¹ã¨ã„ã†è¡¨ç¾ã¯ã„ã¾ã„ã¡ã§ã™ãŒã€DbContext ã‚’ä½¿ã† POCO
shigiryou 2015/08/23
EntityFramework

EF

DB

excellent

æ‡‡åˆ‡ä¸å¯§
ãƒªãƒ³ã‚¯
DBã‚³ãƒžãƒ³ãƒ‰æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä½œã‚Šã¾ã—ãŸ - clock-up-blog
æ¨ªæ–çš„ã«DBæ“ä½œã®é¡žä¼¼ã‚³ãƒžãƒ³ãƒ‰ã‚’æŽ¢ã™ãŸã‚ã®ã‚µã‚¤ãƒˆ ä¾‹ãˆã° MySQL ã‚’çŸ¥ã£ã¦ã„ã‚‹äººãŒ æ–°ã—ãä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ä¾‹ãˆã° Oracle ã‚’å¦ç¿’ã™ã‚‹éš›ã« MySQL ã§ã„ã†ã¨ã“ã‚ã®ã‚¢ãƒ¬ã¯ Oracle ã§ã¯ã©ã†ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãªã‚“ã ã‚ã† ã¨ã„ã†æ„Ÿã˜ã«æƒ…å ±ã‚’æŽ¢ã™å ´é¢ãŒå¤šãã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã†é¡žã®æƒ…å ±ã‚’æŽ¢ã™ã¨ãã«å½¹ã«ç«‹ã¡ãã†ãªãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚µã‚¤ãƒˆã‚’ä½œã‚Šã¾ã—ãŸã€‚ xref.jp xref.jp - Database è¿½è¨˜: ã‚³ãƒ³ãƒ†ãƒ³ãƒ„å¢—ã‚„ã—ã¾ã—ãŸ yum, apt-get, rpm ç‰ã€…ã®æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ - clock-up-blog ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ GitHub ã«ä¸Šã’ã¦ã‚ã‚‹ã®ã§èˆˆå‘³ã‚ã‚‹äººã¯è¦‹ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã™ã€‚ kobake/xref.jp Â· GitHub PHP ã§æ›¸ã„ã¦ã¾ã™ã€‚ã™ã‚“ã”ã„æ±šã„ã§ã™ã€‚è¬™éœã˜ã‚ƒãªãã¦æœ¬å½“ã«ã€‚ ãƒ—ãƒ«ãƒªã‚¯æ“è¿Žã€‚ æ©Ÿèƒ½ ãƒžãƒˆãƒªã‚¯ã‚¹æ–¹å‘ã®åˆ‡æ›¿ æ¯”è¼ƒè¡¨ã®è¦‹å‡ºã—ã®å‘ãã£ã¦ã€ãã®çµ„ã¿
shigiryou 2015/01/01
DB
ãƒªãƒ³ã‚¯
http://homepage2.nifty.com/yoks/TechNote/H2/H2_MnFrm.htm
shigiryou 2014/01/15
H2

DB

Install

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
IDã®è¨è¨ˆã«ã¤ã„ã¦ã®ã•ã‚‰ã«çªã£è¾¼ã‚“ã è°è«–
ä»Šæ—¥ã‚‚å‰å›žã«å¼•ãç¶šããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®è©±ã‚’ã™ã‚‹ã€‚ä»Šå›žã®è©±ã§ä¸€æ—¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ã¤ã„ã¦ã¯ç†ã‚’ç½®ãã¤ã‚‚ã‚Šï¼ˆãƒ–ãƒã‚°æ›¸ã„ã¦ãªã„ã§åŽŸç¨¿æ›¸ã‘ã‚ˆï¼žä¿ºï¼‰ã§ã‚ã‚‹ãŒã€ãã®å‰ã«è©±ã‚’ã™ã£ãã‚Šã•ã›ã¦ç½®ããŸã„ã¨æ€ã†ã€‚æœ€å¾Œã‚’é£¾ã‚‹ãƒ†ãƒ¼ãƒžã¯IDã®è¨è¨ˆã§ã‚ã‚‹ã€‚ æ•°å—ã—ã‹ãªã„ã®ã«æ„å‘³ã‚’å«ã‚“ã IDå‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã‚’è¦‹ã¦ã„ãŸã ã„ãŸæ–¹ã‹ã‚‰ã€æ¬¡ã®ã‚ˆã†ãªæ§‹é€ ã‚’æŒã£ãŸå¦ç±ç•ªå·ãŒã‚ã‚‹ã¨ã„ã†ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’é ‚ã„ãŸã€‚ å…¨éƒ¨æ•°å€¤ã§"å…¥å¦å¹´åº¦ä¸‹2æ¡"+"å¦ç§‘ã‚³ãƒ¼ãƒ‰"+"å¦ç§‘å†…ã®ã‚ã„ã†ãˆãŠé †ã®é †ä½" ã“ã®ã‚ˆã†ãªãƒ«ãƒ¼ãƒ«ã§å‰²ã‚Šå½“ã¦ãŸå¦ç±ç•ªå·ã‚’ã€å˜ãªã‚‹æ•°å€¤ã¨ã—ã¦æ‰±ã†ã®ã§ã‚ã‚Œã°å¤§ããªå•é¡Œã¯ãªã„ã€‚ã“ã‚Œã¯æ•°å€¤ã—ã‹å«ã¾ã‚Œã¦ã„ãªã„ã®ã§ã€SQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦ã¯å˜ã«æ•°å€¤åž‹ã‚’ä½¿ãˆã°è‰¯ã„ã ã‚ã†ã€‚ã ãŒã€å¦ç±ç•ªå·ã‹ã‚‰å…¥å¦å¹´åº¦ã‚’åˆ¤æ–ã™ã‚‹ã€ã‚ã‚‹ã„ã¯å¦ç§‘ã‚’åˆ¤æ–ã™ã‚‹ã¨ã„ã£ãŸç”¨é€”ã§ä½¿ã‚ã‚Œã‚‹ã®ã§ã‚ã‚Œã°ã‚„ã¯ã‚Šé©åˆ‡ã§ã¯ãªã„ã¨ã„ãˆã‚‹ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã®è¦³ç‚¹ã ã‘ã‹ã‚‰ã§ã¯ãªãã€IDã¨ã—ã¦é©åˆ‡ã§
shigiryou 2013/12/10
DB

ID

database
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸