Menu

📰
0

Advice request

Reddit r/Database·u/krispyglover·about 1 month ago
#2Yfh1KrI
#titles#store#child#first#multiple#article
Reading 0:00
15s threshold

Advice request Hey everyone. First-time poster because it's my first time having to make decisions about a database. As concisely as I can, here's my question: I'm building an SEO audit tool. Some HTML elements I need to store can appear multiple times on a page such as title tags, canonical tags, H1s... and so on. Multiple instances are usually a bug, and I want to surface them to the user AND be able to produce the content of each element (show them all the values, not just flag that there are multiples). So I've narrowed it down to a few options (let's just say we're dealing with titles). 1. Store the first title as a scalar value (most often a page will only have one) and have a child table for overflow titles that get stitched together when there are multiple and there's a request to see them all 2. Store titles in a child table period. All titles in a child table, the report holds all the titles that appear for that page id. 3. store the titles in JSON without child tables.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More