/*
  # Add Poems category and sample blog posts

  1. Categories
    - Add "Poems" category

  2. Sample Blog Posts
    - Add poetry and other content under various categories
*/

-- Insert Poems category
INSERT INTO categories (name, slug, description, color) VALUES
  ('Poems', 'poems', 'Poetry and literary expressions', '#9B59B6')
ON CONFLICT (slug) DO NOTHING;

-- Insert more blog posts under various categories
INSERT INTO blog_posts (
  title, 
  slug, 
  description, 
  content, 
  featured_image, 
  featured, 
  published, 
  pub_date
) VALUES
(
  'Verses of Heritage',
  'verses-of-heritage',
  'A collection of poems celebrating India''s rich cultural heritage and numismatic legacy',
  '# Verses of Heritage

*A collection of poems celebrating India''s rich cultural heritage and numismatic legacy*

## The Coin''s Tale

In copper, silver, gold so bright,  
Lies history''s eternal light.  
Each mark, each symbol, each design,  
Speaks of a past both yours and mine.

From Mauryan punch to Mughal art,  
Each coin plays its sacred part.  
In telling tales of kings and queens,  
Of trade routes and forgotten scenes.

O keeper of these metal scrolls,  
You guard the stories of ancient souls.  
In every collection, every find,  
Lives the treasure of mankind.

## The Collector''s Prayer

Grant me wisdom to discern  
The lessons that these coins can teach.  
Let patience be my faithful friend  
As knowledge stays within my reach.

May I preserve with gentle care  
These fragments of our glorious past.  
And share their stories far and wide  
So heritage forever lasts.

In every auction, every sale,  
Let honesty guide my way.  
For I am but a custodian  
Of treasures from yesterday.

## The Mint Master''s Song

In the forge where metals dance,  
And hammers sing their ancient song,  
I shape the currency of dreams  
Where art and commerce both belong.

Each die I cut with careful hand  
Bears symbols of our sacred land.  
The lotus, wheel, and royal seal  
Make every coin both true and real.

From molten gold to finished piece,  
I craft what time will never cease  
To value—not for weight alone,  
But stories in the metal sown.

## The Scholar''s Meditation

In libraries of silent halls,  
Where ancient wisdom softly calls,  
I trace the paths of bygone days  
Through numismatic displays.

Each catalog, each learned tome,  
Becomes my intellectual home.  
Where theories bloom and facts align  
In patterns both complex and fine.

The joy of discovery burns bright  
When new connections come to light.  
Between the coins and history''s page  
Across each era, every age.

## The Heritage Keeper

We are the guardians of the past,  
Ensuring memories ever last.  
In museums, collections, auction halls,  
We answer heritage''s sacred calls.

Not for profit do we strive,  
But to keep culture alive.  
Each coin preserved, each story told,  
Is worth much more than silver, gold.

For in these metal witnesses  
Lie civilizations'' promises  
That beauty, truth, and human art  
Will never from this world depart.

## The Numismatist''s Creed

I believe in the power of small things  
To carry the weight of history.  
I believe in the stories that coins tell  
Of human hopes and mystery.

I believe in preservation  
Of our cultural treasure trove.  
I believe in education  
And the knowledge that we''ve wove.

I believe in honest dealing  
And the ethics of our trade.  
I believe in sharing wisdom  
That the ancients for us made.

I believe in future generations  
Who will hold what we hold dear.  
I believe in the continuation  
Of traditions we revere.

## The Auctioneer''s Rhythm

Going once, going twice,  
For this treasure beyond price!  
History hammers in the hall  
As bidders heed the auction''s call.

Each lot tells its special tale  
Of kingdoms lost and holy grail.  
The gavel falls, the deal is done,  
Another chapter has begun.

From collector unto collector  
These metal memories transfer.  
Each new home, each caring hand  
Helps our heritage to stand.

## The Student''s Wonder

In wonder do I hold this coin,  
This messenger from distant time.  
What hands have touched its weathered face?  
What stories could its scratches rhyme?

Did merchants count it in their trade?  
Did pilgrims carry it afar?  
Did children play with it in streets  
Beneath some ancient, guiding star?

Each question leads to ten more,  
Each answer opens up new doors.  
In numismatics'' vast domain  
Lies learning''s everlasting gain.

## The Philanthropist''s Vision

Beyond the buying and the selling,  
Beyond the profit and the gain,  
Lies service to humanity  
And easing of collective pain.

Through education, preservation,  
And sharing knowledge far and wide,  
We build bridges between cultures  
With heritage as our guide.

The coins we study, love, and keep  
Are more than metal, more than art.  
They are the bonds that tie us all  
To history''s beating heart.

## The Future''s Promise

To those who''ll come when we are gone,  
We leave this legacy of care.  
The coins we''ve saved, the knowledge gained,  
The stories we''ve learned to share.

May you continue what we''ve started,  
May you preserve what we hold dear.  
May the heritage we''ve guarded  
Shine bright for many a year.

In digital age or distant time,  
When new technologies arise,  
Remember that the human touch  
Is what gives history its prize.

---

*These verses celebrate the passion, dedication, and vision of all who work to preserve our numismatic heritage. May they inspire continued commitment to this noble calling.*

> "In poetry, as in numismatics, we find the soul of a civilization expressed in its most concentrated form."',
  'https://images.pexels.com/photos/8849302/pexels-photo-8849302.jpeg?auto=compress&cs=tinysrgb&w=1200',
  false,
  true,
  '2024-02-20'::timestamptz
),
(
  'The Philosophy of Collecting: Beyond Material Possession',
  'philosophy-of-collecting-beyond-material-possession',
  'Exploring the deeper philosophical dimensions of collecting and its role in human culture and personal development',
  '# The Philosophy of Collecting: Beyond Material Possession

Collecting is often misunderstood as mere accumulation of objects, but at its deepest level, it represents one of humanity''s most profound expressions of meaning-making, cultural preservation, and spiritual connection. Through the lens of numismatics and philately, we can explore the philosophical dimensions that transform simple acquisition into a sacred practice.

## The Nature of Collecting

### Beyond Materialism
True collecting transcends material possession. It represents:

#### Stewardship
- **Temporary Guardianship** of cultural artifacts
- **Responsibility** for preservation and care
- **Trust** placed in us by history
- **Obligation** to future generations

#### Connection
- **Bridge** between past and present
- **Link** to human experiences across time
- **Thread** in the fabric of cultural continuity
- **Bond** with fellow collectors and scholars

### The Collector as Curator
Every serious collector becomes a curator of human experience:

#### Selection and Preservation
- **Discernment** in choosing what to preserve
- **Care** in maintaining condition and context
- **Documentation** of provenance and significance
- **Sharing** of knowledge and access

#### Interpretation and Meaning
- **Research** into historical context
- **Analysis** of cultural significance
- **Synthesis** of diverse information sources
- **Communication** of findings to others

## The Spiritual Dimensions

### Sacred Objects
In many traditions, certain objects carry spiritual significance:

#### Numismatic Spirituality
- **Temple Coins** as sacred artifacts
- **Religious Symbols** on currency
- **Blessing** of monetary transactions
- **Divine Protection** through sacred imagery

#### Meditative Practice
- **Contemplation** of historical significance
- **Reflection** on impermanence and change
- **Appreciation** of artistic beauty
- **Connection** with ancestral wisdom

### The Ritual of Collecting
Collecting often involves ritualistic elements:

#### Acquisition Rituals
- **Research** and preparation
- **Anticipation** and excitement
- **Moment of Acquisition** as sacred event
- **Integration** into collection

#### Care Rituals
- **Cleaning** and preservation
- **Organization** and cataloging
- **Display** and contemplation
- **Sharing** and teaching

## Psychological Dimensions

### Identity and Self-Expression
Collections often reflect and shape personal identity:

#### Self-Discovery
- **Exploration** of personal interests
- **Development** of expertise and knowledge
- **Expression** of values and aesthetics
- **Growth** through challenge and learning

#### Social Connection
- **Community** with fellow collectors
- **Mentorship** relationships
- **Cultural Participation** in preservation efforts
- **Legacy** creation for future generations

### The Paradox of Possession
Collecting reveals the paradox of ownership:

#### Temporary Stewardship
- **Illusion** of permanent ownership
- **Reality** of temporary guardianship
- **Responsibility** that transcends possession
- **Humility** before historical significance

#### Non-Attachment
- **Appreciation** without clinging
- **Enjoyment** without obsession
- **Sharing** without loss
- **Letting Go** when appropriate

## Cultural and Historical Significance

### Preservation of Heritage
Collectors play crucial roles in cultural preservation:

#### Documentation
- **Recording** of historical information
- **Cataloging** of variations and types
- **Photography** and digital preservation
- **Research** and publication

#### Education
- **Museum** donations and loans
- **Academic** collaboration
- **Public** exhibitions and talks
- **Student** mentorship and guidance

### Economic and Social Impact
Collecting creates positive economic and social effects:

#### Market Development
- **Value Discovery** for historical objects
- **Economic Activity** in related industries
- **Employment** for specialists and experts
- **Tourism** and cultural attractions

#### Social Benefits
- **Community Building** among enthusiasts
- **Educational Opportunities** for the public
- **Cultural Pride** and identity
- **International Understanding** through shared interests

## Ethical Considerations

### Responsible Collecting
Ethical collecting requires careful consideration:

#### Provenance and Legality
- **Legal Acquisition** through proper channels
- **Documented Provenance** when possible
- **Respect** for cultural patrimony laws
- **Cooperation** with law enforcement

#### Cultural Sensitivity
- **Understanding** of cultural significance
- **Respect** for sacred or sensitive objects
- **Collaboration** with source communities
- **Repatriation** when appropriate

### The Collector''s Responsibility
With collecting comes moral obligation:

#### Preservation Duty
- **Proper Care** and conservation
- **Environmental Protection** from damage
- **Security** against theft or loss
- **Documentation** for future reference

#### Sharing Obligation
- **Access** for researchers and students
- **Publication** of significant findings
- **Education** of the public
- **Mentorship** of new collectors

## The Transformative Power of Collecting

### Personal Transformation
Serious collecting often leads to personal growth:

#### Intellectual Development
- **Research Skills** and methodology
- **Critical Thinking** and analysis
- **Historical Understanding** and context
- **Cultural Appreciation** and sensitivity

#### Character Development
- **Patience** in long-term pursuits
- **Perseverance** through challenges
- **Humility** before vast knowledge
- **Generosity** in sharing discoveries

### Social Transformation
Collecting communities create positive social change:

#### Knowledge Creation
- **Collaborative Research** projects
- **Peer Review** and validation
- **Innovation** in preservation techniques
- **Discovery** of new information

#### Cultural Bridge-Building
- **International Cooperation** among collectors
- **Cross-Cultural Understanding** through shared interests
- **Diplomatic Relations** through cultural exchange
- **Peace Building** through common pursuits

## The Digital Age and Collecting

### New Opportunities
Technology creates new possibilities for collectors:

#### Digital Preservation
- **High-Resolution Imaging** for documentation
- **3D Scanning** for detailed analysis
- **Database Management** for organization
- **Virtual Exhibitions** for sharing

#### Global Connection
- **Online Communities** for collaboration
- **Digital Auctions** for access
- **Research Databases** for information
- **Educational Platforms** for learning

### Challenges and Considerations
Digital transformation also brings challenges:

#### Authenticity Concerns
- **Digital Manipulation** possibilities
- **Authentication** difficulties
- **Provenance** verification challenges
- **Trust** in digital representations

#### Human Connection
- **Physical Experience** importance
- **Personal Relationships** in collecting
- **Tactile Appreciation** of objects
- **Community Gathering** significance

## The Future of Collecting Philosophy

### Evolving Understanding
Our understanding of collecting continues to evolve:

#### Interdisciplinary Approaches
- **Anthropological** perspectives on collecting
- **Psychological** studies of collector behavior
- **Sociological** analysis of collecting communities
- **Philosophical** examination of meaning and value

#### Global Perspectives
- **Cross-Cultural** collecting traditions
- **Indigenous** approaches to preservation
- **Eastern** philosophies of possession
- **Universal** human collecting impulses

### Sustainable Collecting
Future collecting must be sustainable:

#### Environmental Responsibility
- **Conservation** techniques and materials
- **Digital** alternatives to physical storage
- **Sharing** resources and collections
- **Minimal Impact** preservation methods

#### Social Responsibility
- **Inclusive** collecting communities
- **Accessible** educational programs
- **Ethical** acquisition practices
- **Collaborative** preservation efforts

## Practical Applications

### For New Collectors
Understanding collecting philosophy helps newcomers:

#### Mindful Beginning
- **Intentional** collecting focus
- **Educational** approach to acquisition
- **Community** engagement from the start
- **Ethical** foundation for practice

#### Long-term Perspective
- **Patience** in building collections
- **Quality** over quantity emphasis
- **Learning** as primary goal
- **Service** to preservation mission

### For Experienced Collectors
Philosophical reflection enriches established practice:

#### Renewed Purpose
- **Deeper** understanding of mission
- **Enhanced** appreciation of responsibility
- **Expanded** vision of impact
- **Refined** approach to collecting

#### Legacy Planning
- **Thoughtful** disposition of collections
- **Educational** use of accumulated knowledge
- **Mentorship** of next generation
- **Institutional** collaboration for preservation

## Conclusion

The philosophy of collecting reveals that this ancient human practice is far more than the accumulation of objects. It is a form of cultural stewardship, spiritual practice, intellectual pursuit, and social service that connects us to the deepest currents of human experience.

When we collect with awareness of these deeper dimensions, we transform ourselves from mere acquirers into guardians of human heritage. We become links in an unbroken chain of preservation that stretches from the ancient past into the distant future.

In our modern world, where the pace of change threatens to disconnect us from our roots, collecting serves as an anchor to continuity and meaning. It reminds us that we are part of something larger than ourselves—a human story that deserves to be preserved, understood, and shared.

The true collector understands that they own nothing permanently, but are privileged to serve as temporary custodians of humanity''s treasures. In this service, they find not only personal fulfillment but also contribute to the great work of cultural preservation that defines our highest aspirations as human beings.

---

*May our collecting be guided by wisdom, motivated by service, and dedicated to the preservation of human heritage for all generations.*

> "The true collector does not possess objects; rather, the objects possess the collector with their stories, their beauty, and their call to preservation."',
  'https://images.pexels.com/photos/8849303/pexels-photo-8849303.jpeg?auto=compress&cs=tinysrgb&w=1200',
  false,
  true,
  '2024-02-25'::timestamptz
),
(
  'Digital Transformation in Numismatics: Embracing Technology',
  'digital-transformation-numismatics-embracing-technology',
  'How modern technology is revolutionizing numismatic research, authentication, and collection management',
  '# Digital Transformation in Numismatics: Embracing Technology

The field of numismatics is experiencing a revolutionary transformation as digital technologies reshape how we research, authenticate, catalog, and share our understanding of coins and currency. This digital evolution presents both unprecedented opportunities and unique challenges for collectors, researchers, and institutions worldwide.

## The Digital Revolution in Numismatics

### Historical Context
The transition from traditional to digital methods represents a paradigm shift:

#### Traditional Methods
- **Physical Examination** with magnifying glasses
- **Paper Catalogs** and reference books
- **Photography** with film cameras
- **Manual Record Keeping** in ledgers

#### Digital Evolution
- **High-Resolution Digital Imaging** with specialized equipment
- **Online Databases** and digital catalogs
- **3D Scanning** and modeling technologies
- **Cloud-Based** collection management systems

### Driving Forces
Several factors accelerate digital adoption:

#### Technological Advancement
- **Improved Camera** sensors and optics
- **Faster Internet** connectivity
- **Cloud Computing** accessibility
- **Mobile Technology** proliferation

#### Changing Expectations
- **Global Access** to information
- **Real-Time** communication and sharing
- **Interactive** learning experiences
- **Collaborative** research platforms

## Digital Imaging and Documentation

### Advanced Photography Techniques
Modern digital imaging surpasses traditional photography:

#### High-Resolution Capture
- **Macro Lenses** for extreme detail
- **Focus Stacking** for complete sharpness
- **Color Accuracy** with calibrated systems
- **Consistent Lighting** for reliable results

#### Specialized Equipment
- **Coin Photography** systems with controlled lighting
- **Multispectral Imaging** revealing hidden details
- **UV Photography** for authentication
- **Infrared Imaging** for analysis

### 3D Scanning and Modeling
Three-dimensional capture opens new possibilities:

#### Scanning Technologies
- **Photogrammetry** using multiple photographs
- **Structured Light** scanning systems
- **Laser Scanning** for precise measurements
- **CT Scanning** for internal structure

#### Applications
- **Virtual Exhibitions** accessible worldwide
- **Research Analysis** of wear patterns
- **Authentication** through detailed comparison
- **Educational Tools** for interactive learning

## Database Management and Cataloging

### Digital Catalog Systems
Modern databases revolutionize collection management:

#### Features and Capabilities
- **Searchable Fields** for quick retrieval
- **Image Integration** with detailed photos
- **Provenance Tracking** for complete history
- **Value Tracking** with market data

#### Popular Platforms
- **Numista** for community cataloging
- **CoinArchives** for auction records
- **PCGS CoinFacts** for certified coins
- **Custom Solutions** for institutional needs

### Standardization Efforts
Digital systems require consistent standards:

#### Metadata Standards
- **Dublin Core** for basic description
- **CIDOC-CRM** for cultural heritage
- **Numismatic Standards** for specific fields
- **Interoperability** between systems

#### Image Standards
- **Resolution Requirements** for different uses
- **Color Profiles** for accuracy
- **File Formats** for preservation
- **Naming Conventions** for organization

## Authentication and Analysis

### Digital Authentication Tools
Technology enhances authentication capabilities:

#### Image Analysis
- **Pixel-Level** examination of details
- **Comparison Algorithms** for matching
- **Pattern Recognition** for die varieties
- **Statistical Analysis** of measurements

#### Advanced Techniques
- **Spectroscopy** for metal composition
- **X-Ray Fluorescence** for non-destructive testing
- **Microscopy** for surface analysis
- **Weight Distribution** analysis

### Artificial Intelligence Applications
AI transforms numismatic analysis:

#### Machine Learning
- **Pattern Recognition** for classification
- **Anomaly Detection** for counterfeits
- **Predictive Modeling** for valuations
- **Natural Language** processing for research

#### Computer Vision
- **Automatic Grading** assistance
- **Die Variety** identification
- **Condition Assessment** standardization
- **Batch Processing** for large collections

## Online Marketplaces and Auctions

### Digital Commerce Evolution
Online platforms transform numismatic commerce:

#### Auction Platforms
- **Heritage Auctions** leading digital sales
- **Stack''s Bowers** online presence
- **Specialized Platforms** for different markets
- **International Access** to global auctions

#### Marketplace Features
- **Real-Time Bidding** systems
- **Detailed Photography** and descriptions
- **Condition Reports** and guarantees
- **Secure Payment** and shipping

### Challenges and Solutions
Digital commerce presents unique challenges:

#### Authentication Concerns
- **High-Quality Images** for examination
- **Return Policies** for protection
- **Third-Party Grading** for confidence
- **Reputation Systems** for trust

#### Market Transparency
- **Price Databases** for reference
- **Sales History** tracking
- **Market Analysis** tools
- **Educational Resources** for buyers

## Research and Collaboration

### Digital Research Tools
Technology enhances numismatic research:

#### Online Archives
- **Digitized Collections** from museums
- **Historical Documents** and records
- **Academic Papers** and publications
- **Collaborative Databases** for sharing

#### Research Platforms
- **Virtual Conferences** and symposiums
- **Online Journals** and publications
- **Collaborative Projects** across institutions
- **Crowdsourcing** for data collection

### Global Collaboration
Digital tools enable worldwide cooperation:

#### International Projects
- **Shared Databases** across borders
- **Joint Research** initiatives
- **Cultural Exchange** programs
- **Educational Partnerships** between institutions

#### Knowledge Sharing
- **Open Access** publications
- **Creative Commons** licensing
- **Data Sharing** agreements
- **Collaborative Standards** development

## Education and Outreach

### Digital Learning Platforms
Technology transforms numismatic education:

#### Online Courses
- **University Programs** with digital components
- **Professional Development** for dealers
- **Collector Education** through societies
- **Youth Programs** engaging new generations

#### Interactive Tools
- **Virtual Museums** and exhibitions
- **Augmented Reality** experiences
- **Gaming Elements** for engagement
- **Social Learning** platforms

### Public Engagement
Digital tools expand public access:

#### Virtual Exhibitions
- **360-Degree** viewing experiences
- **Interactive** storytelling
- **Multilingual** accessibility
- **Mobile-Friendly** interfaces

#### Social Media
- **Community Building** through platforms
- **Educational Content** sharing
- **Live Streaming** of events
- **Influencer** partnerships for outreach

## Preservation and Conservation

### Digital Preservation
Technology aids long-term preservation:

#### Documentation Standards
- **High-Resolution** archival imaging
- **Metadata Preservation** for context
- **Format Migration** strategies
- **Redundant Storage** systems

#### Conservation Applications
- **Condition Monitoring** through imaging
- **Treatment Documentation** with photos
- **Environmental Monitoring** with sensors
- **Preventive Conservation** planning

### Disaster Recovery
Digital systems enhance disaster preparedness:

#### Backup Strategies
- **Cloud Storage** for off-site backup
- **Distributed Systems** for redundancy
- **Regular Testing** of recovery procedures
- **Documentation** of critical information

#### Emergency Response
- **Rapid Assessment** tools
- **Damage Documentation** systems
- **Recovery Planning** software
- **Insurance** claim support

## Challenges and Considerations

### Technical Challenges
Digital transformation faces obstacles:

#### Infrastructure Requirements
- **High-Speed Internet** for large files
- **Storage Capacity** for growing collections
- **Processing Power** for analysis
- **Specialized Equipment** costs

#### Skills and Training
- **Digital Literacy** for users
- **Technical Support** requirements
- **Ongoing Education** for new technologies
- **Generational Gaps** in adoption

### Ethical and Legal Issues
Digital systems raise important concerns:

#### Privacy and Security
- **Data Protection** regulations
- **Cybersecurity** threats
- **Access Control** systems
- **User Privacy** considerations

#### Intellectual Property
- **Copyright** issues with images
- **Fair Use** in educational contexts
- **Commercial Rights** for databases
- **Attribution** requirements

## Future Trends and Innovations

### Emerging Technologies
New technologies promise further transformation:

#### Blockchain Applications
- **Provenance Tracking** with immutable records
- **Authentication** through digital certificates
- **Smart Contracts** for transactions
- **Decentralized** databases

#### Virtual and Augmented Reality
- **Immersive** museum experiences
- **Virtual Handling** of rare coins
- **Educational** simulations
- **Remote Collaboration** tools

### Predictive Analytics
Data analysis reveals future trends:

#### Market Predictions
- **Price Forecasting** models
- **Demand Analysis** for different types
- **Investment** guidance tools
- **Risk Assessment** systems

#### Collection Management
- **Acquisition** recommendations
- **Conservation** priority planning
- **Insurance** value updates
- **Disposal** timing optimization

## Implementation Strategies

### For Individual Collectors
Personal digital transformation approaches:

#### Starting Points
- **Digital Photography** of collections
- **Spreadsheet** or database creation
- **Online Research** skill development
- **Community Participation** in digital platforms

#### Advanced Steps
- **Professional Photography** equipment
- **Specialized Software** for cataloging
- **3D Scanning** for valuable pieces
- **Backup Systems** for data protection

### For Institutions
Organizational digital strategies:

#### Planning Phase
- **Needs Assessment** and goal setting
- **Budget Planning** for technology
- **Staff Training** programs
- **Vendor Selection** for systems

#### Implementation Phase
- **Pilot Projects** for testing
- **Gradual Rollout** of systems
- **User Training** and support
- **Continuous Improvement** processes

## Best Practices and Recommendations

### Quality Standards
Maintaining excellence in digital work:

#### Image Quality
- **Consistent Lighting** and backgrounds
- **Color Accuracy** with calibration
- **Appropriate Resolution** for intended use
- **File Naming** conventions

#### Data Management
- **Regular Backups** and testing
- **Version Control** for updates
- **Access Controls** for security
- **Documentation** of procedures

### Collaboration Guidelines
Working effectively in digital environments:

#### Sharing Protocols
- **Permission Systems** for access
- **Attribution** requirements
- **Quality Standards** for contributions
- **Communication** channels

#### Community Building
- **Inclusive** participation policies
- **Mentorship** programs for newcomers
- **Recognition** systems for contributors
- **Feedback** mechanisms for improvement

## Conclusion

The digital transformation of numismatics represents one of the most significant developments in the field''s modern history. While challenges exist, the opportunities for enhanced research, improved accessibility, and global collaboration far outweigh the obstacles.

Success in this digital age requires embracing new technologies while maintaining the scholarly rigor and ethical standards that define our field. By combining traditional numismatic expertise with modern digital tools, we can preserve our heritage more effectively and share it more widely than ever before.

The future of numismatics lies not in choosing between traditional and digital approaches, but in thoughtfully integrating both to create a more comprehensive, accessible, and sustainable field of study. As we move forward, our commitment to excellence, education, and preservation must guide our adoption of new technologies.

---

*The digital transformation of numismatics is not just about technology—it''s about expanding our ability to preserve, understand, and share the rich heritage contained in the world''s coins and currency.*

> "Technology is not the destination, but the vehicle that carries us toward better preservation, deeper understanding, and wider sharing of our numismatic heritage."',
  'https://images.pexels.com/photos/8849304/pexels-photo-8849304.jpeg?auto=compress&cs=tinysrgb&w=1200',
  false,
  true,
  '2024-03-01'::timestamptz
)
ON CONFLICT (slug) DO NOTHING;

