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

monnalisasmile id:monnalisasmile

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

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

https://sqlzoo.net/wiki/SQL_Tutorial
monnalisasmile 2015/11/30
learning

join

db

sql

tutorial

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

webã‚µãƒ¼ãƒ“ã‚¹

ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«

MySQL

learn
ãƒªãƒ³ã‚¯
Hadoopåˆ©ç”¨è€…ãªã‚‰ãã£ã¨çŸ¥ã£ã¦ã‚‹ã€Hive/Prestoã‚¯ã‚¨ãƒªé–¢æ•°ã®æŒ™å‹•ã®é•ã„ - Qiita
HiveQLã§ã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã«é›£ã‚’æ„Ÿã˜ã¦ã„ãŸãŸã‚ã€ç§ã‚‚Prestoã‚’ä½¿ã„å§‹ã‚ã¾ã—ãŸã€‚ MySQLã‚„Hiveã§ä½¿ã£ã¦ã„ãŸã‚¯ã‚¨ãƒªã‚’ç½®ãæ›ãˆã‚‹æ™‚ã«ãƒãƒžã£ãŸTipsã‚’ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ AWS Athenaã§Prestoã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã‚‚å¢—ãˆã¦ã‚‹ã¨æ€ã†ã®ã§ã€Prestoæ¨™æº–é–¢æ•°ã§ã®è¨˜è¿°ä¾‹ã‚‚æ‹¡å……ã—ã¦ã„ãã¾ã™ã€‚ Prestoã¨ã¯ Prestoã¯ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§å‹•ãåˆ†æ•£SQLã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ãã®é€²åŒ–ã¯ç›®ã‚’è¦‹å¼µã‚‹ç‰©ã§ã™ã€‚ ç™ºè¡¨ã•ã‚ŒãŸå½“æ™‚ã¯è‰²ã€…ãªæˆç´„ãŒã‚ã‚Šä½¿ã†ã“ã¨ã‚’èºŠèº‡ã—ã¦ã„ã¾ã—ãŸãŒã€2015å¹´é ƒã‹ã‚‰ã¯ã‚‚ã†ä½¿ã‚ãªã„ç†ç”±ã¯ãªããªã‚Šã¾ã—ãŸã€‚ ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ã«ä½¿ãˆã‚‹ã¨ã¦ã‚‚é«˜é€ŸãªSQLã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã®ã§ã€ãƒãƒƒãƒå‘ã‘ã®Hiveã®ã‚ˆã†ã«å®Ÿè¡Œçµæžœã‚’å¾…ã¤æ™‚é–“ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¾ã›ã‚“ã€‚ Hiveã§ã™ã¨1ã¤1ã¤ã®å®Ÿè¡Œã«æ™‚é–“ãŒæŽ›ã‹ã‚‹ã®ã§ã€ã‚¯ã‚¨ãƒªã«æ…£ã‚Œã¦ã„ãªã„æ–°å‚è€…ã«ã¯è¾›ã„ç‰©ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—Prestoã§ã¯ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ã«å®Ÿè¡Œã§ãã¾ã™ã®ã§ã€ãƒˆãƒ©ã‚¤
monnalisasmile 2015/11/05
hadoop

Presto

MySQL

ã‚ã¨ã§èªã‚€

HIVE

SELECT

SQL
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆWITHå¥ï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ ORACLE9iã‹ã‚‰ã€WITHå¥ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¾ã—ãŸã€‚ WITHå¥ã§æŒ‡å®šã—ãŸï¼³ï¼±ï¼¬ã®çµæžœã¯ã€VIEWã®æ§˜ã«SQLå†…éƒ¨ã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã‚Œã«ã‚ˆã‚Šã€ã‚¤ãƒ³ãƒ©ãƒ³ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ã€ã‚„ã€å†…éƒ¨çµåˆã€å¤–éƒ¨çµåˆã‚’ä½¿ã£ãŸè¤‡é›‘ãªï¼³ï¼±ï¼¬ã‚’åˆ†ã‹ã‚Šã‚„ã™ãè¦‹ã›ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ æ§‹æ–‡ã¯ã€WITHã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®å¾Œã«ã€å‰¯å•åˆã›SQLçµæžœã®VIEWåã¨ã€ASã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã«ç¶šã„ã¦æ‹¬å¼§å†…ã«ï¼³ï¼±ï¼¬ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€å‰¯å•åˆã›çµæžœã®ã€Œview01ã€ã¨è¡¨ã€Œtable01ã€ã‚’å†…éƒ¨çµåˆã—ã¦ã„ã¾ã™ã€‚ with view01 as ( select column99 from table99 where column01 = '01' ) select view01.column99, table01.column77 from table01, view01 where table01.column99
monnalisasmile 2015/04/07
column

