Vibecode PosteAhora

You are building a lean indie version of PosteAhora.

Create the following project files first, then implement the application by following them. Keep the files updated as decisions change. Do not collapse this into a single README or prompt.

===== README.md =====
# PosteAhora indie build

## Goal

Build the smallest trustworthy replacement for the core PosteAhora workflow for one developer or a tiny team.

## Scope

Compose posts into a slot-based queue, publish on schedule to open-API networks through per-network adapters, and log outcomes, with a push-to-post-by-hand fallback for the approval-gated platforms.

## Quick start

1. Install the documented dependencies.
2. Copy `.env.example` to `.env`.
3. Run the development command chosen during implementation.
4. Complete the acceptance checks in `BUILD_PLAN.md`.

## Honest limits

This build deliberately does not replace:
- one-click connect to approval-gated platforms (Instagram, TikTok, YouTube, Facebook, Threads, LinkedIn)
- pre-approved platform OAuth apps you often cannot obtain as an individual
- per-platform media handling and token-refresh babysitting as APIs and policies change
- cross-network analytics, an ideas kanban, workspaces and team roles
- the hosted API and MCP server that lets a coding agent post for you

If those capabilities are essential, use Postiz instead of pretending the gap is solved.

===== AGENTS.md =====
# Agent instructions

- Optimize for a working, understandable weekend build.
- Prefer the fewest moving parts that satisfy the brief.
- Do not invent cryptography, security guarantees, APIs, or compliance claims.
- Keep secrets out of source control and logs.
- Add focused tests for destructive, security-sensitive, and data-loss paths.
- Run the project checks before declaring the build complete.
- Record any deliberate shortcut in the README under "Tradeoffs".

===== BUILD_PLAN.md =====
# Build plan

## Original build brief

Build me a personal social post scheduler to replace PosteAhora. Requirements:

- Node + Express + better-sqlite3; a localhost page with a compose box,
  image/video attach, and the queue ordered by send time.
- Targets with open APIs only: Bluesky (app password via @atproto/api),
  Mastodon (access token), and a Telegram channel (bot token). Creds in
  .env, one small adapter file per network so a fourth is addable later.
- For the approval-gated platforms people actually want (Instagram, TikTok,
  YouTube, Facebook, Threads, LinkedIn), do NOT fight their APIs: at post
  time send me an ntfy.sh push with the caption and media path so I post by
  hand in a minute. Say clearly in the README that these need approved
  developer apps and business verification you cannot one-shot.
- Slot-based queue: I define posting times per weekday in my timezone and
  new posts fill the next free slot; a post can also be pinned to an exact
  datetime or duplicated across networks with per-network text and counts.
- A node-cron tick every minute publishes due posts, marks each row sent or
  failed, retries failures 3 times with backoff, and marks before sending so
  nothing double-posts.
- Per-network character counter in the composer (X counts URLs as 23 and
  most emoji as 2); attached media stored in media/ next to the database,
  images resized per network with sharp.
- A history page of the last 100 sent posts linking to the live posts.
- Runs on my always-on box; localhost only, no accounts, no telemetry.
- Out of scope: cross-network analytics, teams and approvals, and
  per-platform video transcoding.
- README: getting a Bluesky app password, a Mastodon token and a Telegram
  bot token, plus an honest note that social APIs drift and this needs
  occasional patching.

## Required capabilities

- OAuth/API access per social network
- always-on box for the scheduler
- database
- media storage

## Delivery order

1. Scaffold the smallest runnable application and document its commands.
2. Implement the primary data model and core workflow.
3. Add validation, safe failure states, and persistence.
4. Cover the critical path with automated tests.
5. Exercise a clean install from the README and fix every missing step.

## Done when

- A new user can go from clone to first successful workflow using only the README.
- The core workflow works without paid infrastructure unless the brief requires it.
- Tests cover the highest-risk behavior.
- Known limitations are explicit rather than hidden.

===== .env.example =====
# Copy to .env and document every variable when it is introduced.
# Never put real credentials in this file.

APP_ENV=development
# Add only values required by the selected implementation.

You are building a lean indie version of PosteAhora.

