sqlfmt: A free online SQL formatter for writing prettier SQL
This post was originally published in 2018 by former CockroachDB engineer Matt Jibson, who owns goats and makes his own soap. It’s one of the most popular blogs we’ve ever published so we wanted to get it back up on the site for a new crop of blog readers. What is sqlfmt?sqlfmt is an online SQL formatter. It is pronounced sequel fumpt. Its purpose is to beautifully format SQL statements. I built s
scheman diff - ✘╹◡╹✘
https://github.com/r7kamura/scheman 旅行を兼ãã¦æ²–縄ã«é–‹ç™ºåˆå®¿ã«æ¥ã¦ã„ã‚‹ã®ã§ã€1日目ã®æˆæžœã‚’書ã出ã—ã¦ãŠã。 目的 Webアプリã®é–‹ç™ºãƒ•ãƒãƒ¼ã§æ¬¡ã®ã‚ˆã†ãªçŠ¶æ…‹ã‚’実ç¾ã—ãŸã„。 DBã®å¤‰æ›´ã®ãŸã³ã«å¤‰æ›´ç”¨ã®SQLã‚„Migrationファイルを人間ãŒæ›¸ã‹ãªãã¦è‰¯ã„ migrationファイルを書ã代ã‚ã‚Šã«äººé–“ã¯ã‚¹ã‚ーマを編集ã™ã‚‹ スã‚ーマã¯SQLã§è¨˜è¿°ã§ãã‚‹ (DSLã®ä½¿ç”¨ã‚’強制ã•ã‚Œãªã„) SQL以外ã®è¨€èªžã§ã‚‚記述ã§ãã‚‹ (DSLを使用ã—ã¦ã‚‚良ã„) æ–¹é‡ æ¬¡ã®ã‚ˆã†ãªå®Ÿè£…を試ã¿ãŸã€‚ SQLを構文解æžã—ã¦ã‚¹ã‚ーマデータã«å¤‰æ›ã™ã‚‹ (解æžå™¨ã¯äº‹å‰ã«å®Ÿè£…済ã¿) é©ç”¨ã™ã¹ãSQLã‚’2ã¤ã®ã‚¹ã‚ーマデータã®å·®åˆ†ã‹ã‚‰è‡ªå‹•ã§è¨ˆç®—ã™ã‚‹ SQL以外ã®è§£æžå™¨ã‚‚作æˆå¯èƒ½ã« scheman diff scheman diffã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’実装ã—ãŸã€‚ ã“ã‚Œã¯å¤‰æ›´å‰å¾Œã®äºŒã¤ã®ã‚¹ã‚ーマã®å·®åˆ†ã‚’標
The JSON SQL Injection Vulnerability
tl;dr Many SQL query builders written in Perl do not provide mitigation against JSON SQL injection vulnerability. Developers should not forget to either type-check the input values taken from JSON (or any other hierarchical data structure) before passing them to the query builders, or should better consider migrating to query builders that provide API immune to such vulnerability. Note: å•é¡Œã®ç™ºè¦‹è€…ã«ã‚ˆã‚‹æ—¥
紹介：ã€æ›¸ç±ã€‘SQLアンãƒãƒ‘ターン
リレーショナルデータベースã®çˆ¶ã€ã‚¨ãƒ‰ã‚¬ãƒ¼ãƒ»F・コッドæ°ãŒè«–文を発表ã—ãŸã®ã¯1970年。ç§ãŒç”Ÿã¾ã‚Œã‚‹å‰ã®è©±ã§ã‚る。ãã—ã¦SQLãŒANSI標準ã«ãªã£ãŸã®ãŒ1986年。RDBMSã‚’ã€ãã—ã¦SQLを使ã£ãŸã‚·ã‚¹ãƒ†ãƒ 開発ã¯å¸¸ã«ä¸»æµã§åœ¨ã‚Šç¶šã‘ãŸã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„。ãã‚“ãªæ´å²ã®ã‚ã‚‹SQLã§ã‚ã‚‹ãŒã€æœªã ã«å¤šãã®äººã¯SQLを使ã„ã“ãªã›ã¦å±…ãªã„よã†ã«è¦‹ãˆã‚‹ã€‚ SQLã¯ã¨ã¦ã‚‚奥ãŒæ·±ã„。ソートやトランザクションãŒä½¿ç”¨å‡ºæ¥ã‚‹ãŠã‹ã’ã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’無視ã—ã¦å˜ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã®å…¥ã‚Œç‰©ã¨ã—ã¦ä½¿ã£ã¦ã‚‚ãã‚Œãªã‚Šã«ä¾¿åˆ©ã ã£ãŸã‚Šã™ã‚‹ã€‚ã ãŒã€ãã‚ŒãŒä»Šç¾åœ¨å¤šãã®æ‚²åŠ‡ã‚’生んã§ã„ã‚‹åŽŸå› ã§ã‚‚ã‚る。多ãã®äººãŒåŒã˜ã‚ˆã†ã«SQLã‚’ç†è§£ã›ãšã€ãã®ãŸã‚多ãã®äººãŒåŒã˜æ‚²åŠ‡ã«è¦‹èˆžã‚れる。ãã†ã€ãã‚ŒãŒã‚¢ãƒ³ãƒãƒ‘ターンã§ã‚ã‚‹ï¼ ä»Šå›žç´¹ä»‹ã™ã‚‹SQLアンãƒãƒ‘ターンã¯ã€æ´‹æ›¸SQL Antipatternsã®é‚¦è¨³ç‰ˆã 。ç§ã¯å…ƒã€…英語版ã®ãƒ•ã‚¡ãƒ³ã§ã§ã‚ã‚Šã€äººã€…ãŒé™¥ã‚Š
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - florajs/sql-parser: Parse SQL (select) statements into abstract syntax tree (AST) and convert ASTs back to SQL.
https://labs.cybozu.co.jp/blog/kazuho/archives/2007/09/dbi_printf.php
{{#tags}}- {{label}}
{{/tags}}