Skip to content

Commit

Permalink
Tempaltes keywords (chartdb#325)
Browse files Browse the repository at this point in the history 
* fix for tempaltes keywords

* remove keywords

* update templates description

---------

Co-authored-by: Guy Ben-Aharon <baguy3@gmail.com>
  • Loading branch information
@johnnyfish @guyb1
johnnyfish and guyb1 authored Nov 5, 2024
1 parent 3d3efc5 commit 588c64b
Show file tree
Hide file tree
Showing 7 changed files with 48 additions and 74 deletions.
21 changes: 7 additions & 14 deletions src/pages/template-page/template-page.tsx
View file
Original file line number Diff line number Diff line change
Expand Up @@ -65,31 +65,22 @@ const TemplatePageComponent: React.FC = () => {
<Helmet>
{template ? (
<>
<title>
Database schema diagram for {template.name} |
ChartDB
</title>
{HOST_URL !== 'https://chartdb.io' ? (
<link
rel="canonical"
href={`https://chartdb.io/templates/${templateSlug}`}
/>
) : null}
<meta
name="title"
content={`Database schema for - ${template.name} | ChartDB`}
/>
<title>
{`Database schema diagram for - ${template.name} | ChartDB`}
</title>
<meta
name="description"
content={`${template.shortDescription}: ${template.description}`}
/>
<meta
name="keywords"
content={`${template.keywords.join(', ')}`}
/>
<meta
property="og:title"
content={`Database schema for - ${template.name} | ChartDB`}
content={`Database schema diagram for - ${template.name} | ChartDB`}
/>
<meta
property="og:url"
Expand All @@ -104,7 +95,7 @@ const TemplatePageComponent: React.FC = () => {
content={`${HOST_URL}${template.image}`}
/>
<meta property="og:type" content="website" />

<meta property="og:site_name" content="ChartDB" />
<meta
name="twitter:title"
content={`Database schema for - ${template.name} | ChartDB`}
Expand All @@ -121,6 +112,8 @@ const TemplatePageComponent: React.FC = () => {
name="twitter:card"
content="summary_large_image"
/>
<meta name="twitter:site" content="@ChartDB_io" />
<meta name="twitter:creator" content="@ChartDB_io" />
</>
) : (
<title>Database Schema Diagram | ChartDB</title>
Expand Down
40 changes: 35 additions & 5 deletions src/pages/templates-page/templates-page.tsx
View file
Original file line number Diff line number Diff line change
Expand Up @@ -33,10 +33,41 @@ const TemplatesPageComponent: React.FC = () => {
return (
<>
<Helmet>
<title>ChartDB - Database Schema Templates</title>
{HOST_URL !== 'https://chartdb.io' ? (
<link rel="canonical" href="https://chartdb.io/templates" />
) : null}
<title>Database Schema Diagram Templates | ChartDB</title>
<meta
name="description"
content="Discover a collection of real-world database schema diagrams, featuring example applications and popular open-source projects."
/>
<meta
property="og:title"
content="Database Schema Diagram Templates | ChartDB"
/>
<meta property="og:url" content={`${HOST_URL}/templates`} />
<meta
property="og:description"
content="Discover a collection of real-world database schema diagrams, featuring example applications and popular open-source projects."
/>
<meta property="og:image" content={`${HOST_URL}/ChartDB.png`} />
<meta property="og:type" content="website" />
<meta property="og:site_name" content="ChartDB" />
<meta
name="twitter:title"
content="Database Schema Diagram Templates | ChartDB"
/>
<meta
name="twitter:description"
content="Discover a collection of real-world database schema diagrams, featuring example applications and popular open-source projects."
/>
<meta
name="twitter:image"
content={`${HOST_URL}/ChartDB.png`}
/>
<meta name="twitter:card" content="summary_large_image" />
<meta name="twitter:site" content="@ChartDB_io" />
<meta name="twitter:creator" content="@ChartDB_io" />
</Helmet>

<section className="flex w-screen flex-col bg-background">
Expand Down Expand Up @@ -74,10 +105,9 @@ const TemplatesPageComponent: React.FC = () => {
Database Schema Templates
</h1>
<h2 className="mt-1 font-primary text-base text-muted-foreground">
Explore a collection of real-world database schemas
drawn from real-world live applications and open-source
projects. Use these as a foundation or source of
inspiration when designing your app’s architecture.
Discover a collection of real-world database schema
diagrams, featuring example applications and popular
open-source projects.
</h2>
{!templates ? (
<Spinner
Expand Down
1 change: 0 additions & 1 deletion src/templates-data/templates-data.ts
View file
Original file line number Diff line number Diff line change
Expand Up @@ -13,7 +13,6 @@ export interface Template {
imageDark: string;
diagram: Diagram;
tags: string[];
keywords: string[];
featured: boolean;
url?: string;
}
Expand Down
12 changes: 0 additions & 12 deletions src/templates-data/templates/airbnb-db.ts
View file
Original file line number Diff line number Diff line change
Expand Up @@ -11,18 +11,6 @@ export const airbnbDb: Template = {
image,
imageDark,
tags: ['postgres', 'example apps'],
keywords: [
'airbnb database schema',
'airbnb database template',
'database schema visualization',
'airbnb database design',
'ChartDB',
'airbnb schema diagram',
'relational database structure',
'airbnb development',
'airbnb tables',
'database template for airbnb',
],
featured: true,
diagram: {
id: 'airbnb_db',
Expand Down
14 changes: 1 addition & 13 deletions src/templates-data/templates/employee-db.ts
View file
Original file line number Diff line number Diff line change
Expand Up @@ -5,25 +5,13 @@ import imageDark from '@/assets/templates/employeedb-dark.png';

export const employeeDb: Template = {
slug: 'employees-db',
name: 'Employees schema',
name: 'Employees',
shortDescription: 'Employees, departments, and salaries',
description:
'A schema for database of employees, departments, and salaries.',
image,
imageDark,
tags: ['mysql'],
keywords: [
'Employees database schema',
'Employees database template',
'database schema visualization',
'Employees database design',
'ChartDB',
'Employees schema diagram',
'relational database structure',
'Employees development',
'Employees tables',
'database template for Employees',
],
featured: true,
diagram: {
id: 'employees_db',
Expand Down
20 changes: 4 additions & 16 deletions src/templates-data/templates/visual-novel-db.ts
View file
Original file line number Diff line number Diff line change
Expand Up @@ -5,25 +5,13 @@ import imageDark from '@/assets/templates/visual-novel-db-dark.png';

export const visualNovelDb: Template = {
slug: 'visual-novel-db',
name: 'The Visual Novel Database | vndb',
shortDescription: 'The Visual Novel Database | vndb',
description: 'A comprehensive database for information about visual novels',
name: 'The Visual Novel Database',
shortDescription: 'The Visual Novel Database',
description:
'A comprehensive database for information about visual novels.',
image,
imageDark,
tags: ['postgres'],
keywords: [
'VNDB',
'visual novel database schema',
'visual novel database template',
'database schema visualization',
'visual novel database design',
'ChartDB',
'VNDB schema diagram',
'relational database structure',
'VNDB development',
'VNDB tables',
'database template for VNDB',
],
featured: true,
url: 'https://vndb.org',
diagram: {
Expand Down
14 changes: 1 addition & 13 deletions src/templates-data/templates/wordpress-db.ts
View file
Original file line number Diff line number Diff line change
Expand Up @@ -5,25 +5,13 @@ import imageDark from '@/assets/templates/wordpress-db-dark.png';

export const wordpressDb: Template = {
slug: 'wordpress-db',
name: 'WordPress Database',
name: 'WordPress',
shortDescription: 'An open-source PHP Content Management System',
description:
'(CMS) ideal for building websites, blogs, or apps. Flexible, customizable, and designed for developers to expand',
image,
imageDark,
tags: ['mysql', 'open source', 'WordPress', 'php'],
keywords: [
'WordPress database schema',
'WordPress database template',
'database schema visualization',
'WordPress database design',
'ChartDB',
'WordPress schema diagram',
'relational database structure',
'WordPress development',
'WordPress tables',
'database template for WordPress',
],
featured: true,
url: 'https://wordpress.org',
diagram: {
Expand Down

0 comments on commit 588c64b

Please sign in to comment.