Microsoft has taken a significant step towards blurring the lines between relational and NoSQL databases with its open-source PostgreSQL extension stack.
When Microsoft introduced an open source extension stack for PostgreSQL to handle document-style data, it wasn't just targeting MongoDB – the dominant NoSQL player – but also blurring the lines between relational and non- relational databases , according to one expert.
Despite the tech giant having built a multitrillion-dollar valuation largely on proprietary software, its latest move to back open source systems and compete in the document database market promises a schema-light approach popular with developers. \It has built pg_documentdb_core, a custom PostgreSQL extension that enables support for Binary JavaScript Object Notation (BSON, a binary-encoded serialization of JSON documents), and pg_documentdb_api, a data layer providing MongoDB-compatible commands for create, read, update and delete (CRUD) operations, queries, and index management. They are set to run on the Azure Cosmos DB PostgreSQL database service. Microsoft also notes that its extensions can be used with FerretDB, an open source MongoDB alternative. FerretDB claims its 2.0 version delivers up to 20x performance improvements for certain workloads over earlier versions, partly due to backend optimizations. \The move was another sign that document databases, classified as part of the NoSQL or non-relational database category, would become a feature of relational systems rather than a category on their own. 'The intellectual distance between document/JSON DBMSes and relational DBMSes is shrinking. At some point, the two system categories will be indistinguishable (at least in terms of the data model). The DocumentDB/FerretDB announcement is further evidence of this,' he said. 'All the NoSQL systems are becoming relational, except for Redis. They now expose a relational data model with support for nested data (for example, JSON). They also expose a SQL interface, but they can't get themselves to call it SQL for some reason. Instead, they give their query languages a different name – Cassandra has CQL and Aerospike has AQL – and claim it is 'inspired' by SQL. Even MongoDB added support for –, which requires any organization offering MongoDB as a service to release the source code of the entire service – and also offers proprietary licenses. Its claim to be a favorite among developers is not without justification as it ranks highly on the Stack Overflow survey and counts Wells Fargo bank, Sega, and L'Oréal among its customers. \A spokesperson at MongoDB said: 'The rise of MongoDB imitators proves our document model is the industry standard. But bolting an API onto a relational database isn't innovation – it's just kicking the complexity can down the road. These 'modern alternatives' come with a built-in sequel: the inevitable second migration when performance, scale, and flexibility hit a wall. Developers building modern, AI-powered applications don't have time for do-overs. MongoDB is purpose-built to get it right the first time.', CEO Peter Farkas said FerretDB wanted to work with Microsoft to achieve the long-term aim of building a 'more solid foundation for users to have a MongoDB alternative.' 'The goal with this is to work broadly among the providers of MongoDB alternatives and have more cooperation. After a while, they would have one solid foundation for MongoDB alternatives, which everybody could build on,' he said. The reason for building on PostgreSQL was that, like Pavlo, Farkas sees the NoSQL group of databases eventually becoming a feature of relational systems. 'From time to time, specialized databases appear on the market, and these would live independently for a good while, but then going by history, large databases like Oracle or PostgreSQL would start to support features, either at their core or through extensions like what we did with Microsoft,' he said. PostgreSQL began adding support for JSON documents in 2013 and has developed it ever since, but that is not enough to create a rival to MongoDB on its own, Farkas argued. 'With PostgreSQL, working with extensions is much easier than getting something into the core database. Even large enterprises like Microsoft may not be able to steer the PostgreSQL community in that way, but extensions provide a very similar experience to the user. It's not complicated to install a Postgres extension and use it alongside PostgreSQL and for now, the innovation with PostgreSQL happens through extensions,' he said. Meanwhile, MongoDB has introduced new data types and features that could not be supported by the current JSON functionality of PostgreSQL, Farkas said. 'It would not be possible to implement a performant MongoDB-compatible experience on top of the JSON support in PostgreSQL, and it was never a goal to become MongoDB-compatible.' Through the partnership with Microsoft, Farkas wants to create a developer-friendly experience for a document database without having to get their hands dirty with PostgreSQL itself
Microsoft Postgresql Mongodb Nosql Document Databases Open Source Relational Databases Azure Cosmos DB Ferretdb Software Database Technology
United Kingdom Latest News, United Kingdom Headlines
Similar News:You can also read news stories similar to this one that we have collected from other news sources.
Microsoft Sues Cybercriminals for Exploiting AI ToolsMicrosoft has taken legal action against a group of unidentified cybercriminals accused of developing tools to bypass security measures in its generative AI systems. The lawsuit alleges that these criminals used stolen API keys and custom software to gain unauthorized access to Microsoft's Azure OpenAI service, generating harmful content and reselling this access as a 'hacking-as-a-service' scheme. Microsoft is seeking damages and relief related to this illegal activity, aiming to disrupt the criminal operation and gather evidence about the individuals involved.
Read more »
Microsoft Expands Xbox Repair Options and Sustainability InitiativesMicrosoft partners with uBreakiFix to offer repairs for Xbox Series X|S consoles, increasing accessibility for players. The company also plans to sell replacement parts through the Microsoft Store and iFixit's Microsoft Repair Hub. Microsoft emphasizes its commitment to sustainability by using zero single-use plastics in the latest Xbox Series X|S packaging and improving power consumption through software updates.
Read more »
Microsoft builds open source document database on PostgreSQL, suggests FerretDB as front endWe're not in Kansas anymore
Read more »
Microsoft Embraces Open Source with Document Database Built on PostgreSQLMicrosoft has made a significant move into the open-source world by launching a document database platform powered by PostgreSQL. This new platform, along with the FerretDB open-source interface, offers developers a flexible and high-performing alternative to traditional document databases. The platform's open governance, combined with performance enhancements, positions it as a potential challenger to established players like MongoDB.
Read more »
‘Liverpool open to selling Harvey Elliott as talks open’The inside track on the football stories that matter
Read more »
Microsoft Embraces Open-Source AI with DeepSeek R1 IntegrationMicrosoft rapidly integrates the open-source DeepSeek R1 LLM into Azure AI Foundry and GitHub, emphasizing its commitment to providing accessible and powerful AI tools.
Read more »