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

YassLab id:YassLab

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

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

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€DBè¨è¨ˆã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æžï¼¿ï¼¿ã€‚Railsã‚’ä½¿ã£ãŸWebã‚¢ãƒ—ãƒªé–‹ç™ºã‚’ãƒ‘ãƒ¯ãƒ¼ã‚¢ãƒƒãƒ—ã™ã‚‹æ›¸ç±6å†Š | ãƒ¬ãƒãƒ†ãƒƒã‚¯ãƒ©ãƒœï¼ˆãƒ¬ãƒãƒ†ãƒƒã‚¯LABï¼‰
TOPã‚³ãƒ©ãƒ ãƒ—ãƒãƒ•ã‚§ãƒƒã‚·ãƒ§ãƒŠãƒ«ã®æŠ€è¡“æ›¸æœ¬æ£šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€DBè¨è¨ˆã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æžï¼¿ï¼¿ã€‚Railsã‚’ä½¿ã£ãŸWebã‚¢ãƒ—ãƒªé–‹ç™ºã‚’ãƒ‘ãƒ¯ãƒ¼ã‚¢ãƒƒãƒ—ã™ã‚‹æ›¸ç±6å†Š æ—¥æœ¬Rubyã®ä¼šä»£è¡¨ç†äº‹ é«˜æ©‹ å¾ç¾© æ ªå¼ä¼šç¤¾é”äººå‡ºç‰ˆä¼šä»£è¡¨å–ç· å½¹ã€ä¸€èˆ¬ç¤¾å›£æ³•äººæ—¥æœ¬Rubyã®ä¼šä»£è¡¨ç†äº‹ã€‚20ä¸–ç´€æœ«ã‚ˆã‚ŠWebåˆ¶ä½œä¼šç¤¾ã«ã¦ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã¨ã—ã¦å‹¤å‹™ã™ã‚‹å‚ã‚‰ã€ä»»æ„å›£ä½“ã¨ã—ã¦æ—¥æœ¬Rubyã®ä¼šã‚’è¨ç«‹ã€‚å¾Œã«æ³•äººåŒ–ã—ã€ç¾åœ¨ã¾ã§ä»£è¡¨ç†äº‹ã‚’å‹™ã‚ã‚‹ã€‚2010å¹´ã‚ˆã‚ŠIT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®é›»åæ›¸ç±ã®åˆ¶ä½œã¨è²©å£²ã‚’è¡Œã†é”äººå‡ºç‰ˆä¼šã‚’å‰µæ¥ã€ç¾åœ¨ã¾ã§ä»£è¡¨å–ç· å½¹ã€‚ã»ã‹ã€RubyKaigiã‚„æŠ€è¡“æ›¸å…¸ã®é‹å–¶ã«ã‚‚é–¢ã‚ã‚‹ã€‚è‘—æ›¸ã«ã€ŽãŸã®ã—ã„Rubyã€ï¼ˆå…±è‘—ï¼‰ãªã©ã€‚å¥½ããªä½œå®¶ã¯æ–°äº•ç´ åã€‚ Xï¼š@takahashim keyboard_arrow_down ã¯ã˜ã‚ã« keyboard_arrow_down æƒ³å®šã—ã¦ã„ã‚‹ãƒ¬ãƒ™ãƒ«æ„Ÿã«ã¤ã„ã¦ keyboard_arrow_down
YassLab 2024/12/18
â€œRailsã‚¢ãƒ—ãƒªé–‹ç™ºè€…ã¯å…¨å“¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆè€…ã§ã‚‚ã‚ã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã“ã‚Œã¯DBã«è©³ã—ã„äººã«DBã®ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã‚’ãŠé¡˜ã„ã™ã‚‹ã¹ãã§ã¯ãªãã€Railsã‚¢ãƒ—ãƒªé–‹ç™ºè€…å…¨å“¡ãŒã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã§ããªã‘ã‚Œã°ã„ã‘ãªã„ã€ã¨ã„ã†ã“ã¨â€

Ruby

Rails

Railsã‚¬ã‚¤ãƒ‰

