Spaces:
Sleeping
Sleeping
| title: TextArchive | |
| emoji: 📚 | |
| colorFrom: blue | |
| colorTo: purple | |
| sdk: gradio | |
| python_version: "3.11" | |
| app_file: app.py | |
| pinned: false | |
| # TextArchive - Universal Text Management System | |
| A powerful and intuitive web application for managing all your text-based content with a clear hierarchical structure: **Category → Section → Content Type → Content**. | |
| ## 🎯 What is TextArchive? | |
| TextArchive is not just a prompt manager - it's a universal system for organizing ANY text-based content: | |
| - 💬 Prompts for AI models | |
| - 📝 Notes and documentation | |
| - 🐍 Code snippets (Python, JavaScript, SQL, etc.) | |
| - 📐 LaTeX documents | |
| - 💻 Bash scripts | |
| - ⚙️ Functions and utilities | |
| - 🌐 HTML/CSS templates | |
| - 📄 Any other text content | |
| ## 📐 Organization Structure | |
| Your content is organized in a clear three-level hierarchy: | |
| - **Category** (High-level grouping) - e.g., "Coding", "Writing", "Research" | |
| - **Section** (Subsection under category) - e.g., "Python", "JavaScript", "Blog Posts" | |
| - **Content Type** (What kind of content) - e.g., "python", "note", "prompt", "latex" | |
| - **Content** (Your actual text) | |
| Example hierarchy: | |
| ``` | |
| 📁 Coding (Category) | |
| └── 📄 Python (Section) | |
| └── 🐍 Python Code: "Function to calculate fibonacci..." | |
| └── 💬 Prompt: "Write a Python function that..." | |
| └── 📄 JavaScript (Section) | |
| └── 📜 JavaScript: "React component for login..." | |
| 📁 Research (Category) | |
| └── 📄 AI Papers (Section) | |
| └── 📝 Note: "Summary of transformer architecture..." | |
| └── 📐 LaTeX: "\documentclass{article}..." | |
| ``` | |
| ## ✨ Features | |
| ### Core Functionality | |
| - ✅ **Add New Items**: Create content with custom categories, sections, and types | |
| - 📋 **View All Items**: See all your content organized hierarchically | |
| - 🔍 **Auto-Filter**: Filters update automatically (AJAX-style, no search button needed) | |
| - 📄 **Easy Copy**: Click any row to preview, then use the copy button to copy just the text content | |
| - ✏️ **Edit Items**: Click any item to edit its details | |
| - 🗑️ **Delete Items**: Remove items you no longer need | |
| - 🎯 **Fixed Height Table**: Scrollable table maintains consistent size | |
| - 💾 **Persistent Storage**: SQLite database stores all your data | |
| ### Advanced Management | |
| - 🔄 **Rename Categories**: Rename categories and automatically update all items | |
| - 🔄 **Rename Sections**: Rename sections across all categories or within a specific category | |
| - 🗑️ **Bulk Delete**: Delete entire categories or sections at once (with confirmation) | |
| - 📊 **Statistics**: View insights about your content collection | |
| - 🏷️ **11 Content Types**: Prompt, Note, Python, JavaScript, LaTeX, SQL, Bash, Function, HTML, CSS, Other | |
| ### Smart UX | |
| - 🎯 **Filtered Dropdowns**: Section dropdown automatically filters by selected category | |
| - 🔄 **Auto-Refresh**: All dropdowns update automatically after changes | |
| - ⚠️ **Confirmation Dialogs**: Destructive actions require confirmation | |
| - 📦 **Auto-Generated Titles**: Leave title empty to auto-generate from content | |
| - 🎨 **Type Icons**: Visual icons for each content type | |
| ## 🚀 How to Use | |
| ### Adding Content | |
| 1. Go to the "➕ Add New Item" tab | |
| 2. Select or type a **Category** (high-level grouping) | |
| 3. Select or type a **Section** (subsection - dropdown auto-filters by category) | |
| 4. Choose **Content Type** (prompt, note, python, etc.) | |
| 5. (Optional) Enter a **Title** or leave empty for auto-generation | |
| 6. Enter your **Content** | |
| 7. Click "Add Item" | |
| ### Viewing and Filtering Content | |
| 1. Go to the "📋 View & Manage Items" tab | |
| 2. Use filters to narrow down items: | |
| - **Filter by Category**: Auto-updates table | |
| - **Filter by Section**: Auto-updates table (filtered by category) | |
| - **Filter by Type**: Auto-updates table | |
| 3. Click "Clear Filters" to reset | |
| ### Copying Content | |
| 1. In the "View & Manage Items" tab, click on any row in the table | |
| 2. The content appears in the **Content Preview** box below | |
| 3. Click the **copy button** (📋) in the preview box, OR | |
| 4. Click in the text box and press Ctrl+A (select all), then Ctrl+C (copy) | |
| 5. Only the text content is copied - NO ID, category, or section included! | |
| ### Editing Content | |
| 1. Click on a row in the table to load it | |
| 2. The item loads in the editing section below | |
| 3. Modify Category, Section, Type, Title, or Content as needed | |
| 4. Click "💾 Update Item" to save changes | |
| ### Deleting Content | |
| 1. Click on a row to select it | |
| 2. Click the "🗑️ Delete Item" button | |
| 3. The item will be removed immediately | |
| ### Managing Categories & Sections | |
| 1. Go to the "⚙️ Manage Categories & Sections" tab | |
| **Rename Category:** | |
| - Select the category to rename | |
| - Enter new name | |
| - Click "🔄 Rename Category" | |
| - All items in that category will be updated | |
| **Rename Section:** | |
| - (Optional) Select a category to limit scope | |
| - Select the section to rename | |
| - Enter new name | |
| - Click "🔄 Rename Section" | |
| **Delete Category:** | |
| - Select the category | |
| - Check the confirmation box | |
| - Click "🗑️ Delete Category" | |
| - ALL items in that category will be deleted | |
| **Delete Section:** | |
| - (Optional) Select a category to limit scope | |
| - Select the section | |
| - Check the confirmation box | |
| - Click "🗑️ Delete Section" | |
| ### Viewing Statistics | |
| 1. Go to the "📊 Statistics" tab | |
| 2. View total counts, top categories, and breakdown by type | |
| 3. Click "🔄 Refresh Statistics" to update | |
| ## 🎨 Content Types | |
| TextArchive supports 11 content types, each with its own icon and file extension: | |
| | Type | Icon | Extension | Use For | | |
| |------|------|-----------|---------| | |
| | prompt | 💬 | .txt | AI prompts and instructions | | |
| | note | 📝 | .md | Notes and documentation | | |
| | python | 🐍 | .py | Python code and scripts | | |
| | javascript | 📜 | .js | JavaScript code | | |
| | latex | 📐 | .tex | LaTeX documents | | |
| | sql | 🗄️ | .sql | SQL queries and scripts | | |
| | bash | 💻 | .sh | Bash shell scripts | | |
| | function | ⚙️ | .txt | Reusable functions | | |
| | html | 🌐 | .html | HTML markup | | |
| | css | 🎨 | .css | CSS stylesheets | | |
| | other | 📄 | .txt | Any other text content | | |
| ## 🔧 Technical Details | |
| - **Framework**: Gradio 4.44.0+ | |
| - **Database**: SQLite (automatically created as `textarchive.db`) | |
| - **Python**: 3.8+ | |
| - **Auto-Migration**: Automatically migrates from old `prompts.db` if exists | |
| ## 📊 Database Schema | |
| ```sql | |
| CREATE TABLE text_items ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| category TEXT NOT NULL, | |
| section TEXT NOT NULL, | |
| title TEXT NOT NULL, | |
| content TEXT NOT NULL, | |
| content_type TEXT DEFAULT 'prompt', | |
| file_extension TEXT DEFAULT '.txt', | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, | |
| updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| ``` | |
| Indexes are created on `category`, `section`, and `content_type` for optimal performance. | |
| ## 🚀 Deployment to Hugging Face Spaces | |
| ### Method 1: Direct Upload | |
| 1. Create a new Space on Hugging Face: | |
| - Go to https://huggingface.co/new-space | |
| - Choose "Gradio" as the SDK | |
| - Set visibility (Public or Private) | |
| 2. Upload these files to your Space: | |
| - `app.py` | |
| - `requirements.txt` | |
| - `README.md` (optional) | |
| 3. Your app will automatically deploy! | |
| ### Method 2: Git (With Your Sync Script) | |
| 1. Initialize your local repository: | |
| ```bash | |
| git init | |
| git add . | |
| git commit -m "Initial commit" | |
| ``` | |
| 2. Add remotes: | |
| ```bash | |
| # Add GitHub remote | |
| git remote add github https://github.com/YOUR_USERNAME/textarchive.git | |
| # Add Hugging Face remote | |
| git remote add huggingface https://huggingface.co/spaces/YOUR_USERNAME/textarchive | |
| ``` | |
| 3. Use your sync script: | |
| ```powershell | |
| # Set your Hugging Face token | |
| $env:HF_TOKEN = "your_hf_token_here" | |
| # Run sync | |
| .\sync.ps1 "Initial deployment" | |
| ``` | |
| ## 🔄 Migration from Old "Prompt Manager" | |
| If you have an existing `prompts.db` from the old Prompt Manager: | |
| 1. **Automatic Migration**: Just run the new app - it will automatically: | |
| - Detect the old `prompts.db` | |
| - Create the new `textarchive.db` schema | |
| - Migrate all your data | |
| - Set content_type to "prompt" for all old items | |
| - Generate titles from the first 50 characters | |
| 2. **Manual Backup** (Recommended): | |
| ```bash | |
| # Backup your old database first | |
| cp prompts.db prompts.db.backup | |
| ``` | |
| 3. **Verify Migration**: | |
| - Open the app | |
| - Go to Statistics tab | |
| - Check that all items were migrated | |
| - Check a few items to ensure content is intact | |
| ## 📝 Notes | |
| - The database file persists between sessions | |
| - All users share the same database (unless you add authentication) | |
| - Backup your `textarchive.db` file regularly | |
| - Section dropdowns auto-filter by selected category for better UX | |
| - Auto-filtering eliminates the need for a search button | |
| - Fixed-height table with scrolling maintains clean interface | |
| ## 🎯 Use Cases | |
| ### For Developers | |
| - Store code snippets and functions | |
| - Organize SQL queries by project | |
| - Keep bash scripts and automation tools | |
| - Document API endpoints | |
| ### For Writers | |
| - Organize story prompts and ideas | |
| - Store article outlines | |
| - Keep writing templates | |
| - Manage blog post drafts | |
| ### For Researchers | |
| - Store LaTeX document snippets | |
| - Organize research notes by topic | |
| - Keep citation templates | |
| - Document methodologies | |
| ### For AI/ML Engineers | |
| - Organize prompts by use case | |
| - Store fine-tuning examples | |
| - Document model configurations | |
| - Keep evaluation templates | |
| ## 🔮 Future Enhancements (Suggestions) | |
| - Export individual items as files | |
| - Export category/section as ZIP | |
| - Import from files/folders | |
| - Tags system for cross-category organization | |
| - Full-text search within content | |
| - Syntax highlighting in preview | |
| - Markdown rendering for notes | |
| - Version history for items | |
| - User authentication for private libraries | |
| - API access for programmatic usage | |
| - Favorites/bookmarks | |
| - Sharing capabilities | |
| ## 📜 License | |
| MIT License - Feel free to modify and use as needed! | |
| ## 🤝 Contributing | |
| Contributions are welcome! Please feel free to submit issues or pull requests. | |
| --- | |
| **Built with ❤️ using Gradio and SQLite** |