Create the following project files first, then implement the application by following them. Keep the files updated as decisions change. Do not collapse this into a single README or prompt.

===== README.md =====
# PosteAhora indie build

## Goal

Build the smallest trustworthy replacement for the core PosteAhora workflow for one developer or a tiny team.

## Scope

Compose posts into a slot-based queue, publish on schedule to open-API networks through per-network adapters, and log outcomes, with a push-to-post-by-hand fallback for the approval-gated platforms.

## Quick start

1. Install the documented dependencies.
2. Copy `.env.example` to `.env`.
3. Run the development command chosen during implementation.
4. Complete the acceptance checks in `BUILD_PLAN.md`.

## Honest limits

This build deliberately does not replace:
- one-click connect to approval-gated platforms (Instagram, TikTok, YouTube, Facebook, Threads, LinkedIn)
- pre-approved platform OAuth apps you often cannot obtain as an individual
- per-platform media handling and token-refresh babysitting as APIs and policies change
- cross-network analytics, an ideas kanban, workspaces and team roles
- the hosted API and MCP server that lets a coding agent post for you

If those capabilities are essential, use Postiz instead of pretending the gap is solved.

===== AGENTS.md =====
# Agent instructions

- Optimize for a working, understandable weekend build.
- Prefer the fewest moving parts that satisfy the brief.
- Do not invent cryptography, security guarantees, APIs, or compliance claims.
- Keep secrets out of source control and logs.
- Add focused tests for destructive, security-sensitive, and data-loss paths.
- Run the project checks before declaring the build complete.
- Record any deliberate shortcut in the README under "Tradeoffs".

===== BUILD_PLAN.md =====
# Build plan

## Original build brief

Build me a personal social post scheduler to replace PosteAhora. Requirements:

- Node + Express + better-sqlite3; a localhost page with a compose box,
  image/video attach, and the queue ordered by send time.
- Targets with open APIs only: Bluesky (app password via @atproto/api),
  Mastodon (access token), and a Telegram channel (bot token). Creds in
  .env, one small adapter file per network so a fourth is addable later.
- For the approval-gated platforms people actually want (Instagram, TikTok,
  YouTube, Facebook, Threads, LinkedIn), do NOT fight their APIs: at post
  time send me an ntfy.sh push with the caption and media path so I post by
  hand in a minute. Say clearly in the README that these need approved
  developer apps and business verification you cannot one-shot.
- Slot-based queue: I define posting times per weekday in my timezone and
  new posts fill the next free slot; a post can also be pinned to an exact
  datetime or duplicated across networks with per-network text and counts.
- A node-cron tick every minute publishes due posts, marks each row sent or
  failed, retries failures 3 times with backoff, and marks before sending so
  nothing double-posts.
- Per-network character counter in the composer (X counts URLs as 23 and
  most emoji as 2); attached media stored in media/ next to the database,
  images resized per network with sharp.
- A history page of the last 100 sent posts linking to the live posts.
- Runs on my always-on box; localhost only, no accounts, no telemetry.
- Out of scope: cross-network analytics, teams and approvals, and
  per-platform video transcoding.
- README: getting a Bluesky app password, a Mastodon token and a Telegram
  bot token, plus an honest note that social APIs drift and this needs
  occasional patching.

## Required capabilities

- OAuth/API access per social network
- always-on box for the scheduler
- database
- media storage

## Delivery order

1. Scaffold the smallest runnable application and document its commands.
2. Implement the primary data model and core workflow.
3. Add validation, safe failure states, and persistence.
4. Cover the critical path with automated tests.
5. Exercise a clean install from the README and fix every missing step.

## Done when

- A new user can go from clone to first successful workflow using only the README.
- The core workflow works without paid infrastructure unless the brief requires it.
- Tests cover the highest-risk behavior.
- Known limitations are explicit rather than hidden.

===== .env.example =====
# Copy to .env and document every variable when it is introduced.
# Never put real credentials in this file.

APP_ENV=development
# Add only values required by the selected implementation.

You are building a production product version of PosteAhora.

Create the following project files first, then implement the application by following them. Keep the files updated as decisions change. Do not collapse this into a single README or prompt.

===== PRODUCT.md =====
# PosteAhora product brief

