interface BlogPostProps {
  title: string;
  description: string;
  date: string;
  readTime: string;
  tags: string[];
}

const BlogPost: React.FC<BlogPostProps> = ({ 
  title, 
  description, 
  date, 
  readTime, 
  tags 
}) => {
  return (
    <article className="max-w-2xl mx-auto">
      <header className="mb-8">
        <h1 className="text-3xl font-bold mb-2">{title}</h1>
        <p className="text-muted-foreground mb-4">{description}</p>
        <div className="flex items-center gap-4 text-sm text-muted-foreground">
          <time dateTime={date}>{new Date(date).toLocaleDateString()}</time>
          <span>{readTime}</span>
        </div>
        <div className="flex gap-2 mt-4">
          {tags.map((tag) => (
            <span 
              key={tag} 
              className="px-2 py-1 bg-primary/10 text-primary rounded-md text-xs"
            >
              #{tag}
            </span>
          ))}
        </div>
      </header>
    </article>
  );
};

// pages/api/blog/[slug].js
export default async function handler(req, res) {
  const { slug } = req.query;
  
  if (req.method === 'GET') {
    try {
      const post = await getBlogPost(slug);
      
      if (!post) {
        return res.status(404).json({ error: 'Post not found' });
      }
      
      res.status(200).json(post);
    } catch (error) {
      console.error('Error fetching blog post:', error);
      res.status(500).json({ error: 'Internal server error' });
    }
  } else {
    res.setHeader('Allow', ['GET']);
    res.status(405).end(`Method ${req.method} Not Allowed`);
  }
}

import os
import json
from datetime import datetime

def generate_blog_metadata(posts_dir: str) -> dict:
    """
    Generate metadata for all blog posts in a directory.
    """
    metadata = {
        'posts': [],
        'generated_at': datetime.now().isoformat(),
        'total_posts': 0
    }
    
    for filename in os.listdir(posts_dir):
        if filename.endswith('.mdx'):
            post_path = os.path.join(posts_dir, filename)
            
            with open(post_path, 'r', encoding='utf-8') as file:
                content = file.read()
                
                # Extract frontmatter (simplified)
                if content.startswith('---'):
                    end_index = content.find('---', 3)
                    frontmatter = content[3:end_index]
                    
                    metadata['posts'].append({
                        'filename': filename,
                        'slug': filename.replace('.mdx', ''),
                        'frontmatter': frontmatter.strip()
                    })
    
    metadata['total_posts'] = len(metadata['posts'])
    return metadata

# Usage
if __name__ == "__main__":
    posts_metadata = generate_blog_metadata('./src/posts')
    print(json.dumps(posts_metadata, indent=2))

-- Get blog posts with tag statistics
SELECT 
    p.id,
    p.title,
    p.published_at,
    p.read_time,
    COUNT(pt.tag_id) as tag_count,
    STRING_AGG(t.name, ', ') as tags
FROM blog_posts p
LEFT JOIN post_tags pt ON p.id = pt.post_id
LEFT JOIN tags t ON pt.tag_id = t.id
WHERE p.published = true
GROUP BY p.id, p.title, p.published_at, p.read_time
ORDER BY p.published_at DESC
LIMIT 10;