{"id":9338,"date":"2025-10-13T15:50:53","date_gmt":"2025-10-13T15:50:53","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=9338"},"modified":"2025-10-13T15:50:53","modified_gmt":"2025-10-13T15:50:53","slug":"decathlon-dblinter-a-static-analysis-tool-for-postgresql-databases","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/9338\/","title":{"rendered":"Decathlon\/dblinter: A static analysis tool for postgresql databases"},"content":{"rendered":"\n<\/p>\n<div id=\"\">\n<p dir=\"auto\">Static conformity is largely used in the dev world but there is no such tool for databases schemas.<br \/>\nThis tool connect to a postgres database to check good practices in schema design and output a file in <a target=\"_blank\" href=\"https:\/\/docs.oasis-open.org\/sarif\/sarif\/v2.1.0\/sarif-v2.1.0.html\" rel=\"nofollow\">Sarif<\/a> format.<br \/>\nA configuration file describe the rule to enforce and acceptable threshold<\/p>\n<p dir=\"auto\">An example of the output is: <a target=\"_blank\" target=\"_blank\" rel=\"noopener noreferrer\" href=\"https:\/\/github.com\/Decathlon\/dblinter\/blob\/main\/docs\/dblinter-output.png\"><img decoding=\"async\" src=\"https:\/\/github.com\/Decathlon\/dblinter\/raw\/main\/docs\/dblinter-output.png\" alt=\"dblinter output\" style=\"max-width: 100%;\"\/><\/a><\/p>\n<p dir=\"auto\">You can use the docker image if you prefer not to install python on your computer.<\/p>\n<p dir=\"auto\">Launch the docker image<\/p>\n<div class=\"highlight highlight-source-shell notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"docker run --rm -t decathlon\/dblinter:latest  --dbname $PGDATABASE --host $PGHOST --user $PGUSER --password $PGPASSWORD --port $PGPORT\">\n<pre>docker run --rm -t decathlon\/dblinter:latest  --dbname <span class=\"pl-smi\">$PGDATABASE<\/span> --host <span class=\"pl-smi\">$PGHOST<\/span> --user <span class=\"pl-smi\">$PGUSER<\/span> --password <span class=\"pl-smi\">$PGPASSWORD<\/span> --port <span class=\"pl-smi\">$PGPORT<\/span><\/pre>\n<\/div>\n<p dir=\"auto\">You can launch dblinter directly from the source code. You will need python and poetry to install the dependencies:<\/p>\n<div class=\"highlight highlight-source-shell notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"# Install poetry&#10;curl -sSL https:\/\/install.python-poetry.org | python3 -&#10;# Install dependencies&#10;poetry install --with dev&#10;# Launch the program&#10;poetry run python -m dblinter --dbname $PGDATABASE --host $PGHOST --user $PGUSER --password $PGPASSWORD --port $PGPORT\">\n<pre><span class=\"pl-c\"><span class=\"pl-c\">#<\/span> Install poetry<\/span>\ncurl -sSL https:\/\/install.python-poetry.org <span class=\"pl-k\">|<\/span> python3 -\n<span class=\"pl-c\"><span class=\"pl-c\">#<\/span> Install dependencies<\/span>\npoetry install --with dev\n<span class=\"pl-c\"><span class=\"pl-c\">#<\/span> Launch the program<\/span>\npoetry run python -m dblinter --dbname <span class=\"pl-smi\">$PGDATABASE<\/span> --host <span class=\"pl-smi\">$PGHOST<\/span> --user <span class=\"pl-smi\">$PGUSER<\/span> --password <span class=\"pl-smi\">$PGPASSWORD<\/span> --port <span class=\"pl-smi\">$PGPORT<\/span><\/pre>\n<\/div>\n<div class=\"highlight highlight-source-shell notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"&#10; Usage: python -m dblinter [OPTIONS]&#10;&#10;\u256d\u2500 Options \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256e&#10;\u2502 *  --user      -U      TEXT                                                 pg username [env var: PGUSER] [default: None]         \u2502&#10;\u2502                                                                             [required]                                            \u2502&#10;\u2502 *  --password  -W      TEXT                                                 pg pwd     [env var: PGPASSWORD] [default: None]      \u2502&#10;\u2502                                                                             [required]                                            \u2502&#10;\u2502 *  --host      -h      TEXT                                                 pg hostname [env var: PGHOST] [default: None]         \u2502&#10;\u2502                                                                             [required]                                            \u2502&#10;\u2502    --port      -p      TEXT                                                 pg port [env var: PGPORT] [default: 5432]             \u2502&#10;\u2502 *  --dbname    -d      TEXT                                                 pg dbname  [env var: PGDATABASE] [default: None]      \u2502&#10;\u2502                                                                             [required]                                            \u2502&#10;\u2502    --sslmode   -s      [allow|prefer|require|verify-ca|verify-full|simple|  pg sslmode                 [env var: PGSSLMODE]       \u2502&#10;\u2502                        disable]                                             [default: SslMode.disable]                            \u2502&#10;\u2502    --describe  -b      TEXT                                                 describe is added in sarif invocation field           \u2502&#10;\u2502                                                                             [default: None]                                       \u2502&#10;\u2502    --filename  -f      TEXT                                                 rules configuration file                              \u2502&#10;\u2502    --append    -a                                                           sarif report is append to output file [default: True] \u2502&#10;\u2502    --output    -o      TEXT                                                 report output file [default: None]                    \u2502&#10;\u2502    --loglevel  -l      [DEBUG|INFO|WARNING|ERROR|CRITICAL]                  log level [default: LogLevels.warning]                \u2502&#10;\u2502    --schema    -n      TEXT                                                 tables in schema only filter                          \u2502&#10;\u2502    --exclude   -x      TEXT                                                 Exclude table filter                                  \u2502&#10;\u2502    --include   -i      TEXT                                                 Include table filter                                  \u2502&#10;\u2502    --quiet     -q                                                           Quiet mode [env var:QUIET]                            \u2502&#10;\u2502    --help                                                                   Show this message and exit.                           \u2502&#10;\u2570\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256f&#10;\">\n<pre> Usage: python -m dblinter [OPTIONS]\n\n\u256d\u2500 Options \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256e\n\u2502 <span class=\"pl-k\">*<\/span>  --user      -U      TEXT                                                 pg username [env var: PGUSER] [default: None]         \u2502\n\u2502                                                                             [required]                                            \u2502\n\u2502 <span class=\"pl-k\">*<\/span>  --password  -W      TEXT                                                 pg <span class=\"pl-c1\">pwd<\/span>     [env var: PGPASSWORD] [default: None]      \u2502\n\u2502                                                                             [required]                                            \u2502\n\u2502 <span class=\"pl-k\">*<\/span>  --host      -h      TEXT                                                 pg hostname [env var: PGHOST] [default: None]         \u2502\n\u2502                                                                             [required]                                            \u2502\n\u2502    --port      -p      TEXT                                                 pg port [env var: PGPORT] [default: 5432]             \u2502\n\u2502 <span class=\"pl-k\">*<\/span>  --dbname    -d      TEXT                                                 pg dbname  [env var: PGDATABASE] [default: None]      \u2502\n\u2502                                                                             [required]                                            \u2502\n\u2502    --sslmode   -s      [allow<span class=\"pl-k\">|<\/span>prefer<span class=\"pl-k\">|<\/span>require<span class=\"pl-k\">|<\/span>verify-ca<span class=\"pl-k\">|<\/span>verify-full<span class=\"pl-k\">|<\/span>simple<span class=\"pl-k\">|<\/span>  pg sslmode                 [env var: PGSSLMODE]       \u2502\n\u2502                        disable]                                             [default: SslMode.disable]                            \u2502\n\u2502    --describe  -b      TEXT                                                 describe is added <span class=\"pl-k\">in<\/span> sarif invocation field           \u2502\n\u2502                                                                             [default: None]                                       \u2502\n\u2502    --filename  -f      TEXT                                                 rules configuration file                              \u2502\n\u2502    --append    -a                                                           sarif report is append to output file [default: True] \u2502\n\u2502    --output    -o      TEXT                                                 report output file [default: None]                    \u2502\n\u2502    --loglevel  -l      [DEBUG<span class=\"pl-k\">|<\/span>INFO<span class=\"pl-k\">|<\/span>WARNING<span class=\"pl-k\">|<\/span>ERROR<span class=\"pl-k\">|<\/span>CRITICAL]                  log level [default: LogLevels.warning]                \u2502\n\u2502    --schema    -n      TEXT                                                 tables <span class=\"pl-k\">in<\/span> schema only filter                          \u2502\n\u2502    --exclude   -x      TEXT                                                 Exclude table filter                                  \u2502\n\u2502    --include   -i      TEXT                                                 Include table filter                                  \u2502\n\u2502    --quiet     -q                                                           Quiet mode [env var:QUIET]                            \u2502\n\u2502    --help                                                                   Show this message and exit.                           \u2502\n\u2570\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256f\n<\/pre>\n<\/div>\n<p dir=\"auto\">We welcome contributions from the community. For more details on contributing to the project (including requirements), please refer to &#8220;<a target=\"_blank\" href=\"https:\/\/github.com\/Decathlon\/dblinter\/blob\/main\/CONTRIBUTING.md\">Getting Started with Contributing<\/a>.&#8221;<\/p>\n<\/div>\n\n<br \/><a href=\"https:\/\/github.com\/Decathlon\/dblinter\">\u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Static conformity is largely used in the dev world but there is no such tool for databases schemas. This tool  [&hellip;]","protected":false},"author":1,"featured_media":9339,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9338","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hatena-blog"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Decathlon\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/github.com\/Decathlon\/dblinter\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Decathlon\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"og:description\" content=\"Static conformity is largely used in the dev world but there is no such tool for databases schemas. This tool [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/github.com\/Decathlon\/dblinter\" \/>\n<meta property=\"og:site_name\" content=\"\u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-13T15:50:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"info@pokecon.jp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"info@pokecon.jp\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/9338\\\/\"},\"author\":{\"name\":\"info@pokecon.jp\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"headline\":\"Decathlon\\\/dblinter: A static analysis tool for postgresql databases\",\"datePublished\":\"2025-10-13T15:50:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/9338\\\/\"},\"wordCount\":129,\"image\":{\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/dblinter.png\",\"articleSection\":[\"\u306f\u3066\u306a\u30d6\u30ed\u30b0\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/9338\\\/\",\"url\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter\",\"name\":\"Decathlon\\\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/dblinter.png\",\"datePublished\":\"2025-10-13T15:50:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#primaryimage\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/dblinter.png\",\"contentUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/dblinter.png\",\"width\":1200,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/github.com\\\/Decathlon\\\/dblinter#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Decathlon\\\/dblinter: A static analysis tool for postgresql databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\",\"name\":\"\u30dd\u30b1\u30b3\u30f3\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\",\"name\":\"info@pokecon.jp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"caption\":\"info@pokecon.jp\"},\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/author\\\/infopokecon-jp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Decathlon\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/github.com\/Decathlon\/dblinter","og_locale":"ja_JP","og_type":"article","og_title":"Decathlon\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3","og_description":"Static conformity is largely used in the dev world but there is no such tool for databases schemas. This tool [&hellip;]","og_url":"https:\/\/github.com\/Decathlon\/dblinter","og_site_name":"\u30dd\u30b1\u30b3\u30f3","article_published_time":"2025-10-13T15:50:53+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png","type":"image\/png"}],"author":"info@pokecon.jp","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"info@pokecon.jp","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"2\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/github.com\/Decathlon\/dblinter#article","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/9338\/"},"author":{"name":"info@pokecon.jp","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"headline":"Decathlon\/dblinter: A static analysis tool for postgresql databases","datePublished":"2025-10-13T15:50:53+00:00","mainEntityOfPage":{"@id":"https:\/\/pokecon.jp\/job\/9338\/"},"wordCount":129,"image":{"@id":"https:\/\/github.com\/Decathlon\/dblinter#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png","articleSection":["\u306f\u3066\u306a\u30d6\u30ed\u30b0"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/pokecon.jp\/job\/9338\/","url":"https:\/\/github.com\/Decathlon\/dblinter","name":"Decathlon\/dblinter: A static analysis tool for postgresql databases - \u30dd\u30b1\u30b3\u30f3","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/#website"},"primaryImageOfPage":{"@id":"https:\/\/github.com\/Decathlon\/dblinter#primaryimage"},"image":{"@id":"https:\/\/github.com\/Decathlon\/dblinter#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png","datePublished":"2025-10-13T15:50:53+00:00","author":{"@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"breadcrumb":{"@id":"https:\/\/github.com\/Decathlon\/dblinter#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/github.com\/Decathlon\/dblinter"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/github.com\/Decathlon\/dblinter#primaryimage","url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png","contentUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/dblinter.png","width":1200,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/github.com\/Decathlon\/dblinter#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/pokecon.jp\/job\/"},{"@type":"ListItem","position":2,"name":"Decathlon\/dblinter: A static analysis tool for postgresql databases"}]},{"@type":"WebSite","@id":"https:\/\/pokecon.jp\/job\/#website","url":"https:\/\/pokecon.jp\/job\/","name":"\u30dd\u30b1\u30b3\u30f3","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pokecon.jp\/job\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997","name":"info@pokecon.jp","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","caption":"info@pokecon.jp"},"url":"https:\/\/pokecon.jp\/job\/author\/infopokecon-jp\/"}]}},"_links":{"self":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/9338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/comments?post=9338"}],"version-history":[{"count":1,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/9338\/revisions"}],"predecessor-version":[{"id":9340,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/9338\/revisions\/9340"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media\/9339"}],"wp:attachment":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media?parent=9338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/categories?post=9338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/tags?post=9338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}