DB
ãƒªãƒ³ã‚¯
DHHæ°ãŒRails 8ã®æ–°æ©Ÿèƒ½ã‚’è§£èª¬ã€‚Redisãªã©ä¸è¦ã«ãªã‚Šã€SQLiteå¯¾å¿œã§ã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ãªæ§‹æˆã«ã€‚Rails World 2024
DHHæ°ãŒRails 8ã®æ–°æ©Ÿèƒ½ã‚’è§£èª¬ã€‚Redisãªã©ä¸è¦ã«ãªã‚Šã€SQLiteå¯¾å¿œã§ã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ãªæ§‹æˆã«ã€‚Rails World 2024 9æœˆ26æ—¥ã¨27æ—¥ã®2æ—¥é–“ã€ã‚«ãƒŠãƒ€ã®ãƒˆãƒãƒ³ãƒˆã§é–‹å‚¬ã•ã‚ŒãŸRails World 2024ã®åŸºèª¿è¬›æ¼”ã§ã€Ruby on Railsï¼ˆä»¥ä¸‹Railsï¼‰ã®ä½œè€…ã§ã‚ã‚‹DHHï¼ˆDavid Heinemeier Hanssonï¼‰æ°ãŒã€ŒRails 8ã€ã®ä¸»ãªæ–°æ©Ÿèƒ½ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ The #RailsWorld 2024 Opening Keynote with @dhh is now online. Rails 8 beta shipped with Authentication, Propshaft, Solid Cache, Solid Queue, Solid Cable, Kamal 2.0, and Thruster. #NoPaaS needed in
YassLab 2024/10/02
"ç¾ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ååˆ†ã«é«˜é€Ÿã«ãªã£ãŸã“ã¨ã§ã“ã‚Œã‚‰ã‚’1ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã«ã¾ã¨ã‚ã‚‹ã“ã¨ãŒå¯èƒ½ã« / Rails 8ã§ã¯ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã€ã‚ãƒ¥ãƒ¼ã€ã‚±ãƒ¼ãƒ–ãƒ«ã®å…¨ã¦ãŒSQLiteã§ã¾ã‹ãªãˆã‚‹ã‚ˆã†ã«ãªã£ãŸ"

Ruby

Rails

DB

SQLite

DHH

Ruby on Rails

é–‹ç™º

Webé–‹ç™º

Web
ãƒªãƒ³ã‚¯
Conceptual compression - ohbarye
YassLab 2024/07/15
"Conceptual compression -- ç›´è¨³ã™ã‚‹ã¨æ¦‚å¿µçš„åœ§ç¸® / æŠ½è±¡åŒ–ã‚’æ´»ç”¨ã™ã‚‹äº‹ã§è©³ç´°ãªç†è«–ã‚„æ¦‚å¿µã‚’åœ§ç¸®ã—ã¦ç›®çš„ã‚’é”æˆã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚„è€ƒãˆæ–¹ / DHHãŒå¥½ã‚“ã§ä½¿ã† / e.g. ORMã®ç™ºæ˜Žã«ã‚ˆã‚ŠSQLã‚’çŸ¥ã‚‰ãšã¨ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã§ãã‚‹"

DB

SQL

ORM

Ruby

DHH

Rails
ãƒªãƒ³ã‚¯
Techouseç¤¾å†…å‹‰å¼·ä¼šã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã™(1) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹<ACIDç·¨> - Techouse Developers Blog
Techouseã®ã€Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢åŸºç¤Žå‹‰å¼·ä¼šã€ã¨ã¯ Techouse ã§ã¯ã€ŒåŸºç¤Žå‹‰å¼·ä¼šã€ã¨ç§°ã—ã¦2é€±é–“ã«1å›žã€ã‚ãŸã—ãŒ OSãƒ»ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ãƒ»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã©ã‚’ãŠè©±ã™ã‚‹å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ è¬›å¸«ã¯ç§ã²ã¨ã‚Šã€è³‡æ–™ã‚’æº–å‚™ã™ã‚‹ã®ã‚‚ç§ã²ã¨ã‚Šã€å‹•ç”»ã‚’åŽéŒ²ã—ã¦ YouTube Live ã§ç¤¾å†…å‘ã‘ã«é…ä¿¡ã™ã‚‹ä½œæ¥ã‚‚ç§ã²ã¨ã‚Šã§ã‚„ã£ã¦ã¾ã™ã€‚ å‚åŠ ã¯ä»»æ„ã§ã™ãŒã€ç¤¾å†…ã®ãƒ¡ãƒ³ãƒãƒ¼ (ç¤¾å“¡ãƒ»ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ³ç”Ÿãƒ»æ¥å‹™å§”è¨—ã§ã”å‚ç”»ã„ãŸã ã„ã¦ã„ã‚‹æ–¹) ã®å¤šãã®æ–¹ãŒå‚åŠ ã—ã¦ãã‚Œã¦ã„ã¾ã™ã€‚å…ˆæ—¥ã® RubyKaigi 2024 ã«å‚åŠ ã—ã¦ãã‚ŒãŸãƒ¡ãƒ³ãƒãƒ¼ã‚‚ã»ã¨ã‚“ã©ãŒã“ã®å‹‰å¼·ä¼šã«å‚åŠ ã—ã€åŸºç¤Žçš„ãªçŸ¥è˜ã‚’ã‚‚ã£ãŸä¸Šã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¸è‡¨ã‚“ã§ãã‚Œã¾ã—ãŸã€‚ é–‹å‚¬å±¥æ´ ã“ã‚Œã¾ã§ã®é–‹å‚¬å±¥æ´ã¯ã“ã‚“ãªå…·åˆã§ã™ã€‚ è¦‹ã¦ã„ãŸã ãã¨ã‚ã‹ã‚‹é€šã‚Šã€ã»ã‚“ã¨ã†ã«åŸºç¤Žçš„ãªå†…å®¹ã‚’1å€‹ãšã¤ã‚„ã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ã‹ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚
YassLab 2024/07/09
"ä½•å›žãƒ†ã‚¹ãƒˆã—ã¦ã‚‚å•é¡Œãªãã¦ã€è² è·ãƒ†ã‚¹ãƒˆã—ã¦ã‚‚å•é¡Œãªãã¦ã€æœ¬ç•ªã§ã‚‚æ•°å¹´é–“ã«ã‚ãŸã£ã¦å•é¡Œãªãå‹•ä½œã—ã¦ã„ãŸã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€ã‚ã‚‹æ—¥çªç„¶ãŸãã•ã‚“ç™ºç”Ÿ / ãƒ†ã‚¹ãƒˆã¯æ¬ é™¥ãŒã‚ã‚‹ã“ã¨ã¯ç¤ºã›ã‚‹ãŒã€æ¬ é™¥ãŒãªã„ã“ã¨ã¯ç¤ºã›ãªã„"

