Databases, at their core, store and organize data to serve a multitude of purposes. To meet modern challenges, databases have evolved to include different types, functions, and features. A particular database may be the preferred option over another because of its unique capabilities or because of other databases’ limitations. This plethora of options makes it interesting to understand where different populations lean when selecting their database.
As a next-generation open-source ORM designed to abstract away the functions of traditional management systems to improve developer productivity, we at Prisma were curious to learn which databases are most predominant throughout the United States. So, we performed a bit of research on our own. Check out the map to see what database is each state’s favorite going into 2022 - the results may surprise you!
- Microsoft Access is the overall favorite database for the entire country, taking the top spot in 26 states.
- IBM Db2 came in dead last, with only two states (Minnesota & Wisconsin) claiming it as their top database pick.
- Three states tied for their favorite databases
- Arizona tied between Microsoft SQL Server and Microsoft Access
- Virginia tied between MySQL, Microsoft SQL Server, and Elasticsearch
- District of Columbia tied between Oracle, PostgreSQL, and Microsoft Access
- 33 states’ favorite databases are Microsoft-owned products.
- Redis is popular among coastal states like New York, California, and Washington.
We looked at the 10 most popular databases across the nation and analyzed their Google Trends search volume data over the past 12 months to determine each state’s favorite.
For each state, we observed, recorded, and compared the predominance of search activity for the following databases:
- Microsoft SQL Server
- IBM Db2
- Microsoft Access
|Arizona||Microsoft SQL Server/ Microsoft Access|
|District of Columbia||Oracle/PostrgeSQL/Microsoft Access|
|Indiana||Microsoft SQL Server|
|Michigan||Microsoft SQL Server|
|Missouri||Microsoft SQL Server|
|North Dakota||Microsoft Access|
|Ohio||Microsoft SQL Server|
|Rhode Island||Microsoft Access|
|South Carolina||Microsoft Access|
|Virginia||MySQL/Microsoft SQL Server/ElasticSearch|
|West Virginia||Microsoft Access|