The latest articles on DEV Community by Khaled Mohamed (@khaledhamam). https://dev.to/khaledhamam https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F348212%2Ff3586716-c2b0-4717-a9bf-372e9db2caf3.jpeg https://dev.to/khaledhamam en Khaled Mohamed Fri, 29 May 2020 04:11:04 +0000 https://dev.to/khaledhamam/how-to-group-multiple-different-tables-for-a-many-to-many-relation-3na0 https://dev.to/khaledhamam/how-to-group-multiple-different-tables-for-a-many-to-many-relation-3na0 <p>Hey all, I'm working on a project an I needed some help in the database design.<br> The project is a platform in which the user can upload a video, write a blog, or create a course.<br> Each of them has its own table without any connections, but now I need the user to be able to bookmark the content.</p> <p>The question is, should I make a separate bookmark table for each content type? I was also thinking to make a table called <strong>content</strong>, that contains only an id field, then each of the content types will add a <strong>contentId</strong> field as a foreign key (or maybe also a pk), now I can make a bookmarks table containing a <strong>userId</strong> and a <strong>contentId</strong>, but I think I'll have a hard time querying the bookmarks and trying to find the data of the content.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--Gid_AY3n--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/bd6cwfldzdalmq20ay93.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Gid_AY3n--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/bd6cwfldzdalmq20ay93.png" alt="Alt Text"></a></p> <p>I'll really appreciate your opinion on this, thank you all.</p> help Khaled Mohamed Tue, 10 Mar 2020 09:31:12 +0000 https://dev.to/khaledhamam/looking-for-a-cms-that-integrates-with-a-custom-db-4b1m https://dev.to/khaledhamam/looking-for-a-cms-that-integrates-with-a-custom-db-4b1m <p>Hey all, I'm having an issue with a project I'm working on.<br> I have an app with its own db that contains the users and their credentials.<br> I want to have a headless CMS that manages some blogs to avoid writing one of my own, but I can't seem to find a CMS that doesn't have its own separate users system.<br> So my question is whether there is a CMS that I can integrate with to make it see my users in my database? or should I make my own and forget about integrating with a third-party?</p> <p>Thank you</p> help