How Octopus uses RavenDB

Paul Stovell describes his transition from using SQL Server to RavenDB for Octopus Deploy, highlighting the limitations he faced with SQL Server in terms of database complexity and installation issues. He found SQL Server's rigid structure constrained feature development and complicated the installation process for his deployment automation product. In contrast, RavenDB, with its document-oriented model, offered a more natural fit for their domain, simplifying both database design and the installation process. RavenDB's flexibility allowed him to focus on application needs without worrying about complex joins or intermediary tables, and its embedded nature facilitated easier communication between the Octopus Server and web instances. Stovell also appreciated RavenDB's implicit indexing and effective caching, which improved performance without the need for complex cache invalidation strategies. He concludes that while SQL Server still has its place, RavenDB better suited the needs of Octopus Deploy, and he expresses a preference for document databases over relational models for similar applications.