Oracle

SQL

WITHå¥
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
å¯’æ³¢ã«å‚™ãˆã‚ˆï¼2024å¹´å†¬æ”¯åº¦ æ€¥ã«å†¬ã«ãªã£ãŸã€‚æ¯Žå¹´ã®ã“ã¨ã ã‘ã©æ€¥ã™ãŽã‚‹ã€‚ ä»¤å’Œã«ãªã£ãŸãã‚‰ã„ã‹ã‚‰ã€9æœˆä»¥é™å£ç¯€ã®å¤‰ã‚ã‚Šæ–¹ãŒå¤ï¼å¤ï¼å¤ï¼å¤ï¼ã‚ã€ç§‹ï¼Ÿã„ã‚„ã¾ã å¤ï¼å¤ï¼ã¤ã„ã«ç§‹ï¼Ÿç§‹ã‹â€¥ï¼Ÿã„ã‚„ã¾ã å¤ã ï¼ç§‹ï¼ŸãŠã€ã¤ã„ã«ç§‹ã ï¼â€¦ã¯ã„ç§‹çµ‚ã‚ã‚Šã¾ã—ãŸå†¬ã§ï½žï½žï½žï½žã™ï¼ã¿ãŸã„ãªã€ãã†ã„ã†æ€¥ã•ãŒã‚ã‚‹ã€‚ ç§‹â€¦
monnalisasmile 2014/12/27
python

DB

SQL
ãƒªãƒ³ã‚¯
PostgreSQLã®ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§
PostgreSQLã®åŸºæœ¬çš„(ã‚ˆãä½¿ã†)ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ [toc heading_levels="2"] ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã‚’è¦‹ã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã‚’è¦‹ã‚‹æ–¹æ³•ã§ã™ã€‚ æ§‹æ–‡ \l ä½¿ç”¨ä¾‹ postgres=# \l List of databases Name | Owner | Encoding -----------+----------+---------- postgres | postgres | UTF8 sasuke | postgres | UTF8 sasuke2 | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8 test1 | postgres | UTF8 (6 rows) ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã®ç¢ºèªæ–¹æ³•ã§ã™ã€‚ æ§‹æ–‡ \d ä½¿ç”¨ä¾‹ postgres=# \d L
monnalisasmile 2014/12/25
databases

PostgreSQL

åŸºæœ¬ã‚³ãƒžãƒ³ãƒ‰

ãƒªãƒãƒ“ãƒª

postgres

SQL