ORM

DB

RDBMS

ãƒ†ã‚¹ãƒˆ

Test

å¦ç¿’
ãƒªãƒ³ã‚¯
Deploy for Free â€“ Render Docs
You can deploy instances of some Render services free of charge: Web services (web apps in Node.js, Python, Rails, etc.) PostgreSQL databases Redis instances Free instances have important limitations, and you should not use them for production applications. However, theyâ€™re perfect for testing out a new techno logy, working on a hobby project, or previewing Renderâ€™s developer experience! You can al
YassLab 2024/06/11
â€œFree PostgreSQL databases expire 30 days after creation. An expired Free database is inaccessible unless you upgrade it to a paid instance type. Free PostgreSQL databases created before 20 May 2024 expire 90 days after creation.â€

Render

DB

PostgreSQL
ãƒªãƒ³ã‚¯
è‡ªä½œRDBMSã‚„ã‚ã†ãœ!
Skip to the content. è‡ªä½œRDBMSã‚„ã‚ã†ãœ! ã“ã®ã‚µã‚¤ãƒˆã®ç›®çš„ RDBMSï¼ˆã„ã‚ã‚†ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã¨ã„ã†ã‚‚ã®ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®å‡¦ç†ç³»ã‚„ã€OSãªã©ã¨åŒæ§˜ã«ã€ä¸–ã®ä¸ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€ã„ã–è‡ªä½œã—ã¦ã¿ã‚ˆã†ã¨æ€ã†ã¨æ—¥æœ¬èªžã§è¨˜è¿°ã•ã‚ŒãŸã‚µã‚¤ãƒˆã‚„æ›¸ç±ã§ã€å¿…è¦ãªæƒ…å ±ãƒ»æƒ…å ±æºãŒã¾ã¨ã¾ã£ãŸã‚‚ã®ãŒãªã„ã“ã¨ã«æ°—ã¥ãã¾ã—ãŸ ãã“ã§ã€å©ãå°ã¨ã—ã¦ã€æœ¬ã‚µã‚¤ãƒˆç®¡ç†äººãŠã‚ˆã³æ•°åã®ã‚³ãƒŸãƒƒã‚¿ã§é–‹ç™ºã—ã¦ã„ã‚‹è‡ªä½œRDBMSã§ã‚ã‚‹ SamehadaDB ãŒè»Œé“ã«ä¹—ã‚‹ã¾ã§ã®çµŒé¨“ã‚’ãƒ™ãƒ¼ã‚¹ã«ã€è‡ªä½œRDBMSã™ã‚‹ãŸã‚ã®é“ç‹ã‚’ã‚ã‚‹ç¨‹åº¦æ•´ç†ã—ã¦æ›¸ãè¨˜ã—ã¦ã¿ã¾ã—ãŸ å„ã€…ã®æƒ…å ±ãƒ»æƒ…å ±æºã¯ã‚ã„ã‹ã‚ã‚‰ãšå¤šããŒè‹±èªžã§è¨˜è¿°ã•ã‚Œã¦ã„ã¾ã™ãŒã€ãã®ç‚¹ã¯ã”å®¹èµ¦ä¸‹ã•ã„ ãªãŠã€æœ¬ã‚µã‚¤ãƒˆã¯æŠ€è¡“çš„ãªè§£èª¬ã‚’æä¾›ã™ã‚‹ã®ã§ã¯ãªãã€é©åˆ‡ã¨æ€ã‚ã‚Œã‚‹æƒ…å ±ãƒ»æƒ…å ±æºã‚’ãƒã‚¤ãƒ³ãƒˆã™ã‚‹ã‚ˆã†ãªã‚µã‚¤ãƒˆã¨ãªã‚‹ã“ã¨ã‚’æƒ³å®šã—ã¦ã„ã¾ã™
YassLab 2024/04/29
â€œãƒãƒ¼ãƒ‰ã‚³ãƒ¼ã‚¹ - è‹±èªžã‚¹ãƒ©ã‚¹ãƒ©èªã‚ã‚‹ã—ã€ã¨ã£ã‹ã‹ã‚Šã•ãˆã‚ã‚Œã°è‡ªåˆ†ã§ã©ã†ã«ã‹ã§ãã‚‹ã¨ã„ã†æ–¹ / æ®µéšŽçš„ã«é€²ã‚“ã§ã„ã“ã†ã‚³ãƒ¼ã‚¹ - ã„ããªã‚Šè‹±èªžã¨ã‹è¾›ã„ã®ã§æ—¥æœ¬èªžãªã‚µã‚¤ãƒˆã‚„æ›¸ç±ç‰ã§åŸºæœ¬ã‚’æŠ¼ã•ãˆã¦ã‹ã‚‰æ®µéšŽçš„ã«â€

