--- title: "State of PostgreSQL 2024: PostgreSQL and AI" published: 2024-12-17T09:48:53.000-05:00 updated: 2024-12-17T09:48:53.000-05:00 excerpt: "A sneak peek into how PostgreSQL developers are using AI, courtesy of the 2024 State of PostgreSQL survey." tags: State of PostgreSQL, AI, PostgreSQL, Blog authors: Ana Tavares, Melanie Savoia --- > **TimescaleDB is now Tiger Data.** Over the course of 2024, artificial intelligence (AI) continued to dominate conversations in the tech world, and PostgreSQL developers were no exception. The _2024_ _State of PostgreSQL_ survey provided intriguing insights into how developers are using PostgreSQL for AI, the tools they prefer, and their evolving attitudes toward integrating AI into their workflows.  Here’s a sneak peek of what we learned. You can read the complete [_2024 State of PostgreSQL_ report here](https://www.timescale.com/state-of-postgres/2024). ✨ ****About the State of PostgreSQL**** __Timescale’s love for PostgreSQL, one of the world’s most advanced open-source databases with 35+ years of history, runs deep.__ [__We built our products on PostgreSQL__](http://www.timescale.com/?ref=timescale.com)__, we love__ [__enabling other developers to use this reliable technology__](https://www.timescale.com/developers?ref=timescale.com)__, and__ [__we wouldn’t exist without it and the extensibility it provides__](https://www.timescale.com/blog/scaling-postgresql-to-petabyte-scale/)__.__ __In 2019, Timescale launched the first State of PostgreSQL report, advancing our desire to provide greater insights into the vibrant and growing PostgreSQL user base. The report provides valuable insights into this great community, from whether respondents use PostgreSQL for work or personal projects (or both!) to their favorite PostgreSQL tools, features, and information sources. Following a one-year hiatus due to the pandemic, we resumed the annual survey in 2021.__ __This is the__ [__fifth State of PostgreSQL report__](https://www.timescale.com/state-of-postgres/2024)__. Check out the__ [__second__](https://drive.google.com/drive/folders/14elckaNv7FLKyWhzp3JKd3tH6PvI9F45?usp=sharing&ref=timescale.com)__,__ [__third__](https://s3.amazonaws.com/assets.timescale.com/resources/state_of_postgres/State_of_PostgreSQL_2022_Full_Report.pdf?ref=timescale.com)__, and__ [__fourth__](https://www.timescale.com/state-of-postgres/2023?ref=timescale.com) __report editions.__ ## PostgreSQL and AI: Adoption on the Rise ![A bar graph with the percentage of answers to the question: do you currently use AI tools in your developement process. 55.3% said yes.](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024-do-you-currently-use-ai-tools.png) This year’s survey revealed that AI is becoming a cornerstone in the PostgreSQL community: - **55.3 % of developers** now use AI tools in their development process, a significant jump from 36.9 % in 2023. This 18.4 percentage point increase underscores AI's growing role in enhancing productivity and tackling complex challenges. - Conversely, the percentage of developers not using AI tools dropped dramatically from 63 % to 44.7 %, reflecting a clear trend toward adoption. ## Why PostgreSQL for AI Applications? ![Bar graph with the answers to "Why did you choose PostgreSQL over other databases for your AI application?"](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024-why-did-you-choose-posgresql-for-ai.png) When asked why they chose PostgreSQL for their AI workloads, the community emphasized familiar themes: 1. **Storing vectors alongside other data types**: 78.6 % of respondents highlighted this unique capability as the top reason. 2. **Ease of use**: 56 % pointed to PostgreSQL’s simplicity and accessibility. 3. **SQL query language**: trusted by 53.6 % of developers, SQL remains a key factor. 4. **Support for vector search and time-series data**: valued by 33.3 %. 5. **Ecosystem and integrations**: cited by 31 % of respondents. These results align with 2023’s findings, reinforcing PostgreSQL’s reputation as a versatile and robust database for AI and large language model (LLM) workloads. 👉 If you're building AI applications using PostgreSQL, [check out our "Easy Mode" open-source AI stack](https://www.timescale.com/blog/the-emerging-open-source-ai-stack), our picks of the most developer-friendly models and tools. ## Shifting Attitudes Toward AI ![Bar graph showing the respondents' attitudes toward AI.](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024_attitude-towards-ai.png) While most developers are embracing AI, attitudes vary: - **48 % expressed favorable views** of AI tools in development, up three percentage points from last year. - A smaller group remains neutral (26 %), while **25 % voiced unfavorable opinions**, a slight increase from 2023. These numbers highlight a growing appreciation for AI’s potential, coupled with ongoing concerns around its implementation and ethical considerations. ## What’s Next for PostgreSQL and AI? As AI adoption grows, so does the need for robust, scalable, and developer-friendly solutions. PostgreSQL’s ability to store vectors alongside other data types, combined with its familiar SQL interface, makes it an ideal choice for AI and LLM workloads, especially [if you're looking for an open-source AI stack](https://www.timescale.com/blog/the-emerging-open-source-ai-stack). At Timescale, we’re excited to continue using [PostgreSQL for Everything](https://www.timescale.com/blog/postgres-for-everything/) and providing others with the tools to do so. This is the goal of our AI-focused extensions, [pgai](https://github.com/timescale/pgai/) (with [pgai Vectorizer](https://github.com/timescale/pgai/blob/main/docs/vectorizer.md)) and [pgvectorscale](https://github.com/timescale/pgvectorscale). What do you think about these trends? Read the complete [_2024 State of PostgreSQL_ report](https://www.timescale.com/state-of-postgres/2024) and let us know! You can join the conversation in our [Timescale Community Slack](https://slack.timescale.com/). If you’re already building AI applications with PostgreSQL, join our [Postgres for AI Discord](https://discord.gg/Q8TajvAPRN), where you can share what you’re working on and help or get helped by a community of peers.