ã‚³ãƒžãƒ³ãƒ‰
ãƒªãƒ³ã‚¯
Amazon Redshiftã§è‰¯ãä½¿ã„ãã†ãªä¾¿åˆ©ç³»SQLã‚’ã¾ã¨ã‚ã¦ã¿ãŸ | DevelopersIO
Redshiftã§è‰²ã€…ç’°å¢ƒæ§‹ç¯‰ã‚„èª¿æŸ»ã‚’é€²ã‚ã¦è¡Œãã¨ã€å‰²ã¨ã¡ã‚‡ã„ã¡ã‚‡ã„è‰¯ãä½¿ã†SQLç‰ã‚‚å‡ºã¦æ¥ã¾ã™ã€‚ãã“ã§ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€æ™®æ®µä½¿ã£ã¦ã„ã‚‹ä¾¿åˆ©ç³»SQLã€éƒ½åº¦ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã¯ã‚³ãƒ”ãƒšã—ã¦ä½¿ã£ã¦ã‚‹ã‚ˆã†ãªSQLã€æ›´ã«ã¯ãã‚Œã‚‰ã«ã¡ã‚‡ã£ã¨ä¸€æ‰‹é–“åŠ ãˆãŸSQLç‰ã‚’é›†ç´„ã—ä¸€è¦§ã¨ã—ã¦ã¿ã‚‹äº‹ã«ã—ã¾ã—ãŸã€‚ å¿…é ˆãªã‚‚ã®ã€ã¾ãŸã€Žã“ã‚Œã‚‚ä½¿ãˆã‚‹ãã€ã¨ã„ã†ã‚ˆã†ãªã‚‚ã®ã«ã¤ã„ã¦ã¯é©å®œè¿½åŠ æ›´æ–°ã‚’è¡Œã£ã¦ã„ã“ã†ã¨æ€ã£ã¦ã¾ã™ã®ã§ã€ã‚ªã‚¹ã‚¹ãƒ¡ã®SQLæ–‡ãŒã‚ã‚Œã°æ˜¯éžæ•™ãˆã¦é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ ç›®æ¬¡ S3ã‹ã‚‰ã®COPYå‡¦ç†ã‚¨ãƒ©ãƒ¼ã«é–¢ã™ã‚‹ãƒã‚°ã‚’ç¢ºèªã™ã‚‹ COPYå‡¦ç†æ™‚ã«å‡ºåŠ›ã•ã›ã‚‹ã‚¨ãƒ©ãƒ¼ä»¶æ•°é‡ã‚’åˆ¶å¾¡ã™ã‚‹ æŒ‡å®šãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’ç¢ºèªã™ã‚‹(type1:psqlã‚³ãƒžãƒ³ãƒ‰ã§ç°¡æ˜“è¡¨ç¤º) æŒ‡å®šãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’ç¢ºèªã™ã‚‹(type2:distkey,sortkeyç‰ã‚‚è¡¨ç¤º) æŒ‡å®šãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’ç¢ºèªã™ã‚‹(type3:ã‚³ãƒ¡ãƒ³ãƒˆæ–‡ã‚‚ä½µã›ã¦è¡¨ç¤º) ãƒ†ãƒ¼
monnalisasmile 2014/12/25
amazon redshift

copy

amazon

analyze

AWS

AmazonRedshift

redshift

SQL
ãƒªãƒ³ã‚¯
Bora Beran
monnalisasmile 2014/09/11
blog

article

data

tableau

as

R

mac

sql

custom
ãƒªãƒ³ã‚¯
AUTOINCREMENTã‚’è¨å®šã™ã‚‹å ´åˆã¨ã—ãªã„å ´åˆã®é•ã„
SQLite ã®ç’°å¢ƒã§ INTEGER PRIMARY KEY ã« AUTOINCREMENT ã‚’åˆã‚ã›ã¦è¨å®šã—ãŸå ´åˆã«ã©ã®ã‚ˆã†ã«è‡ªå‹•çš„ã«å€¤ãŒå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã¾ãŸä»Šã¾ã§ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚ŒãŸã“ã¨ã®ã‚ã‚‹æœ€å¤§ã®å€¤ã‚’ç¢ºèªã™ã‚‹æ–¹æ³•ã‚’åˆã‚ã›ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ AUTOINCREMENTã‚’è¨å®šã—ãŸå ´åˆã®å€¤ã®å‰²ã‚Šå½“ã¦ãƒ«ãƒ¼ãƒ« ã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦ INTEGER PRIMARY KEY ã‚’è¨å®šã—ãŸå ´åˆã€ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸæ™‚ã« INTEGER PRIMARY KEY ã‚’è¨å®šã—ãŸã‚«ãƒ©ãƒ ã®å€¤ã‚’æŒ‡å®šã—ãªã„ã¨è‡ªå‹•çš„ã«å€¤ãŒæ ¼ç´ã•ã‚Œã¾ã™ã€‚è‡ªå‹•çš„ã«æ ¼ç´ã•ã‚Œã‚‹å€¤ã¯ã€å¯¾è±¡ã®ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹æœ€å¤§ã®å€¤ã« 1 ã‚’åŠ ãˆãŸå€¤ã¨ãªã‚Šã¾ã™ã€‚ã“ã®å€¤ã¯ä»¥å‰ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚ŒãŸã“ã¨ãŒã‚ã‚‹ã‹ã©ã†ã‹é–¢ä¿‚ãŒãªã„ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ ã¨å‰Šé™¤ã‚’ç¹°ã‚Šè¿”ã—ã¦ã„ã‚‹ã¨ä»¥å‰ã«æ ¼ç´ã•ã‚ŒãŸã“ã¨ãŒã‚ã‚‹å€¤ãŒå†åº¦ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ã‚«ãƒ©ãƒ ã« I
monnalisasmile 2014/08/26
column

db

sqlite

sql

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

programming

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

devel
ãƒªãƒ³ã‚¯
Python: Accessing elements from nested dictionaries a la SQL
monnalisasmile 2014/08/06
dictionary

