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

Ooo id:Ooo

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

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

sqlfmtã«ã‚ˆã£ã¦ä½•ã‚’è§£æ±ºã—ãŸã„ã®ã‹
ã“ã‚Œã¯ä½• ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã®é–‹ç™ºã«sqlfmtã‚’å°Žå…¥ã™ã‚‹ã“ã¨ã«ã¤ã„ã¦è€ƒãˆã¦ã¿ãŸã‚‚ã®ã§ã™ã€‚ (ãƒãƒ¼ãƒ ã«sqlfmtã‚’å°Žå…¥ã™ã‚‹ãŸã‚ã«æ›¸ã„ã¦ã‚‹ã‚‚ã®ã«ãªã‚Šã¾ã™) sqlfmtã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãªèª²é¡Œã‚’è§£æ±ºã—ãŸã„ã®ã‹ å¤§ããã¯ã“ã‚Œã«é›†ç´„ã•ã‚Œã‚‹ã‹ãªã¨æ€ã„ã¾ã™ã€‚ ã§ã¯ã‚¹ã‚¿ã‚¤ãƒ«å‘¨ã‚Šã«ã‚ã‚‹é–‹ç™ºè€…ç”Ÿç”£æ€§ã‚’é˜»å®³ã™ã‚‹è¦å› ã¨ã¯ã©ã®ã‚ˆã†ãªã‚‚ã®ã‹ã¨ã„ã†ã¨: èªã¿ã¥ã‚‰ã„SQLã«ã‚ˆã‚‹ãƒã‚°ã®ç™ºè¦‹ã®é…ã‚Œ ãƒã‚¸ãƒƒã‚¯å‘¨ã‚Šã«ã¯é–¢ä¿‚ã®ãªã„ç®‡æ‰€ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’ã™ã‚‹å¿…è¦æ€§ SQLã‚¹ã‚¿ã‚¤ãƒ«ã®ã‚¹ã‚¿ãƒ³ã‚¹ã®é•ã„ã«ã‚ˆã‚‹è¡çª ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚’sqlfmtãªã‚‰ã©ã†è§£æ±ºã§ãã‚‹ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ sqlfmtãªã‚‰ã©ã†è§£æ±ºã§ãã‚‹ã‹ èªã¿ã¥ã‚‰ã„SQLã«ã‚ˆã‚‹ãƒã‚°ã®ç™ºè¦‹ã®é…ã‚Œ ã“ã‚Œã¯ãã‚‚ãã‚‚formatterã‚’å°Žå…¥ã—ã¦ã„ãªã„ã“ã¨ã«ã‚ˆã‚Šç”Ÿã˜ã‚‹ã‚‚ã®ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ ã‚„ãŸã‚‰ã¨é•·ã„ä¸€è¡Œã€ã‚¹ãƒšãƒ¼ã‚¹ã®ç„¡ã„æ¿ƒå¯†ãªä¸€è¡Œã€æƒã‚ãªã„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã€ç„¡æ„å‘³ãªæ”¹è¡Œ...ãªã©ã«ã‚ˆã‚Šã€ä¸ç”¨æ„ã«
Ooo 2023/05/15
sql

programming

database
ãƒªãƒ³ã‚¯
sql.js
sql.js is an SQL library for javascript containing a version of SQLite compiled for the web.
Ooo 2020/11/08
sql