DB

RDBMS
ãƒªãƒ³ã‚¯
https://twitter.com/gorilla0513/status/1784599259976991009
YassLab 2024/04/29
â€œã“ã‚Œã‚‚ã‚ã‚‹ è‡ªä½œDBã¯æ€ã£ãŸã‚ˆã‚Šã‚‚æƒ…å ±ãŒå¤šãã¦åŠ©ã‹ã‚‹ https://ryogrid.github.io/dbms-jisaku/ ã¯ç¥žãƒšãƒ¼ã‚¸â€

DB

RDBMS
ãƒªãƒ³ã‚¯
https://twitter.com/DRichardHipp/status/1784720563090465208
YassLab 2024/04/29
â€œWhen I first wrote SQLite, I didn't know much about SQL database engines. But I was familiar with compilers. So it was natural for me to treat the problem of writing an SQL database engine as a compiler-construction problem. Hence, SQLite compiles SQL into byte-code.â€

SQLite

DB
ãƒªãƒ³ã‚¯
å€‹äººé–‹ç™ºè€…ï¼ˆRailsï¼‰ãŒå®‰ãDBã‚’ä½¿ã†ã«ã¯TiDB serverlessãŒã‚¢ãƒªãªæ°—ãŒã™ã‚‹
ç¾æ™‚ç‚¹ã§ã¯ã¾ã å®Ÿéš›ã«ã¯è§¦ã£ã¦ã„ãªã„ãŸã‚ã€ã‚ãã¾ã§ã‚‚ã€Œã“ã‚“ãªã®ã‚ã£ãŸã‚ˆï½žã€ãã‚‰ã„ã®æ¸©åº¦æ„Ÿã®è¨˜äº‹ã ã¨æ€ã£ã¦ãã ã•ã„ ã©ã†ã‚‚ã“ã‚“ã«ã¡ã¯ã€ã¡ã‚‡ã£ã¨å‰ã«ã“ã‚“ãªè¨˜äº‹ãŒãƒã‚ºã£ãŸã®ã‚’è¦šãˆã¦ã„ã‚‹äººã‚‚å¤šã„ã¨æ€ã„ã¾ã™ ã‚‚ã¡ã‚ã‚“1ã¤ã®VPSã®ä¸ã«MySQLã¨Nginxã¨Redisã¨Railsã‚’çªã£è¾¼ã‚“ã§å‹•ã‹ã›ã°æœˆ1000å††ã§å¤¢ã®å…¨è¼‰ã›ã‚µãƒ¼ãƒãƒ¼ã«ãªã‚‹ã®ã§ã™ãŒç®¡ç†ãŒã‚ã‚“ã©ãã•ã„ã§ã™ã—ã€Appã‚µãƒ¼ãƒãƒ¼ã¨RDBã‚µãƒ¼ãƒãƒ¼ã¨ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒãƒ¼ã‚’ãã‚Œãžã‚Œåˆ†é›¢ã—ã¦ãã‚Œãžã‚Œã‚’ç‹¬ç«‹ç®¡ç†ã™ã‚‹ã‚ˆã†ãªæ„Ÿã˜ã§é‹ç”¨ã—ãŸã„ã£ã¦äººãŒå¤šã„ã®ã§ã¯ãªã„ã‹ã¨æ€ã‚ã‚Œã¾ã™ ãã†ãªã£ã¦ãã‚‹ã¨RDBã‚µãƒ¼ãƒãƒ¼ã®éƒ¨åˆ†ãŒæ¯”è¼ƒçš„æ–™é‡‘ãŒé«˜ã„å ´åˆãŒå¤šã„â€¦â€¦ã¨è¨€ã†ã®ãŒå¤§ä½“ã®è¶£æ—¨ã§ãã®å†…å®¹ã«ã¤ã„ã¦ã¯å¤šãã®äººãŒã€Œã¾ã‚ãã†ã ã‚ˆãªãƒ¼ã€ã¨é ·ã„ãŸã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ TiDB serverlessè‰¯ã„ã‹ã‚‚ ã•ã£ããæœ¬é¡Œã§ã™ãŒã€ãã‚“ãªæ™‚ã«ã€ŒTiDBã€ãŒæŽ¡ç”¨ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ åŽ³å¯†ã«è¨€ã†ã¨
YassLab 2024/03/05
â€œãŠãã‚‰ã1000å††ã§ä½¿ãˆã‚‹RDBã¨æ¯”è¼ƒã—ã¦ã‚‚å……åˆ†ã¨è¨€ãˆã‚‹ãã‚‰ã„ã«ã¯ãŸã£ã·ã‚Šã¨ä½¿ãˆã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ ä»–ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸æ–™é‡‘ã‚‚ã‹ã‹ã‚Šã¾ã™ãŒã€1GBã‚‚ã‚ã‚Œã°ä¸Šã®æ¡ä»¶ãªã‚‰å……åˆ† =30å††ç¨‹åº¦ ã‹ã¨æ€ã„ã¾ã™â€

