How we built Text-to-SQL at Pinterest
Adam Obeng | Data Scientist, Data Platform Science; J.C. Zhong | Tech Lead, Analytics Platform; Charlie Gu | Sr. Manager, Engineering Writing queries to solve analytical problems is the core task for Pinterest’s data users. However, finding the right data and translating an analytical problem into correct and efficient SQL code can be challenging tasks in a fast-paced environment with significant
GitHub - kysely-org/kysely: A type-safe TypeScript SQL query builder
Kysely (pronounce “Key-Seh-Leeâ€) is a type-safe and autocompletion-friendly TypeScript SQL query builder. Inspired by Knex.js. Mainly developed for Node.js but also runs on all other JavaScript environments like Deno, Bun, Cloudflare Workers and web browsers. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has th
TypeScriptã§ä¸–界一型安全ãªåž‹ãƒ¬ãƒ™ãƒ«SQL Interpreterを作ã£ã¦ã„る話
ã“ã‚“ã«ã¡ã¯ã€‚DevOps芸人ã¨åŒ–ã—ã¦ä¹…ã—ã„Andyã§ã™ã€‚ 2020å¹´ã®ç§‹ã«TypeScript 4.1ã¸Template Literal TypesãŒå°Žå…¥ã•ã‚Œã€ãã®ã‚¤ãƒ³ãƒ‘クトã«ä¿„ã‹ã«ä¸€éƒ¨ã®ç•ŒéšˆãŒã‚¶ãƒ¯ã¤ã„ãŸã®ã¯è¨˜æ†¶ã«æ–°ã—ã„ã‹ã¨æ€ã„ã¾ã™ã€‚ 今回ã¯åž‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®å¯èƒ½æ€§ã‚’大ã„ã«æŠ¼ã—広ã’ãŸTemplate Literal Typesを用ã„ã¦SQL文を型レベルã§è§£æžã—ã€ãã®å®Ÿè¡Œçµæžœã‚’åž‹æƒ…å ±ã¨ã—ã¦å°Žå‡ºã™ã‚‹ãŸã‚ã®sqlptureã¨ã„ã†ãƒ©ã‚¤ãƒ–ラリを作ã£ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ Embedded content: https://github.com/andoshin11/sqlpture SQLã®å®Ÿè¡Œ/検証対象ã¯PostgreSQL v13ã§ã™ã€‚ tl;dr SQL文を型レベルã§è§£æžãƒ»è©•ä¾¡ã—ã¦è¿”り値型をå–å¾—ã§ãã‚‹mini interpreterを作ã£ãŸã‚ˆ 型レベルã®SQL validatorも作ã£ã¦ã‚‹ã‚ˆ 実際
SQL Style Guide
A set of conventions and guidelines for writing SQL at GitLab SQL Style Guide This guide establishes our standards for SQL and are enforced by the SQLFluff linter and by code review. The target code changes that this stile guide apply to are those made using dbt. If you are not on the Data Team or you are developing SQL outside of dbt, keep in mind that the linting tools may be more difficult to a
You now can use a SQL-compatible query language to query, insert, update, and delete table data in Amazon DynamoDB - AWS
You now can use a SQL-compatible query language to query, insert, update, and delete table data in Amazon DynamoDB You now can use PartiQL (a SQL-compatible query language)—in addition to already-available DynamoDB operations—to query, insert, update, and delete table data in Amazon DynamoDB. PartiQL makes it easier to interact with DynamoDB and run queries in the AWS Management Console. Because P
Client-Side SQL Query Parsing with ANTLR
Multiple Queries in the Console Query Editor Rockset Console’s query editor allows users to type and run queries over collections. Until now, however, whatever was typed in the editor was run and parsed as a single query. This means that, for a user, it wasn’t that easy to switch between multiple queries in our editor. They would have to comment out the queries they didn’t want to run, or keep all
What’s New in SQL:2016
In December 2016, ISO released a new version of the international SQL standard (ISO/IEC 9075:2016). It supersedes the previous version from 2011. This article is a brief overview of the new features being introduced into the SQL language. Strictly speaking, this article covers the additions to part 2 of the standard (SQL/Foundation), i.e. the most commonly used part. This article also shows the av
「ドクターSQLã€ã«èžãã€æ¬¡æœŸæ¨™æº–「SQL2016ã€ã§æ³¨ç›®ã™ã¹ã三ã¤ã®æ–°æ©Ÿèƒ½
「ドクターSQLã€ã«èžãã€æ¬¡æœŸæ¨™æº–「SQL2016ã€ã§æ³¨ç›®ã™ã¹ã三ã¤ã®æ–°æ©Ÿèƒ½ï¼šDatabase Watch（2015å¹´12月版）（1/2 ページ） RDBã§ãƒ‡ãƒ¼ã‚¿ã‚’æ“作ã™ã‚‹è¨€èªžãŒã€ŒSQLã€ã§ã™ã€‚ãã®ä»•æ§˜ã¯å›½éš›æ¨™æº–ã¨ãªã£ã¦ãŠã‚Šã€RDBã®æ™®åŠã‚’å¼·ã支ãˆã¦ã„ã¾ã™ã€‚今ã§ã‚‚進化を続ã‘ã€æ¬¡æœŸç‰ˆã®æ¨™æº–ã¨ãªã‚‹äºˆå®šã®ã€ŒSQL2016ã€ã¯ã©ã†ãªã‚‹ã®ã‹ã€‚“ドクターSQLâ€ã“ã¨æ—¥æœ¬ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¦ä¼šå‰¯ä¼šé•·ã®åœŸç”°æ£å£«æ°ã«è©±ã‚’èžãã¾ã—ãŸã€‚ 連載ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ RDB（リレーショナルデータベース）ã§ãƒ‡ãƒ¼ã‚¿ã‚’æ“作ã™ã‚‹è¨€èªžã€ã€ŒSQLã€ã¯å›½éš›æ¨™æº–ã¨ã—ã¦å®šã‚られã¦ãŠã‚Šã€æ”¹è¨‚ã•ã‚ŒãŸå¹´è¡¨è¨˜ã‚’組ã¿åˆã‚ã›ã¦ã€ŒSQL92ã€ã€ŒSQL:2008ã€ãªã©ã¨è¡¨è¨˜ã•ã‚Œã¾ã™ã€‚RDB製å“ãªã‚‰ã°ã€ã©ã®SQL標準ã«æº–æ‹ ã—ã¦ã„ã‚‹ã®ã‹ãŒä»•æ§˜ã¨ã—ã¦æ˜Žç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®SQL標準ã¯ç¾åœ¨ã‚‚進化を続ã‘ã¦ãŠã‚Šã€æ¬¡æœŸç‰ˆã®ã€ŒSQL2016ã€ã‚‚2016å¹´ã®ãƒªãƒªãƒ¼ã‚¹ãŒäºˆå®šã•ã‚Œ
ç¾ä»£ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å¼·åŠ›ãªãƒ¡ãƒ¢å¸³ Jupyter notebookã®ã™ã‚ã‚ - クックパッド開発者ブãƒã‚°
会員事æ¥éƒ¨ã®æœ‰è³€(id:chezou)ã§ã™ã€‚ 今年一年ã€ç¤¾å†…ã§ã¯å‹æ‰‹ã«"Jupyterã®ä¼é“師"を標榜ã—ã¦Jupyter notebookã®æ™®åŠæ´»å‹•ã‚’展開ã—ã¦ãã¾ã—ãŸã€‚ 先日ã€ç¤¾å†…ã§ãƒãƒ³ã‚ºã‚ªãƒ³ã‚‚è¡Œã£ãŸãŠã‹ã’ã‚‚ã‚ã‚Šã€ã‹ãªã‚Šç¤¾å†…ã®ãƒžã‚·ãƒ³ã«Python環境ãŒæ§‹ç¯‰ã•ã‚Œã¦ãã¾ã—㟠:) Jupyter notebookã¨ã¯ï¼Ÿ ã²ã¨ã“ã¨ã§è¨€ã†ã¨ãƒ–ラウザã§å‹•ãã™ã”ã„便利ãªREPL*1ã§ã™ã€‚ 百èžã¯ä¸€è¦‹ã«ã—ã‹ãšã€è¦‹ã¦ã¿ã¾ã—ょã†ã€‚ ã“ã®ã‚ˆã†ã«ã€Rubyã®å¯¾è©±ç’°å¢ƒã§ã‚ã‚‹pryを触ã£ã¦ã„るよã†ã«ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ã«ã‚³ãƒ¼ãƒ‰ã‚’書ãã“ã¨ãŒã§ãã¾ã™ã€‚ 以é™ã§èª¬æ˜Žã‚’ã—ã¾ã™ãŒã€Jupyter notebookã¯è¨˜éŒ²ãƒ»å…±æœ‰ãƒ»å†ç¾ãŒã¨ã¦ã‚‚å¾—æ„ã§ã™ã€‚特ã«å›³è¡¨ãŒã‚ã‚‹ã¨ãã«ãã®åŠ¹æžœã‚’発æ®ã—ã¾ã™ã€‚ Jupyter notebookã®è‰¯ã„所 éŽåŽ»ã®ã‚³ãƒ¼ãƒ‰ã‚’改変ã€å†å®Ÿè¡Œã§ãã‚‹ セルã¨å‘¼ã°ã‚Œã‚‹å…¥åŠ›éƒ¨åˆ†ã«ã¯MarkdownやコードãŒè¨˜è¿°ã§ãã¾ã™
巨大ãªãƒãƒƒãƒã‚’分割ã—ã¦æ§‹æˆã™ã‚‹ 〜SQLãƒãƒƒãƒãƒ•ãƒ¬ãƒ¼ãƒ ワークBricolage〜 - クックパッド開発者ブãƒã‚°
トレンド調査ラボã®é’木峰郎（id:mineroaoki）ã§ã™ã€‚ 好ããªRubyã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯10å¹´å‰ã‹ã‚‰String#slice(re, nth)ã§ã™ãŒã€ 最近ã¯RubyよりCoffeeScriptã¨SQLã®ã»ã†ãŒæ›¸ãé‡ãŒå¤šãã¦æ‚©ã‚“ã§ã„ã¾ã™ã€‚ 今日ã¯ã‚ãŸã—ãŒé–‹ç™ºã—ã¦ã„る「ãŸã¹ã¿ã‚‹ã€ã®èƒŒå¾Œã§åƒã„ã¦ã„ã‚‹ 巨大ãƒãƒƒãƒã®æ§‹æˆã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã¹ã¿ã‚‹ã®ãƒãƒƒãƒã¯ç´„3000è¡Œã®SQLã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ 処ç†æ™‚é–“ãŒ1æ—¥ã§4時間程度ã‹ã‹ã‚‹ã€ãã“ãã“ã®è¦æ¨¡ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ ã“ã®ãƒãƒƒãƒå‡¦ç†ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’Bricolage（ブリコラージュ）ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ãƒ ワークã§æ§‹é€ 化ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ 「ãŸã¹ã¿ã‚‹ã€ã¨ã¯ ã¾ãšæœ€åˆã«ã€ã€ŒãŸã¹ã¿ã‚‹ã€ãŒã©ã†ã„ã†ã‚‚ã®ãªã®ã‹ã”ãç°¡å˜ã«ãŠè©±ã—ã—ã¦ãŠãã¾ã—ょã†ã€‚ 「ãŸã¹ã¿ã‚‹ã€ã¯ä¼æ¥ã®ã¿ã«æä¾›ã—ã¦ã„ã‚‹B2Bã®åˆ†æžã‚µãƒ¼ãƒ“スã§ã€ クックパッドã®ãƒ¬ã‚·ãƒ”検索ã®åˆ†æžã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾
DeNA Engineering - DeNAエンジニアã®ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
技術を活ã‹ã—ã€æ–°ã—ã„ä¾¡å€¤ã‚’å‰µé€ ã™ã‚‹ DeNAã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€æƒ³åƒã‚’超ãˆã‚‹Delightを届ã‘ã‚‹ãŸã‚ã«ä½•ãŒã§ãã‚‹ã‹ã‚’考ãˆã€æŠ€è¡“力ã¨ç™ºæƒ³åŠ›ã§æ–°ã—ã„価値を生ã¿å‡ºã—ã¦ã„ã¾ã™ã€‚ 多様ãªå°‚門性をæŒã£ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒåˆ‡ç£‹ç¢ç£¨ã—ã€äº’ã„ã«åˆºæ¿€ã—åˆãˆã‚‹ç’°å¢ƒã‚„制度ãŒã•ã‚‰ãªã‚‹æˆé•·ã¸ã¨ã¤ãªã’ã¾ã™ã€‚
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã‚¸ãƒ§ãƒ¼ãƒ»ã‚»ãƒ«ã‚³ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL 第4版〠- ミックã®ãƒ–ãƒã‚°
皆ã•ã‚“ã€ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚長らãブãƒã‚°ã®æ›´æ–°ãŒæ¢ã¾ã£ã¦ã„ãŸã®ã¯ã€å°‘ã—大ããªä»•äº‹ã‚’ã—ã¦ã„ãŸãŸã‚ã§ã™ã€‚ジョー・セルコ『プãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL 第4版ã€ã®ç¿»è¨³ã€‚ã“ã‚Œã«é›†ä¸ã™ã‚‹ãŸã‚ã€ãƒ–ãƒã‚°ã‚‚やらãšTwitterもやらãšï¼ˆã“ã£ã¡ã¯ã¡ã‚‡ã£ã¨ã‚„ã£ã¦ã—ã¾ã£ãŸï¼‰é ‘å¼µã£ã¦ãŠã‚Šã¾ã—ãŸã€‚ é•·ã‹ã£ãŸã€‚ 本当ã«é•·ã‹ã£ãŸã€‚ 原著ãŒ800ページ以上ã‚ã‚‹ã†ãˆå†…容も簡å˜ã§ã¯ãªã„ã®ã§ã€ã‚‚ã¨ã‚‚ã¨æ¥½ãªä»•äº‹ã¨ã¯æ€ã£ã¦ã„ã¾ã›ã‚“ã§ã—ãŸãŒã€ã„や大変ã§ã—ãŸã€‚ã§ã™ãŒç„¡äº‹ä»ŠæœˆåˆŠè¡Œã¨ã‚ã„ãªã‚Šã¾ã—ãŸã€‚ã™ã§ã«Amazonã¯ã˜ã‚オンラインショップã§ã‚‚予約å—付を開始ã—ã¦ã„ã¾ã™ã€‚ã‚らã‹ã˜ã‚言ã£ã¦ãŠãã¾ã™ãŒã€Œè¡¨ç´™ã®ãŠã£ã•ã‚“誰？ã€ã¨ã„ã†è³ªå•ã¯ç§ã«ã¯ã—ãªã„よã†ã«ã€‚ç§ã‚‚ç”ãˆã‚‰ã‚Œãªã„ã®ã§ï¼ˆç¬‘）。 ã•ã¦ã€æœ¬æ›¸ã®å†…容を紹介ã™ã‚‹ä»£ã‚ã‚Šã«ã€å°‘ã—é•·ããªã‚Šã¾ã™ãŒè¨³è€…å‰æ›¸ãを引用ã—ã¾ã™ã€‚購入ã™ã‚‹ã‹åˆ¤æ–ã®å‚考ã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ãªãŠã€å®Ÿè¡Œç’°å¢ƒã¨ã—ã¦ã¯å‰æ›¸ãã§ã‚‚書ã„ã¦ã„ã¾ã™
SQL Query Builder for Javascript | Knex.js
Knex.js (pronounced /kəˈnɛks/) is a "batteries included" SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full-featured query and schema build
ランã‚ング
ランã‚ング
メンテナンス
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - SweetIQ/schemats: Generate typescript interface definitions from SQL database schema
GitHub - andoshin11/sqlpture: Type Level SQL interpreter & validator.
GitHub - joereynolds/sql-lint: An SQL linter
GitHub - matsuzaki215/sqlint
presto/presto-parser/src/main/antlr4/com/facebook/presto/sql/parser/SqlBase.g4 at b7dcdb9cf2f2ddcb3fbf86b88770de6da053353c · prestodb/presto
Amazon.co.jp: 10年戦ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ã€€SQLã‚’æ¦å™¨ã«ãƒ‡ãƒ¼ã‚¿æ´»ç”¨æ™‚代を生ã抜ã (Informatics ＆IDEA): é’木峰郎: Digital Ebook Purchas
Amazon.co.jp: プãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL 第4版: ジョーセルコ: 本
{{#tags}}- {{label}}
{{/tags}}