## Problem

The core loop, compose into a queue, tick a cron, publish, log the result, is one-shottable for the open networks like Bluesky, Mastodon and a Telegram channel. What you cannot one-shot is the reason PosteAhora exists: one-click posting to Instagram, TikTok, YouTube, Facebook, Threads and LinkedIn. Those APIs sit behind Meta App Review, TikTok's Content Posting API, YouTube quota and business verification, gates an individual often cannot even qualify for. On top of that sit per-platform media handling (Instagram carousels, TikTok photo vs video, small-Reel framing, X's 280-vs-25k length math), constant token-refresh babysitting as tokens expire and policies drift, and a hosted API plus MCP server so a coding agent can post for you. You can vibecode a personal cross-poster for the open networks in a sitting. You cannot vibecode the approvals.

## Product outcome

Compose posts into a slot-based queue, publish on schedule to open-API networks through per-network adapters, and log outcomes, with a push-to-post-by-hand fallback for the approval-gated platforms.

## Target user

A serious builder who needs a maintainable product foundation rather than a one-off demo.

## Required capabilities

- OAuth/API access per social network
- always-on box for the scheduler
- database
- media storage

## Explicit non-goals for v1

- one-click connect to approval-gated platforms (Instagram, TikTok, YouTube, Facebook, Threads, LinkedIn)
- pre-approved platform OAuth apps you often cannot obtain as an individual
- per-platform media handling and token-refresh babysitting as APIs and policies change
- cross-network analytics, an ideas kanban, workspaces and team roles
- the hosted API and MCP server that lets a coding agent post for you

## Success criteria

- The primary workflow is measurable end to end.
- Setup is reproducible in a clean environment.
- Failure, recovery, and support paths are documented.
- Product claims match what the implementation actually guarantees.

===== ARCHITECTURE.md =====
# Architecture

## Starting brief

Build me a personal social post scheduler to replace PosteAhora. Requirements:

- Node + Express + better-sqlite3; a localhost page with a compose box,
  image/video attach, and the queue ordered by send time.
- Targets with open APIs only: Bluesky (app password via @atproto/api),
  Mastodon (access token), and a Telegram channel (bot token). Creds in
  .env, one small adapter file per network so a fourth is addable later.
- For the approval-gated platforms people actually want (Instagram, TikTok,
  YouTube, Facebook, Threads, LinkedIn), do NOT fight their APIs: at post
  time send me an ntfy.sh push with the caption and media path so I post by
  hand in a minute. Say clearly in the README that these need approved
  developer apps and business verification you cannot one-shot.
- Slot-based queue: I define posting times per weekday in my timezone and
  new posts fill the next free slot; a post can also be pinned to an exact
  datetime or duplicated across networks with per-network text and counts.
- A node-cron tick every minute publishes due posts, marks each row sent or
  failed, retries failures 3 times with backoff, and marks before sending so
  nothing double-posts.
- Per-network character counter in the composer (X counts URLs as 23 and
  most emoji as 2); attached media stored in media/ next to the database,
  images resized per network with sharp.
- A history page of the last 100 sent posts linking to the live posts.
- Runs on my always-on box; localhost only, no accounts, no telemetry.
- Out of scope: cross-network analytics, teams and approvals, and
  per-platform video transcoding.
- README: getting a Bluesky app password, a Mastodon token and a Telegram
  bot token, plus an honest note that social APIs drift and this needs
  occasional patching.

## Boundaries

Separate the product into replaceable modules for interface, application logic, persistence, external integrations, and operational concerns. Keep domain logic independent from delivery frameworks and vendors.

## Production baseline

- Configuration: validated at startup with safe local defaults where possible.
- Security: least privilege, input validation, secret redaction, rate limits on abuse-prone paths, and no invented security primitives.
- Data: explicit schema and migrations, transactional writes where integrity matters, backup and restore instructions.
- Integrations: adapters around third-party providers, idempotent webhook or job processing, bounded retries, and timeouts.
- Observability: structured logs with request or operation IDs, an error-tracking hook, and health/readiness checks where a server exists.
- Quality: unit tests for domain rules, integration tests at module boundaries, and one end-to-end critical-path test.