Ruby

Rails

DB
ãƒªãƒ³ã‚¯
Rails 7.1æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚æœ¬ç•ªãƒ‡ãƒ—ãƒã‚¤ç”¨ã®Dockerfileè‡ªå‹•ç”Ÿæˆã€é…ã„ã‚¯ã‚¨ãƒªã®éžåŒæœŸåŒ–ãªã©æ–°æ©Ÿèƒ½
Rails 7.1æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚æœ¬ç•ªãƒ‡ãƒ—ãƒã‚¤ç”¨ã®Dockerfileè‡ªå‹•ç”Ÿæˆã€é…ã„ã‚¯ã‚¨ãƒªã®éžåŒæœŸåŒ–ãªã©æ–°æ©Ÿèƒ½ Rubyè¨€èªžã«ã‚ˆã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®æœ€æ–°ç‰ˆã¨ãªã‚‹ã€ŒRails 7.1ã€æ£å¼ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ Rails 7.1: Dockerfiles, BYO Authentication, More Async Queries, and more!https://t.co/c32MdUifNs â€” Ruby on Rails (@rails) October 5, 2023 ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã¨ãªã£ãŸRails 7ã®ç™»å ´ãŒ2021å¹´12æœˆã€‚ Rails 7ã¯ã€ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰é–‹ç™ºç’°å¢ƒãŒåˆ·æ–°ã•ã‚Œã¦Node.jsã‚’ç”¨ã„ãªã„æ§‹æˆãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¨ãªã‚Šã€Turboã¨Stimulusã¨ã„ã†2ã¤ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’æè¼‰ã—ãŸHotwireãªã©ãŒæè¼‰ã•ã‚Œã‚‹ãªã©ã€å¤§åž‹ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã§
YassLab 2023/10/10
"Ralis 7.1ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ€ãƒ—ã‚¿ã¨ã—ã¦GitHubãŒé–‹ç™ºã—ãŸã€ŒTrilogyã€ã‚’æè¼‰ / Trilogyã¯Ruby VMç’°å¢ƒã«çµ„ã¿è¾¼ã‚“ã ã¨ãã«åŠ¹çŽ‡çš„ã«å‹•ä½œã™ã‚‹ã‚ˆã†ã«ç‰¹åˆ¥ã«è¨è¨ˆ / GitHubã¨Shopifyã®æœ¬ç•ªç’°å¢ƒã§ä½¿ã‚ã‚Œã¦ã„ã¾ã™"

GitHub

Ruby

Rails

Trilogy

DB

Shopify
ãƒªãƒ³ã‚¯
Supabase vs Firebase
YassLab 2023/08/13
"Firebase charges for reads, writes and deletes, which can lead to some unpredictability, especially in the early stages of a project ... Supabase charges based on the amount of data stored, with breathing room for unlimited API requests and an unlimited number of Auth users.â€

