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

blogpants id:blogpants

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

${{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è¨è¨ˆã®å…±æœ‰ã§ç–²å¼Šã—ã¦ãªã„ï¼Ÿdbdocsã®ã™ã‚ã‚
DBè¨è¨ˆã®ç®¡ç†ã‚„ä½œæˆã«ç–²å¼Šã—ã¦ã¾ã›ã‚“ï¼Ÿã“ã‚“ã«ã¡ã¯ã€‚ukmshiã§ã™ã€‚ä»Šæ—¥ã¯DBè¨è¨ˆã®å…±æœ‰ã¨ç®¡ç†ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã€dbdocsã«ã¤ã„ã¦ãŠè©±ã—ã—ã¾ã™ã€‚dbdocsã‚’ä½¿ãˆã°ã€è¨è¨ˆã®å¯è¦–åŒ–ã‚„å…±æœ‰ãŒã‚ã¡ã‚ƒãã¡ã‚ƒç°¡å˜ã«ãªã‚‹ã‚“ã§ã™ã€‚ä»Šå›žã¯ã€ãã®é…åŠ›ã¨åˆ©ç‚¹ã€ãã—ã¦å®Ÿéš›ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¾ã™ã€‚ dbdocsã¨ã¯ï¼Ÿ dbdocsã¯ã€ã‚³ãƒ¼ãƒ‰ãƒ™ãƒ¼ã‚¹ï¼ˆDBMLï¼‰ã§DBè¨è¨ˆã‚’ç®¡ç†ã—ã€URLã§å…±æœ‰ã™ã‚‹ã“ã¨ãŒå¯èƒ½ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‚„é–¢ä¿‚æ€§ã‚’å¯è¦–åŒ–ã—ã€ãã‚Œã‚’ä»–ã®ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ã‚„ã‚¹ãƒ†ãƒ¼ã‚¯ãƒ›ãƒ«ãƒ€ãƒ¼ã¨æ‰‹è»½ã«å…±æœ‰ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ DBMLã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’å‚è€ƒã« dbdocsã®åˆ©ç‚¹ dbdocsã®åˆ©ç‚¹ã«ã¤ã„ã¦è©³ã—ãè¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ç„¡æ–™ ã¾ãšæœ€åˆã«ã€dbdocsã¯åŸºæœ¬ç„¡æ–™ã§ã™ã€‚ã‚³ã‚¹ãƒˆã‚’æ°—ã«ã›ãšã«åˆ©ç”¨ã§ãã‚‹ã®ã§ã€ãƒãƒ¼ãƒ ã®èª°ã‚‚ãŒã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ã§ã™ã€‚ ã‚³ãƒ¼ãƒ‰ãƒ™ãƒ¼ã‚¹ã§ç®¡ç† dbdocsã¯ã‚³ãƒ¼ãƒ‰ãƒ™ãƒ¼ã‚¹ã§DB
blogpants 2023/06/01
DB
ãƒªãƒ³ã‚¯
Web APIã‚’æ‰‹ä½œã‚Šã™ã‚‹æ™‚ä»£ã¯çµ‚ã‚ã£ãŸï¼Ÿ
::: message info ã“ã‚Œã¯[ãƒ•ã‚£ãƒ¨ãƒ«ãƒ‰ãƒ–ãƒ¼ãƒˆã‚ãƒ£ãƒ³ãƒ— Advent Calendar 2022 Part.1](https://adventar.org/calendars/7760)ã®25æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ æ˜¨æ—¥ã®è¨˜äº‹ã¯:@shujiwatanabe:shujiwatanabeã•ã‚“ã®[è³ªå•ã—ãªãŒã‚‰å‡ºæ¥ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã](https://shu91327.hatena blog.com/entry/2022/12/24/091025)ã¨:@saeyama:saeyamaã•ã‚“ã®[Rails/Vue ç·¨é›†æ™‚ã«ç”»åƒã‚’D&Dã§å…¥ã‚Œæ›¿ãˆã—ãŸæ™‚ã®Active Storageã®ä¿å˜æ–¹æ³•](https://saeyama.hatena blog.com/entry/2022/12/24/000123)ã§ã—ãŸã€‚ ::: â†“ã“ã†ã„ã†ã®ã‚’è·äººãŒä¸¹ç²¾è¾¼ã‚ã¦ä¸€ã¤ä¸€ã¤æ‰‹ä½œã‚Šã™ã‚‹æ™‚ä»£ã¯çµ‚ã‚ã‚Šã¾ã—ãŸã€‚ ```sh
blogpants 2022/12/25
db

api
ãƒªãƒ³ã‚¯
ã€Laravelã€‘ç‹¬è‡ªã®DBç”¨ã‚¯ã‚¨ãƒªé–¢æ•°ã‚’å®Ÿè£…ã™ã‚‹ - Qiita
<?php namespace CustomBuilder; use Illuminate\Support\ServiceProvider; use Illuminate\Database\Connection; class CustomBuilderServiceProvider extends ServiceProvider { /** * Bootstrap the application services. * * @return void */ public function boot() { // è¿½åŠ Connection::resolverFor('mysql', function (...$parameters) { return new Database\MySqlConnection(...$parameters); }); } /** * Register the
blogpants 2020/12/06
laravel

db
ãƒªãƒ³ã‚¯
Loading...
blogpants 2019/11/20
varcharåž‹ã‚’æ•°å€¤ã§ã‚½ãƒ¼ãƒˆã™ã‚‹å ´åˆã®ãƒ¡ãƒ¢(å¿˜ã‚Œã‚‹ï¼‰

mysql

sort

db
ãƒªãƒ³ã‚¯
MySQLæ—¥æœ¬èªžåˆ©ç”¨å¾¹åº•å…¥é–€
1. <Insert Picture Here> MySQL æ—¥æœ¬èªžåˆ©ç”¨å¾¹åº•å…¥é–€ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ MySQL Global Business Unit ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚¢ãƒŠãƒªã‚¹ãƒˆ å¥¥é‡Žå¹¹ä¹Ÿ 2012 å¹´ 5 æœˆ 29 æ—¥ CopyrightÂ© 2012, Oracle. All rights reserved. 2. 2 ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ã¾ ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ã§ã ã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ãƒˆï¼ˆç¢º ç´„ï¼‰ã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ãŸã‚ã€è³¼è²·æ±ºå®šã‚’è¡Œã†éš›ã®åˆ¤æ–ææ–™ã«ãªã•ã‚‰ãªã„ã§ä¸‹ã•ã„ã€‚ã‚ª ãƒ©ã‚¯ãƒ«è£½å“ã«é–¢ã—ã¦è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹æ©Ÿèƒ½ã®é–‹ç™ºã€ãƒªãƒªãƒ¼ã‚¹ãŠã‚ˆã³æ™‚æœŸã«ã¤ã„ã¦ã¯ã€å¼Š ç¤¾ã®è£é‡ã«ã‚ˆã‚Šæ±ºå®šã•ã‚Œã¾ã™ã€‚ Oracle ã¨ Java ã¯ã€ Oracle Cor
blogpants 2012/05/30
mysql

db
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
1. åˆå¿ƒè€…å‘ã‘ MySQLã®å§‹ã‚æ–¹ MySQL Beginners Talk ã¨ã¿ãŸã¾ã•ã²ã‚ 2012-05-29 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6 2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸã¾ã•ã²ã‚ âœ“ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(ä»£è¡¨) âœ“ id:tmtms âœ“ @tmtms âœ“ Rubyã‹ã‚‰MySQLã‚’ä½¿ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªæ›¸ã„ãŸã‚Š 1/80 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6
blogpants 2012/05/30
db
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
blogpants 2012/04/05
titanium mobile

DB
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
blogpants 2012/02/08
mysql

DB

mac
ãƒªãƒ³ã‚¯
WebKit HTML 5 SQL Storage Notes Demo
This page demonstrates the use of the HTML 5 Client-side Database Storage API. Any notes you create will be saved in a database on your local hard drive, and will be reloaded from that database the next time you visit this page. To try it out, use a WebKit Nightly Build. New Note
blogpants 2011/08/10
ã“ã‚Œã¯ã„ã„ã‚µãƒ³ãƒ—ãƒ«

html5

DB
ãƒªãƒ³ã‚¯
Safari 3.1 ã«å®Ÿè£…ã•ã‚ŒãŸã€ŒClient-side database storage (SQL API)ã€ã¨ã¯ä½•ã‹ï¼Ÿ - ITæˆ¦è¨˜
ã¯ã˜ã‚ã« Safari 3.1 ã«ã¯ Client-side database storage ï¼ˆSQL API ã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ï¼‰ã¨ã„ã†æ–°ã—ã„ä»•æ§˜ãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã“ã®æ–°ã—ã„ API ã«ã¤ã„ã¦è‰²ã€…èª¿ã¹ãŸã“ã¨ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ Client-side database storage ãŒä½¿ãˆã‚‹ãƒ–ãƒ©ã‚¦ã‚¶ 2008 å¹´ 03 æœˆ 27 æ—¥ç¾åœ¨ã§ã¯ã€ Safari ç³»ã®ãƒ–ãƒ©ã‚¦ã‚¶ã®ã¿ã§ã™ã€‚ Safari 3.1 WebKit Nightly Client-side database storage ã¨ã¯ Selectors API ã¨ã¯ HTML5 ã§å®šç¾©ã•ã‚ŒãŸä»•æ§˜ã§ã™ã€‚è©³ç´°ã«é–¢ã—ã¦ã¯ã“ã¡ã‚‰ã‚’ã©ã†ãžã€‚ ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ JavaScript å†…ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã‚‚ã£ã¨ç°¡å˜ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã™ã‚‹ãŸã‚ã«ã€å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã‚’ç¤ºã™ã¨ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ va
blogpants 2011/08/10
ã“ã‚“ãªã“ã¨ã‚‚ã§ãã‚‹ã‚“ã‹

safari

DB
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
blogpants 2010/01/22
DB
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
blogpants 2010/01/19
KVS

DB
ãƒªãƒ³ã‚¯
pgmemcacheã‹ã‚‰memcachedã®ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹
æœ¬ç¨¿ã®å‰æç’°å¢ƒ memcached 1.2.5 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šPostgreSQL 8.3.1 OSï¼šCentOS 5ï¼ˆLinux kernel 2.6 ï¼‰ ã‚·ã‚§ãƒ«ï¼šbash CPUï¼šIntel Core2Quad 9660 2.4GHz RAMï¼šPC2-6400 8GBytes ä»¥é™ã§ã¯ã€å‰ç·¨ã®å†…å®¹ã‚’å‰æã¨ã—ã¦ã€å®Ÿéš›ã«memcachedã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãªãŒã‚‰pgmemcacheã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã—ã¾ã™ã®ã§ã€memcachedãŒèµ·å‹•ã•ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹ç¢ºèªã—ã¦ãã ã•ã„ã€‚ æœ€åˆã«ã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚½ãƒ•ãƒˆpsqlã‚’ä½¿ã£ã¦ç›´æŽ¥pgmemcacheã®ä¸»è¦ãªé–¢æ•°ã‚’å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ æ¬¡ãƒšãƒ¼ã‚¸ã‹ã‚‰ã¯ç°¡å˜ãªä¾‹ã‚’ä½¿ã£ã¦ã€PostgreSQLã¨memcachedã‚’é€£æºã•ã›ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹é–¢æ•° pgmemcacheã¯libmemcacheã®ã»ã¨ã‚“ã©ã®æ©Ÿèƒ½ã‚’åˆ©ç”¨ã§ãã¾ã™ãŒã€ã“ã“ã§ã¯åŸºæœ¬çš„ãªé–¢æ•°ã®èª¬æ˜Žã«ã¨ã©
blogpants 2010/01/19
memcached

KVS

DB

postgres
ãƒªãƒ³ã‚¯
memcachedï¼‹PostgreSQLã§å®Ÿç¾ã™ã‚‹ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ï¼ˆ1/4ï¼‰ â€• ï¼ IT
æœ¬ç¨¿ã®å‰æç’°å¢ƒ memcached 1.2.5 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šPostgreSQL 8.3.1 OSï¼šCentOS 5ï¼ˆLinux kernel 2.6 ï¼‰ ã‚·ã‚§ãƒ«ï¼šbash CPUï¼šIntel Core2Quad 9660 2.4GHz RAMï¼šPC2-6400 8GBytes memcachedã¯ã€Danga Interactiveã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ¡ãƒ¢ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã§ã™ã€‚ ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§memcachedã‚’çµ‚äº†ã™ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã¾ã™ãŒã€ï¼ˆOracleã‚„MySQLã¨ã„ã£ãŸï¼‰RDBMSã¨æ¯”è¼ƒã™ã‚‹ã¨ã‘ãŸé•ã„ã®é«˜é€Ÿãƒ¬ã‚¹ãƒãƒ³ã‚¹æ€§èƒ½ã‚’æœ‰ã—ã€æ•°åƒä¸‡ä»¶ã¨ã„ã†å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã£ã¦ã‚‚ã»ã¨ã‚“ã©æ€§èƒ½ãŒåŠ£åŒ–ã—ãªã„ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ æ©Ÿèƒ½ã¯é™ç•Œã¾ã§åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã€åŸºæœ¬çš„ã«ã¯ã‚ãƒ¼ã¨ãƒ‡ãƒ¼ã‚¿ã®çµ„ï¼ˆä»¥ä¸‹ã€it emã¨å‘¼ã³ã¾ã™ï¼‰ã®ä¿å˜ã¨æ¤œç´¢ã¨å‰Šé™¤ã—ã‹ã§ãã¾ã›ã‚“ã€‚ ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€me
blogpants 2010/01/19
memcached

KVS

DB

postgres
ãƒªãƒ³ã‚¯
PostgreSQL 8.4 ã®æ–°æ©Ÿèƒ½ â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ æ¿åž£ è²´è£• 2009å¹´7æœˆ1æ—¥ã€PostgreSQL 8.4 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‹ã‚‰1å¹´5ãƒ¶æœˆã¶ã‚Šã®ãƒªãƒªãƒ¼ã‚¹ã§ã™ã€‚æ•°å¤šãã®æ–°æ©Ÿèƒ½ãŒç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ãŒã€å¤§ã¾ã‹ã«ä»¥ä¸‹ã®ã‚«ãƒ†ã‚´ãƒªã«åˆ†ã‘ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ä»Šå›žã¯ã€å¿œç”¨SQLã€å¤§è¦æ¨¡å¯¾å¿œã«å¼•ãç¶šãã€é‹ç”¨ç®¡ç†ã«é–¢ã™ã‚‹æ–°æ©Ÿèƒ½ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ å¿œç”¨SQL å¤§è¦æ¨¡å¯¾å¿œ é‹ç”¨ç®¡ç† ãã®ä»–ã®æƒ…å ± ãã®ä»–ã®æ–°æ©Ÿèƒ½ æ¬¡ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¸å…ˆé€ã‚Šã•ã‚ŒãŸæ©Ÿèƒ½ å…¬å¼ã®ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã¯ PostgreSQL 8.4ãƒ—ãƒ¬ã‚¹ã‚ãƒƒãƒˆã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¨å„ãƒ—ãƒ©ãƒƒãƒˆãƒ›ãƒ¼ãƒ å‘ã‘ã®ãƒã‚¤ãƒŠãƒªã‚‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ å¿œç”¨SQLã«é–¢ã™ã‚‹æ–°æ©Ÿèƒ½ å¿œç”¨SQLã«é–¢ã™ã‚‹æ©Ÿèƒ½ã§ã¯ã€ç‰¹ã«ã€Œå†å¸°SQLã€ã¨ã€ŒWindowé–¢æ•°ã€ã¸ã®å¯¾å¿œãŒå¤§ãã„ã§ã—ã‚‡ã†ã€‚ PostgreSQL ã¯æ¨™æº–SQLã«è‰¯ãæº–æ‹ ã—ã¦ã„ã‚‹ã¨è©•ä¾¡ã•ã‚Œã‚‹ã“ã¨ãŒå¤š
blogpants 2009/09/02
ã•ã‚‰ã«8.4ã§ã¯ã€€distinctã§ã‚‚é€Ÿã„ã‚‰ã—ã„ å‹‰å¼·ã—ãªãŠã•ãªã‚ã‹ã‚“ã€‚

postgres

DB
ãƒªãƒ³ã‚¯
PostgreSQL tuning technique
PostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›† SELECT ... WHERE foo = 100 ORDER BY barã‚’SELECT ... WHERE foo = 100 ORDER BY i, jã«æ›¸ãæ›ãˆã‚‹(2004/08/18æŽ²è¼‰) SELECT * FROM t1 WHERE i = 100 ORDER BY j; ã®ã‚ˆã†ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã®æ¤œç´¢ã§ã¯ï¼Œiã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦ã®é«˜ é€ŸåŒ–ãŒã§ãã¾ã™ãŒï¼Œãã®å¾Œã§ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã—ï¼Œé€Ÿåº¦ä½Žä¸‹ã®è¦å› ã«ãªã‚Šã¾ã™ï¼Ž SELECT * FROM t1 WHERE i = 100 ORDER BY j LIMIT 5; ã®ã‚ˆã†ã«ï¼Œå‡ºåŠ›çµæžœä»¶æ•°ã‚’åˆ¶é™ã—ã‹ã¤jã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã¨ï¼Œä»Šåº¦ã¯jã®ã‚¤ ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼Ž ã—ã‹ã—ï¼Œã‚ˆãè€ƒãˆã¦ã¿ã‚‹ã¨ï¼Œiã§æ¤œç´¢ã—ï¼Œjã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã¯iã¨jã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã®ä¸¡æ–¹ã‚’ä½¿ãˆã°ä¸€åº¦ã«ã§ãã‚‹ã¯ãšã§ã™
blogpants 2009/09/02
7.4ä»¥é™ã¯group by ãŒé€Ÿã„ã‚‰ã—ã„ã€€ä»Šæ›´æ„Ÿã‚ã‚Šã‚ã‚Šã®ãƒ¡ãƒ¢

postgres

DB

ã‚·ã‚¹ãƒ†ãƒ
ãƒªãƒ³ã‚¯
ã‚«ãƒ©ãƒ ã®å‰Šé™¤
blogpants 2008/08/17
Postgres

DB

ã‚·ã‚¹ãƒ†ãƒ æŠ€è¡“
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬3å›žï¼šVACUUMã®æ´»ç”¨ã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° (1/2)
VACUUMã¯ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ãªã„PostgreSQLå›ºæœ‰ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚Šã€ä½¿ã„æ–¹æ¬¡ç¬¬ã§PostgreSQLã®æ€§èƒ½ã‚’å·¦å³ã™ã‚‹é‡è¦ãªå½¹å‰²ã‚’æŒã¡ã¾ã™ã€‚ PostgreSQLã§ã¯ã€å‰Šé™¤ã‚„æ›´æ–°ãŒè¡Œã‚ã‚Œã¦ã‚‚å¤ã„è¡Œã¯æ¶ˆãˆã¾ã›ã‚“ã€‚VACUUMã‚³ãƒžãƒ³ãƒ‰ã¯ã€ã“ã®ã‚ˆã†ãªå¤ã„è¡Œã®ä¸ã‹ã‚‰ã€ã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã‚‚å‚ç…§ã•ã‚Œã¦ã„ãªã„å®‰å…¨ã«å†åˆ©ç”¨ã§ãã‚‹è¡Œã‚’æŽ¢ã—ã¦ã€FSMï¼ˆFree Space Mapï¼‰ã¨ã„ã†å…±æœ‰ãƒ¡ãƒ¢ãƒªä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã«ãã®ä½ç½®ã¨å¤§ãã•ã‚’è¨˜éŒ²ã—ã¾ã™ã€‚è¿½åŠ ã‚„æ›´æ–°ãªã©ã€æ–°ã—ãè¡Œã‚’è¿½åŠ ã™ã‚‹å ´åˆã¯ã¾ãšFSMã‚’æ¤œç´¢ã—ã¦ã€æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚’ä¿ç®¡ã™ã‚‹ã®ã«é©å½“ãªå¤§ãã•ã®è¡ŒãŒè¦‹ã¤ã‹ã‚Œã°ãã‚ŒãŒå†åˆ©ç”¨ã•ã‚Œã¾ã™ï¼ˆå›³3ï¼‰ã€‚
blogpants 2008/07/31
Postgres ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€€VACUUMã®ç« å¾Œã§ã‚ˆãç¢ºèªã—ãªãã¦ã¯ã€‚

Postgres

DB

IT
ãƒªãƒ³ã‚¯
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿ
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿï¼šLinuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ˆ3ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ NTTã‚°ãƒ«ãƒ¼ãƒ—ã®å„ç¤¾ã§é³´ã‚‰ã—ãŸä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã¯ã€å„ç¤¾ã§åŸ¹ã£ãŸOSSé–¢é€£æŠ€è¡“ã‚’æ‰‹ã«ã€NTT OSSã‚»ãƒ³ã‚¿ã«é›†ã‚ã‚‰ã‚ŒãŸã€‚æ™®æ®µã¯åŸºæœ¬çš„ã«NTTã‚°ãƒ«ãƒ¼ãƒ—ã®ã¿ã‚’ç›¸æ‰‹ã«æ´»å‹•ã—ã¦ã„ã‚‹ãŒã€ãã‚Œã ã‘ã§çµ‚ã‚ã‚‹ä¿ºãŸã¡ã˜ã‚ƒã‚ãªã„ã€‚å¼•ãç¶šãOSSã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã®è§£æ±ºéŽç¨‹ã‚’ï¼ ITã§é€£è¼‰ã—ã¦ã„ããœã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã•ãˆã‚ã‚Œã°ã©ã‚“ãªãƒˆãƒ©ãƒ–ãƒ«ã§ã‚‚è§£æ±ºã™ã‚‹å‘½çŸ¥ã‚‰ãšã€ä¸å¯èƒ½ã‚’å¯èƒ½ã«ã—ã€å¤šãã®ãƒã‚°ã‚’ç²‰ç •ã™ã‚‹ã€ä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ã€€åŠ©ã‘ã‚’å€Ÿã‚ŠãŸã„ã¨ãã¯ã€ã„ã¤ã§ã‚‚ã„ã£ã¦ãã‚Œï¼ OSï¼šé«˜ç”°å“²ç”Ÿ ä¿ºã¯ãƒªãƒ¼ãƒ€ãƒ¼ã€é«˜ç”°å“²ç”Ÿã€‚Linuxã®é”äººã€‚ä¿ºã®ã‚ˆã†ã«ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§OSã‚’ç†è§£ã—ã¦ã„ã‚‹äººé–“ã§ãªã‘ã‚Œã°ã€ç™¾æˆ¦éŒ¬ç£¨ã®Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã®ãƒªãƒ¼ãƒ€ãƒ¼ã¯å‹™ã¾ã‚‰ã‚“ã€‚
blogpants 2008/06/10
ã‚·ã‚¹ãƒ†ãƒ æŠ€è¡“

Postgres

DB
ãƒªãƒ³ã‚¯
HOMMEZå…¬å¼ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚·ãƒ§ãƒƒãƒ—
HOMMEZ(ã‚ªãƒ ã‚º)ã¯ç”·æ€§ã®å¿ƒã¨èº«ä½“ã®å¥åº·ã‚’æ”¯æ´ã—ã€ä¸€äººã§ã‚‚å¤šãã®äººãŒåä¾›ã‚’å¾—ã‚‹å¹¸ã›ã‚„ç”·æ€§ã¨ã—ã¦ã®å–œã³ã‚’äº«å—ã§ãã‚‹ç¤¾ä¼šã®å®Ÿç¾ã‚’ç›®æŒ‡ã—ã¦ã„ã¾ã™ã€‚ç”·æ€§ã®å¦Šæ´»ã€æ´»åŠ›ã«ã¾ã¤ã‚ã‚‹æƒ…å ±ã‚„å•†å“ã®åŠ›ã§æ€§ã‚„å¦Šæ´»ã«æ‚©ã‚€ç”·æ€§ãŒåŠ¹çŽ‡çš„ã«ç´å¾—æ„Ÿã‚’æŒã£ã¦æ´»å‹•ã§ãã‚‹æ©Ÿä¼šã‚’å‰µå‡ºã—ã¾ã™ã€‚
blogpants 2007/07/07
ã‚ã‚Œãªã‚“ã ã£ã‘ã€ãªæ™‚ã«ä¾¿åˆ©ã§ã™ã€‚

Postgres

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