-- Link new posts to categories
DO $$
DECLARE
  verses_post_id uuid;
  philosophy_post_id uuid;
  digital_post_id uuid;
  poems_cat_id uuid;
  thoughts_cat_id uuid;
  numismatics_cat_id uuid;
  business_cat_id uuid;
BEGIN
  -- Get post IDs
  SELECT id INTO verses_post_id FROM blog_posts WHERE slug = 'verses-of-heritage';
  SELECT id INTO philosophy_post_id FROM blog_posts WHERE slug = 'philosophy-of-collecting-beyond-material-possession';
  SELECT id INTO digital_post_id FROM blog_posts WHERE slug = 'digital-transformation-numismatics-embracing-technology';
  
  -- Get category IDs
  SELECT id INTO poems_cat_id FROM categories WHERE slug = 'poems';
  SELECT id INTO thoughts_cat_id FROM categories WHERE slug = 'thoughts';
  SELECT id INTO numismatics_cat_id FROM categories WHERE slug = 'numismatics';
  SELECT id INTO business_cat_id FROM categories WHERE slug = 'business';
  
  -- Link posts to categories
  INSERT INTO post_categories (post_id, category_id) VALUES
    (verses_post_id, poems_cat_id),
    (verses_post_id, numismatics_cat_id),
    (philosophy_post_id, thoughts_cat_id),
    (philosophy_post_id, numismatics_cat_id),
    (digital_post_id, numismatics_cat_id),
    (digital_post_id, business_cat_id)
  ON CONFLICT (post_id, category_id) DO NOTHING;
