Which database should I use for my app?
4 likes1,754 views
Which database should I use for my app? SQL vs NoSQL databases. What is Polyglot Persistence? What are different types of databases out there? Introduction to CloudBoost : http://www.cloudboost.io Building your first app with CloudBoost.io
Which database should I use for my app?
- 1. Nawaz Dhandala Hacker at CloudBoost.io nawaz@cloudboost.io Which database should I use for my app? and Introduction to CloudBoost.io cloudboost
- 2. Agenda cloudboost Different types of databases Which database is right for my app?. Why use CloudBoost.io? Getting started with CloudBoost. Building your first web app. Using Data-storage, and real-time.
- 3. Different types of databases. There are quite a few types of NoSQL databases out there. Some of them are : Relational Database. For ex : MySQL Document Databases. For ex : MongoDB, CouchDB Graph Databases. For ex : Neo4j Search Databases. For ex : ElasticSearch Column Oriented. For ex : Cassandra Distributed Cache. For ex : Redis cloudbooost
- 4. Relational Databases Pros : Transaction support and ACID Simple queries to retrieve the data. Cons: Scalability is difficult. Little support for complex objects video, images, Geospatial and more. Examples : MySQL cloudboost
- 5. Document Databases Pros : Simple JSON Document Storage Extremely scalable Can scale out very well. Cons: No relations or joins. Most of the databases have no transaction support. Examples : MongoDB, CouchDB cloudboost
- 6. Graph Databases Pros : Excellent at storing relations between data. Relational queries / joins are extremely fast. Cons: Most of the graph databases are very hard to scale out. Can be conceptually difficult to understand at first. Example : Neo4j cloudboost
- 7. Search DB Pros : Excellent at full-text search and other search queries. Can scale out well. Cons: No relational support. Bad at MapReduce, No transactions. Example : ElasticSearch cloudboost
- 8. Column-oriented Pros : Fastest writes. Good for storing log / sensor data. Excellent scalability and high availability. Cons: No relational support. No transactions. Example : Cassandra cloudboost
- 9. Cache Pros : Fastest read / writes. Good for storing data you need all the time. Scalable and can be distributed over multiple machines Cons: Not persistent. It stores data on RAM which is expensive. Example : Redis cloudboost
- 10. Problem? No database available today can do everything which you need for your app.
- 11. To solve this Companies built multi-model databases. For ex : OrientDB = Document + Graph Database FoundationDB = SQL + Document Database cloudboost
- 12. Problems with Multi-Model databases? They have two / three data-model supported which still does-not cover all the scenarios for the requirements of an app.
- 13. Solution? Pick and use multiple databases to build one app.
- 14. and this is called Polyglot Persistence
- 15. For example, If youre building an e-commerce application
- 18. Using multiple databases to build one app is an excellent solution but
- 19. As a developer you need to Hire an expert for each database. Learn different databases yourself. Sync data between databases Manage different databases yourself
- 20. Which means Longer go-to-market time More Development and maintenance costs cloudboost
- 21. Why CloudBoost.io? CloudBoost is a database service that not only does data-storage, but also search, real-time and a whole lot more. We leverage the strengths of multiple databases and give you one simple API to use which will help you build much richer apps in half less time. cloudboost
- 24. A very simple API that does Search Storage Relations Time Series Real-time Geo Location
- 25. For Developers We Auto Sync your Data We manage Databases A ton of features Save Time Simple API
- 27. Step 1 : Create your app cloudboost
- 28. Step 2 : Create a new table Create a new table with name Custom cloudboost
- 29. Step 3 : Create a new column Create a new column name of type text cloudboost
- 30. Step 4 : Get your App Keys cloudboost
- 31. Step 5 : Link the JS SDK
- 32. Step 6 : Init your app. cloudboost
- 33. Step 7 : Save Data Custom is the name of the Table.
- 34. Step 8 : Adding real-time You can listen to any real-time notification event from the database service. Here for example, the event fires whenever a custom table object is inserted into the database. cloudboost
- 35. Thats it folks! Build your next big thing on CloudBoost.io. #BeginToday For more features, visit http://docs.cloudboost.io