{"id":7184,"date":"2016-06-28T20:47:37","date_gmt":"2016-06-28T18:47:37","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=7184"},"modified":"2023-11-07T23:00:01","modified_gmt":"2023-11-07T22:00:01","slug":"trivadis-plsql-sql-coding-guidelines-version-3-1","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/","title":{"rendered":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1"},"content":{"rendered":"\n

The latest version 3.1<\/a> of the Trivadis PL\/SQL & SQL Coding Guidelines has 150 pages. More than 90\u00a0additional pages compared to version 2.0<\/a>. Roger Troller did a tremendous job in updating and extending an already comprehensive document while making it simpler to read and easier to understand. In this post, I will emphasise some changes I consider relevant.<\/p>\n\n\n\n

New Guideline Categorisation Scheme<\/h2>\n\n\n\n

In version 2.0<\/a> coding guidelines are categorised by icons for information, caution, performance relevance, maintainability and readability. A guideline is associated exactly with one icon. Here’s an example:<\/p>\n\n\n\n

\"guideline_12\"<\/a><\/figure>\n\n\n\n

In version 3.1<\/a> the characteristics for changeability, efficiency, maintainability, portability, reliability, reusability, security and testability as defined by the Software Quality Assessment based on Lifecycle Expectations<\/a> (SQALE) methodology are used to categorise guidelines. A guideline is associated with one or more SQALE characteristics. Additionally a guideline is assigned to a severity (blocker, critical, major, minor, info). So guidelines are categorised in two dimensions: SQALE characteristics and severity. These categorisations are used to filter guidelines in SonarQube or PL\/SQL Cop to be enabled or disabled. It’s not by chance that SonarQube is using exactly these categorisations.<\/p>\n\n\n\n

Here’s the same example as above using this new guideline categorisation scheme:<\/p>\n\n\n\n

\"guideline_2150\"<\/a><\/figure>\n\n\n\n

In this excerpt, you see other changes as well. The reference to the CodeXpert rule is gone, guideline 12 got a new identifier\u00a02150 and there is a good and bad example.<\/p>\n\n\n\n

Good and Bad Examples for Every Guideline<\/h2>\n\n\n\n

In version 2.0 some guidelines had no examples, some just an excerpt of an example, some just a good and some just a bad example. Now in version 3.1<\/a> almost every\u00a0guideline has a complete bad and a complete good example. By complete I mean that they are executable in SQL*Plus, SQLcl or within your\u00a0IDE of choice. Why “almost”? For example, there is this guideline 65\/7210 which says “Try to keep your packages small. Include only a few procedures and functions that are used in the same context”. So, in some cases, it is just not feasible\/helpful to include a complete example.<\/p>\n\n\n\n

For me as the guy who is responsible for writing rules to check the compliance of\u00a0the guidelines, good and bad examples are essential for unit testing. Such examples also help the developer to understand guidelines. That’s why we include\u00a0these examples in PL\/SQL Cop.<\/p>\n\n\n\n

New Guidelines<\/h2>\n\n\n\n

Besides some changes in the categorisation and presentation of the guidelines, there are some new guidelines which I’d like to mention here:<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
ID<\/th>Guideline<\/th>Severity<\/th>SQALE Characteristics<\/th>\n<\/tr>\n<\/thead>\n
2230<\/td>Try to use SIMPLE_INTEGER datatype when appropriate.<\/td>Minor<\/td>Efficiency<\/td>\n<\/tr>\n
3150<\/td>Try to use identity columns for surrogate keys.<\/td>Minor<\/td>Maintainability, Reliability<\/td>\n<\/tr>\n
3160<\/td>Avoid virtual columns to be visible.<\/td>Major<\/td>Maintainability, Reliability<\/td>\n<\/tr>\n
3170<\/td>Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.<\/td>Major<\/td>Reliability<\/td>\n<\/tr>\n
3180<\/td>Always specify column names instead of positional references in ORDER BY clauses.<\/td>Major<\/td>Changeability, Reliability<\/td>\n<\/tr>\n
3190<\/td>Avoid using NATURAL JOIN.<\/td>Major<\/td>Changeability, Reliability<\/td>\n<\/tr>\n
5010<\/td>Try to use a error\/logging framework for your application.<\/td>Critical<\/td>Reliability, Reusability, Testability<\/td>\n<\/tr>\n
7460<\/td>Try to define your packaged\/standalone function to be deterministic if appropriate.<\/td>Major<\/td>Efficiency<\/td>\n<\/tr>\n
7810<\/td>Do not use SQL inside PL\/SQL to read sequence numbers (or SYSDATE)<\/td>Major<\/td>Efficiency, Maintainability<\/td>\n<\/tr>\n
8120<\/td>Never check existence of a row to decide whether to create it or not.<\/td>Major<\/td>Efficiency, Reliability<\/td>\n<\/tr>\n
8310<\/td>Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.<\/td>Minor<\/td>Maintainability, Reliability, Reusability, Testability<\/td>\n<\/tr>\n
8410<\/td>Always use application locks to ensure a program unit only running once at a given time.<\/td>Minor<\/td>Efficiency, Reliability<\/td>\n<\/tr>\n
8510<\/td>Always use dbms_application_info to track programm process transiently<\/td>Minor<\/td>Efficiency, Reliability<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n

Deprecated Guidelines<\/h2>\n\n\n\n

Guideline 54 “Avoid use of EXCEPTION_INIT pragma for a -20,NNN error” is not part of the document anymore.<\/p>\n\n\n\n

New Guideline Identifiers<\/h2>\n\n\n\n

All guidelines got a new identifier. The first digit identifies the chapter of the document, e.g. “1” for “4.1 General”, “2” for “4.2 Variables & Types”,  etc. The second digit is reserved for the sub-chapters and the remaining digits are just for ordering purposes. The gaps in the numbering scheme should allow to add future guidelines at the right place without renumbering everything (again).<\/p>\n\n\n\n

There is an appendix to map old guideline identifiers to new ones. This should simplify the change to version 3.1<\/a>. Here’s an excerpt:<\/p>\n\n\n\n

\"appendix_a\"<\/a><\/figure>\n\n\n\n

Tool Support<\/h2>\n\n\n\n

PL\/SQL Cop is mentioned in the guidelines. However, currently, only the Trivadis PL\/SQL & SQL Guidelines Version 2.0 are supported. But sometime in Q4 of 2016, an update supporting version 3.1<\/a> should be available.<\/p>\n\n\n\n

Download<\/h2>\n\n\n\n

Get your copy of the Trivadis PL\/SQL & SQL Guidelines Version 3.1<\/a> from here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

The latest version 3.1 of the Trivadis PL\/SQL & SQL Coding Guidelines has 150 pages. More than 90\u00a0additional pages compared to version 2.0. Roger Troller did a tremendous job in updating and extending an already comprehensive document while making it simpler to read and easier to understand. In this post, I will [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":9531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[13,92,85],"class_list":["post-7184","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-plsql","tag-plsql-cop","tag-sql"],"yoast_head":"\nTrivadis PL\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog<\/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:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"The latest version 3.1 of the Trivadis PL\/SQL & SQL Coding Guidelines has 150 pages. More than 90\u00a0additional pages compared to version 2.0. Roger Troller did a tremendous job in updating and extending an already comprehensive document while making it simpler to read and easier to understand. In this post, I will [\u2026]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-28T18:47:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-07T22:00:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png\" \/>\n\t<meta property=\"og:image:width\" content=\"753\" \/>\n\t<meta property=\"og:image:height\" content=\"551\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Trivadis PL\\\/SQL & SQL Coding Guidelines Version 3.1\",\"datePublished\":\"2016-06-28T18:47:37+00:00\",\"dateModified\":\"2023-11-07T22:00:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/\"},\"wordCount\":583,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/plsql_sql_guidelines.png\",\"keywords\":[\"PL\\\/SQL\",\"PL\\\/SQL Cop\",\"SQL\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/\",\"name\":\"Trivadis PL\\\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/plsql_sql_guidelines.png\",\"datePublished\":\"2016-06-28T18:47:37+00:00\",\"dateModified\":\"2023-11-07T22:00:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/plsql_sql_guidelines.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/plsql_sql_guidelines.png\",\"width\":753,\"height\":551},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2016\\\/06\\\/28\\\/trivadis-plsql-sql-coding-guidelines-version-3-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trivadis PL\\\/SQL & SQL Coding Guidelines Version 3.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog","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:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/","og_locale":"en_US","og_type":"article","og_title":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog","og_description":"The latest version 3.1 of the Trivadis PL\/SQL & SQL Coding Guidelines has 150 pages. More than 90\u00a0additional pages compared to version 2.0. Roger Troller did a tremendous job in updating and extending an already comprehensive document while making it simpler to read and easier to understand. In this post, I will [\u2026]","og_url":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2016-06-28T18:47:37+00:00","article_modified_time":"2023-11-07T22:00:01+00:00","og_image":[{"width":753,"height":551,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1","datePublished":"2016-06-28T18:47:37+00:00","dateModified":"2023-11-07T22:00:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/"},"wordCount":583,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png","keywords":["PL\/SQL","PL\/SQL Cop","SQL"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/","url":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/","name":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1 - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png","datePublished":"2016-06-28T18:47:37+00:00","dateModified":"2023-11-07T22:00:01+00:00","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2017\/02\/plsql_sql_guidelines.png","width":753,"height":551},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2016\/06\/28\/trivadis-plsql-sql-coding-guidelines-version-3-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Trivadis PL\/SQL & SQL Coding Guidelines Version 3.1"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/7184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=7184"}],"version-history":[{"count":28,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/7184\/revisions"}],"predecessor-version":[{"id":12600,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/7184\/revisions\/12600"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/9531"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=7184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=7184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=7184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}