javascript
ãƒªãƒ³ã‚¯
ã™ã¹ã¦ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLã®è‡ªå‹•è£œå®Œã‚’ã™ã‚‹ãŸã‚ã«SQL Language Server(sqls)ã‚’ä½œã£ãŸ - Qiita
sqlsã¨ã¯ sqlsã¨ã¯ã€ã„ã¾ç§ãŒé–‹ç™ºä¸ã®SQLç”¨Language Serverã§ã™ã€‚SQLã‚’ã‚¨ãƒ‡ã‚£ã‚¿ã§ç·¨é›†ã™ã‚‹ã¨ãã®æ”¯æ´æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸã‚µãƒ¼ãƒã¨ãªã£ã¦ãŠã‚Šã€ä¸»ãªç‰¹å¾´ã¯ä»¥ä¸‹ã§ã™ã€‚ Language Serverãªã®ã§LSã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒå˜åœ¨ã™ã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ã§ã‚ã‚Œã°ã©ã‚“ãªã‚¨ãƒ‡ã‚£ã‚¿ã§ã‚‚åˆ©ç”¨å¯èƒ½ SQLç·¨é›†æ”¯æ´æ©Ÿèƒ½ è‡ªå‹•è£œå®Œ(ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã‚«ãƒ©ãƒ åãªã©) å®šç¾©å‚ç…§ SQLå®Ÿè¡Œ è¤‡æ•°ã®RDSMSã«å¯¾å¿œ MySQL PostgreSQL SQLite3 Language Serverã¨ã¯ Language Server(ã‚ã‚‹ã„ã¯Language Server Protocol)ã¨ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ è¨€èªžã®é–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’ã‚¨ãƒ‡ã‚£ã‚¿ã«æä¾›ã™ã‚‹ã‚µãƒ¼ãƒã€ãŠã‚ˆã³ãã®é€šä¿¡å†…å®¹ã‚’è¦å®šã—ãŸãƒ—ãƒãƒˆã‚³ãƒ«ã§ã™ã€‚ãŸã ã—ã‚µãƒ¼ãƒã¨ã„ã£ã¦ã‚‚ã»ã¨ã‚“ã©ã®å ´åˆãƒãƒ¼ã‚«ãƒ«å†…ã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã—ã¦ãƒãƒ¼ã‚«ãƒ«ã®ã‚¨ãƒ‡ã‚£ã‚¿ã¨é€šä¿¡ã‚’ã—ã¾ã™ã€‚ ã“ã“ã§ã¯ä¸»é¡Œã§ã¯ãªã„ã®ã§è©³ã—
Ooo 2020/05/16
sql

language

go

vim
ãƒªãƒ³ã‚¯
2020å¹´ç¾åœ¨ã®NewSQLã«ã¤ã„ã¦ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? Disclaimer å½“è¨˜äº‹ã¯NewSQLé–‹ç™ºãƒ™ãƒ³ãƒ€ã®æŠ€è¡“ãƒ–ãƒã‚°ã‚„å„ç¨®è«–æ–‡ã€ãã®ä»–ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚µã‚¤ãƒˆç‰ã®å†…å®¹ã‚’å€‹äººçš„ã«ã¾ã¨ã‚ãŸã‚‚ã®ã§ã™ã€‚ ãã®ãŸã‚ã€ç†è§£ä¸è¶³ç‰ã«èµ·å› ã™ã‚‹èª¤è§£ãƒ»èª¤èªã‚’å«ã‚€å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚æ›´ãªã‚‹ç†è§£ãŒå¿…è¦ãªæ–¹ã¯ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«æŒ™ã’ãŸå„ç¨®æ–‡çŒ®ã‚’ç›´æŽ¥å‚ç…§ä¸‹ã•ã„ã€‚æŠ€è¡“çš„ãªæŒ‡æ‘˜ã¯å¯èƒ½ã§ã‚ã‚Œã°å–ã‚Šè¾¼ã¿ä¿®æ£ã—ã¾ã™ãŒã€è¿…é€Ÿãªå¯¾å¿œã¯ãŠç´„æŸã§ãã¾ã›ã‚“ã€‚ NewSQLã®è§£èª¬ã¯äºŒéƒ¨æ§‹æˆ å½“è¨˜äº‹ã¯å‰ç·¨ã§NewSQLã®æ¦‚è¦ç·¨ã¨ãªã‚‹ã€‚ å…¨ä½“ã®ç›®æ¬¡ã¯ä¸‹è¨˜ã§ã‚ã‚‹ã€‚ NewSQLã¨ã¯ä½•ã‹ NewSQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ NewSQLã¨ã“ã‚Œã¾ã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¯”è¼ƒ
Ooo 2020/02/28
nosql

sql

newsql

database
ãƒªãƒ³ã‚¯
Announcing PartiQL: One query language for all your data | Amazon Web Services
AWS Open Source Blog Announcing PartiQL: One query language for all your data Data is being gathered and created at rates unprecedented in history. Much of this data is intended to drive business outcomes but, according to the Harvard Business Review, â€œâ€¦on average, less than half of an organizationâ€™s structured data is actively used in making decisionsâ€¦â€ The root of the probl em is that data is typ
Ooo 2019/08/02
language

