[B! postgresql] ko-ya-maã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ko-ya-ma id:ko-ya-ma

postgresqlã«é–¢ã™ã‚‹ko-ya-maã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (29)

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

EdgeDB 1.0 | EdgeDB Blog
Check out the discussion of this post on Hacker News. See the recording of the live launch event on YouTube. Today, after several years of building (and a long list of prereleases) we are extremely proud to announce the release of EdgeDB 1.0, the first open source, graph-relational database! ðŸŽŠ A brief Q&A is in order. What are the killer features? Modern, lean query language designed to surpass S
ko-ya-ma 2022/02/12
ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„ã™ãã†

dev

db

graph

postgresql
ãƒªãƒ³ã‚¯
Leaving MySQL
ko-ya-ma 2021/12/07
mysql

dev

postgresql
ãƒªãƒ³ã‚¯
Googleã€å¤§è¦æ¨¡åˆ†æ•£DBã€ŒSpannerã€ã«PostgreSQLäº’æ›ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®Ÿè£…ã€‚å¼·ã„ä¸€è²«æ€§ã§ç§’é–“10å„„ä»¥ä¸Šã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†å¯èƒ½ã€‚Google Cloud Next '21
Googleã¯Google Cloudã§æä¾›ã—ã¦ã„ã‚‹å¤§è¦æ¨¡åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒCloud Spannerã€ã«ã€PostgreSQLäº’æ›ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®Ÿè£…ã—ãŸã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚ At #GoogleCloudNext, we've announced the preview of Cloud Spannerâ€™s PostgreSQL interfaceâ€”combining the scalability & reliability of Spanner that enterprises trust with the familiarity & portability of PostgreSQL that dev teams . Take a deeper dive â†“ https://t.co/Y3xD1lDPLg â€” Google Cloud Tech (@GoogleCloudTech
ko-ya-ma 2021/10/14
dev

postgresql

cloud

db
ãƒªãƒ³ã‚¯
Universal data access layer for next-gen apps and AI
The fastest and simplest way to build, run, govern, and evolve a high-quality API layer on all your data.
ko-ya-ma 2021/09/15
è¶…é«˜é€ŸGraphQL/REST APIé–‹ç™ºã‚µãƒ¼ãƒ“ã‚¹

graphql

postgresql

dev

api

backend
ãƒªãƒ³ã‚¯
GitHub - techschool/simplebank: Backend master class: build a simple bank service in Go
This repository contains the codes of the Backend Master Class course by TECH SCHOOL. You can also find it on Udemy at this link. And don't hesitate to join Tech School's Discord group to chat directly with me and other students. In this course, you will learn step-by-step how to design, develop and deploy a backend web service from scratch. I believe the best way to learn programming is to build
ko-ya-ma 2021/09/15
tutorial

dev

backend

golang

video

api

postgresql

docker

aws
ãƒªãƒ³ã‚¯
NocoDB Cloud
This website employs cookies to guarantee that you receive the optimal experience while using our platform. We use cookies for the best user experience.
ko-ya-ma 2021/05/28
nocode

db

mysql

postgresql

dev
ãƒªãƒ³ã‚¯
DbGate | Open Source SQL+noSQL Database Client
Free and open source Free to use for any purpose, source code available under GPL-3.0 license Cross database MySQL, PostgreSQL, MS SQL, Oracle, Mongo DB, SQLite and others
ko-ya-ma 2021/04/23
app

db

mongodb

mysql

free

postgresql
ãƒªãƒ³ã‚¯
Hasura
ko-ya-ma 2020/12/02
â€œThe Hasura GraphQL Engine gives you fast, instant realtime GraphQL on any Postgres applicationâ€

dev

graphql