Supabase

Firebase

DB

PostgreSQL
ãƒªãƒ³ã‚¯
Supabase VS Firebase
åˆã‚ã« æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºã§Supabaseã‚’æŽ¡ç”¨ã™ã‚‹ã“ã¨ã«ãªã£ãŸã®ã§, ä»¥å‰ä½¿ç”¨ã—ã¦ã„ãŸã“ã¨ã‚‚ã‚ã‚‹Firebaseã¨ã®æ¯”è¼ƒã‚’ç°¡å˜ã«è¡Œã£ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚æ¯”è¼ƒé …ç›®ã¯Auth, Database(Firebaseã¯Firestore)ã§ã™ã€‚ â€» Supabaseã®ç´¹ä»‹ãŒä¸»æ—¨ãªã®ã§è‹¥å¹²Supabaseè´”å±“ãªå†…å®¹ã«ãªã£ã¦ãŠã‚Šã¾ã™ã®ã§ã”äº†æ‰¿ãã ã•ã„ã€‚ â€»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒãƒ¼ã‚¸ãƒ§ãƒ³ ãƒ» @supabase/supabase-js 1.33.3 ãƒ» firebase 9.6.6 Auth ã“ã“ã§ã¯ç°¡å˜ã«ãƒ¡ãƒ¼ãƒ«&ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰èªè¨¼ã«ãŠã‘ã‚‹ã‚µã‚¤ãƒ³ã‚¢ãƒƒãƒ—, ã‚µã‚¤ãƒ³ã‚¤ãƒ³, ã‚µã‚¤ãƒ³ã‚¢ã‚¦ãƒˆå‡¦ç†ã«ã¤ã„ã¦å…¬å¼ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ä¸¡è€…ã®æ¯”è¼ƒã‚’ã—ã¦ã¿ã¾ã™ã€‚ ãƒ» Supabase // ã‚µã‚¤ãƒ³ã‚¢ãƒƒãƒ— const { data, session, error } = await supabase.auth.signUp({ e
YassLab 2023/08/13
"Firestoreã¯NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æœ‰åã§ã™ãŒ, Supabaseã¯PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ / çŸ¥è˜ã‚’æŒã£ã¦ã„ã‚‹äººã¯ãã®ã¾ã¾æ´»ã‹ã™ã“ã¨ãŒã§ãã‚‹/ ç•°ãªã‚‹åˆ†é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã®ã§ã©ã¡ã‚‰ãŒç§€ã§ã¦ã„ã‚‹ã¨ç°¡å˜ã«fæ–è¨€ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“"

Firebase

Supabase

DB

PostgreSQL
ãƒªãƒ³ã‚¯
Pricing and plans
Our plans scale with you. All plans include: Daily backups Automatic failover Enterprise-grade security
YassLab 2023/07/21
â€œAll plans include: Daily backups / Automatic failover / Enterprise-grade security / Plans: Hobby - Free forever for hobby use $0 per month / 5 GB storage included, 1B row reads/ month, 10 million row reads per month, 10M row writes/ month, 1 production branch, 1 development branchâ€