sql

amazon

data

partial
ãƒªãƒ³ã‚¯
Java ORãƒžãƒƒãƒ‘ãƒ¼é¸å®šã®ãƒã‚¤ãƒ³ãƒˆ #jsug
2019/01 JSUGå‹‰å¼·ä¼šã®è³‡æ–™ã§ã™ã€‚ ã“ã®è³‡æ–™ã§Disã£ã¦ã„ã‚‹ã®ã¯JPAã§ã¯ãªãã€ ãƒ»ä½•ã‚‚è€ƒãˆãšã«ã€Œæ¨™æº–ã ã‹ã‚‰ã€ã¨ã„ã†ã ã‘ã§JPAã‚’é¸ã¶äºº ãƒ»OSSã«å…¨ãã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆã›ãšã«ãƒ•ãƒªãƒ¼ãƒ©ã‚¤ãƒ‰ã™ã‚‹äºº ã§ã™ã€‚Read less
Ooo 2019/02/01
jdbc

sql

java

spring
ãƒªãƒ³ã‚¯
Elasticsearch SQL
Search and analytics, data ingestion, and visualization â€“ all at your fingertips.
Ooo 2018/04/03
elasticsearch

SQL

Java

jdbc
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2017/08/30/20170829salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language/
Ooo 2017/08/30
SQL

AI

Salesforce
ãƒªãƒ³ã‚¯
GitHub - jarulraj/sqlcheck: Automatically identify anti-patterns in SQL queries
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
Ooo 2017/08/20
database

sql
ãƒªãƒ³ã‚¯
JDBCãƒ¬ã‚¤ãƒ¤ã§DBã®ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã†sharding-jdbcã‚’è©¦ã—ã¦ã¿ãŸ - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°
DBã®ãƒ‡ãƒ¼ã‚¿é‡ãŒå¢—ãˆã¦ããŸå ´åˆã®å¯¾ç–ã®1ã¤ã¨ã—ã¦ãƒ¦ãƒ¼ã‚¶IDãªã©ã‚’ã‚ãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†å‰²ã™ã‚‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨å‘¼ã°ã‚Œã‚‹æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã‚’JDBCã®ãƒ¬ã‚¤ãƒ¤ã§å®Ÿç¾ã—ã¦ã—ã¾ã†sharding-jdbcã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’è¦‹ã¤ã‘ã¾ã—ãŸã€‚ github.com sharding-jdbcã¯ä¸å›½ã®dangdangï¼ˆå½“å½“ï¼‰ã¨ã„ã†ECå¤§æ‰‹ä¼æ¥ãŒé–‹ç™ºã—ãŸOSSã§ã€SQLã‚’ãƒ‘ãƒ¼ã‚¹ã—ã€SQLã«å«ã¾ã‚Œã‚‹ã‚·ãƒ£ãƒ¼ãƒ‰ã‚ãƒ¼ã‚’æŠ½å‡ºã—ã¦æŽ¥ç¶šå…ˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ã€å‚ç…§ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ‡ã‚Šæ›¿ãˆã¦ãã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ ä½¿ã£ã¦ã¿ã‚‹ ã¾ãšã¯pom.xmlã«ä»¥ä¸‹ã®ä¾å˜é–¢ä¿‚ã‚’è¿½åŠ ã—ã¾ã™ã€‚ <dependency> <groupId>com.dangdang</groupId> <artifactId>sharding-jdbc-core</artifactId> <version>1.4.1</version> </dependency>
Ooo 2017/02/22
Java

database

sql

