In a notable shift within the database development landscape, Google is advocating for its developers to embrace AI coding tools, particularly in their contributions to open source projects like PostgreSQL. This initiative reflects a broader trend towards leveraging artificial intelligence to enhance productivity while maintaining accountability among developers. Sailesh Krishnamurthy, Vice President of Databases at Google Cloud, emphasized this balance during a recent conversation with The Register.
Krishnamurthy stated, “We do encourage folks to use AI heavily. We are seeing huge amounts of productivity improvements internally.” However, he was quick to clarify that each developer is ultimately responsible for their contributions, regardless of the extent to which AI tools are utilized. “Whether you have a piece of code that is completely drafted by AI, or not even part of what you’re pasting into your development environment, you have a whole spectrum where AI is used in different places. Either way, the accountability remains on behalf of the person who’s done it,” he explained.
The suitability of AI coding tools for open source projects stems from the accessibility of the codebase, which has been instrumental in training generative models. Krishnamurthy noted that this contrasts sharply with proprietary code, which is often shielded behind firewalls. PostgreSQL, known for its extensibility, presents an ideal environment for rapid experimentation and innovation. “The sweet spot is where you have maybe an interesting academic idea that is well understood, and you have a codebase that’s well understood,” he remarked. This allows developers to explore new concepts and build extensions efficiently, all while keeping the risk manageable.
MORE CONTEXT
According to a recent Stack Overflow survey, PostgreSQL has emerged as the most favored database among developers in 2023. This surge in popularity can be attributed to the extensive array of PostgreSQL database services offered by major cloud providers, who have significantly increased their investments in the open source system. For instance, Microsoft has made substantial contributions, including the development of pg_documentdb_core and pg_documentdb_api, which enhance PostgreSQL’s capabilities to support BSON and MongoDB-compatible commands.
Furthermore, Microsoft has introduced a distributed PostgreSQL database service known as HorizonDB, illustrating the industry’s growing commitment to PostgreSQL. Krishnamurthy observed, “The industry at large is investing heavily in PostgreSQL. We see this across the board, whether it’s customers, whether it’s digital native services, and certainly we see the migrations coming from commercial databases.” This trend is evident as organizations transition away from legacy systems such as Oracle, Microsoft SQL Server, and IBM Db2.
Research from Gartner indicates that among the leading database vendors from 15 years ago, only Microsoft has managed to grow its market share. While Oracle continues to hold a dominant position, Google and other cloud providers are gradually shifting the momentum towards open source solutions like PostgreSQL. As these developments unfold, the landscape of database management systems is poised for significant transformation.
