{"id":1716,"date":"2021-04-11T13:42:04","date_gmt":"2021-04-11T12:42:04","guid":{"rendered":"https:\/\/adavault.com\/?p=1716"},"modified":"2021-04-11T13:57:14","modified_gmt":"2021-04-11T12:57:14","slug":"cardano-metrics-e1-259","status":"publish","type":"post","link":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/","title":{"rendered":"Cardano Metrics E1-259"},"content":{"rendered":"\n

We’ve been messing around with Cardano-db-sync<\/a> which puts the entire block chain into a Postgres SQL database instance, and means you can easily access via SQL or PostgREST. This will allow us to start offering some better realtime stats for our delegators, and lay the foundations for some services we are planning to develop.<\/p>\n\n\n\n

As a byproduct we took a few minutes out to put some data into a spreadsheet and this simple view of total transactions per epoch, total fees per epoch, and total value transferred tells a compelling growth story.<\/p>\n\n\n\n

It’s a log plot, and we added some trend lines so you easily see the growth in the 2 key areas- total transactions, and total fees.<\/p>\n\n\n\n

You might remember our arguments about Metcalfe’s law<\/a> a while back, and why these are such strong indicators of growth in utility.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

We’ve been messing around with Cardano-db-sync which puts the entire block chain into a Postgres SQL database instance, and means you can easily access via SQL or PostgREST. This will allow us to start offering some better realtime stats for our delegators, and lay the foundations for some services we are planning to develop. As…<\/p>\n","protected":false},"author":1,"featured_media":1717,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[6],"tags":[199,110,198],"class_list":["post-1716","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-musings","tag-cardano-db-sync","tag-metcalfe","tag-metrics"],"yoast_head":"\nCardano Metrics E1-259 - ADAvault<\/title>\n<meta name=\"description\" content=\"The ADAvault blog\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cardano Metrics E1-259 - ADAvault\" \/>\n<meta property=\"og:description\" content=\"The ADAvault blog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\" \/>\n<meta property=\"og:site_name\" content=\"ADAvault\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-11T12:42:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-11T12:57:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3247\" \/>\n\t<meta property=\"og:image:height\" content=\"1972\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@adavaultops\" \/>\n<meta name=\"twitter:site\" content=\"@adavaultops\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\/\/dev.adavault.com\/#\/schema\/person\/49b7a35bfadc7aa22c3643a455a1f179\"},\"headline\":\"Cardano Metrics E1-259\",\"datePublished\":\"2021-04-11T12:42:04+00:00\",\"dateModified\":\"2021-04-11T12:57:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\"},\"wordCount\":146,\"publisher\":{\"@id\":\"https:\/\/dev.adavault.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png\",\"keywords\":[\"cardano-db-sync\",\"Metcalfe\",\"Metrics\"],\"articleSection\":[\"Musings\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\",\"url\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\",\"name\":\"Cardano Metrics E1-259 - ADAvault\",\"isPartOf\":{\"@id\":\"https:\/\/dev.adavault.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png\",\"datePublished\":\"2021-04-11T12:42:04+00:00\",\"dateModified\":\"2021-04-11T12:57:14+00:00\",\"description\":\"The ADAvault blog\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage\",\"url\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png\",\"contentUrl\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png\",\"width\":3247,\"height\":1972},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.adavault.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cardano Metrics E1-259\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.adavault.com\/#website\",\"url\":\"https:\/\/dev.adavault.com\/\",\"name\":\"ADAvault\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/dev.adavault.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.adavault.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dev.adavault.com\/#organization\",\"name\":\"ADAvault.com\",\"url\":\"https:\/\/dev.adavault.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/dev.adavault.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2020\/10\/cropped-logo-wp-top-2.png\",\"contentUrl\":\"https:\/\/dev.adavault.com\/wp-content\/uploads\/2020\/10\/cropped-logo-wp-top-2.png\",\"width\":512,\"height\":512,\"caption\":\"ADAvault.com\"},\"image\":{\"@id\":\"https:\/\/dev.adavault.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/adavaultops\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dev.adavault.com\/#\/schema\/person\/49b7a35bfadc7aa22c3643a455a1f179\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/dev.adavault.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cab5b4ef880b9b0561c19eeea56044b2fad250d084091ecd4feb7e8faf92d61f?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cab5b4ef880b9b0561c19eeea56044b2fad250d084091ecd4feb7e8faf92d61f?s=96&d=retro&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\/\/adavault.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cardano Metrics E1-259 - ADAvault","description":"The ADAvault 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:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/","og_locale":"en_GB","og_type":"article","og_title":"Cardano Metrics E1-259 - ADAvault","og_description":"The ADAvault blog","og_url":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/","og_site_name":"ADAvault","article_published_time":"2021-04-11T12:42:04+00:00","article_modified_time":"2021-04-11T12:57:14+00:00","og_image":[{"width":3247,"height":1972,"url":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png","type":"image\/png"}],"author":"webmaster","twitter_card":"summary_large_image","twitter_creator":"@adavaultops","twitter_site":"@adavaultops","twitter_misc":{"Written by":"webmaster","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#article","isPartOf":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/"},"author":{"name":"webmaster","@id":"https:\/\/dev.adavault.com\/#\/schema\/person\/49b7a35bfadc7aa22c3643a455a1f179"},"headline":"Cardano Metrics E1-259","datePublished":"2021-04-11T12:42:04+00:00","dateModified":"2021-04-11T12:57:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/"},"wordCount":146,"publisher":{"@id":"https:\/\/dev.adavault.com\/#organization"},"image":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png","keywords":["cardano-db-sync","Metcalfe","Metrics"],"articleSection":["Musings"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/","url":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/","name":"Cardano Metrics E1-259 - ADAvault","isPartOf":{"@id":"https:\/\/dev.adavault.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage"},"image":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png","datePublished":"2021-04-11T12:42:04+00:00","dateModified":"2021-04-11T12:57:14+00:00","description":"The ADAvault blog","breadcrumb":{"@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#primaryimage","url":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png","contentUrl":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2021\/04\/Cardano-Metrics-E1-259.png","width":3247,"height":1972},{"@type":"BreadcrumbList","@id":"https:\/\/dev.adavault.com\/index.php\/2021\/04\/11\/cardano-metrics-e1-259\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.adavault.com\/"},{"@type":"ListItem","position":2,"name":"Cardano Metrics E1-259"}]},{"@type":"WebSite","@id":"https:\/\/dev.adavault.com\/#website","url":"https:\/\/dev.adavault.com\/","name":"ADAvault","description":"","publisher":{"@id":"https:\/\/dev.adavault.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.adavault.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/dev.adavault.com\/#organization","name":"ADAvault.com","url":"https:\/\/dev.adavault.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/dev.adavault.com\/#\/schema\/logo\/image\/","url":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2020\/10\/cropped-logo-wp-top-2.png","contentUrl":"https:\/\/dev.adavault.com\/wp-content\/uploads\/2020\/10\/cropped-logo-wp-top-2.png","width":512,"height":512,"caption":"ADAvault.com"},"image":{"@id":"https:\/\/dev.adavault.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/adavaultops"]},{"@type":"Person","@id":"https:\/\/dev.adavault.com\/#\/schema\/person\/49b7a35bfadc7aa22c3643a455a1f179","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/dev.adavault.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cab5b4ef880b9b0561c19eeea56044b2fad250d084091ecd4feb7e8faf92d61f?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cab5b4ef880b9b0561c19eeea56044b2fad250d084091ecd4feb7e8faf92d61f?s=96&d=retro&r=g","caption":"webmaster"},"sameAs":["https:\/\/adavault.com"]}]}},"_links":{"self":[{"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/posts\/1716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/comments?post=1716"}],"version-history":[{"count":3,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/posts\/1716\/revisions"}],"predecessor-version":[{"id":1720,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/posts\/1716\/revisions\/1720"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/media\/1717"}],"wp:attachment":[{"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/media?parent=1716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/categories?post=1716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.adavault.com\/index.php\/wp-json\/wp\/v2\/tags?post=1716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}