## Decision records

For each major dependency, document why it was chosen, its failure mode, and how it can be replaced. Do not introduce infrastructure until a requirement justifies it.

===== AGENTS.md =====
# Agent instructions

- Read `PRODUCT.md` and `ARCHITECTURE.md` before changing code.
- Implement milestone by milestone; keep each change reviewable and leave the application runnable.
- Treat authentication, payments, encryption, imports, webhooks, and destructive actions as high-risk boundaries when present.
- Never invent cryptography or silently weaken a requirement to make a test pass.
- Use provider interfaces for external services and deterministic fakes in tests.
- Add migrations and rollback or recovery notes for persistent data changes.
- Log useful operational context without credentials, tokens, passwords, or personal data.
- Update documentation and run all checks before completing a milestone.

===== MILESTONES.md =====
# Delivery milestones

## M0 — Decisions and scaffold

- Confirm the runtime, persistence model, threat boundaries, and deployment target.
- Create a reproducible local environment and continuous checks.

## M1 — Core workflow

- Implement the smallest end-to-end product path with validation and tests.
- Keep integrations behind interfaces.

## M2 — Trust layer

- Add secure failure behavior, recovery paths, audit-relevant events, and data safeguards.
- Test abuse cases and destructive operations.

## M3 — Operability

- Add structured logs, error reporting hooks, health signals, backup/restore documentation, and deployment configuration.

## M4 — Release gate

- Run a clean-install test, critical-path end-to-end test, dependency review, and documented rollback exercise.
- Compare the shipped behavior with `PRODUCT.md` and publish remaining limitations.

===== OPERATIONS.md =====
# Operations

## Before release

- Validate configuration and secrets at startup.
- Define backup, restore, and rollback procedures and test them.
- Document logs, error tracking, health signals, and alert ownership.
- Set dependency update and vulnerability review expectations.

## Incident checklist

1. Contain the issue without destroying evidence or user data.
2. Record the timeline and affected scope.
3. Rotate exposed secrets and revoke compromised sessions or credentials.
4. Restore from a verified source when needed.
5. Document the root cause, remediation, and regression test.

## Launch constraint

Do not market omitted PosteAhora capabilities as implemented. The v1 non-goals in `PRODUCT.md` remain user-visible limitations until they are deliberately delivered.

# PosteAhora indie build

## Goal

Build the smallest trustworthy replacement for the core PosteAhora workflow for one developer or a tiny team.

## Scope

Compose posts into a slot-based queue, publish on schedule to open-API networks through per-network adapters, and log outcomes, with a push-to-post-by-hand fallback for the approval-gated platforms.

## Quick start

1. Install the documented dependencies.
2. Copy `.env.example` to `.env`.
3. Run the development command chosen during implementation.
4. Complete the acceptance checks in `BUILD_PLAN.md`.

## Honest limits

This build deliberately does not replace:
- one-click connect to approval-gated platforms (Instagram, TikTok, YouTube, Facebook, Threads, LinkedIn)
- pre-approved platform OAuth apps you often cannot obtain as an individual
- per-platform media handling and token-refresh babysitting as APIs and policies change
- cross-network analytics, an ideas kanban, workspaces and team roles
- the hosted API and MCP server that lets a coding agent post for you

If those capabilities are essential, use Postiz instead of pretending the gap is solved.

# Agent instructions

- Optimize for a working, understandable weekend build.
- Prefer the fewest moving parts that satisfy the brief.
- Do not invent cryptography, security guarantees, APIs, or compliance claims.
- Keep secrets out of source control and logs.
- Add focused tests for destructive, security-sensitive, and data-loss paths.
- Run the project checks before declaring the build complete.
- Record any deliberate shortcut in the README under "Tradeoffs".

# Build plan

## Original build brief

Build me a personal social post scheduler to replace PosteAhora. Requirements:

- Node + Express + better-sqlite3; a localhost page with a compose box,
  image/video attach, and the queue ordered by send time.
- Targets with open APIs only: Bluesky (app password via @atproto/api),
  Mastodon (access token), and a Telegram channel (bot token). Creds in
  .env, one small adapter file per network so a fourth is addable later.
