Databases
High Performance, High Reliability, SQL & NoSQL Expertise
Over the past few years, the amount of data an application is expected to handle has grown exponentially. Whereas 10 years ago, an application with 10 million user accounts would be considered large, now a web or mobile application can grow from zero to tens of millions of users in a matter of just a few months.
NoSQL systems have emerged as one answer to the problems posed by contemporary database demands. In particular:
- Fault tolerance.
- Distributed, scalable operation across commodity hardware nodes.
- High performance.
- Rapid development.
NoSQL databases are not all equal
While NoSQL is a convenient label for grouping modern database innovations, there is a great disparity in terms of features and usage models. For example depending on your answers to the following questions, you could be looking at completely different NoSQL technologies:
- Do you need Hadoop / Map Reduce integration?
- Are you looking for a realtime OLTP system, or batch processing?
- What are the query patterns?
- Write or read heavy workload?
SQL still has a place
Meanwhile, SQL/RDBMS systems have not stood still. Over the past number of years they have greatly improved in the areas of:
- Replication for fault tolerance.
- Performance.
- Reduced cost of schema changes.
- Cloud hosted offerings.
Choose the right tool for the job
At FrozenRidge, our belief is that databases are not "one size fits all". While new NoSQL databases offer many benefits, SQL/RDBMS systems continue to offer advantages in the realm of:
- ACID guarantees - especially useful in financial applications.
- Data validation and integrity.
- Reporting and business intelligence tooling ecosystem.
- Reliability, well-tested and well-understood.
Cross technology expertise
We have expertise across database systems, in particular:
- MongoDB.
- CouchDB.
- MySQL.
- PostgreSQL.