postgresql
ãƒªãƒ³ã‚¯
trdsqlã¯CSV,LTSV,JSONã‚’DB(PostgreSQL,MySQL)ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™
trdsqlã¯CSV,LTSV,JSONã‚’DB(PostgreSQL,MySQL)ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ trdsqlã¯CSV,LTSV,JSONã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¨æ›¸ã„ã¦ã‚ã£ã¦ã€ã€ŒPostgreSQLã‚„MySQLã«æŽ¥ç¶šã§ãã‚‹ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã€ã¨æ›¸ã„ã¦ã‚ã‚‹ãŸã‚ã€ã‚ªãƒžã‚±çš„ã«æ‰ãˆã‚‰ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€å°‚ç”¨ãƒ„ãƒ¼ãƒ«ã‚’ä¸Šå›žã‚‹ãã‚‰ã„ä¾¿åˆ©ã«ä½¿ãˆã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸã„æ™‚ã«ã€ãã‚‚ãã‚‚å€™è£œã¨ã—ã¦ã™ã‚‰æŒ™ãŒã£ã¦ãŠã‚‰ãšã€å¯‚ã—ã„æ°—æŒã¡ãŒã‚ã‚‹ã®ã§ã™ãŒã€ãã‚Œã‚ˆã‚Šã‚‚ä½•ã‚ˆã‚Šã‚‚ã€ãã‚Œtrdsqlã§ã‚µã‚¯ãƒƒã¨å‡ºæ¥ã¡ã‚ƒã†ã®ã«...ã¨ã„ã†å ´é¢ã‚’åº¦ã€…ç›®ã«ã™ã‚‹ã®ã§ã€ã“ã“ã§ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãã‚‚ãã‚‚ã®trdsqlã®å‹•ä½œ ãã‚‚ãã‚‚trdsqlã®å‹•ä½œã¯ã€ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§SQLite3ã§ã™ãŒï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚“ã§ã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã€SQLã®å‡¦ç†ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠä»»ã›ã—
ko-ya-ma 2020/11/29
dev

csv

postgresql

mysql

db

sql
ãƒªãƒ³ã‚¯
plant_erd - ERå›³ã‚’PlantUMLç”¨ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ
UMLã‚’ãƒ†ã‚ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã§è¨˜è¿°ã§ãã‚‹PlantUMLã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ã‚¯ãƒ©ã‚¹å›³ã‚’æµç”¨ã™ã‚‹å½¢ã§ERå›³ã‚‚æãã“ã¨ãŒã§ãã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã™ã§ã«ã‚ã‚Šã€ãã“ã‹ã‚‰PlantUMLç”¨ã«å‡ºåŠ›ã§ãã‚Œã°ã„ã„ã®ã«ã€ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ã‚‚ã¾ãŸå¤šã„ã§ã—ã‚‡ã†ã€‚ ãã‚“ãªæ–¹ã«ãŠå‹§ã‚ãªã®ãŒplant_erdã§ã™ã€‚å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸERå›³ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ plant_erdã®ä½¿ã„æ–¹ å‡ºåŠ›ã—ãŸå†…å®¹ã‚’PlantUMLã§è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ plant_erdã¯SQLite3ã€MySQLãã—ã¦PostgreSQLã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’ãã®ã¾ã¾PlantUMLå‘ã‘ã«å‡ºåŠ›ãŒå¯èƒ½ã§ã™ã€‚ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã‚’å‡ºåŠ›å¯¾è±¡ã«ã‚‚ã§ãã¾ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚å†ç¾ã•ã‚Œã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹é€ ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ›¸ãå‡ºã™ã®ã«ã´ã£ãŸã‚Šã§ã™ã€‚ plant_erdã¯Goè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆMIT
ko-ya-ma 2020/01/07
mysql

postgresql

dev

tool

