{"id":16601,"date":"2024-01-18T17:42:37","date_gmt":"2024-01-18T15:42:37","guid":{"rendered":"https:\/\/connectconsulting.be\/?p=16601"},"modified":"2024-06-24T15:55:41","modified_gmt":"2024-06-24T13:55:41","slug":"aws-aurora-postgress","status":"publish","type":"post","link":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/","title":{"rendered":"AWS Aurora Postgress"},"content":{"rendered":"<p>We zijn steeds op zoek naar interessante onderwerpen voor onze Community avonden. Vaak moeten we niet al te ver zoeken en vinden we deze bij onze Connectors!<\/p>\n<p>Voor onze laatste community waren we zoekend naar een actueel onderwerp dat zowel voor onze Javanen als Dotnetters interessant zou zijn. Uiteindelijk kwamen we samen uit op de deploy en implementatie van een AWS Aurora PostgresSql-database.<\/p>\n<p>Wouter vertelde over zijn real-life ervaringen op project in verband met AWS Aurora PostgresSql-database en hoe zij hiermee aan de slag zijn gegaan.<\/p>\n<p>Waarom de keuze werd gemaakt voor PostgresSql kwam vanwege de reeds bestaande integratie met AWS. Komende van on-prem MS Sql leek sql-in-the-cloud de optimale keuze, ware het niet het grote prijsverschil tussen beide.<\/p>\n<p>Via Terraform maakten ze een nieuwe database-cluster aan, dit door het inloggen via Kubectl waarbij ze vervolgens hun tabellen hebben opgesteld.<\/p>\n<p>Uiteindelijk werd er gekozen voor een AM-security met automatic password-rotation. De bewuste keuze hiervoor was, dat dit het verhaal veiliger maakte. Echter bleek al snel dat de werking hiervan toch wat complexer was.<br \/>\nEnerzijds werkte dit verhaal enkel in hun Kubernetes en moesten ze op zoek naar een lokale paralelle oplossing. Deze paralelle oplossing vonden ze in Docker-Compose.<br \/>\nAnderzijds hebben ze de problematiek van dynamische connectionstrings vanwege de wijzigende wachtwoorden. Na wat uitzoekwerk kwamen ze terecht Entity Framework DataSource-builders met refresh-callback-functionaliteit. Dit deed hen migreren naar .Net 7, waarmee uiteindelijk wel verder aan de slag mee kon, worden gaan.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We zijn steeds op zoek naar interessante onderwerpen voor onze Community avonden. Vaak moeten we niet al te ver zoeken en vinden we deze bij onze Connectors! Voor onze laatste community waren we zoekend naar een actueel onderwerp dat zowel voor onze Javanen als Dotnetters interessant zou zijn. Uiteindelijk kwamen<span class=\"more-dots\">&#8230;<\/span><\/p>\n","protected":false},"author":2,"featured_media":16602,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[214,240],"tags":[271,235],"class_list":["post-16601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-ict","tag-aws-aurora-postgress","tag-connect-consulting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application<\/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:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application\" \/>\n<meta property=\"og:description\" content=\"We zijn steeds op zoek naar interessante onderwerpen voor onze Community avonden. Vaak moeten we niet al te ver zoeken en vinden we deze bij onze Connectors! Voor onze laatste community waren we zoekend naar een actueel onderwerp dat zowel voor onze Javanen als Dotnetters interessant zou zijn. Uiteindelijk kwamen...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/\" \/>\n<meta property=\"og:site_name\" content=\"Connect Consulting - ICT Careers | Infrastructure\/Application\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-18T15:42:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-24T13:55:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card-1024x726.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"726\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Emilie Cambier\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emilie Cambier\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/\"},\"author\":{\"name\":\"Emilie Cambier\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#\\\/schema\\\/person\\\/cc2cfe78fceb5d13383b490ab73ad225\"},\"headline\":\"AWS Aurora Postgress\",\"datePublished\":\"2024-01-18T15:42:37+00:00\",\"dateModified\":\"2024-06-24T13:55:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/\"},\"wordCount\":241,\"publisher\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"keywords\":[\"AWS Aurora Postgress\",\"Connect Consulting\"],\"articleSection\":[\"Blog\",\"ICT\"],\"inLanguage\":\"nl-NL\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/\",\"name\":\"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"datePublished\":\"2024-01-18T15:42:37+00:00\",\"dateModified\":\"2024-06-24T13:55:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#primaryimage\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"contentUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"width\":1748,\"height\":1240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/aws-aurora-postgress\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Aurora Postgress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#website\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/\",\"name\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#organization\",\"name\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo-black.png\",\"contentUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo-black.png\",\"width\":268,\"height\":118,\"caption\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/nl\\\/#\\\/schema\\\/person\\\/cc2cfe78fceb5d13383b490ab73ad225\",\"name\":\"Emilie Cambier\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","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:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/","og_locale":"nl_NL","og_type":"article","og_title":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","og_description":"We zijn steeds op zoek naar interessante onderwerpen voor onze Community avonden. Vaak moeten we niet al te ver zoeken en vinden we deze bij onze Connectors! Voor onze laatste community waren we zoekend naar een actueel onderwerp dat zowel voor onze Javanen als Dotnetters interessant zou zijn. Uiteindelijk kwamen...","og_url":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/","og_site_name":"Connect Consulting - ICT Careers | Infrastructure\/Application","article_published_time":"2024-01-18T15:42:37+00:00","article_modified_time":"2024-06-24T13:55:41+00:00","og_image":[{"width":1024,"height":726,"url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card-1024x726.png","type":"image\/png"}],"author":"Emilie Cambier","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Emilie Cambier","Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#article","isPartOf":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/"},"author":{"name":"Emilie Cambier","@id":"https:\/\/connectconsulting.be\/nl\/#\/schema\/person\/cc2cfe78fceb5d13383b490ab73ad225"},"headline":"AWS Aurora Postgress","datePublished":"2024-01-18T15:42:37+00:00","dateModified":"2024-06-24T13:55:41+00:00","mainEntityOfPage":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/"},"wordCount":241,"publisher":{"@id":"https:\/\/connectconsulting.be\/nl\/#organization"},"image":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#primaryimage"},"thumbnailUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","keywords":["AWS Aurora Postgress","Connect Consulting"],"articleSection":["Blog","ICT"],"inLanguage":"nl-NL"},{"@type":"WebPage","@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/","url":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/","name":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","isPartOf":{"@id":"https:\/\/connectconsulting.be\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#primaryimage"},"image":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#primaryimage"},"thumbnailUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","datePublished":"2024-01-18T15:42:37+00:00","dateModified":"2024-06-24T13:55:41+00:00","breadcrumb":{"@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#primaryimage","url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","contentUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","width":1748,"height":1240},{"@type":"BreadcrumbList","@id":"https:\/\/connectconsulting.be\/nl\/aws-aurora-postgress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/connectconsulting.be\/nl\/"},{"@type":"ListItem","position":2,"name":"AWS Aurora Postgress"}]},{"@type":"WebSite","@id":"https:\/\/connectconsulting.be\/nl\/#website","url":"https:\/\/connectconsulting.be\/nl\/","name":"Connect Consulting - ICT Careers | Infrastructure\/Application","description":"","publisher":{"@id":"https:\/\/connectconsulting.be\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/connectconsulting.be\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/connectconsulting.be\/nl\/#organization","name":"Connect Consulting - ICT Careers | Infrastructure\/Application","url":"https:\/\/connectconsulting.be\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/connectconsulting.be\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2023\/03\/logo-black.png","contentUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2023\/03\/logo-black.png","width":268,"height":118,"caption":"Connect Consulting - ICT Careers | Infrastructure\/Application"},"image":{"@id":"https:\/\/connectconsulting.be\/nl\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/connectconsulting.be\/nl\/#\/schema\/person\/cc2cfe78fceb5d13383b490ab73ad225","name":"Emilie Cambier"}]}},"_links":{"self":[{"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/posts\/16601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/comments?post=16601"}],"version-history":[{"count":1,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/posts\/16601\/revisions"}],"predecessor-version":[{"id":16605,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/posts\/16601\/revisions\/16605"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/media\/16602"}],"wp:attachment":[{"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/media?parent=16601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/categories?post=16601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/connectconsulting.be\/nl\/wp-json\/wp\/v2\/tags?post=16601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}