GitHub - harelba/q: q - Run SQL directly on delimited files and multi-file sqlite databasesYou 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
ãªãœRDBã‹ã‚‰CSV + COBOLã«å¤‰æ›´ã™ã‚‹äº‹ã§ã‚³ã‚¹ãƒˆå‰Šæ¸›ã¨é«˜é€ŸåŒ–ã‚’åŒæ™‚ã«å®Ÿç¾å‡ºæ¥ãŸã‹ã®è€ƒå¯Ÿ - ブãƒã‚°ãªã‚“ã よもん
ãã‚‚ãã‚‚æ—¢å˜ã¯ã©ã‚“ãªãƒã‚¸ãƒƒã‚¯ï¼Ÿ RDBãªã‚“ã ã‹ã‚‰Whereå¥ä½¿ã£ãŸã‚‰ï¼Ÿ ãªãœãƒ•ã‚¡ã‚¤ãƒ«ã«ã™ã‚‹ã¨é€Ÿããªã‚‹ã®ã‹ï¼Ÿ 並列化ã¨åˆ†æ•£å‡¦ç†ã«ã‚ˆã‚‹é«˜é€ŸåŒ–ã®å¯èƒ½æ€§ COBOL使ã†å¿…è¦ã‚ã£ãŸã®ï¼Ÿ Javaã¨ã‹ã˜ã‚ƒãƒ€ãƒ¡ã ã£ãŸã®ï¼Ÿ ã¾ã¨ã‚ TLを見ã¦ã‚‹ã¨ä»¥ä¸‹ã®è¨˜äº‹ãŒå°‘ã—話題ã«ãªã£ã¦ã¾ã—ãŸã€‚ tech.nikkeibp.co.jp tech.nikkeibp.co.jp 対象ã®è¨˜äº‹ã¯æœ‰æ–™ä¼šå“¡ã˜ã‚ƒãªã„ã¨è¦‹ã‚Œãªã„ã®ã ã‘ã©äº‹ä¾‹ã¨ã—ã¦ã¯ä»¥ä¸‹ã¿ãŸã„。 リソース - ユーザー事例 - COBOLè£½å“ ãƒ¦ãƒ¼ã‚¶ãƒ¼äº‹ä¾‹ : マイクãƒãƒ•ã‚©ãƒ¼ã‚«ã‚¹ ã•ã¦ã€ã“ã®è¨˜äº‹ã®é©šããƒã‚¤ãƒ³ãƒˆã¯ã€Œï¼‘億レコードãらã„ã®DB処ç†ã‚’RDBã‹ã‚‰COBOL + CSVã«å¤‰æ›´ã—ã¦Unixサーãƒã‹ã‚‰Windowsサーãƒã«å¤‰ãˆã‚‹äº‹ã§æ€§èƒ½ã‚’ç¶æŒã—ã¤ã¤ã‚³ã‚¹ãƒˆã‚’1/5ãらã„ã«ã—ãŸã€ã¨ã„ã†äº‹ã§ã—ょã†ã€‚ 「ã›ã£ã‹ã7割もã‚ã£ãŸSQLを全部COBOLã«å¤‰ãˆã‚‹ã¨ã‹æ™‚代ã«é€†è¡Œã—ã™ãŽï¼ã€
q - Text as Data
q - Run SQL directly on CSV or TSV files¶ Overview¶ q's purpose is to bring SQL expressive power to the Linux command line by providing easy access to text as actual data, and allowing direct access to multi-file sqlite3 databases. q <flags> <sql-query> q allows the following: Performing SQL-like statements directly on tabular text data, auto-caching the data in order to accelerate additional quer
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}