db
ãƒªãƒ³ã‚¯
ERDã‚’PlantUMLå½¢å¼ã§è‡ªå‹•ç”Ÿæˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ãŸ - ãã‚Šã«ã£ã
PlantUML + ERDã§PlantERDã§ã™ github.com ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ PlantERDã®ç‰¹å¾´ ä½¿ã„æ–¹ å‡ºåŠ›ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ã®åˆ¶é™ã«ã¤ã„ã¦ æŠ€è¡“çš„ã«é ‘å¼µã£ãŸã“ã¨ ãƒ†ã‚¹ãƒˆã®ã“ã¨ Foreign keyã§éš£æŽ¥ã—ã¦ã„ã‚‹åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŽ¢ã™æ–¹æ³• è¤‡æ•°DBå¯¾å¿œã®ã¤ã‚‰ã¿ è¿½è¨˜ï¼š2019/12/13 9:45 ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ æ—¢å˜ãƒ—ãƒãƒ€ã‚¯ãƒˆã¸ã®ä¸æº€ãŒä¸€ç•ªå¤§ãã„ã§ã™ã€‚ https://github.com/voormedia/rails-erd ã¯å‡ºåŠ›ãŒç”»åƒãªã®ã§å–ã‚Šå›žã—ã—ã¥ã‚‰ã„ ãã‚‚ãã‚‚Railså‰æãªã®ã§ä»–è¨€èªžã¨ã‹ã§ã¯ä½¿ãˆãªã„ https://github.com/schemaspy/schemaspy ã‚‚æ‚ªããªã•ãã†ãªã‚“ã ã‘ã©ã“ã“ã¾ã§ãƒªãƒƒãƒã˜ã‚ƒãªãã¦ã„ã„ ãƒ†ãƒ¼ãƒ–ãƒ«æ•°å€‹ã®å°è¦æ¨¡ã‚¢ãƒ—ãƒªãªã‚‰ã„ã„ã‚“ã ã‘ã©ã€ä¸è¦æ¨¡ä»¥ä¸Šã®ã‚¢ãƒ—ãƒªã§ä½¿ã†ã¨äººé–“ãŒèªã‚€ã«è€ãˆãªã„ERDãŒç”Ÿæˆã•ã‚Œã¦ç²¾ç¥žãŒå´©å£Šã™ã‚‹ åƒ•ã¯åˆã‚
ko-ya-ma 2019/12/13
db

mysql

postgresql

dev

tool

golang
ãƒªãƒ³ã‚¯
ç„¡æ–™ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã€ŒDBngin for Macã€ãŒPostgreSQL 11ã¨Homebrewã‚µãƒ¼ãƒ“ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã€‚
ç„¡æ–™ã§ä½¿ãˆã‚‹Macç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã€ŒDBngin for Macã€ãŒPostgreSQL 11ã¨Homebrewã‚µãƒ¼ãƒ“ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸãã†ã§ã™ã€‚è©³ç´°ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ DBngin for Macã¯Macç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚¢ãƒ—ãƒªã€ŒTablePlusã€ã‚’é–‹ç™ºï¼†è²©å£²ã—ã¦ã„ã‚‹ã‚«ãƒŠãƒ€ã®TablePlus TeamãŒ2018å¹´09æœˆã«å…¬é–‹ã—ãŸã‚¢ãƒ—ãƒªã§ã€GUIã§ç°¡å˜ã«MySQLã‚„PostgreSQL, Redisãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã‚’ä½œæˆ/èµ·å‹•ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ã“ã®DBnginãŒå…ˆæœˆã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã§PostgreSQL 11ã¨Homebrewã‚µãƒ¼ãƒ“ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸãã†ã§ã™ã€‚ Build 12 â€“ supported dark theme and Homebrew. Supported dark theme. Supported start/stop homebrew service
ko-ya-ma 2018/11/14
DB

app

mac

mysql

postgresql