Python

data

dictionaries

sql

json

access
ãƒªãƒ³ã‚¯
Norikra: Stream processing with SQL for everybody
Schema-less Stream Processing with SQL Norikra is a open source server software provides "Stream Processing" with SQL, written in JRuby, runs on JVM, licensed under GPLv2. Schema-less event streams (called as 'target') Input/Output event streams as JSON objects, which can contain any fields with a target name. SQL processing Norikra's query is SQL with window specifier support (It's actually Esper
monnalisasmile 2014/07/14
event

json

*ã‚ã¨ã§

fluentd

norikra

stream

sql

norika
ãƒªãƒ³ã‚¯
SQLæ„Ÿè¦šã§HiveQLã‚’æ›¸ãã¨ç—›ã„ç›®ã«ã‚ã†ä¾‹ - still deeper
Hadoop Advent Calendar 2013 4æ—¥ç›®ã®è¨˜äº‹ã§ã™ tl;dr explainã¨job historyã‚’èªã‚ 1 reducerã¯æ‚ª data skewã¯æ‚ª å‰æ›¸ã ã¿ã‚“ãªå¤§å¥½ãSQLã§Hadoopä¸Šã§ã®å‡¦ç†ã‚’å®Ÿè¡Œã§ãã‚‹Hiveã«ã¯ã¿ãªã•ã‚“æ™®æ®µã‹ã‚‰ãŠä¸–è©±ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ã¡ã‚‡ã£ã¨èª¿ã¹ç‰©ã§ã‚°ã‚°ã‚‹åº¦ã«ç›®ã«å…¥ã‚‹æ„›ã‚‰ã„ã—ã„ãƒžã‚¹ã‚³ãƒƒãƒˆãŒã€è’ã‚“ã å¿ƒã«æ¸…æ¶¼ãªé¢¨ã‚’ã¯ã“ã‚“ã§ãã‚Œã¾ã™ã€‚ ã§ã™ãŒHiveã®ã‚¯ã‚¨ãƒªè¨€èªžã¯SQLã§ã¯ãªãHiveQLã§ã™ã—ã€å®Ÿè¡Œã‚¨ãƒ³ã‚¸ãƒ³ã‚‚RDBã®ãã‚Œã¨ã¯å…¨ãç•°ãªã‚‹MapReduceã§ã™ã€‚SQLã®ã¤ã‚‚ã‚Šã§HiveQLã‚’æ›¸ã„ã¦ã„ã‚‹ã¨åœ°é›·ã‚’è¸ã‚“ã§ã—ã¾ã†ã“ã¨ãŒã¾ã‚Œã«ã‚ˆãã‚ã‚Šã¾ã™ã€‚æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯é™¥ã‚ŠãŒã¡ãªHiveQLã®è½ã¨ã—ç©´ã‚’2ã¤ç´¹ä»‹ã—ã¾ã™ã€‚ ä¾‹1 SELECT count(DISTINCT user_id) FROM access_log SQLã«æ…£ã‚ŒãŸæ–¹ã§ã‚ã‚Œ
monnalisasmile 2014/06/12
ã»ã»ã†ã»ã†ã»ã†

hiveql

Hadoop

data

hive

history

mapreduce

map

sql

tuning

performance
ãƒªãƒ³ã‚¯
Apache Hive
Apache Hive The Apache Hive â„¢ is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale and facilitates reading, writing, and managing petabytes of data residing in distributed storage using SQL. Github Mail Docker Community Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale. Hive Metastore(HMS) provid
monnalisasmile 2013/09/04
project

hive

query

data

language

Hadoop

IT

analysis

SQL

