{"id":3869,"date":"2019-01-09T08:53:00","date_gmt":"2019-01-09T08:53:00","guid":{"rendered":"http:\/\/the-codest.localhost\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/"},"modified":"2026-04-27T09:51:09","modified_gmt":"2026-04-27T09:51:09","slug":"que-db-escolher-para-o-seu-tipo-de-dados-especifico-no-seu-projeto-de-software","status":"publish","type":"post","link":"https:\/\/thecodest.co\/pt\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/","title":{"rendered":"Que BD escolher para o seu tipo de dados espec\u00edfico no seu projeto de software"},"content":{"rendered":"\n<p>The type of your database is not the only topic to consider. There are many other issues to think about, e.g., how many active users the application may have? Do you need strong consistency everywhere? Will the eventual consistency suffice in some cases? There are so many questions without straightforward answers as \u201cthe more you get into it, the more complicated it becomes.\u201d So, please, make note that this article is focused only on database types.<\/p>\n\n\n\n<p>Take a cup of coffee and enjoy this reading.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">General database classification<\/h2>\n\n\n\n<p>At the beginning, it is good to know that there are two main types of databases: relational (SQL) and non-relational (NoSQL).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The SQL databases are structured in a relational way, which means that you store <a href=\"https:\/\/thecodest.co\/pt\/blog\/app-data-collection-security-risks-value-and-types-explored\/\">data<\/a> in tables and keep relations between them.<\/li>\n\n\n\n<li>The NoSQL (Not only SQL) databases, unlike the relational ones, are not well-structured and, thus, allow more adaptability and flexibility.<\/li>\n<\/ul>\n\n\n\n<p>There is one more type apart from the two mentioned above, namely an in-memory database. It cannot be classified neither as relational nor non-relational because it relates to where the data is physically stored. Every database could be stored on a disk or in memory.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Types of databases<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Relational<\/h3>\n\n\n\n<p>In my opinion, it is the most popular type of database. It works well with structural data where you want to keep relations between the records. The database structure is described in a schema.<\/p>\n\n\n\n<p>The main advantages regard transactions (they help to ensure data integrity and follow the ACID rules) and the ability to handle lots of complex queries.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful for keeping data that does not change structurally very often and that you need to store permanently, for example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CRM (Customer Relationship Management),<\/li>\n\n\n\n<li>Order management,<\/li>\n\n\n\n<li>ERP (<a href=\"https:\/\/thecodest.co\/pt\/dictionary\/what-is-enterprise-hybrid-cloud\/\">Enterprise<\/a> Resource Planning),<\/li>\n\n\n\n<li>data warehousing or inventory management,<\/li>\n\n\n\n<li>accounting or <a href=\"https:\/\/thecodest.co\/pt\/blog\/fintech-the-future-of-finance\/\">finance<\/a>.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Amazon Aurora, Microsoft <a href=\"https:\/\/thecodest.co\/pt\/dictionary\/azure-developer\/\">Azure<\/a> SQL Database, PostgreSQL, <a href=\"https:\/\/thecodest.co\/pt\/blog\/fintech-app-development-services-features-in-2026\/\">MySQL<\/a>.<\/p>\n\n\n\n<p>Relational databases are insufficient for many new applications and you need to have more than one database. In the next part of the article, I will focus on the non-relational databases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Key-value<\/h3>\n\n\n\n<p>It stores each data value with a unique key. It means that data is accessed by a single key, just like it is done in a <a href=\"https:\/\/thecodest.co\/pt\/blog\/hash-to-use-or-not-to-use\/\">hash<\/a> map. In contrast to relational databases, it neither enforces the scheme nor relationships between records. Most of these databases do not ordinarily support update operations. To modify data, you have to overwrite the whole existing set.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful for data that you want to read\/write fast (but do not update very often):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>real-time bidding, ad serving,<\/li>\n\n\n\n<li>data caching,<\/li>\n\n\n\n<li>session management,<\/li>\n\n\n\n<li>shopping carts,<\/li>\n\n\n\n<li>customer preferences or profile management.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Memcached, Amazon DynamoDB, Azure Cosmos DB, Redis.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Document<\/h3>\n\n\n\n<p>It stores collections of documents. Every document contains fields with data, which may be simple values or complex elements, like lists or child collections. It is important to know that every document may have a different structure, even if they represent the same thing (each document is unique and evolves over time). For example, the first customer document contains less info than the second:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">{\n \"FirstName\": \"John\",\n \"LastName\": \"Fake\",\n \"Motorcycles:\" [\n  {\n    \"Model\": \"BMW\",\n    \"Year\": 2020\n  }\n ]\n}<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">{\n \"FirstName\": \"Alex\",\n \"LastName\": \"Nolastname\",\n \"Age\": 15,\n \"Address\": {\n    \"Country\": \"<a href=\"https:\/\/thecodest.co\/pt\/blog\/the-codest-guide-how-to-successfully-outsource-from-poland\/\">Poland<\/a>\",\n    \"City\": \"Somewhere\"\n  },\n \"Motorcycles:\" [\n  {\n    \"Model\": \"BMW\",\n    \"Year\": 2020\n  }\n ]\n}<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful for data that require a flexible schema for fast processing:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/thecodest.co\/pt\/dictionary\/how-to-make-product\/\">product<\/a> catalogs,<\/li>\n\n\n\n<li>CMS (content management system),<\/li>\n\n\n\n<li>user profiles and personalization.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Amazon DocumentDB, Azure Cosmos DB, MongoDB, Redis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Graph<\/h2>\n\n\n\n<p>It uses a graph structure and is built of two elements: nodes and edges. Nodes are analogous to table rows or JSON documents. Edges are relationships between the nodes \u2013 they are as important as nodes. Both of them can have properties. Moreover, edges can have a defined direction of a relationship.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful when your data is similar to a graph, i.e., relationships between data items are dynamic and change over time. Furthermore, it is a good choice for when a business or technical <a href=\"https:\/\/thecodest.co\/pt\/blog\/how-to-hire-the-best-outsourced-development-team-for-a-scaleup\/\">team<\/a> need to understand relationships within their data. Some prominent examples include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>organization charts,<\/li>\n\n\n\n<li>fraud detection,<\/li>\n\n\n\n<li>social graphs\/networking,<\/li>\n\n\n\n<li>recommendations engines,<\/li>\n\n\n\n<li>knowledge graphs.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Amazon Neptune, Neo4j, ArangoDB, Titan.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Time series<\/h3>\n\n\n\n<p>It stores data organized by time. Typically, it accumulates enormous amounts of data in real-time. It is most often used to save data, though updating is very rare. Generally, a timestamp is used as the primary key and\/or sorting data. Some databases allow defining tags to be included as additional information, like data origin or type.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful to store small amounts of data appended sequentially in chronological order, for example in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/thecodest.co\/pt\/blog\/maximize-your-software-delivery-the-4-essential-devops-practices-you-need-to-know\/\">DevOps<\/a>,<\/li>\n\n\n\n<li>application monitoring,<\/li>\n\n\n\n<li>monitoring and event telemetry,<\/li>\n\n\n\n<li><a href=\"https:\/\/thecodest.co\/pt\/case-studies\/scaling-iot-solutions-for-office-space-management\/\">IoT<\/a> applications (like data collections from device sensors).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Azure Time Series Insights, Amazon Timestream, InfluxDB.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. Ledger<\/h3>\n\n\n\n<p>It provides an immutable, transparent, and cryptographically verifiable transaction log owned by a central authority. \u2013 Amazon\u2019s QLDB Overview<\/p>\n\n\n\n<p>Let&#8217;s shortly explain every keyword in the above quotation:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>immutable \u2013 means that a record created in this database cannot be deleted, modified, or even overwritten,<\/li>\n\n\n\n<li>transparent \u2013 it tracks and keeps a sequence record of each change in your data,<\/li>\n\n\n\n<li>cryptographically verifiable \u2013 data created in this database is verified by cryptographic hashing techniques, similar to blockchains (using the SHA-256 hash function).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">When to choose it?<\/h4>\n\n\n\n<p>It is useful to store accurate history, e.g., logging sequenced entry of every data change, as in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>finances (history of debit or credit transactions),<\/li>\n\n\n\n<li><a href=\"https:\/\/thecodest.co\/pt\/dictionary\/manufacturing-software-development\/\">manufacturing<\/a> (track where parts were sourced),<\/li>\n\n\n\n<li><a href=\"https:\/\/thecodest.co\/pt\/blog\/which-companies-lead-germanys-insurance-market-discover-the-top-10\/\">insurance<\/a>,<\/li>\n\n\n\n<li>HR and payroll,<\/li>\n\n\n\n<li>retail,<\/li>\n\n\n\n<li>supply chains.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Examples:<\/h4>\n\n\n\n<p>Amazon QLDB<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusions<\/h2>\n\n\n\n<p>There is no simple answer to the question posed in the title of this article. The only way to choose the right database is to learn more about your data. Answer the question: \u201cWhat kind of data does your application generate?\u201d, and you will be able to make the right choices.<\/p>\n\n\n\n<p>Furthermore, you should know the business requirements and the application domain very well. You need to know how you will use the data, what queries you will send to the database, how many times you will keep, read, update, or delete your data. All of these things matter, but not all developers pay enough attention to these areas.<\/p>\n\n\n\n<p>Please think about your data in the application you develop to improve\/create better software. Overall, I hope your will get to know your data well enough to store it in a place where it will be happy.<\/p>\n\n\n\n<p><strong>Read more:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/thecodest.co\/blog\/tricks-to-speed-up-javascript-application\/\">A few tricks to speed up your JavaScript application<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/thecodest.co\/blog\/ways-to-increase-your-rails-performance\/\">Ways to increase your Rails performance<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/thecodest.co\/blog\/facts-and-myths-about-cooperating-with-external-software-development-partner\/\">Facts and myths about cooperating with external software development partner<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A cria\u00e7\u00e3o de um novo projeto inclui a escolha da base de dados correta para armazenar os seus dados. Muitos programadores que conhe\u00e7o escolhem a base de dados relacional por defeito desde o in\u00edcio. Mas ser\u00e1 essa a melhor decis\u00e3o? Claro que sim, depende de muitos factores. Neste artigo, gostaria de lhe dar a conhecer outros tipos de bases de dados para facilitar as suas escolhas e ajud\u00e1-lo a estar preparado para os seus futuros empreendimentos.<\/p>","protected":false},"author":2,"featured_media":3870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-3869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Which DB to choose for your specific data type in your software project - The Codest<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/thecodest.co\/pt\/blogue\/que-db-escolher-para-o-seu-tipo-de-dados-especifico-no-seu-projeto-de-software\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which DB to choose for your specific data type in your software project\" \/>\n<meta property=\"og:description\" content=\"Creating a new project includes choosing the right database to store your data. Many developers that I know choose the relational database by default from the beginning. But is it the best decision? Of course, it depends on many factors. In this article, I would like to introduce you to other types of databases to make your choices easier and help you be prepared in your future endeavors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thecodest.co\/pt\/blogue\/que-db-escolher-para-o-seu-tipo-de-dados-especifico-no-seu-projeto-de-software\/\" \/>\n<meta property=\"og:site_name\" content=\"The Codest\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-09T08:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-27T09:51:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"thecodest\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"thecodest\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/\"},\"author\":{\"name\":\"thecodest\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/person\\\/7e3fe41dfa4f4e41a7baad4c6e0d4f76\"},\"headline\":\"Which DB to choose for your specific data type in your software project\",\"datePublished\":\"2019-01-09T08:53:00+00:00\",\"dateModified\":\"2026-04-27T09:51:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/\"},\"wordCount\":1091,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/date-base-software-project.png\",\"articleSection\":[\"Software Development\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/\",\"url\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/\",\"name\":\"Which DB to choose for your specific data type in your software project - The Codest\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/date-base-software-project.png\",\"datePublished\":\"2019-01-09T08:53:00+00:00\",\"dateModified\":\"2026-04-27T09:51:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#primaryimage\",\"url\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/date-base-software-project.png\",\"contentUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/date-base-software-project.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/thecodest.co\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Which DB to choose for your specific data type in your software project\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#website\",\"url\":\"https:\\\/\\\/thecodest.co\\\/\",\"name\":\"The Codest\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/thecodest.co\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\",\"name\":\"The Codest\",\"url\":\"https:\\\/\\\/thecodest.co\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/03\\\/thecodest-logo.svg\",\"contentUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/03\\\/thecodest-logo.svg\",\"width\":144,\"height\":36,\"caption\":\"The Codest\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/pl.linkedin.com\\\/company\\\/codest\",\"https:\\\/\\\/clutch.co\\\/profile\\\/codest\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/person\\\/7e3fe41dfa4f4e41a7baad4c6e0d4f76\",\"name\":\"thecodest\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"caption\":\"thecodest\"},\"url\":\"https:\\\/\\\/thecodest.co\\\/pt\\\/author\\\/thecodest\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Que BD escolher para o seu tipo de dados espec\u00edfico no seu projeto de software - The Codest","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/thecodest.co\/pt\/blogue\/que-db-escolher-para-o-seu-tipo-de-dados-especifico-no-seu-projeto-de-software\/","og_locale":"pt_PT","og_type":"article","og_title":"Which DB to choose for your specific data type in your software project","og_description":"Creating a new project includes choosing the right database to store your data. Many developers that I know choose the relational database by default from the beginning. But is it the best decision? Of course, it depends on many factors. In this article, I would like to introduce you to other types of databases to make your choices easier and help you be prepared in your future endeavors.","og_url":"https:\/\/thecodest.co\/pt\/blogue\/que-db-escolher-para-o-seu-tipo-de-dados-especifico-no-seu-projeto-de-software\/","og_site_name":"The Codest","article_published_time":"2019-01-09T08:53:00+00:00","article_modified_time":"2026-04-27T09:51:09+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png","type":"image\/png"}],"author":"thecodest","twitter_card":"summary_large_image","twitter_misc":{"Written by":"thecodest","Est. reading time":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#article","isPartOf":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/"},"author":{"name":"thecodest","@id":"https:\/\/thecodest.co\/#\/schema\/person\/7e3fe41dfa4f4e41a7baad4c6e0d4f76"},"headline":"Which DB to choose for your specific data type in your software project","datePublished":"2019-01-09T08:53:00+00:00","dateModified":"2026-04-27T09:51:09+00:00","mainEntityOfPage":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/"},"wordCount":1091,"commentCount":0,"publisher":{"@id":"https:\/\/thecodest.co\/#organization"},"image":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#primaryimage"},"thumbnailUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png","articleSection":["Software Development"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/","url":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/","name":"Que BD escolher para o seu tipo de dados espec\u00edfico no seu projeto de software - The Codest","isPartOf":{"@id":"https:\/\/thecodest.co\/#website"},"primaryImageOfPage":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#primaryimage"},"image":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#primaryimage"},"thumbnailUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png","datePublished":"2019-01-09T08:53:00+00:00","dateModified":"2026-04-27T09:51:09+00:00","breadcrumb":{"@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#primaryimage","url":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png","contentUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/date-base-software-project.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/thecodest.co\/blog\/which-db-to-choose-for-your-specific-data-type-in-your-software-project\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/thecodest.co\/"},{"@type":"ListItem","position":2,"name":"Which DB to choose for your specific data type in your software project"}]},{"@type":"WebSite","@id":"https:\/\/thecodest.co\/#website","url":"https:\/\/thecodest.co\/","name":"The Codest","description":"","publisher":{"@id":"https:\/\/thecodest.co\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/thecodest.co\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/thecodest.co\/#organization","name":"The Codest","url":"https:\/\/thecodest.co\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/thecodest.co\/#\/schema\/logo\/image\/","url":"https:\/\/thecodest.co\/app\/uploads\/2024\/03\/thecodest-logo.svg","contentUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/03\/thecodest-logo.svg","width":144,"height":36,"caption":"The Codest"},"image":{"@id":"https:\/\/thecodest.co\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/pl.linkedin.com\/company\/codest","https:\/\/clutch.co\/profile\/codest"]},{"@type":"Person","@id":"https:\/\/thecodest.co\/#\/schema\/person\/7e3fe41dfa4f4e41a7baad4c6e0d4f76","name":"thecodest","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","caption":"thecodest"},"url":"https:\/\/thecodest.co\/pt\/author\/thecodest\/"}]}},"_links":{"self":[{"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/posts\/3869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/comments?post=3869"}],"version-history":[{"count":4,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/posts\/3869\/revisions"}],"predecessor-version":[{"id":8135,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/posts\/3869\/revisions\/8135"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/media\/3870"}],"wp:attachment":[{"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/media?parent=3869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/categories?post=3869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thecodest.co\/pt\/wp-json\/wp\/v2\/tags?post=3869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}