GitHub - tconbeer/harlequin: The SQL IDE for Your Terminal.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
生SQLã«åž‹ã‚’手書ãã™ã‚‹æ™‚代ã¯çµ‚ã‚り？Prismaã®æ–°æ©Ÿèƒ½ã€ŒTypedSQLã€
生SQLを扱ㆠ$queryRaw TypeScriptå‘ã‘ã®ORMライブラリã¨ã—ã¦PrismaãŒã‚ã‚Šã¾ã™ã€‚Prismaã¯ç›´æ„Ÿçš„ã§åž‹å®‰å…¨ãªAPIã‚’æä¾›ã—ã€TypeScriptå‘ã‘ã®ORMã¨ã—ã¦ã¯ç¬¬ä¸€ã«åå‰ãŒä¸ŠãŒã‚‹ã“ã¨ãŒå¤šã„ライブラリã§ã™ã€‚ ã—ã‹ã—ãã‚“ãªäººæ°—ãªPrismaã§ã‚‚ã€è£å´ã§ã¯å°‘ã—クセã®ã‚ã‚‹SQLãŒç™ºè¡Œã•ã‚Œã¦ã„ãŸã‚Šã€æ¬²ã—ã„SQLãŒPrismaã®APIã§ã¯å®Ÿç¾ã§ããªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã£ãŸå ´åˆã®ãŸã‚ã« $queryRaw ã¨ã„ã†ãƒ¡ã‚½ãƒƒãƒ‰ãŒç”¨æ„ã•ã‚Œã¦ãŠã‚Šã€ã“れを使ã†ã“ã¨ã§ç”ŸSQLを書ã„ã¦ãã®çµæžœã‚’å—ã‘å–ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ä»–ã®ORMã«ã‚‚よãã‚る機能ã§ã™ã€‚ 例ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«å®Ÿè£…ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ const users = await prisma.$queryRaw` SELECT id, name FROM "Users" WHERE id = ${userID} `; co
endatabas | SQL Document Database with Full History
Endatabas is an open source immutable database. We hope you will enjoy building with Endatabas as much as you enjoyed writing your first program. Endatabas is now in Beta. Read the One-Page Executive Summary. For more information, please contact us at [email protected]. -- store documents without CREATE TABLE INSERT INTO msgs {text: "Here is some classic material", user: "George", send_at: 2024-
Compile SQL to type-safe code
You write SQL queries You run sqlc to generate code that presents type-safe interfaces to those queries You write application code calling the methods sqlc generated. Seriously, it's that easy. You don't have to write any boilerplate SQL querying code ever again. See the current list of supported programming languages and databases. Schema updates and poorly-written queries often bring down produc
An in-process SQL OLAP database management system
DuckDB is a fast in-process analytical database DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs. DuckDB v1.1.0 was released in September 2024. Installation Documentation -- Get the top-3 busiest train stations SELECT station_name, count(*) AS num_services FROM train_services GROUP BY ALL ORDER BY num_services DESC LIMIT 3;
パスワードãŒãƒãƒƒã‚·ãƒ¥å€¤ã§ä¿å˜ã•ã‚Œã¦ã„るサイトã®SQLインジェクションã«ã‚ˆã‚‹èªè¨¼å›žé¿ã®ç·´ç¿’å•é¡Œ - Qiita
SQLインジェクションã«ã‚ˆã‚‹èªè¨¼å›žé¿ SQLインジェクションã«ã‚ˆã‚‹å½±éŸ¿ã¨ã—ã¦ã€æƒ…å ±ãŒæ¼æ´©ã™ã‚‹ã¨ã‹ã€ãƒ‡ãƒ¼ã‚¿ãŒå‹æ‰‹ã«æ›´æ–°ã•ã‚Œã¦ã—ã¾ã†ãªã©ã¨ã¨ã‚‚ã«ã€èªè¨¼å›žé¿ã®ä¾‹ãŒã‚ˆã紹介ã•ã‚Œã¾ã™ï¼ˆç§ã®æœ¬ã§ã‚‚å–り上ã’ã¦ã„ã¾ã™ï¼‰ã€‚ 典型的ãªä¾‹ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ // $id 㨠$password ã¯å¤–部ã‹ã‚‰ã®å…¥åŠ› $sql = "SELECT * FROM users WHERE id='$id' AND password='$password'";
セマンティックレイヤー / Headless BIã¨ã¯
ã“ã®è¨˜äº‹ã¯ä½• 2023å¹´ã€ä¸–é–“ã¯LLMã§å¤§é¨’ãŽã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®æ¥ç•Œã§ã¯ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯ãƒ¬ã‚¤ãƒ¤ãƒ¼ãƒ»Headless BIã¸ã®æ³¨ç›®ã‚‚高ã¾ã£ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯ã€ã¾ã 国内ã§ã¯é»Žæ˜ŽæœŸã¨ã‚‚ã„ãˆã‚‹ãã‚“ãªæŠ€è¡“ãŒã€ä»Šå¾Œã©ã‚“ãªå˜åœ¨ã¨ãªã‚Šã†ã‚‹ã®ã‹ã‚’ã€ç†è€…ã®å€‹äººçš„ãªè§£é‡ˆã¨å¦„想をもã¨ã«è¿°ã¹ã‚‹é•·æ–‡ãƒã‚¨ãƒ ã§ã™ã€‚ セマンティックレイヤーã¨ã¯ ã¾ãšæœ€åˆã«ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯ãƒ¬ã‚¤ãƒ¤ãƒ¼ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ セマンティックレイヤーã¨ã¯ セマンティックレイヤーã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ‡ãƒ¼ã‚¿åˆ©ç”¨è€…ã®é–“ã«å…¥ã‚Šã€ä¸¡è€…é–“ã®ã‚„ã‚Šã¨ã‚Šã‚’円滑ã«ã™ã‚‹å˜åœ¨ã§ã™ã€‚ データ統åˆãƒ—ラットフォームをæä¾›ã™ã‚‹Airbyte社ã¯ã€ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’データã¨ãƒ“ジãƒã‚¹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä¸é–“ã«ä½ç½®ã™ã‚‹ã€è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿ã‚’ç†è§£å¯èƒ½ãªãƒ“ジãƒã‚¹ã®æ¦‚念ã«å¤‰æ›ãƒ»ç¿»è¨³ã™ã‚‹ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ A semantic layer is a translation layer that sits
データベースã®ä»•çµ„ã¿(アーã‚テクãƒãƒ£)ã‚’ã–ã£ãã‚Šç†è§£ã™ã‚‹
フリーランスエンジニアをã—ã¦ã„ã‚‹revenue-hackã§ã™ï¼ 普段ã¯Go言語ã§ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’ä¸å¿ƒã«ã‚„ã£ã¦ã„ã¾ã™ã€œ ↓登壇ã—ãŸã¨ãã®è³‡æ–™ã§ã™ï¼ より図を入れã¦è©³ã—ã書ã„ã¦ãŠã‚Šã¾ã™ï¼ 今回ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç‰¹ã«RDBã®ä»•çµ„ã¿(アーã‚テクãƒãƒ£)ã«ã¤ã„ã¦ã–ã£ãã‚Šç†è§£ã—ã¦ã€ãªã«ã‹ã«å½¹ç«‹ã¦ã‚ˆã†ãœã€œ ã¨ã„ã†ã‚ˆã†ãªå†…容ã«ãªã‚Šã¾ã™ã€‚ ↓記事ã¯ã“ã¡ã‚‰ã«ç§»ã—ã¾ã—ãŸï¼â†“
æ¼¢å—データベースを使ã£ã¦æ¼¢å—ベン図を作å•ã™ã‚‹ - Ryusei’s Notes (a.k.a. M59ã®ãƒ–ãƒã‚°)
æ¼¢å—ベン図ã¯ã€QuizKnockãŒã‚„ã£ã¦ã„ãŸæ¼¢å—クイズã§ã™ã€‚æ¡ä»¶ãŒ3ã¤ä¸Žãˆã‚‰ã‚Œã‚‹ã®ã§ã€è¤‡æ•°ã®æ¡ä»¶ã«å½“ã¦ã¯ã¾ã‚‹æ¼¢å—ã‚’ç”ãˆã¦ã„ãã¾ã™ã€‚ www.youtube.com ã“ã®è¨˜äº‹ã§ã¯ã€æ¼¢å—æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Mojidata を活用ã—ã¦ã€æ¼¢å—ベン図を作å•ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ github.com Mojidataã¯SQLiteã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã§ä½¿ã†ã“ã¨ãŒã§ãるデータベースã«ãªã£ã¦ã„ã¦ã€æƒ…å ±ã‚’SQLã§å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ データベースを使ã†æº–å‚™ Mojidataを使ã†ã«ã¯ã€Node.jsã¨SQLiteをインストールã—ã¦ã‚ã‚‹ã¨æ¥½ã§ã™ã€‚ ãã®å¾Œã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’実行ã—ã¦ã€moji.dbをダウンãƒãƒ¼ãƒ‰ã—ã€sqlite3ã‚’èµ·å‹•ã—ã¦ãã ã•ã„。 # 作æ¥ç”¨ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’作る mkdir kanji-venn # カレントディレクトリを変更ã™ã‚‹ cd kanji-venn # npm
Chrome開発ãƒãƒ¼ãƒ ãŒSQLiteãƒãƒ¼ãƒ ã¨WebAssembly版SQLiteを開発ä¸ã€‚Webブラウザ上ã‹ã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«æ›¸ãè¾¼ã¿ã§æ°¸ç¶šåŒ–ã‚‚å¯èƒ½ã€‚Web SQL APIã®ä»£æ›¿ã¨ã—ã¦
Chrome開発ãƒãƒ¼ãƒ ãŒSQLiteãƒãƒ¼ãƒ ã¨WebAssembly版SQLiteを開発ä¸ã€‚Webブラウザ上ã‹ã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«æ›¸ãè¾¼ã¿ã§æ°¸ç¶šåŒ–ã‚‚å¯èƒ½ã€‚Web SQL APIã®ä»£æ›¿ã¨ã—㦠Google Chromeã®é–‹ç™ºãƒãƒ¼ãƒ ã¯ã€ã™ã§ã«éžæŽ¨å¥¨ã¨ãªã£ã¦ã„ã‚‹Web標準ã®Web SQL Database APIã‚’Chromeã‹ã‚‰å‰Šé™¤ã€ãã®ä»£æ›¿æ©Ÿèƒ½ã¨ã—ã¦SQLite開発ãƒãƒ¼ãƒ ã¨å”力ã—ã¦WebAssembly版ã®SQLiteを開発ã—ã€æä¾›ã™ã‚‹äºˆå®šã§ã‚ã‚‹ã“ã¨ã‚’明らã‹ã«ã—ã¾ã—ãŸã€‚ Chrome is deprecating and eventually removing Web SQL! Read @tomayac’s post that details all the steps for getting there. [We are here] Chrome 105 shows a deprecation w
ç°¡å˜é–¢ä¿‚照会言語 Erq ã§å¿«é©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ†æžç”Ÿæ´»ã‚’é€ã‚‹ - Ryusei’s Notes (a.k.a. M59ã®ãƒ–ãƒã‚°)
Erq（アーク）ã¯ã€SQLã®ä»£ã‚ã‚Šã«ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªãƒ‡ãƒ¼ã‚¿åˆ†æžã«ç”¨ã„ã‚‹ã“ã¨ã‚’主目的ã¨ã—ãŸã€æ–°ã—ã„データベース言語ã§ã™ã€‚リレーショナルデータベースã¯ä¾¿åˆ©ã§ã™ãŒã€ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’è¡Œã†ä¸Šã§ã€SQLã®æ–‡æ³•ã¯é¢å€’ãªã‚‚ã®ã§ã™ã€‚Erqã¯ã€SQLã®ã‚»ãƒžãƒ³ãƒ†ã‚£ã‚¯ã‚¹ã¯æ¥µåŠ›ãã®ã¾ã¾ã«ç•°ãªã‚‹æ–‡æ³•ã‚’採用ã™ã‚‹ã“ã¨ã§ã€ç°¡å˜ã«ã‚¯ã‚¨ãƒªã‚’書ã‘るよã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ SQLクエリã®å®Ÿä¾‹ ç§ã¯SQLiteデータベースã«æ¼¢å—ã®æ–‡å—æƒ…å ±ã‚’å…¥ã‚Œã¦ã€è¤‡é›‘ãªæ¤œç´¢ã‚„分æžãŒã§ãるよã†ã«ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€å®Ÿéš›ã«ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’使ã£ãŸã‚¯ã‚¨ãƒªä¾‹ã‚’見ã¦ã¿ã¾ã—ょã†ã€‚使ã£ã¦ã„ã‚‹Mojidataデータベースã¯ã€æ¬¡ã®ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ãƒ“ルドã§ãã¾ã™ã€‚ GitHub - mandel59/mojidata: Character Database for CJKV Text Processing ã¾ãšã€æ¼¢å—ã®èªã¿ã‚’集ã‚ãŸmji_readingテーブルã®å†…容を全
PRQL
Pipelined Relational Query Language, pronounced “Prequelâ€PRQL is a modern language for transforming data— a simple, powerful, pipelined SQL replacement from invoices filter invoice_date >= @1970-01-16 derive { transaction_fees = 0.8, income = total - transaction_fees } filter income > 1 group customer_id ( aggregate { average total, sum_income = sum income, ct = count total, } ) sort {-sum_income}
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - AmrDeveloper/LLQL: LLQL is a tool that allow you to run SQL-like query with Pattern matching functions inspired by LLVM InstCombine Pattern Matchers on LLVM IR/Bitcode files
ActiveRecord SQLインジェクションクイズ (Rails 7.1.3.4)
SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL
GitHub - drawdb-io/drawdb: Free, simple, and intuitive online database design tool and SQL generator.
GitHub - Mindinventory/MindSQL: MindSQL: A Python Text-to-SQL RAG Library simplifying database interactions. Seamlessly integrates with PostgreSQL, MySQL, SQLite, Snowflake, and BigQuery. Powered by GPT-4 and Llama 2, it enables natural language queries.
SQL Embedding / Extensions - HackMD
YDB Is Now Available as Open-Source Project
GitHub - theduke/wasi-sql: SQL interface for Webassembly components
{{#tags}}- {{label}}
{{/tags}}