*å‹‰å¼·
ãƒªãƒ³ã‚¯
Hadoopã‚’ã‚ˆã‚Šä¾¿åˆ©ã«ä½¿ã†ï¼Hiveã§ã®MapReduceã¾ã¨ã‚ - Y's note
ç›®æ¬¡ Hiveã¨ã¯ Hiveã®è¨å®š HiveQLæ§‹æ–‡(DDL) DataBase/SCHEMAã®ä½œæˆ Database/SCHEMAã®å‰Šé™¤ Tableã®ä½œæˆ Tableã®å‰Šé™¤ Tableåå¤‰æ›´ Partitionä½œæˆ Partitionã®å‰Šé™¤ Columnã®å¤‰æ›´ Columnã®è¿½åŠ /ç½®ãæ›ãˆ Tableã®Propertyå¤‰æ›´ SerDe Propertyã®è¿½åŠ HiveQLæ§‹æ–‡(SQL) ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§è¡¨ç¤º ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†…å®¹ã‚’è¡¨ç¤º åŸºæœ¬çš„ãªSELECTæ–‡ WHEREå¥(æ¡ä»¶æŒ‡å®š) DISTINCT(é‡è¤‡å‰Šé™¤) ORDER BY / SORT BYå¥(ã‚½ãƒ¼ãƒˆ) GROUP BYå¥(ã‚°ãƒ«ãƒ¼ãƒ—åŒ–) HAVINGå¥(ã‚°ãƒ«ãƒ¼ãƒ—åŒ–å¾Œã®æ¡ä»¶) LIMITå¥ JOIN(ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ) æŠ½å‡ºã‚«ãƒ©ãƒ ã‚’æ£è¦è¡¨ç¾ã§æŒ‡å®š UNION(çµæžœã®çµåˆ) SUBQUERY LOAD(ãƒ‡ãƒ¼ã‚¿ã®èªã¿è¾¼ã¿) Hiveã‚’ä½¿ã† äº‹å‰æº–å‚™
monnalisasmile 2013/07/29
hive

database

MapReduce

SQL

Hadoop

query

hiveql

cheat

HQL
ãƒªãƒ³ã‚¯
Hadoop â€“ Hiveã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— â€“ OpenGroove
monnalisasmile 2013/07/27
hive

hadoop

MapReduce

sql

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

ã‚µãƒ¼ãƒ“ã‚¹

DB

ãƒ‡ãƒ¼ã‚¿

RDBMS

site
ãƒªãƒ³ã‚¯
sqlite3
1. åˆã‚ã« (æ›¸ãã‹ã‘) SQLite ã¯ RDMS (é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ) ã®ä¸€ç¨®ã§ã™ã€‚ é€šå¸¸ã® RDMS ã¨ç•°ãªã‚Šé¢å€’ãªã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒä¸è¦ã§ã€ç°¡å˜ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é€šå¸¸ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸¦ã«ç°¡å˜ã«æ‰±ãˆã‚‹ã®ã§ã€ ä»Šã¾ã§ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã«ä¿å˜ã—ã¦ã„ãŸãƒ‡ãƒ¼ã‚¿ã¯ sqlite ã«ä¿å˜ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ 2. Python ã‹ã‚‰ SQLite ã‚’ä½¿ã† ã‚‚ã¡ã‚ã‚“ã€Python ã‹ã‚‰ã‚‚ SQLite ã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ Python 2.5 ã‹ã‚‰ sqlite3 ãŒ build-in package ã¨ã—ã¦é…å¸ƒã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ ã™ãã«ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ æ¬¡ã®ä¾‹ã®ã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã« connect ã™ã‚‹ã ã‘ã§ã€ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ å˜åœ¨ã—ãªã‘ã‚Œã°è‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã€ å˜åœ¨ã™ã‚Œã°ã€ãã‚ŒãŒé–‹ã‹ã‚Œã¾ã™ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® co
monnalisasmile 2013/07/12
SQLite

DB

shopping

python

programming

sqlite3

sql

mysql

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

Python-article
ãƒªãƒ³ã‚¯
SQLite3ã‚’ä½¿ç”¨ã™ã‚‹ - Python Tips
è»½é‡ãƒ»é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹SQLiteã‚’Pythonã‹ã‚‰æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Python2.5ã‹ã‚‰æ¨™æº–ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«å…¥ã‚Šã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä½œæ¥ã¯ä¸è¦ã§ã™ã€‚ ä½¿ç”¨æ–¹æ³• sqlite3ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ #!python2.6 # -*- coding: utf-8 -*- import sqlite3 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ con = sqlite3.connect("data.db") ãƒ•ã‚¡ã‚¤ãƒ«ãŒã™ã§ã«å˜åœ¨ã™ã‚‹ã¨ãã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã„ã¨ãã¯æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã€‚ isolation_levelã«Noneã‚’æŒ‡å®šã™ã‚‹ã¨ã€è‡ªå‹•ã‚³ãƒŸãƒƒãƒˆãƒ¢ãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ con = sqlite3.connect('temp.db', isolation_level=None) ç‰¹åˆ¥ãªåå‰ã§ã‚ã‚‹ ":memory:" ã‚’ä½¿ã†ã¨RAMä¸Šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ c
monnalisasmile 2013/07/12
SQLite