redis
ãƒªãƒ³ã‚¯
Goè£½ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«sql-migrate
æ¦‚è¦ Goè£½ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹migrationãƒ„ãƒ¼ãƒ«ã¨ã—ã¦sql-migrateã‚’ä½¿ã£ã¦é–‹ç™ºã—ã¦ã„ã‚‹ã®ã§ã‚³ãƒžãƒ³ãƒ‰ã‚„å‹•ä½œä»•æ§˜ãªã©ã‚’ç°¡å˜ã«æ›¸ãã€‚ å…¬å¼ãƒªãƒã‚¸ãƒˆãƒª ç‰¹å¾´ CLIãƒ„ãƒ¼ãƒ« SQLite, PostgreSQL, MySQL, Oracleãªã©ã®è‰²ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆ ã‚¹ã‚ãƒ¼ãƒžã®ä½œæˆ/å¤‰æ›´/ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯æ©Ÿèƒ½ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã®å®Ÿè¡Œåˆ¶å¾¡ ãã®ä»–è‰²ã€… ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« è©³ç´° å…¬å¼ã®READMEã‚’è¦‹ã‚Œã°åˆ†ã‹ã‚‹äº‹ã ã‘ã©æ—¥æœ¬èªžã§æ›¸ã„ã¦ã„ã è¨å®šãƒ•ã‚¡ã‚¤ãƒ« ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯dbconfig.ymlã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«åã§å‚ç…§ã•ã‚Œã‚‹ã€‚ymlå†…ã®envã‚ãƒ¼ã§ã¯development, productionãªã©ç’°å¢ƒã”ã¨ã«è¨å®šã‚’å®šç¾©ã§ãã‚‹ã€‚migrationã®å®Ÿè¡Œã‚’ç®¡ç†ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«åã¯gorp_migrationsã€‚dirã¯ä½œæˆã•ã‚ŒãŸmigrationãƒ•ã‚¡ã‚¤ãƒ«ã®ä¿å˜å…ˆã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ã“ã®è¾ºã‚Šã®åå‰ã¯è‰²ã€…å¤‰æ›´ãŒã§ãã‚‹ã—
ko-ya-ma 2018/10/06
dev

sql

mysql

postgresql

golang

tool
ãƒªãƒ³ã‚¯
TCPãƒ‘ã‚±ãƒƒãƒˆã‚’è§£æžã—ã¦æ§‹é€ åŒ–ãƒã‚°ã§ãƒ€ãƒ³ãƒ—ã™ã‚‹ãƒ„ãƒ¼ãƒ« tcpdp ã‚’ä½œã£ãŸ - Copy/Cut/Paste/Hatena
ã‚„ã£ã¨å½¢ã«ãªã£ã¦ãã¾ã—ãŸã€‚ github.com ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¯ã‚¨ãƒªãƒã‚°ã‚’å–å¾—ã—ãŸã„ã€ ä¾‹ãˆã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBMSï¼‰ã®ã‚¯ã‚¨ãƒªãƒã‚°ã‚’å–å¾—ã—ãŸã„ã¨ãä¸€ç•ªç¢ºå®Ÿãªæ–¹æ³•ã¯ã€ãã®RDBMSã«å‚™ã‚ã£ã¦ã„ã‚‹ãƒã‚°æ©Ÿæ§‹ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã™ã€‚ ä¸€æ–¹ã§ã€å…¨ã¦ã®ã‚¯ã‚¨ãƒªãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹ã¨ãªã‚‹ã¨ãã‚Œãªã‚Šã«IOè² è·ãŒã‹ã‹ã‚‹ã“ã¨ãŒäºˆæƒ³ã•ã‚Œã‚‹ã®ã§ã€è² è·çŠ¶æ³ã«ã‚ˆã£ã¦ã¯ã‚¯ã‚¨ãƒªãƒã‚°å‡ºåŠ›ï¼ˆã®IOè² è·ï¼‰ã‚’åˆ¥ã‚µãƒ¼ãƒã«åˆ†é›¢ã—ãŸããªã‚Šã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ã‚ˆã„ã‹ã¨ã„ã†ã¨ã€ä¾‹ãˆã° ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã®é–“ã«ãƒ—ãƒã‚ã‚·ã‚µãƒ¼ãƒã‚’æŒŸã‚“ã§ãã“ã§è¨˜éŒ²ã™ã‚‹ã“ã¨ã§IOè² è·ã‚’åˆ†é›¢ã™ã‚‹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒå´ã§ï¼ˆnotã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ï¼‰è¨˜éŒ²ã™ã‚‹ã“ã¨ã§ï¼ˆå¤§æŠµã€ã‚µãƒ¼ãƒå°æ•°ã®å¤šã„ï¼‰ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã«IOè² è·ã‚’åˆ†æ•£ã™ã‚‹ ã¨ã„ã†ã‚ˆã†ãªæ–¹æ³•ã‚’æ€ã„ã¤ãã¾ã™ã€‚ ãã“ã§ã€ã€Œã‚‚ã—ã€TCPã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ä¸Šã«æµã‚Œã¦ã„ã‚‹ï¼ˆä¾‹ãˆã°ï¼‰ã‚¯ã‚¨ãƒªãƒã‚°ã‚’è§£æžã—ã¦ãƒã‚°
ko-ya-ma 2018/09/25
proxy