jdbc
ãƒªãƒ³ã‚¯
MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨
â€” ããƒ¼ã ã„ï¼ åˆä»£ALF (@soudai1025) 2015, 8æœˆ 24 ã¨ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³æŠ•ã’ã¦è¦‹äº‹ã«åˆºã•ã£ã¦ã‚‹ã®ã§ä»Šã‹ã‚‰è¨˜äº‹æ›¸ãã€‚ ä¸¡ã‚µã‚¤ãƒ‰ã«ã¯ã‹ãªã‚ŠåŽ³ã—ã„è©±ã‚‚ã™ã‚‹ãŒä¿ºã®æœ¬éŸ³ã‚’è´ã„ã¦ãŠã‘ï¼ˆé–¢ç™½å®£è¨€ï¼‰ ã¾ãæ´å²ã®é•·ã„RDBãªã®ã§ãŠäº’ã„ã®æ¯”è¼ƒè¨˜äº‹ã¯æ²¢å±±ã‚ã‚‹ã€‚ ãªã®ã§ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰(MySQL)ã¨ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹(PostgreSQL)ã ã¨ã‹VACUUMã ã£ã¦è©±ã¯ã—ãªã„ã€‚ ã‚€ã—ã‚å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸéš›ã®é•ã„ã‚’ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã™ã‚‹ã€‚ 1. SQLã®é•ã„ åŸºæœ¬çš„ã«MySQLã§ã‚„ã£ã¦ã„ãŸã“ã¨ã¯PostgreSQLå‡ºæ¥ã‚‹ã€‚ ã—ã‹ã—é–¢æ•°ã®æŒ™å‹•ã®é•ã„ã¯å¹¾ã¤ã‹ã‚ã‚‹ã€‚ ä¾‹ãˆã°æ™‚é–“ã‹ã‚‰æ›œæ—¥ã«è©²å½“ã™ã‚‹æ•°å—ã«å¤‰æ›ã—ãŸå ´åˆã« MySQLã€€â†’ã€€date_format(time,"%w")ã€€0ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ PostgreSQLã€€â†’ã€€to_char(time,'D')ã€€1ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ ãªã©æŒ™å‹•ã«äº’æ›æ€§
Ooo 2015/08/24
Database

PostgreSQL

MySQL

SQL
ãƒªãƒ³ã‚¯
SQL style guide by Simon Holywell
Overview General Do Avoid Naming conventions General Tables Columns Aliasing or correlations Stored procedures Uniform suffixes Query syntax Reserved words White space Indentation Preferred formalisms Create syntax Choosing data types Specifying default values Constraints and keys Designs to avoid Appendix Reserved keyword reference Column data types SQL style guide Overview You can use this set o
Ooo 2015/07/25
SQL

naming

guide
ãƒªãƒ³ã‚¯
Time-based SQL Injectionã¯æ„å¤–ã«å®Ÿç”¨çš„ã ã£ãŸ
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€Time-based SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã™ãªã‚ã¡æ™‚é–“å·®ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒæ„å¤–ã«å®Ÿç”¨çš„ã ã£ãŸã¨ã„ã†å ±å‘Šã‚’ã—ã¾ã™ã€‚ãƒ‡ãƒ¢æ˜ åƒã‚ã‚Šã§ã™ã€‚ ã¯ã˜ã‚ã« Time-based SQL Injectionã¨ã„ã†æ”»æ’ƒãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€ç¨®ã§ã€ã‚ã‚‹æ¡ä»¶ã®å ´åˆã«ä¸€å®šæ™‚é–“ï¼ˆä¾‹ãˆã°5ç§’ï¼‰ã‚¹ãƒªãƒ¼ãƒ—ã—ã€ãã†ã§ãªã„æ™‚ã¨ã®å¿œç”æ™‚é–“ã®å·®ã§æƒ…å ±ã‚’ç›—ã‚‚ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚1å›žã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã§1ãƒ“ãƒƒãƒˆã®æƒ…å ±ãŒå¾—ã‚‰ã‚Œã‚‹ã®ã§ã€ãã‚Œã‚’ç©ã¿é‡ãã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ã„ãã‚‰ã§ã‚‚æƒ…å ±ã‚’ç›—ã‚ã‚‹ã¯ãšã§ã™â€¦ç†è«–çš„ã«ã¯ã€‚ ã—ã‹ã—ã€ã€Œç†å±ˆã¯ãã†ã§ã‚‚ã€æ™‚é–“ãŒæŽ›ã‹ã‚Šã™ãŽã‚‹ã‚ˆãã€ã¨ã„ã†ã“ã¨ã§ã€æ·±ãã¯è¿½ã£ã‹ã‘ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ¤œæŸ»ã«ã¯æœ‰åŠ¹ã§ã‚‚ã€æ‚ªç”¨ã¨ã—ã¦ã®å®Ÿç”¨æ€§ã¯ã‚ã¾ã‚Šãªã„ã¨è€ƒãˆã¦ã„ãŸã®ã§ã™ã€‚ ãã£ã‹ã‘ ãã£ã‹ã‘ã¯ã€ä»¥ä¸‹ã®Yahoo!çŸ¥æµè¢‹ã«ä»¥ä¸‹ã®è³ªå•ã§ã™ã€‚ SQL
Ooo 2015/04/16
security

