Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This application is a web app designed to manage user-generated content such as profiles, posts, and comments. It facilitates interaction among users while ensuring secure and efficient management of user data and content through robust database structures and authentication mechanisms.

## CORE FEATURES
1. **User Profiles**: Automatically created upon signup, profiles store display names linked to authenticated users, allowing users to view and manage their own profiles.
2. **Posts Management**: Users can create, read, update, and delete their own posts, which consist of titles, body content, and tags, ensuring a personalized content experience.
3. **Comments System**: Authenticated users can comment on posts. Comments are linked to both the post and the user, promoting community engagement.
4. **Authentication**: Secure email/password signup and login system that includes email verification to enhance account security.
5. **Real-time Updates**: Automatic updating of timestamps for posts and profiles whenever there are changes, ensuring data accuracy and relevance.
6. **Robust Security Policies**: Implement Row Level Security (RLS) policies to ensure that users can only manage their own data, while all profiles and posts remain publicly readable.

## DESIGN SPECIFICATIONS
- **Visual Style**: Minimalist - Emphasizing a clean and simple interface with ample white space, a minimal color palette, and a strong focus on typography.
- **Color Mode**: Light theme featuring dark text on light backgrounds for optimal readability and a pleasant user experience.
- **Layout**: A single-column layout that allows for straightforward navigation, with a header for branding, a main content area for user interactions, and a footer for additional information and links.
- **Typography**: Utilize a sans-serif font like Inter or Roboto for clarity and modern feel, with a clear hierarchy: larger font sizes for headings, medium for subheadings, and standard for body text.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript for building a robust and scalable application.
- **Styling**: Tailwind CSS for utility-first styling and rapid design implementation.
- **UI Components**: Utilize shadcn/ui for consistent and beautiful UI components.
- **State Management**: React Context API for managing global state across the application as needed.

## IMPLEMENTATION STEPS
1. **Set up the development environment**: Initialize a new React project with TypeScript and install necessary dependencies (React, TypeScript, Tailwind CSS, and shadcn/ui).
2. **Database Configuration**: Set up the database schema based on the defined tables (profiles, posts, comments) and implement RLS policies.
3. **Authentication Flow**: Create user authentication components for signup and login, including email verification functionality.
4. **Profile Management**: Implement profile auto-creation on signup and allow users to view/edit their profiles.
5. **Post Creation and Management**: Develop components for creating, displaying, updating, and deleting posts. Ensure that timestamp updates are handled automatically.
6. **Comment System**: Create a commenting feature that allows users to add comments to posts, managing the relationships with post and user IDs effectively.
7. **Implement Security Policies**: Ensure that RLS policies are correctly enforced in the database to maintain data integrity and security.

## USER EXPERIENCE
Users will access the application through a straightforward landing page that guides them to sign up or log in. Upon logging in, they will be directed to their dashboard where they can manage their profiles, create new posts, and engage with other users through comments. The minimalist design ensures ease of use, while the responsive layout adapts seamlessly across devices, providing an optimal experience regardless of screen size. The application prioritizes user security and data integrity, enhancing trust and encouraging active participation.