dev

mysql

postgresql

log
ãƒªãƒ³ã‚¯
ãƒ¦ãƒ¼ã‚¶æƒ…å ±ã‚’ä¿å˜ã™ã‚‹æ™‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
ã¯ã˜ã‚ã« â€»ã“ã®ç™ºè¨€ã¯å€‹äººã®è¦‹è§£ã§ã‚ã‚Šã€æ‰€å±žã™ã‚‹çµ„ç¹”ã®å…¬å¼è¦‹è§£ã§ã¯ã‚ã‚Šã¾ã›ã‚“ ç”¨æ³•ç”¨é‡ã‚’å®ˆã‚Šã€å€‹äººã®è²¬ä»»ã§æ¥å‹™ã«æŠ•å…¥ã—ã¦ãã ã•ã„ å‚è€ƒè³‡æ–™ 2024/02/14è¿½è¨˜ å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã®è©³ç´°ã¯ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã©ã†ãžã€‚ agilejourney.uzabase.com è¦ä»¶ Useræƒ…å ±ã‚’ä¿å˜ã™ã‚‹ã¨ãã«ã©ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã‹ ä»ŠåŒ—ç”£æ¥ã§é ¼ã‚€ ãƒ†ãƒ¼ãƒ–ãƒ«ã«çŠ¶æ…‹ã‚’æŒãŸã›ãšçŠ¶æ…‹æ¯Žã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ çŠ¶æ…‹ãŒå¤‰ã‚ã‚Œã°ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¶ˆã—ã¦åˆ¥ã®tableã«ä½œã‚‹ tableã®æ™®éçš„ãªæƒ…å ±ã¯åˆ¥ã«æŒãŸã›ã‚‹ åƒ•ã®è€ƒãˆãŸæœ€å¼·ã®DBè¨è¨ˆ PostgreSQLã‚’ãƒ™ãƒ¼ã‚¹ã®é›‘ãªERå›³ã‚’ä½œã£ãŸã€‚ ã“ã‚Œã‚’å…ƒã«è©±ã‚’é€²ã‚ã‚‹ã€‚ tableæ§‹æˆ users è¦ªtableã§ã‚ã‚Šã€ã™ã¹ã¦ã®ãƒ¦ãƒ¼ã‚¶ã¯ã“ã“ã«å±žã™ã‚‹ã€‚ åŸºæœ¬ã¯INSERTã®ã¿ã§UPDATEã€DELETEã‚’è€ƒæ…®ã—ãªã„ã€‚ user_detail userã«ä»˜éšã™ã‚‹è©³ç´°ã®æƒ…å ±ãŒã“ã“ã«ç™»éŒ²
ko-ya-ma 2018/05/02
dev

tips

DB

mysql