sql
ãƒªãƒ³ã‚¯
Node.js ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã«å¯¾ã™ã‚‹è‡ªå‹•ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã®æ‹¡å¼µæ©Ÿèƒ½
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
Ooo 2014/07/12
SQL

security

appscan
ãƒªãƒ³ã‚¯
YappoLogs: ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹
ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹ ã“ã“æœ€è¿‘ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ãƒ³ã‚°è€ƒã§ã™ã€‚ mysql 5.5.34 ã§è©¦ã—ã¦è¨˜äº‹æ›¸ã„ã¦ã¾ã™ã€‚ bigdata ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ãªã‚«ãƒ©ãƒ ãŒã‚ã‚‹å‰æã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ InnoDB ã§ã™ã€‚ 2014å¹´ãªã‚“ã ã‹ã‚‰COUNT(*)ã¨ã‹SQL_CALC_FOUND_ROWSã¨ã‹LIMIT OFFSETã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã¯ã‚„ã‚ã‚ˆã†ãœ - Togetterã¾ã¨ã‚ãŒç™ºç«¯ã«ã¿ãˆã‚‹ã‘ã©ã€ã‚ã‚Šã¨æ˜”ã‹ã‚‰è©±ã•ã‚Œã¦ã‚‹äº‹ãªã‚“ã ã‘ã©ã€ã€Œnippondanji SQL_CALC_FOUND_ROWSã€ã§ã‚°ã‚°ã£ã¦ã‚‚æœ‰ç”¨ãªæƒ…å ±ãªã„ã—æ–‡æ›¸åŒ–ã•ã‚Œã¦ãªã„ã‹ã‚‰ã—ã¨ãã€‚ ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã§ä½¿ã‚ã‚ŒãŒã¡ãªæ©Ÿèƒ½ã§ã™ã€‚ S
Ooo 2014/03/14
database

mysql

sql

performance
ãƒªãƒ³ã‚¯
DBã‚¹ã‚ãƒ¼ãƒžã‚‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã—ãŸã„ï¼
PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013 LightningTalk ï¼ˆ2013-11-13: migr8.rbã®è¨å®šç®‡æ‰€ã‚’è‹¥å¹²ä¿®æ£ï¼‰ ï¼ˆ2013-11-14: SQLite3ã§ã®è¨å®šç‰ã‚’ä¿®æ£ã€ã€Œmigr8.rb new --table=usersã€ã‚’è¿½åŠ ï¼‰
Ooo 2013/11/13
database

migration

DSL

db