DB
ãƒªãƒ³ã‚¯
GitHub - ridgepole/ridgepole: Ridgepole is a tool to manage DB schema. It defines DB schema using Rails DSL, and updates DB schema according to DSL. (like Chef/Puppet)
Note ridgepole v3.0.0 Support Rails 8.0 (cf. #504) ridgepole v2.0.0 Support Trilogy (cf. #447) Support Rails 7.1 (cf. #441) Drop support AcriveRecord 6.0 (cf. #440) Drop support ActiveRecord 5.x in ridgepole v1.2.0. Partitioning is no longer supported in ridgepole v1.1.0. ActiveRecord 7.x has some incompatible changes. If you get unintended differences in datetime columns consider changing precisi
YassLab 2023/06/23
â€œRidgepole is a tool to manage DB schema. It defines DB schema using Rails DSL, and updates DB schema according to DSL. (like Chef/Puppet)â€

Rails

Migration

DB
ãƒªãƒ³ã‚¯
https://twitter.com/kenn/status/1664865007564214272
YassLab 2023/06/04
â€œã“ã“æ•°ãƒ¶æœˆä½œã‚ŠãªãŒã‚‰è€ƒãˆã¦ã¦ã€SaaSãƒ—ãƒãƒ€ã‚¯ãƒˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯é«˜é »åº¦ãªDBã‚¢ã‚¯ã‚»ã‚¹ãªã®ã§ã‚¨ãƒƒã‚¸ãƒ»ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã®ä½¿ã„ã©ã“ã‚ã¯ã»ã¨ã‚“ã©ãªã„ï¼ˆé€†ã«é…ããªã‚Šã‹ããªã„ï¼‰ã€ã¨ã„ã†çµè«–ã«é”ã—ãŸ / è‡ªç¤¾ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ Render ã«â€

Render

SaaS

DB
ãƒªãƒ³ã‚¯
RubyKaigi 2023ã«å‚åŠ ã—ãŸ #rubykaigi - ç§ãŒæŒå·ã§ã™
RubyKaigi 2023ã«å‚åŠ ã—ã¾ã—ãŸã€‚ ãƒˆãƒ¼ã‚¯ å°è±¡ã«æ®‹ã£ãŸãƒˆãƒ¼ã‚¯ã«ã¤ã„ã¦ç°¡å˜ãªæ„Ÿæƒ³ã‚’æ›¸ãã¾ã™ã€‚ The future vision of Ruby Parser Rubyã«ã¯4ç¨®é¡žã® do ãŒã‚ã‚‹ã€ã¨ã„ã†è©±ãŒãŠã‚‚ã—ã‚ã‹ã£ãŸã§ã™ã€‚ Fix SQL N+1 queries with RuboCop RuboCopã«N+1ã‚¯ã‚¨ãƒªã‚’è‡ªå‹•ä¿®æ£ã•ã›ã‚‹ã€ã¨ã„ã†ãªã‹ãªã‹é‡Žå¿ƒçš„ãªå–ã‚Šçµ„ã¿ã®è©±ã§ã—ãŸã€‚æœ€è¿‘ã ã¨ChatGPTã«ã‚³ãƒ¼ãƒ‰ã‚’ä¿®æ£ã•ã›ã‚‹ã¨ã„ã†å‘ãã‚‚ã‚ã‚‹ã¨æ€ã†ã®ã§ã™ãŒã€ä»Šå¾Œã©ã†ãªã‚‹ã®ã‹ãŒæ°—ã«ãªã‚Šã¾ã™ã€‚ Splitting: the Crucial Optimization for Ruby Blocks TruffleRubyã®æœ€é©åŒ–æ‰‹æ³•ã®è©±ã§ã—ãŸã€‚ã‘ã£ã“ã†ã‚¢ã‚°ãƒ¬ãƒƒã‚·ãƒ–ã«æœ€é©åŒ–ã—ã¦ã„ã‚‹ã‘ã©ã€æœ€é©åŒ–ãƒ•ã‚§ãƒ¼ã‚ºã«å¿…è¦ãªè¨ˆç®—è³‡æºãŒã‘ã£ã“ã†ã‚ã‚Šãã†ï¼Ÿ ã¨ã„ã†ã®ãŒæ°—ã«ãªã‚Šã¾ã—ãŸã€‚ Ruby Committer
YassLab 2023/05/16
â€œBuild Your Own SQLite3: è‡ªä½œã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã®ä¸ã§SQLite3ãŒå‹•ãã€ã‚ãƒ¼ã‚¿ã‚¤ãƒ—ã®çµ±è¨ˆæƒ…å ±ã‹ã‚‰æœ€å¼·ã®ã‚ãƒ¼é…åˆ—ã‚’ä½œã£ãŸçµæžœhjklãŒäººå·®ã—æŒ‡ã«æ¥ã‚‹ã€ã¨ã„ã†ã‚ªãƒã«ãªã£ãŸã®ãŒã¨ã¦ã‚‚ãŠã‚‚ã—ã‚ã‹ã£ãŸ / File.open ã‚’SQLite3ã«ä½¿ã‚ã›ã‚‹â€

RubyKaigi

Ruby

SQLite3

DB
ãƒªãƒ³ã‚¯
Rails: Active Recordãƒ¢ãƒ‡ãƒ«ã®ã‚«ãƒ©ãƒ ã‚’å®‰å…¨ã«å‰Šé™¤ã™ã‚‹ï¼ˆç¿»è¨³ï¼‰ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾
æ¦‚è¦ å…ƒã‚µã‚¤ãƒˆã®è¨±è«¾ã‚’å¾—ã¦ç¿»è¨³ãƒ»å…¬é–‹ã„ãŸã—ã¾ã™ã€‚ è‹±èªžè¨˜äº‹: Safely Remove a Column from an Active Record Model - Andy Croll åŽŸæ–‡å…¬é–‹æ—¥: 2022/11/14 è‘—è€…: Andy Croll å‚è€ƒ: Rails API ignored_columns= -- ActiveRecord::ModelSchema::ClassMethods æ—¢å˜ã®Active Recordãƒ¢ãƒ‡ãƒ«ã«æ–°ã—ã„ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ã¦ãƒ‡ãƒ—ãƒã‚¤ã™ã‚‹ã®ã¯ã€å¤šãã®å ´åˆå•é¡Œãªãã§ãã¾ã™ã€‚é€šå¸¸ã¯ã€æœ€åˆã®ãƒ‡ãƒ—ãƒã‚¤ã§ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿè¡Œã—ã€ãã‚ŒãŒçµ‚ã‚ã£ã¦ã‹ã‚‰ã€æ¬¡ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¿½åŠ ã•ã‚ŒãŸã‚«ãƒ©ãƒ ã‚’åˆ©ç”¨ã™ã‚‹æ–°ã—ã„ã‚³ãƒ¼ãƒ‰ã‚’ãƒªãƒªãƒ¼ã‚¹ã™ã‚‹ã¨ã„ã†æ‰‹é †ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ã‚«ãƒ©ãƒ ã‚’å‰Šé™¤ã™ã‚‹å ´åˆã¯å•é¡ŒãŒèµ·ãã‚„ã™ã„å‚¾å‘ãŒã‚ã‚Šã¾ã™ã€‚Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’èµ·å‹•ã™ã‚‹ã¨ã€Active Reco
YassLab 2023/04/30
"ã‚«ãƒ©ãƒ ã‚’å‰Šé™¤ã™ã‚‹ã¨ãã¯æ‰‹é †ã‚’åˆ†å‰²ã™ã‚‹æˆ¦ç•¥ãŒæœ‰ç”¨ / æœ€åˆã«ã€ignored_columns ã§ Active Record ãŒãã®ã‚«ãƒ©ãƒ ã‚’ç„¡è¦– / æ¬¡ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚«ãƒ©ãƒ ã‚’å®Ÿéš›ã«å‰Šé™¤ã™ã‚‹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆ / å†’é ã§è¿½åŠ ã—ãŸ ignored_columns è¡Œã‚’å‰Šé™¤"

DB

Rails

ActiveRecord
ãƒªãƒ³ã‚¯
ã“ã®10å¹´ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®å¤‰åŒ– - è¥¿å°¾æ³°å’Œã®å¤–éƒ¨è„³
@nishio: ã‚ã€ãã†ã‹ã€10å¹´å‰ã‹ã‚‰ã‚ã£ãŸã‘ã©10å¹´é–“ã®é–“ã«å‹¢åŠ›ã‚’æ‹¡å¤§ã—ãŸã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã‹ã‚‰ã‚ã‚“ã¾ã‚ŠåŽ³ã—ãåˆ‡ã‚‰ãªã„æ–¹ãŒã„ã„ã®ã‹(TypeScriptã®ç™»å ´ãŒ2012å¹´ã€Rustã®ç™»å ´ãŒ2010å¹´ã ã£ãŸ)
YassLab 2023/01/17
"1å°ã®ã‚µãƒ¼ãƒã§RDBMSãŒæä¾›ã§ãã‚‹èƒ½åŠ›ã‚’è¶…ãˆã¦ã—ã¾ã„ã€è¤‡æ•°å°ã§åˆ†æ•£ã™ã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒ¡ãƒªãƒƒãƒˆãŒå¼±ã¾ã£ã¦ã„ã£ã¦ã€Œã˜ã‚ƒã‚æ¨ã¦ã¦NoSQLã«ã—ã‚ˆã†ãœã€ã¨ãªã£ãŸãŒã€IOæ€§èƒ½ãŒä¸ŠãŒã£ãŸã®ã§ç››ã‚Šè¿”ã—ã¦ããŸ"

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

æ´å²

DB

RDBMS

NoSQL
ãƒªãƒ³ã‚¯
Open Data Commons Open Database License (ODbL) Summary â€” Open Data Commons: legal tools for open data
This is a human-readable summary of the ODbL 1.0 license. Please see the disclaimer below. You are free: To share: To copy, distribute and use the database. To create: To produce works from the database. To adapt: To modify, transf orm and build upon the database. As long as you: Attribute: You must attribute any public use of the database, or works produced from the database, in the manner specifi
YassLab 2022/12/08
"You must attribute any public use of the database, or works produced from the DB, in the manner specified in the ODbL. For any use or redistribution of the DB, or works produced from it, you must make clear to others the license of the DB and keep intact any notices on the original DB."

db

ãƒ©ã‚¤ã‚»ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Introducing Trilogy: a new database adapter for Ruby on Rails
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
YassLab 2022/08/30
â€œWeâ€™ve open sourced the database adapter we use at GitHub to connect Ruby on Rails and Active Record clients to MySQL-compatible database servers. Trilogy is a client library for MySQL-compatible database servers, designed for performance, flexibility, and ease of embedding.â€

Rails

Ruby

GitHub

Ruby on Rails

db
ãƒªãƒ³ã‚¯
1