postgresql
ãƒªãƒ³ã‚¯
trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ãŸ - Qiita
trdsqlã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ Goã§ä½œã£ã¦ã¾ã™ã€‚ githubã® trdsqlã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å‡ºæ¥ã¾ã™ã€‚ ã¾ãŸLinux/Windows/macOSã®ãƒã‚¤ãƒŠãƒªã‚‚ã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¯ã€å¤ããªã£ã¦ã„ã‚‹å†…å®¹ã‚‚ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ æœ€æ–°ç‰ˆã«å¯¾å¿œã—ãŸã€ã‚ˆã‚Šè©³ç´°ãªå†…å®¹ã¯ trdsql ç›®æ¬¡ | Noboru Saito's page ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚ ã“ã‚Œã¯ä½•ï¼Ÿ ç°¡å˜ã«è¨€ãˆã°CSV(TSVå«ã‚€)ã‚„LTSVã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ åŒæ§˜ã®ãƒ„ãƒ¼ãƒ«ãŒ q ã‚„ textql ç‰ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ trdsqlã¯PostgreSQLãƒ‰ãƒ©ã‚¤ãƒã¨MySQLãƒ‰ãƒ©ã‚¤ãƒã‚’å«ã‚“ã§ã„ã¦å®Ÿéš›ã«DBã«æŽ¥ç¶šã™ã‚‹ã“ã¨ã§SQLiteä»¥ä¸Šã®æ©Ÿèƒ½ã‚’ä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ PostgreSQLã‚„MySQLã®æ§‹æ–‡ãŒä½¿ãˆã‚‹ã ã‘ã§ã¯ãªãã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã¨å®Ÿãƒ†ãƒ¼ãƒ–ãƒ«ã§JOINã—ãŸã‚Šã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–
ko-ya-ma 2017/08/18
csv

postgresql

dev

DB

json

mysql
ãƒªãƒ³ã‚¯
Microsoft Build 2017 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã§ç™ºè¡¨ã®ã‚ã£ãŸ MySQL / PostgreSQL é–¢é€£ã®ç™ºè¡¨ã‚’ã–ã£ãã‚Šã¨ - ã¾ã„ã‚“ã ãƒ¼ã®ã¯ã¦ãªãƒ–ãƒã‚°
Microsoft ãŒ MySQL/PostgreSQL ã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã‚’å§‹ã‚ã¾ã™ å†…éƒ¨çš„ã«ã¯ãšã£ã¨å‰ã‹ã‚‰å–ã‚Šçµ„ã¿ãŒã•ã‚Œã¦ã„ã¦ã€å¤šãã®æ–°è¦ Azure ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰æœ›ã¾ã‚Œã¦ã„ãŸä¸€æ–¹ãªã‹ãªã‹å‡ºã¦ã“ãªã‹ã£ãŸ MySQL/PostgreSQL ã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ãŒã„ã‚ˆã„ã‚ˆå‡ºã¦ãã¾ã—ãŸã€‚ azure.microsoft.com azure.microsoft.com ä½•å¹´ã‚‚å¾…ã£ãŸã‚ï½žã»ã‚“ã¨ã«ã€‚ã€‚ã€‚ ã“ã‚Œã¾ã§ã® MySQL/PostgreSQL ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®èª²é¡Œ å„ç¨®ã‚¯ãƒ©ã‚¦ãƒ‰ã«ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã«ã¯å¤§ãã2ã¤ã®èª²é¡ŒãŒã‚ã£ãŸã¨æ€ã„ã¾ã™ â€œã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹â€ ã¨ã„ã†ã‚µã‚¤ã‚¸ãƒ³ã‚° ã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚‚åŸºæœ¬çš„ã« â€œä»®æƒ³ãƒžã‚·ãƒ³â€ å˜ä½ã§è¦æ±‚æ€§èƒ½ã¨ã‚ãƒ£ãƒ‘ã‚·ãƒ†ã‚£ã‚’æ±ºã‚ã¦ã€ãã“ã«ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã®è‡ªå‹•åŒ–ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãã—ã¦åˆ¥ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¸ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’æä¾›ã™ã‚‹ã‚‚ã®ã§ã—ãŸã€‚ ä»®æƒ³ãƒžã‚·ãƒ³ã§ã®ãƒ—ãƒãƒ“ã‚¸ãƒ§ãƒ‹ãƒ³ã‚°ã¯ã“ã‚Œã¾ã§ã®
ko-ya-ma 2017/05/11
postgresql

mysql

microsoft

DB

cloud

