Which RDBMS do you feel best suits the needs of today's climate of rapid change and iteration?
SQLite8%
CouchDB15%
PostgreSQL25%
MongoDB30%
SQLServer19%
1466 PARTICIPANTS
Sort By:
Oldest
CTO in Software5 years ago
Snowflake CTO in Finance (non-banking)4 years ago
CouchDB and Mongo are not RDBMS but at Document-oriented databases. SQLLite has relational features but calling it a full RDBMS is a stretch.Principal Enterprise Architect in Software3 years ago
Snowflake or a similar data “engine” as part of a broader data platform that can manage relational, object, graph and stream/telemetry types of data.Senior Enterprise Architect, Application Consulting in Healthcare and Biotech3 years ago
Oracle Autonomous Database. It is a multimodel converged database incorporating machine learning-based automation.CIO in Services (non-Government)3 years ago
As previously noted, Mongo isn’t really an rdbms. However, it has come a long way in supporting flexible schemas and performant relational functionality. We initially adopted it for iterative development of an in-house statistical data dashboard and are currently working on a refactor of that. When looking at alternative traditional rdbms’ or lightweight versions like SQLite, ultimately we found that latest iterations of Mongo support the level of relational separation and transactional modeling we wanted while still offering the flexibility of optimized document store. It’s definitely a contender at small scale, but I’m guessing based on the percent of people who chose it as a “preferred rdbms” here that our experience scales pretty far up, even if not all the way to F5000 size. At those scales though there is rarely less than some mix of data store engines in use with multiple teams (and in at least one client’s case multiple divisions) dedicated just to ETL to glue legacy and new services together across the mix of platforms. P.S. Snowflake comes up a lot too.