explainã ã‘ã˜ã‚ƒã‚ã‹ã‚‰ãªã„ï¼MySQLã®indexã®è€ƒãˆæ–¹ - BASEプãƒãƒ€ã‚¯ãƒˆãƒãƒ¼ãƒ ブãƒã‚°
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Sakiã§ã™ï¼ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã§PHPを書ã„ãŸã‚Šã€PHPã¨ã„ã†è¨€èªžãã®ã‚‚ã®ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ¼ã‚‚ã—ã¦ã„ã¾ã™ã€‚ ã“ã®åº¦ã€æ³¨æ–‡ãƒ‡ãƒ¼ã‚¿ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰Appã®ãƒ‘フォーマンスをアップã•ã›ã‚‹ãŸã‚ã€ã¨ã¦ã‚‚入念ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¾ã‚ã‚Šã®å‡¦ç†ã‚’見直ã—ã¾ã—ãŸã€‚ãã®ä¸ã§ã‚‚特ã«é€Ÿåº¦ã«é–¢ã‚ã£ã¦ãる「indexã€ã«ã¤ã„ã¦ã®è€ƒãˆæ–¹ã‚’ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯MySQL（InnoDB）ã«ã¤ã„ã¦ã®è¨˜äº‹ã§ã‚ã‚Šã€ä»–ã®RDBã«ã¤ã„ã¦ã¯å½“ã¦ã¯ã¾ã‚‰ãªã„å ´åˆã‚‚ã‚ã‚‹ã¨ã„ã†ã“ã¨ã«ã”注æ„ãã ã•ã„。 indexã¨ã¯ä½•ã‹ã€ãŠã•ã‚‰ã„ ã”å˜çŸ¥ã®æ–¹ã‚‚ã‚‚ã¡ã‚ん多ã„ã¨æ€ã„ã¾ã™ãŒã€indexã«ã¤ã„ã¦ãŠã•ã‚‰ã„ã•ã›ã¦ãã ã•ã„。 indexã¨ã¯è¾žæ›¸ã§ã„ã†ã¨ã“ã‚ã®ç›®æ¬¡ã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ç›®çš„ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã„ã¡æ—©ã検索ã™ã‚‹ãŸã‚ã«é‡è¦ãªã‚‚ã®ã§ã™ã€‚ã‚‚ã—辞書ã«ç›®æ¬¡ãŒå˜åœ¨ã—ãªã‹ã£ãŸå ´åˆã€ç›®çš„ã®æƒ…å ±ã‚’æŽ¢ã™ã®ã«ã¨ã¦ã‚‚苦労ã™ã‚‹ã ã‚ã†ã¨ã„ã†ã®ã¯æƒ³åƒã—ã‚„
DuckDB as the New jq
Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats. I work extensively with JSON day to day, and I often reach for jq when exploring document
Canarytokensサービスを試ã—ã¦ã¿ãŸ - ã“ã‚“ã¨ã‚ーるã—ーã“ã‚“ã¨ã‚ーるã¶ã„
ã‚る調ã¹ã‚‚ã®ã‚’ã—ã¦ã„ãŸã¨ã“ã‚ã€Canarytokensã¨ã„ã†ã‚µãƒ¼ãƒ“スãŒã‚ã‚‹ã“ã¨ã‚’知ã£ãŸã€‚ canarytokens.org Canarytokensã¯ã‚«ãƒŠãƒªã‚¢ãƒˆãƒ¼ã‚¯ãƒ³ã‚’生æˆã™ã‚‹ã‚µãƒ¼ãƒ“スã§ã‚ã‚Šã€ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ã»ã‹ã€githubã§ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚„DockerfileãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ãŸã‚自分ã§ã‚µãƒ¼ãƒ“ス稼åƒç’°å¢ƒã‚’構築ã§ãる。カナリアトークンã¨ã¯ã‚¿ãƒ¼ã‚²ãƒƒãƒˆï¼ˆè¢«å®³è€…）ãŒWebページã€é›»åメールã€ãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã®ãƒªã‚½ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ“作をã—ãŸã¨ãã«ã€ãã®ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸäº‹å®Ÿã‚„ターゲットã®ç’°å¢ƒæƒ…å ±ï¼ˆIPアドレスã€UserAgentã€ãƒ¦ãƒ¼ã‚¶åãªã©ï¼‰ã‚’攻撃者ã«é€šçŸ¥ã™ã‚‹ãŸã‚ã®ä»•æŽ›ã‘ã§ã‚る。 ã“ã®ã‚µãƒ¼ãƒ“スを知ã£ãŸæ™‚ã¯ã€ã‚¢ã‚¯ã‚»ã‚¹è§£æžã§ä½¿ã‚れるよã†ãªWebページã«æ¥µå°ã®é€æ˜Žç”»åƒã‚„iframeを埋ã‚込むよã†ãªæ–¹å¼ã‚’想åƒã—ãŸãŒã€ãƒ‰ã‚ュメントをèªã‚“ã§ã„ã‚‹ã¨ä»–ã«ã‚‚様々ãªæ–¹å¼ã‚’サãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã£ãŸã€‚ãã“ã§ã€å®Ÿéš›ã«ã©ã†ã„ã£
Excelã‚’HTML/Markdownã«å¤‰æ›ã™ã‚‹ ï¼ ãƒ„ãƒ¼ãƒ« - Hirota Yano
Excelã‹ã‚‰HTML/Markdown記法（マークダウン記法）ã«å¤‰æ›ã™ã‚‹Webツールã§ã™ã€‚ Excelã®å¤‰æ›ã—ãŸã„セル範囲をコピーã—ã¦ã€ãƒ„ールã®ãƒ†ã‚ストエリアã«è²¼ã‚Šä»˜ã‘ã‚‹ã¨å¤‰æ›ã•ã‚Œã¾ã™ã€‚ å½¢å¼ï¼šHTMLã®<table>ã€<dl>ã¾ãŸã¯Markdownã‹ã‚‰é¸æŠžã§ãã¾ã™ã€‚ 見出ã—：<table>ã®å ´åˆã¯thã‚¿ã‚°ã®ä½ç½®ã‚’é¸æŠžã§ãã¾ã™ã€‚ 実体å‚照：セル内ã®&<>"ã®æ–‡å—ã¯å®Ÿä½“å‚照（&ãªã©ï¼‰ã«ç½®æ›ã—ã¾ã™ã€‚ 装飾：Excelã§è¨å®šã—ãŸç½«ç·šã‚„色ãªã©ã®è£…飾ã¯åæ˜ ã•ã‚Œã¾ã›ã‚“。 改行・çµåˆï¼šã‚»ãƒ«å†…ã®æ”¹è¡Œã‚„çµåˆã«ã¯å¯¾å¿œã—ã¦ã„ã¾ã›ã‚“。 スタイル：プレビューã«ã¯æœ¬ã‚µã‚¤ãƒˆã®Styleã‚’é©ç”¨ã—ã¦ã„ã¾ã™ãŒã€å¤‰æ›çµæžœã¯Styleã‚’å«ã¾ãªã„HTMLã‚¿ã‚°ã®ã¿ã§ã™ã€‚
sqlcommenter
sqlcommenter Attach SQL comments to correlate user code in ORMs and SQL drivers with SQL statements sqlcommenter is a suite of middlewares/plugins that enable your ORMs to augment SQL statements before execution, with comments containing information about the code that caused its execution. This helps in easily correlating slow performance with source code and giving insights into backend database
ランã‚ング
ãŠçŸ¥ã‚‰ã›
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - hogehuga/epss-db: Download all epss data, and import database. We can explore the data by SQL querys!
xlsxファイルã«SQLを実行ã™ã‚‹xlsxsql - Qiita
SQL Chat
GitHub - mithrandie/csvq: SQL-like query language for csv
Accessing WARC files via SQL
Ranking the top subdomains using Rapid 7’s Sonar FDNS dataset
GitHub - speee/go-athena: Golang database/sql driver for AWS Athena
Shift Left Join: Using Shodan to test AWS Public IPs | Blog | Steampipe
Simple ETL using Apache Spark & PostgreSQL
GitHub - haochi/jql.js: Query JSON data in a SQL manner
Know. Before it matters
GitHub - commoncrawl/cc-index-table: Index Common Crawl archives in tabular format
PySpark SQL Recipes PDF | FREE Programming PDF eBooks
GitHub - google/sqlcommenter
GitHub - RhinoSecurityLabs/SleuthQL: Python3 Burp History parsing tool to discover potential SQL injection points. To be used in tandem with SQLmap.
{{#tags}}- {{label}}
{{/tags}}