postgresql

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ŒIDãƒªã‚¯ãƒ¯ã‚¤ã‚¢ãƒ‰ã€ã®å†æ¤œè¨Ž - æ¥µåŒ—ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä½œè€…: Bill Karwin,å’Œç”°å“äºº,å’Œç”°çœäºŒ,å…å³¶ä¿®å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2013/01/26ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 9äºº ã‚¯ãƒªãƒƒã‚¯: 698å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (46ä»¶) ã‚’è¦‹ã‚‹è©±é¡Œã®SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã®ç›®æ¬¡ã«ã€Œã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ï¼šã™ã¹ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«IDåˆ—ã‚’ç”¨ã„ã‚‹ã€ã¨ã‚ã‚‹ã®ã‚’è¦‹ã¦ã€å¤§èƒ†ã«ã‚‚ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’å¦å®šã—ã¦ã„ã‚‹ã®ã‹ã¨æ€ã£ã¦èªã‚“ã§ã¿ãŸãŒã€ã©ã†ã‚‚ä¸»å¼µãŒã¯ã£ãã‚Šã—ãªã„ã€‚è«–ç‚¹ãŒå°½ãã•ã‚Œã¦ã„ãªã„ã‚ˆã†ãª... ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã®ä¸»å¼µ ç¬¬3ç« ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã“ã¨ãŒæ›¸ã„ã¦ã‚ã‚‹ã€‚ ã€ŒIDãƒªã‚¯ãƒ¯ã‚¤ã‚¢ãƒ‰ã€ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ IDãƒªã‚¯ãƒ¯ã‚¤ã‚¢ãƒ‰ã¯ã€Œã™ã¹ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«"id"ã¨ã„ã†åˆ—åã®ç„¡æ„å‘³ãªé€£ç•ªã®åˆ—ã‚’è¿½åŠ ã—ã€PRIMARY KEYåˆ¶ç´„ã‚’ä»˜ä¸Žã™ã‚‹ã€ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã“ã¨ã€‚ ä½•ãŒã„ã‘ãªã„ã®ã‹ è‡ªç„¶ã‚ãƒ¼ã«UNIQUEåˆ¶ç´„ã‚’ä»˜ã‘ãªã„ãªã‚‰ã€è‡ªç„¶ã‚ãƒ¼ã®é‡è¤‡ã‚’
Ooo 2013/03/05
sql

database
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
æœ¬æ›¸ã¯DBè¨è¨ˆã‚„SQLè¨˜è¿°ã®éš›ã«é¿ã‘ã‚‹ã¹ãäº‹æŸ„ã‚’1ç« ã§1ã¤ã€25å€‹ç´¹ä»‹ã™ã‚‹æ›¸ç±ã§ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸å¿ƒã«æ®ãˆãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«ã¯ã€æ§˜ã€…ãªå ´é¢ã§é™¥ã‚Šã‚„ã™ã„å¤±æ•—ï¼ˆã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ›¸ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆã€ã‚¯ã‚¨ãƒªã®è¨˜è¿°ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã¨ã„ã†4ã¤ã®ã‚«ãƒ†ã‚´ãƒªã«åˆ†ã‘ã€ãã‚Œãžã‚Œã®åˆ†é‡Žã«ãŠã‘ã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç´¹ä»‹ã—ã€å¤±æ•—ã‚’é¿ã‘ã‚‹ãŸã‚ã®ã‚ˆã‚Šè‰¯ã„æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚è¤‡æ•°ã®å€¤ã‚’æŒã¤å±žæ€§ã‚„å†å¸°çš„ãªãƒ„ãƒªãƒ¼æ§‹é€ ã®æ ¼ç´ã‹ã‚‰ã€å°æ•°å€¤ã®ä¸¸ã‚ã‚„NULLã®æ‰±ã„ã«èµ·å› ã™ã‚‹å•é¡Œã€å…¨æ–‡æ¤œç´¢ã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€MVCã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã©ã€å®Ÿè·µçš„ã‹ã¤å¹…åºƒã„ãƒˆãƒ”ãƒƒã‚¯ã‚’ç¶²ç¾…ã—ã¾ã™ã€‚æ—¥æœ¬èªžç‰ˆã§ã¯ã€MySQLã®ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦è‘—åãªå¥¥é‡Žå¹¹ä¹Ÿæ°ã«ã‚ˆã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’åŽéŒ²ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®ä¸€å†Šã§ã™ã€‚ æœ¬æ›¸ã¸ã®ç§°è³›ã®å£° ç›£è¨³è€…ã¾ãˆãŒã ã¯ã˜ã‚ã« Iéƒ¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–
Ooo 2013/01/19
database

book

books

sql

mysql

o'reilly
ãƒªãƒ³ã‚¯
http://jsoniq.org/index.html
Ooo 2012/09/30
nosql

json

language

filter

processing

query

sql

javascript
ãƒªãƒ³ã‚¯
The SQL Injection Knowledge Base
Examples: SELECT * FROM Articles WHERE id = '1'''; SELECT 1 FROM dual WHERE 1 = '1'''''''''''''UNION SELECT '2'; Notes: You can use as many apostrophes and quotations as you want as long as they pair up. It is also possible to continue the statement after the chain of quotes. Quotes escape quotes.
Ooo 2012/07/12
security

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