README.md

metadata

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

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:

   git init
   git add .
   git commit -m "Initial commit"
   

2. Add remotes:

   # 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:

   # 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):

   # 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