Programming

SQL

python

database

db

sqlite3

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

page

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLiteå…¥é–€
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã® SQLite ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLite ã¯ã‚µãƒ¼ãƒã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã®ã§ã¯ãªãå˜ç‹¬ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ç°¡å˜ãªä¸Šã«éžå¸¸ã«ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªãŸã‚ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ä¸€ç·’ã«é…å¸ƒã™ã‚‹ã¨ã„ã£ãŸåˆ©ç”¨ã‚‚æ•°å¤šãã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šå–å¾—ã—ãŸã‚Šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ä¸€ã¤ä¸€ã¤è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
monnalisasmile 2013/07/12
SQLite

site

iPhone

db

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

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

å…¥é–€

tutorial
ãƒªãƒ³ã‚¯
Datatypes In SQLite
1. Datatypes In SQLite Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the particular column in which the value is stored. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with i
monnalisasmile 2013/07/11
database

as

text

storage

column

data

db

SQL

SQLite

reference
ãƒªãƒ³ã‚¯
Mouseover dictionaryã®SQLiteãƒ•ã‚¡ã‚¤ãƒ«ã‚’pythonã§ä½œæˆã—ãŸã€‚
Mouseover dictionaryã®è¾žæ›¸ç™»éŒ²ã‚’Pythonã‚’ç”¨ã„ã¦ç›´æŽ¥è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚æµã‚Œã¨ã—ã¦ã¯CSVãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆPDICï¼‰ã‚’èªã¿è¾¼ã‚“ã§SQLiteã®DBã‚’ä½œæˆã—ã€Firefoxã®ãƒ•ã‚©ãƒ«ãƒ€ã«æ”¾ã‚Šè¾¼ã‚“ã ã ã‘ã§ã™ã€‚rubyã§ã‚„ã£ã¦ãŠã‚‰ã‚Œã‚‹æ–¹ãŒã„ãŸã®ã§çœŸä¼¼ã—ã¦pythonã®å‹‰å¼·ãŒã¦ã‚‰ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ PDICã§CSVå½¢å¼ã®è¾žæ›¸ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆ ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã«å¤‰æ› ä¸‹è¨˜ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§SQLiteã®DBã‚’ä½œæˆ /.mozilla/firefox/default.*/ã«å‡ºæ¥ãŸmoseoverdictionary.sqliteã‚’å…¥ã‚Œã‚‹ã€‚ ã“ã‚“ãªæµã‚Œã§é©ç”¨ã—ã¾ã—ãŸã€‚PDICã‚’ä½¿ã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ã®ã§é‚ªé”ãã•ã„ã ã‘ã®ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ãŒã€è¶£å‘³ãªã®ã§ä»•æ–¹ã‚ã‚Šã¾ã›ã‚“ã€‚ #!/usr/bin/env python #-*- coding:utf-8 -*- import sqlite3 import c
monnalisasmile 2013/07/10
python

dictionary

DB

Reader

text

ãƒ‡ãƒ¼ã‚¿

sql

R

*

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMemSQL 2.0ã€å…¬é–‹ã€‚æ•°ç™¾ãƒŽãƒ¼ãƒ‰ã¸ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆå¯èƒ½ã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¯¾å¿œã¸ ï¼ Publickey
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã¾ã‚‹ã”ã¨ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªä¸Šã§å‡¦ç†ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€å¾“æ¥ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ˆã‚Šã‚‚åŠ‡çš„ãªé«˜é€ŸåŒ–ã‚’å®Ÿç¾ã™ã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹Mem SQLã®æœ€æ–°ç‰ˆã€ŒMem SQL 2.0ã€ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚ Mem SQL 2.0ã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã¨SQLã§ã®å•ã„åˆã‚ã›ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆæ©Ÿèƒ½ã€ãã—ã¦ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå¯¾å¿œã®å¯ç”¨æ€§ãªã©ã€4ã¤ã®ç‰¹å¾´ã‚’æŒã¤ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ In-memory architecture Ad hoc SQL-based analytics Horizontal scale-out on commodity hardware Enterprise-grade durability and high availability ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã§ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã«å¯¾å¿œ Mem SQL 2.0ã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç‰¹å¾´ã§ã‚ã‚‹é«˜é€Ÿãªå‡¦ç†ã«åŠ ãˆã¦ã€
monnalisasmile 2013/05/02
sql

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