Post once, publish everywhere — seamless cross-platform social posting.
A lightweight MVP for managing and publishing content across multiple social platforms from one dashboard.

• 🔐 User authentication & simple profile.
• 🔗 Connect 2–3 platforms (Twitter/X, LinkedIn, Facebook).
• 📝 Create a post (text + image upload).
• 📢 Publish simultaneously across connected platforms.
• ⏰ Post scheduling (basic).
• 📊 Dashboard showing posted history.

Frontend: Vue / Inertia
Backend: Laravel Database: PostgreSQL
APIs: Twitter/X API, Facebook Graph API, LinkedIn API
Infrastructure: AWS

# Clone repo
git clone https://github.com/zerexei/posexei.git
cd posexei

# Install dependencies
composer install
npm install

# Run app
composer run dev

#users

• organization_id

#organizations

• owner_id
• invoice_counter

#platform

• name (Facebook/Instagram/LinkedIn)
• endpoint

#platform_connections

• platform_id
• user_id // created_by
• organization_id
• account_name
• access_token
• refresh_token
• token_expires_at

#posts

• user_id // created_by
• organization_id
• content
• scheduled_at
• status (draft / scheduled)

#post_media

• post_id
• type (image, video, gif)
• url
• order_index (to preserve order for carousels)
• metadata (jsonb for dimensions, duration, etc.)

// if post has media -> handle media else text

#post_platform_status

• post_id
• platform_connection_id
• status (pending / success / failed)
• platform_post_id

platform->posts post->platform

#packages

• name
• description
• amount
• billing_interval (monthly / yearly)
• max_users
• max_posts_per_month

#add_ons

• name
• description
• amount
• billing_interval (monthly / yearly)

#payment_providers

• name
• description
• endpoint
• status (active / inactive)

#package_subscriptions

• package_id
• organization_id
• status
• start_date
• end_date
• auto_renew
• payment_provider_id
• reference_id

#addon_subscriptions

• addon_id
• organization_id
• status
• start_date
• end_date
• quantity
• auto_renew

#invoices

• invoice_number
• total_amount
• status (pending / paid / failed / cancelled)

#invoice_items

• invoice_id
• subscription_id
• subscription_type
• quantity

#payment_transactions

• invoice_id
• transaction_type (charge / refund)
• payment_provider_id
• provider_transaction_id
• amount
• currency
• status (pending | succeeded | failed | refunded)
• raw_payload