[B! sql] secondlifeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

secondlife id:secondlife

sqlã«é–¢ã™ã‚‹secondlifeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

GitHub - twada/twowaysql: Template Engine for SQL
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
secondlife 2012/04/20
â€˜TwoWaySQLâ€™ is a concept, looks like a Template Engine for SQL.

ruby

sql
ãƒªãƒ³ã‚¯
DOMQL
Lately its getting more and more obvious that web development is indeed a basic human right. And it should be accessible to every developer in the industry. jQuery played its part by making web development easier for designers, CoffeeScript for Rubyists and Pythonistas, Dart for Java devs, ClojureScript for Lispers etc. But what about DBAs? aren't they equally human? Should they be doomed to suffe
secondlife 2012/04/02
DOMQLãƒ¤ãƒã‚¤

sql

javascript

culture
ãƒªãƒ³ã‚¯
ã‚·ãƒ§ç³– on Twitter: "ï¼äººâ—• â€¿â€¿ â—• äººï¼¼ < ã‚ã‚Œã¯ã¾ãšã‹ã£ãŸã‚ˆãƒ¼ EXPLAIN ãªã—ã« SELECT ã—ã¡ã‚ƒã†ãªã‚“ã¦"
secondlife 2011/02/15
ã‚¨ãƒ«ãƒ—ã‚µã‚¤ã‚³ãƒ³ã‚°ãƒ«ã‚¥

culture