- For the approval-gated platforms people actually want (Instagram, TikTok,
  YouTube, Facebook, Threads, LinkedIn), do NOT fight their APIs: at post
  time send me an ntfy.sh push with the caption and media path so I post by
  hand in a minute. Say clearly in the README that these need approved
  developer apps and business verification you cannot one-shot.
- Slot-based queue: I define posting times per weekday in my timezone and
  new posts fill the next free slot; a post can also be pinned to an exact
  datetime or duplicated across networks with per-network text and counts.
- A node-cron tick every minute publishes due posts, marks each row sent or
  failed, retries failures 3 times with backoff, and marks before sending so
  nothing double-posts.
- Per-network character counter in the composer (X counts URLs as 23 and
  most emoji as 2); attached media stored in media/ next to the database,
  images resized per network with sharp.
- A history page of the last 100 sent posts linking to the live posts.
- Runs on my always-on box; localhost only, no accounts, no telemetry.
- Out of scope: cross-network analytics, teams and approvals, and
  per-platform video transcoding.
- README: getting a Bluesky app password, a Mastodon token and a Telegram
  bot token, plus an honest note that social APIs drift and this needs
  occasional patching.

## Required capabilities

- OAuth/API access per social network
- always-on box for the scheduler
- database
- media storage

## Delivery order

1. Scaffold the smallest runnable application and document its commands.
2. Implement the primary data model and core workflow.
3. Add validation, safe failure states, and persistence.
4. Cover the critical path with automated tests.
5. Exercise a clean install from the README and fix every missing step.

## Done when

- A new user can go from clone to first successful workflow using only the README.
- The core workflow works without paid infrastructure unless the brief requires it.
- Tests cover the highest-risk behavior.
- Known limitations are explicit rather than hidden.

# Copy to .env and document every variable when it is introduced.
# Never put real credentials in this file.

APP_ENV=development
# Add only values required by the selected implementation.

# PosteAhora product brief

## Problem

The core loop, compose into a queue, tick a cron, publish, log the result, is one-shottable for the open networks like Bluesky, Mastodon and a Telegram channel. What you cannot one-shot is the reason PosteAhora exists: one-click posting to Instagram, TikTok, YouTube, Facebook, Threads and LinkedIn. Those APIs sit behind Meta App Review, TikTok's Content Posting API, YouTube quota and business verification, gates an individual often cannot even qualify for. On top of that sit per-platform media handling (Instagram carousels, TikTok photo vs video, small-Reel framing, X's 280-vs-25k length math), constant token-refresh babysitting as tokens expire and policies drift, and a hosted API plus MCP server so a coding agent can post for you. You can vibecode a personal cross-poster for the open networks in a sitting. You cannot vibecode the approvals.

## Product outcome

Compose posts into a slot-based queue, publish on schedule to open-API networks through per-network adapters, and log outcomes, with a push-to-post-by-hand fallback for the approval-gated platforms.

## Target user

A serious builder who needs a maintainable product foundation rather than a one-off demo.

## Required capabilities

- OAuth/API access per social network
- always-on box for the scheduler
- database
- media storage

## Explicit non-goals for v1

- one-click connect to approval-gated platforms (Instagram, TikTok, YouTube, Facebook, Threads, LinkedIn)
- pre-approved platform OAuth apps you often cannot obtain as an individual
- per-platform media handling and token-refresh babysitting as APIs and policies change
- cross-network analytics, an ideas kanban, workspaces and team roles
- the hosted API and MCP server that lets a coding agent post for you

## Success criteria

- The primary workflow is measurable end to end.
- Setup is reproducible in a clean environment.
- Failure, recovery, and support paths are documented.
- Product claims match what the implementation actually guarantees.

# Architecture

## Starting brief

Build me a personal social post scheduler to replace PosteAhora. Requirements:

- Node + Express + better-sqlite3; a localhost page with a compose box,
  image/video attach, and the queue ordered by send time.
- Targets with open APIs only: Bluesky (app password via @atproto/api),
  Mastodon (access token), and a Telegram channel (bot token). Creds in
  .env, one small adapter file per network so a fourth is addable later.