dev
ãƒªãƒ³ã‚¯
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¦—ããªã‚‰AdminerãŒä¾¿åˆ© | Unskilled?
phpMyAdminã‚ˆã‚ŠAdminer PHPã§MySQLã‚„PostgreSQLã¨é€£æºã—ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã—ã¦ã„ã‚‹ã¨ãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸èº«ã‚’GUIç’°å¢ƒã§ç¢ºèªã—ãŸã„æ™‚ã£ã¦ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ æœ‰åãªã®ã¯phpMyAdminã‚„phpPgAdminã§ã€éžå¸¸ã«é«˜æ©Ÿèƒ½ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ã§ã™ãŒã€æ„å¤–ã¨å°Žå…¥ã«æ‰‹é–“ãŒã‹ã‹ã£ãŸã‚Šã€æœ‰åãªã®ã§ãƒ–ãƒ«ãƒ¼ãƒˆãƒ•ã‚©ãƒ¼ã‚¹ã‚¢ã‚¿ãƒƒã‚¯ã®å¯¾è±¡ã«ãªã£ãŸã‚Šã—ã¾ã™ã€‚ ãã“ã§Adminerã§ã™ã‚ˆã€‚ ä»¥ä¸‹ã¯å…¬å¼ã‚µã‚¤ãƒˆã§ã™ã€‚æœ¬ä½“ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚‚ã“ã®ã‚µã‚¤ãƒˆã‹ã‚‰å¯èƒ½ã§ã™ã€‚(ã‚µã‚¤ãƒˆã¯è‹±èªž) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ Adminer Adminerã¯å°Žå…¥ãŒè¶…ç°¡å˜ phpMyAdminã‚„phpPgAdminã¯ç›¸å½“ãªæ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚Šã¾ã™ãŒã€Adminerã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯1ã¤ã ã‘ã§ã™ã€‚ ãƒãƒ³ã£ã¨1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç½®ãã ã‘ã§ä½¿ãˆã¾ã™ã€‚é¢å€’ãªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä½œæ¥ã‚‚å¿…è¦ãªã—ã§ã™ï¼ˆã‚·ã‚¹ãƒ†ãƒ ã«ãƒ‰ãƒ©ã‚¤ãƒã®å°Ž
ko-ya-ma 2016/11/06
php

mysql

postgresql

sqlite

dev
ãƒªãƒ³ã‚¯
RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ // Speaker Deck
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2016ã®è³‡æ–™ã§ã™ http://phpcon.php.gr.jp/2016/
ko-ya-ma 2016/11/04
db

design

mysql

postgresql

dev

tips

pattern

method
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆç®¡ç†ã‚·ã‚¹ãƒ†ãƒ dmemo ã®ã”æ¡ˆå†… - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã«å‡ºå‘ä¸ã®å°å®¤ (id:hogelog) ã§ã™ã€‚ ä»Šå›žã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã¨ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆç®¡ç†ã‚·ã‚¹ãƒ†ãƒ dmemo ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ https://github.com/hogelog/dmemo dmemo ã‚’ä½œæˆã—å°Žå…¥ã—ãŸçµŒç·¯ ç§ã¯2016å¹´3æœˆé ƒã‹ã‚‰ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã§ Redshift, bricolage, embulk, re:dash ç‰ã‚’åˆ©ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿åˆ†æžåŸºç›¤ã®æ§‹ç¯‰ã‚’é€²ã‚ã¦ã„ã¾ã™ã€‚ (ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžåŸºç›¤ã®ç¾çŠ¶ - ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°) ç¤¾å†…ã®èª°ã§ã‚‚æ‰±ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ‡ãƒ¼ã‚¿ã®é›†ç´„ãƒ»è¨ˆç®—ãƒ»åŠ å·¥ã€ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œæˆã€ã‚¯ã‚¨ãƒªã®å…±æœ‰ãªã©ã¯ä¸Šè¨˜ãƒ–ãƒã‚°è¨˜äº‹ã§ã‚‚æ›¸ã„ãŸã‚ˆã†ã« Redshift, bricolage, embulk, re:dash ç‰ã‚’çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§å®Ÿç¾
ko-ya-ma 2016/08/08
éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚åˆ†ã‹ã‚‹ãƒ»ä½¿ãˆã‚‹ã‚ˆã†ã«ä½œã‚‰ã‚ŒãŸDBã®å†…å®¹ã”èª¬æ˜Žãƒ„ãƒ¼ãƒ«

postgresql

docker

db

cookpad

document

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