sql
ãƒªãƒ³ã‚¯
AbstractSQL.jsä½œã‚Šã¾ã—ãŸã€‚ | JavaScript | blog | atsushi nagase * developments
atsushi nagase*developments / blog / éŽåŽ»ã®è¨˜äº‹ / JavaScript / AbstractSQL.jsä½œã‚Šã¾ã—ãŸã€‚ atsushi nagase - ngsdev.org æ±äº¬ã§ã‚¦ã‚§ãƒ–é–‹ç™ºã‚’ã—ã¦ã„ã‚‹ã€é•·ç€¬æ•¦å²ã®ãƒ–ãƒã‚°ã€‚ Â»HOME Â»LABS Â»BLOG å…¨ã¦ã®è¨˜äº‹ã‚’è¦‹ã‚‹ ã“ã®ã‚µã‚¤ãƒˆã‚’è³¼èªã™ã‚‹ CPANã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã€SQL::Abstractã¯ã€Perlã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‹ã‚‰SQLæ–‡ã‚’ç”Ÿæˆã™ã‚‹ã¨ã„ã† ç´ æ™´ã‚‰ã—ã„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãªã®ã§ã™ãŒã€åŒã˜ã‚ˆã†ãªã‚‚ã®ãŒJavaScriptã§å¿…è¦ã«ãªã£ã¦ã€ æŽ¢ã—ã¦ã‚‚ãªã‹ã£ãŸã®ã§ã€è‡ªåˆ†ã§ä½œã‚Šã¾ã—ãŸã€‚ ä¾‹ var sql = new AbstractSQL("test"); sql.createTable([ new AbstractSQL.Field("id",AbstractSQL.FieldType.INTEGER,1
secondlife 2009/09/07
SQL::Abstract ãƒ©ã‚¤ã‚¯ãª JS ãƒ©ã‚¤ãƒ–ãƒ©ãƒª

library

javascript

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
secondlife 2009/07/17
sql

database

performance
ãƒªãƒ³ã‚¯
sql_iabbr.vim - Makes all your favorite SQL keywords uppercase automatically. : vim online
With this ftplugin you can type "create table foo (foo_id int);" and get "CREATE TABLE foo (foo_id INT);".Â Â It is based on both sql.vim and the output from postgresql's \dT command while in psql.Â Â That makes it a tad bit tailored to postgresql, but it will work with any SQL compliant dbms.Â Â Please note that I am not an SQL wizard.Â Â I just know how to copy and paste and use ":%s///".Â Â :)Â Â Enjoy!Â Â C
secondlife 2009/05/27
vim

sql

plugin
ãƒªãƒ³ã‚¯
SQLã®æ¡ä»¶ã‚’çµ„ã¿ç«‹ã¦ã‚‹Railsãƒ—ãƒ©ã‚°ã‚¤ãƒ³ Condition Builder 1.1 - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
Railsã§SQLã®æ¡ä»¶ã‚’æ‰±ã†ã€Condition Builderãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒä¾¿åˆ©ã§ã™ã€‚ æœ€æ–°ç‰ˆ(1.1) http://blog.inquirylabs.com/2007/06/28/condition-builder-11/ èª¬æ˜Ž http://blog.inquirylabs.com/2007/01/04/condition-builder-10-released/ ä»¥å‰ã®è¨˜äº‹ http://blog.inquirylabs.com/index.php?s=condition+builder&submit=Search Conditionã‚¯ãƒ©ã‚¹ã®ãƒ¡ã‚½ãƒƒãƒ‰ä¸€è¦§ é€šå¸¸ã€ActiveRecordã«æ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹å ´åˆã€:conditionsã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ ["a = ? AND b = ?", 1 , 2] ã®ã‚ˆã†ãªé…åˆ—ã‚’æŒ‡å®šã—ã¾ã™ã€‚ã“ã®é…åˆ—ã®æ§‹ç¯‰ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ãã‚Œã‚‹ã®ãŒConditionBu
secondlife 2009/03/17
ãƒ–ãƒãƒƒã‚¯ã§ sql ã‚’ç”Ÿæˆ

ruby

sql

orm

idea
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
secondlife 2007/05/15
ã¹ã‚“ã‚Šï¼

activerecord

sql
ãƒªãƒ³ã‚¯
record_dumper plugin - ãƒ½( ãƒ»âˆ€ãƒ»)ãƒŽãã¾ãã¾ãƒ¼(2007-03-12)
â— [Rails] record_dumper plugin èª¤ã£ã¦ä¼šå“¡ã•ã‚“ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ãªã‚“ã¨ã‹å¾©æ—§ã§ãã¾ã›ã‚“ã‹ï¼Ÿé¡§å®¢ã‹ã‚‰ãã†é€£çµ¡ã‚’å—ã‘ãŸç†Šäº•ã¡ã‚ƒã‚“ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã‚ã‚Šã¾ã™ã‹ã‚‰å¤§ä¸ˆå¤«ã§ã™ã‚ˆã€ã¨è¿”ç”ã€‚ã§ã‚‚ã€åˆ¥é¯–(DB)ç’°å¢ƒã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å¾©å…ƒã—ãŸã¨ã—ã¦ã€ã“ã“ã‹ã‚‰ã©ã†ã‚„ã£ã¦æœ¬ç•ªç’°å¢ƒã¸ã‚³ãƒ”ãƒ¼ã™ã‚‹ã®ãŒæ¥½ãªã‚“ã ã‚ã†ï¼Ÿã¨è€ƒãˆã‚‹éƒ¨ä¸‹ã®nkskã¡ã‚ƒã‚“(ã¿ã‹ã‚“å¥½ã)ã«ã“ã®å†¬ãŠå‹§ã‚ã—ãŸã„å•†å“ã¯ã“ã¡ã‚‰ã€‚ â— ä½¿ã„æ–¹ plugin ã‚’å…¥ã‚Œã‚‹ã¨ ActiveRecord::Base#record_dumper ãƒ¡ã‚½ãƒƒãƒ‰ãŒè¿½åŠ ã•ã‚Œã‚‹ã‚ˆã€‚ã‚ã¨ã¯ã€æ¶ˆã—ã¡ã‚ƒã£ãŸãƒ‡ãƒ¼ã‚¿(record)ã«å¯¾ã—ã¦æŠ•ã’ã‚‹ã ã‘ã€‚ >> member = Member.find(1) #<Member:0xb767d2b8 @attributes={"name"=>"èˆžæ³¢", "tel"=>"090-xxx", "id"=>"1
secondlife 2007/03/14
backup

plugin

rails

sql
ãƒªãƒ³ã‚¯
Collection & Copy - Firefox 2.0ã€Storage(SQLite)ã€ãƒã‚¤ãƒ³ãƒˆ
JavaScriptMDC - Storage ã“ã‚Œã‚’èªã‚“ã§ã€åƒ•ãŒæ€ã£ãŸãƒã‚¤ãƒ³ãƒˆã€‚ Firefox 2.0ã«ã¯ã€SQLiteãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ã€‚åŒã˜ãFirefox 2.0ã§å°Žå…¥ã•ã‚ŒãŸã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸(sessionStorage/globalStorage)ã¨ã¯ç•°ãªã‚‹ã‚‚ã®ã€‚ (ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®ä¸ã§ã¯ã€ã“ã®SQLiteãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚)åŸºæœ¬çš„ã«chrome URLã‚„æ‹¡å¼µã‹ã‚‰ã®åˆ©ç”¨ã‚’æƒ³å®šã—ã€ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã‹ã‚‰ã¯åˆ©ç”¨ã§ããªã„ã€‚ã‚·ã‚¹ãƒ†ãƒ ã‚„æ‹¡å¼µã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«*1ã«ã€æ‹¡å¼µåsqliteã§ä¿å˜ã•ã‚Œã¦ã„ã‚‹ã€‚mozIStorageConnection#executeSimpleSQLã¯ã€å€¤ã‚’è¿”ã•ãªã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆã‚„å‰Šé™¤ã€ãƒ‡ãƒ¼ã‚¿è¿½åŠ ãªã©ã«åˆ©ç”¨ã™ã‚‹ã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„ã«ã‚‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çš„ã«ã‚‚mozIStorageConnection#createStatementã‚’
secondlife 2007/01/28
firefox

sql

sqlite
ãƒªãƒ³ã‚¯
http://www.wpdev.org/wiki/index.php/Convert_sqlite2_to_sqlite3_format
secondlife 2006/03/27
sqlite 2.x -> sqlite 3.x ã¸ã®ã‚³ãƒ³ãƒãƒ¼ãƒˆæ–¹æ³•

convert

sql

sqlite

tips
ãƒªãƒ³ã‚¯
1