END $$;

-- Link new posts to tags
DO $$
DECLARE
  verses_post_id uuid;
  philosophy_post_id uuid;
  digital_post_id uuid;
  numismatics_tag_id uuid;
  heritage_tag_id uuid;
  collecting_tag_id uuid;
  business_tag_id uuid;
BEGIN
  -- Get post IDs
  SELECT id INTO verses_post_id FROM blog_posts WHERE slug = 'verses-of-heritage';
  SELECT id INTO philosophy_post_id FROM blog_posts WHERE slug = 'philosophy-of-collecting-beyond-material-possession';
  SELECT id INTO digital_post_id FROM blog_posts WHERE slug = 'digital-transformation-numismatics-embracing-technology';
  
  -- Get tag IDs
  SELECT id INTO numismatics_tag_id FROM tags WHERE slug = 'numismatics';
  SELECT id INTO heritage_tag_id FROM tags WHERE slug = 'heritage';
  SELECT id INTO collecting_tag_id FROM tags WHERE slug = 'collecting';
  SELECT id INTO business_tag_id FROM tags WHERE slug = 'business';
  
  -- Link posts to tags
  INSERT INTO post_tags (post_id, tag_id) VALUES
    (verses_post_id, numismatics_tag_id),
    (verses_post_id, heritage_tag_id),
    (philosophy_post_id, collecting_tag_id),
    (philosophy_post_id, heritage_tag_id),
    (digital_post_id, numismatics_tag_id),
    (digital_post_id, business_tag_id)
  ON CONFLICT (post_id, tag_id) DO NOTHING;
END $$;