{"id":43,"date":"2008-12-13T22:23:41","date_gmt":"2008-12-13T22:23:41","guid":{"rendered":"http:\/\/oracle-internals.com\/blog\/?p=43"},"modified":"2014-01-26T22:24:33","modified_gmt":"2014-01-26T22:24:33","slug":"sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines","status":"publish","type":"post","link":"http:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/","title":{"rendered":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026"},"content":{"rendered":"<p>It\u2019s been quite awhile since I last wrote a blog entry. For that, I apologize. I\u2019ve been extremely busy at work and haven\u2019t been able to spend much time on Oracle stuff lately. Regardless, this is what I\u2019ve been up to and what you can expect to see soon.<\/p>\n<p><strong>SibylNet &amp; Unofficial Specification of the Oracle Network Protocol<\/strong><\/p>\n<p>Oracle has given me permission to proceed with releasing my open source client software for Oracle, SibylNet. As such, I\u2019ve been combining all of my past research into a single protocol specification and client library which I hope to release in Q1 2009.<\/p>\n<p><strong>Oracle vs. Postgres Benchmark<br \/>\n<\/strong><\/p>\n<p>To end a long-running dispute I\u2019ve had with the Postgres community regarding over-reliance on the operating system to achieve good database performance, I\u2019ve performed a comparison benchmark between Oracle8i Standard Edition (circa 1999) and Postgres 8.3\/8.4-dev (the latest version) on the exact same hardware. The results may or may not surprise you.<\/p>\n<p><strong>A Fast Password Cracker for Oracle<\/strong><\/p>\n<p>Years ago I had written a password cracker for Oracle8i\/9i, but had given up on it. Though, after playing with Laszlo Toth\u2019s woraauthbf awhile back, I decided to update mine to take full advantage of newer multi-core systems. After a bit of redesign, it now makes use of multi-threaded parallel processing, lock-free\/nearly-wait-free cache-optimized hash tables, and atomic locking. I now believe I have the world\u2019s fastest password cracker for Oracle\u2026 but I\u2019ll leave that to others to test. I\u2019m currently getting this re-ported to Windows and after letting a few select people test it, will release it as open source.<\/p>\n<p><strong>A three-part series of articles pertaining to database frontends for custom storage engines<\/strong><\/p>\n<p>In today\u2019s business environment, most companies prefer to buy software rather than build it. However, over the past year and a half, I\u2019ve been approached by three different companies looking for a good database frontend with which they could integrate their own internally-developed storage engines. As each of these companies ran into several of the same issues, I thought that this topic would make for a good series of articles not only for those generally interested in databases, but specifically those who may find themselves in the same situation. The three articles (and products mentioned) are as follows:<\/p>\n<ul>\n<li>Just What the Doctor Ordered (Dr. DeeBee Driver Kit)<\/li>\n<li>Swimming with the Dolphin (MySQL)<\/li>\n<li>An Elephant in the Room (Postgres)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>It\u2019s been quite awhile since I last wrote a blog entry. For that, I apologize. I\u2019ve been extremely busy at work and haven\u2019t been able to spend much time on Oracle stuff lately. Regardless, this is what I\u2019ve been up to and what you can expect to see soon. SibylNet &amp; Unofficial Specification of the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals<\/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:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals\" \/>\n<meta property=\"og:description\" content=\"It\u2019s been quite awhile since I last wrote a blog entry. For that, I apologize. I\u2019ve been extremely busy at work and haven\u2019t been able to spend much time on Oracle stuff lately. Regardless, this is what I\u2019ve been up to and what you can expect to see soon. SibylNet &amp; Unofficial Specification of the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Internals\" \/>\n<meta property=\"article:published_time\" content=\"2008-12-13T22:23:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-26T22:24:33+00:00\" \/>\n<meta name=\"author\" content=\"Jonah Harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:site\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonah Harris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\"},\"author\":{\"name\":\"Jonah Harris\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"headline\":\"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026\",\"datePublished\":\"2008-12-13T22:23:41+00:00\",\"dateModified\":\"2014-01-26T22:24:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\"},\"wordCount\":419,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\",\"url\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\",\"name\":\"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals\",\"isPartOf\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\"},\"datePublished\":\"2008-12-13T22:23:41+00:00\",\"dateModified\":\"2014-01-26T22:24:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/oracle-internals.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\",\"url\":\"http:\/\/oracle-internals.com\/blog\/\",\"name\":\"Oracle Internals\",\"description\":\"Researching the Inner Workings of the World&#039;s Most Powerful Database\",\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\",\"name\":\"Jonah Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"caption\":\"Jonah Harris\"},\"logo\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jonahharris\/\",\"https:\/\/x.com\/jonahharris\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals","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:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/","og_locale":"en_US","og_type":"article","og_title":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals","og_description":"It\u2019s been quite awhile since I last wrote a blog entry. For that, I apologize. I\u2019ve been extremely busy at work and haven\u2019t been able to spend much time on Oracle stuff lately. Regardless, this is what I\u2019ve been up to and what you can expect to see soon. SibylNet &amp; Unofficial Specification of the [&hellip;]","og_url":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/","og_site_name":"Oracle Internals","article_published_time":"2008-12-13T22:23:41+00:00","article_modified_time":"2014-01-26T22:24:33+00:00","author":"Jonah Harris","twitter_card":"summary_large_image","twitter_creator":"@jonahharris","twitter_site":"@jonahharris","twitter_misc":{"Written by":"Jonah Harris","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#article","isPartOf":{"@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/"},"author":{"name":"Jonah Harris","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"headline":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026","datePublished":"2008-12-13T22:23:41+00:00","dateModified":"2014-01-26T22:24:33+00:00","mainEntityOfPage":{"@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/"},"wordCount":419,"commentCount":0,"publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/","url":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/","name":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026 - Oracle Internals","isPartOf":{"@id":"http:\/\/oracle-internals.com\/blog\/#website"},"datePublished":"2008-12-13T22:23:41+00:00","dateModified":"2014-01-26T22:24:33+00:00","breadcrumb":{"@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/oracle-internals.com\/blog\/2008\/12\/13\/sibylnet-oraclepostgres-benchmark-password-cracker-for-oracle-storage-engines\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/oracle-internals.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SibylNet, Oracle\/Postgres Benchmark, Password Cracker for Oracle, Storage Engines\u2026"}]},{"@type":"WebSite","@id":"http:\/\/oracle-internals.com\/blog\/#website","url":"http:\/\/oracle-internals.com\/blog\/","name":"Oracle Internals","description":"Researching the Inner Workings of the World&#039;s Most Powerful Database","publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4","name":"Jonah Harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","caption":"Jonah Harris"},"logo":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/jonahharris\/","https:\/\/x.com\/jonahharris"]}]}},"_links":{"self":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/43"}],"collection":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":1,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":44,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/43\/revisions\/44"}],"wp:attachment":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}