{"id":7357,"date":"2020-06-24T21:54:33","date_gmt":"2020-06-24T19:54:33","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=7357"},"modified":"2020-06-24T13:55:04","modified_gmt":"2020-06-24T11:55:04","slug":"dont-use-database-generated-ids-the-startup","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2020\/06\/24\/dont-use-database-generated-ids-the-startup\/","title":{"rendered":"Don&#8217;t Use Database Generated IDs | The Startup"},"content":{"rendered":"<blockquote><p>Stop letting the database be in charge of your application<\/p><\/blockquote>\n<p>Source: <em><a href=\"https:\/\/medium.com\/swlh\/dont-use-database-generated-ids-d703d35e9cc4\">Don&#8217;t Use Database Generated IDs | The Startup<\/a><\/em><\/p>\n<p><a href=\"https:\/\/medium.com\/swlh\/dont-use-database-generated-ids-d703d35e9cc4\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2020\/06\/1mfjRjgnZNGUwVSeJwYmQvQ.png?w=910&#038;ssl=1\" alt=\"\"\/><\/a><\/p>\n<p>This is old lore: the almight Davide Bianchi wrote in 2002 &#8220;<a href=\"https:\/\/www.soft-land.org\/documenti\/pk\">PK autogenerate&#8230; amici o nemici?<\/a>&#8221; (&#8220;autogenerated Primary Keys&#8230; friends or foes?.<\/p>\n<p>The answer is plain, simple, short<\/p>\n<h1 style=\"text-align: center;\">Absolutely no!<\/h1>\n<p>Then he explain why.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">Stop letting the database be in charge of your application Source: Don&#8217;t Use Database Generated IDs | The Startup This is old lore: the almight Davide Bianchi wrote in 2002 &#8220;PK autogenerate&#8230; amici o nemici?&#8221; (&#8220;autogenerated Primary Keys&#8230; friends or foes?. The answer is plain, simple, short Absolutely no! Then he explain why. &nbsp;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/monodes.com\/predaelli\/2020\/06\/24\/dont-use-database-generated-ids-the-startup\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[72],"tags":[],"class_list":["post-7357","post","type-post","status-publish","format-standard","hentry","category-documentations"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-1UF","jetpack-related-posts":[{"id":12755,"url":"https:\/\/monodes.com\/predaelli\/2025\/02\/14\/an-oh-fuck-moment-in-time\/","url_meta":{"origin":7357,"position":0},"title":"An &#8220;oh fuck&#8221; moment in time","author":"Paolo Redaelli","date":"2025-02-14","format":"link","excerpt":"## An \"oh fuck\" moment in time Over the Christmas break I\u2019ve been critically looking at my own software development loop, learning a new programming language and re-learning a language I haven\u2019t professionally used in over seven years. It's now 2025. Software assistants are now a core staple of my\u2026","rel":"","context":"In &quot;Mood&quot;","block_context":{"text":"Mood","link":"https:\/\/monodes.com\/predaelli\/category\/mood\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4883,"url":"https:\/\/monodes.com\/predaelli\/2018\/11\/07\/unqlite-an-embeddable-nosql-database-engine\/","url_meta":{"origin":7357,"position":1},"title":"UnQLite &#8211; An Embeddable NoSQL Database Engine","author":"Paolo Redaelli","date":"2018-11-07","format":false,"excerpt":"UnQLite - An Embeddable NoSQL Database Engine UnQLite is a in-process software library which implements a self-contained, serverless, zero-configuration, transactional NoSQL database engine. UnQLite is a document store database similar to MongoDB, Redis, CouchDB etc. as well a standard Key\/Value store similar to BerkeleyDB, LevelDB, etc. A cousin of the\u2026","rel":"","context":"In &quot;Software Libero&quot;","block_context":{"text":"Software Libero","link":"https:\/\/monodes.com\/predaelli\/category\/software\/software-libero\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9138,"url":"https:\/\/monodes.com\/predaelli\/2022\/03\/10\/how-to-create-a-very-inexpensive-serverless-database-by-alan-bird-aws-in-plain-english\/","url_meta":{"origin":7357,"position":2},"title":"How to Create a Very Inexpensive Serverless Database | by Alan Bird | AWS in Plain English","author":"Paolo Redaelli","date":"2022-03-10","format":false,"excerpt":"Cloud object storage can used as a powerful, very inexpensive database How to Create a Very Inexpensive Serverless Database | by Alan Bird | AWS in Plain English","rel":"","context":"In &quot;Senza categoria&quot;","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6316,"url":"https:\/\/monodes.com\/predaelli\/2019\/12\/15\/the-7-habits-of-highly-ineffective-programmers-young-coder-medium\/","url_meta":{"origin":7357,"position":3},"title":"The 7 Habits of Highly Ineffective Programmers &#8211; Young Coder &#8211; Medium","author":"Paolo Redaelli","date":"2019-12-15","format":"link","excerpt":"Are you committing crimes against code? From: The 7 Habits of Highly Ineffective Programmers - Young Coder - Medium The 7 Habits of Highly Ineffective Programmers Are you committing crimes against code? Matthew MacDonald Dec 5 \u00b7 4 min read Adapted from Pixabay It\u2019s always good to refactor old code,\u2026","rel":"","context":"In &quot;Senza categoria&quot;","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"Matthew MacDonald","src":"https:\/\/i0.wp.com\/miro.medium.com\/fit\/c\/58\/58\/1%2AsSR_cfRyUkBoM7L1pUYoYA.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4880,"url":"https:\/\/monodes.com\/predaelli\/2018\/11\/07\/neo4j-graph-database\/","url_meta":{"origin":7357,"position":4},"title":"Neo4j, Graph database","author":"Paolo Redaelli","date":"2018-11-07","format":false,"excerpt":"Source: Graph database - Wikipedia Neo4j 3.3.5 (April 2018)[20] GPLv3 Community Edition, commercial & AGPLv3 options for enterprise and advanced editions I do like companies that uses AGPL.","rel":"","context":"In &quot;Proprietary software&quot;","block_context":{"text":"Proprietary software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/proprietary-software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3522,"url":"https:\/\/monodes.com\/predaelli\/2017\/11\/22\/sql-server-why-should-an-application-not-use-the-sa-account-database-administrators-stack-exchange\/","url_meta":{"origin":7357,"position":5},"title":"sql server &#8211; Why should an application not use the sa account &#8211; Database Administrators Stack Exchange","author":"Paolo Redaelli","date":"2017-11-22","format":"status","excerpt":"sql server - Why should an application not use the sa account - Database Administrators Stack Exchange I understand that the sa account enables complete control over a SQL Server and all the databases, users, permissions etc. I have an absolute belief that applications should not use the sa password\u2026","rel":"","context":"In &quot;Proprietary software&quot;","block_context":{"text":"Proprietary software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/proprietary-software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/7357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/comments?post=7357"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/7357\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=7357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=7357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=7357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}