- For the approval-gated platforms people actually want (Instagram, TikTok,
  YouTube, Facebook, Threads, LinkedIn), do NOT fight their APIs: at post
  time send me an ntfy.sh push with the caption and media path so I post by
  hand in a minute. Say clearly in the README that these need approved
  developer apps and business verification you cannot one-shot.
- Slot-based queue: I define posting times per weekday in my timezone and
  new posts fill the next free slot; a post can also be pinned to an exact
  datetime or duplicated across networks with per-network text and counts.
- A node-cron tick every minute publishes due posts, marks each row sent or
  failed, retries failures 3 times with backoff, and marks before sending so
  nothing double-posts.
- Per-network character counter in the composer (X counts URLs as 23 and
  most emoji as 2); attached media stored in media/ next to the database,
  images resized per network with sharp.
- A history page of the last 100 sent posts linking to the live posts.
- Runs on my always-on box; localhost only, no accounts, no telemetry.
- Out of scope: cross-network analytics, teams and approvals, and
  per-platform video transcoding.
- README: getting a Bluesky app password, a Mastodon token and a Telegram
  bot token, plus an honest note that social APIs drift and this needs
  occasional patching.

## Boundaries

Separate the product into replaceable modules for interface, application logic, persistence, external integrations, and operational concerns. Keep domain logic independent from delivery frameworks and vendors.

## Production baseline

- Configuration: validated at startup with safe local defaults where possible.
- Security: least privilege, input validation, secret redaction, rate limits on abuse-prone paths, and no invented security primitives.
- Data: explicit schema and migrations, transactional writes where integrity matters, backup and restore instructions.
- Integrations: adapters around third-party providers, idempotent webhook or job processing, bounded retries, and timeouts.
- Observability: structured logs with request or operation IDs, an error-tracking hook, and health/readiness checks where a server exists.
- Quality: unit tests for domain rules, integration tests at module boundaries, and one end-to-end critical-path test.

## Decision records

For each major dependency, document why it was chosen, its failure mode, and how it can be replaced. Do not introduce infrastructure until a requirement justifies it.

# Agent instructions

- Read `PRODUCT.md` and `ARCHITECTURE.md` before changing code.
- Implement milestone by milestone; keep each change reviewable and leave the application runnable.
- Treat authentication, payments, encryption, imports, webhooks, and destructive actions as high-risk boundaries when present.
- Never invent cryptography or silently weaken a requirement to make a test pass.
- Use provider interfaces for external services and deterministic fakes in tests.
- Add migrations and rollback or recovery notes for persistent data changes.
- Log useful operational context without credentials, tokens, passwords, or personal data.
- Update documentation and run all checks before completing a milestone.

# Delivery milestones

## M0 — Decisions and scaffold

- Confirm the runtime, persistence model, threat boundaries, and deployment target.
- Create a reproducible local environment and continuous checks.

## M1 — Core workflow

- Implement the smallest end-to-end product path with validation and tests.
- Keep integrations behind interfaces.

## M2 — Trust layer

- Add secure failure behavior, recovery paths, audit-relevant events, and data safeguards.
- Test abuse cases and destructive operations.

## M3 — Operability

- Add structured logs, error reporting hooks, health signals, backup/restore documentation, and deployment configuration.

## M4 — Release gate

- Run a clean-install test, critical-path end-to-end test, dependency review, and documented rollback exercise.
- Compare the shipped behavior with `PRODUCT.md` and publish remaining limitations.

# Operations

## Before release

- Validate configuration and secrets at startup.
- Define backup, restore, and rollback procedures and test them.
- Document logs, error tracking, health signals, and alert ownership.
- Set dependency update and vulnerability review expectations.

## Incident checklist

1. Contain the issue without destroying evidence or user data.
2. Record the timeline and affected scope.
3. Rotate exposed secrets and revoke compromised sessions or credentials.
4. Restore from a verified source when needed.
5. Document the root cause, remediation, and regression test.

## Launch constraint

Do not market omitted PosteAhora capabilities as implemented. The v1 non-goals in `PRODUCT.md` remain user-visible limitations until they are deliberately delivered.

$ choose a build depth, inspect the files, then open the complete pack in your agent