Overview
Dayflow and PgDog are both open-source tools, but they address entirely different problems. Dayflow is a macOS app that uses AI and screen recording to automatically journal your workday, helping you remember accomplishments for standups, 1:1s, and performance reviews. PgDog is a PostgreSQL proxy that combines connection pooling, load balancing, and sharding into a single executable, designed to scale Postgres databases without application changes.
Feature Comparison
| Feature | Dayflow | PgDog |
|---|---|---|
| Primary Function | Automatic work journaling and time tracking | PostgreSQL connection pooler, load balancer, sharding proxy |
| Target Users | Developers, freelancers, knowledge workers | Database engineers, DevOps, backend teams |
| Deployment | Native macOS app (SwiftUI), local-first | Single executable, deployable via Docker, Helm, or binary |
| Open Source License | MIT License | Open source (community-driven) |
| AI / Intelligence | Uses AI (local or cloud) to analyze screen captures and generate summaries | No AI; uses SQL parsing for read/write splitting and sharding |
| Privacy / Security | Local storage, local AI option, open source for auditability | Proxy-level security, no data inspection beyond query routing |
| Scalability | Personal use, single machine | Handles 2M+ queries/s, 20TB+ sharded data in production |
| Key Differentiator | Automated, context-aware work journal without manual logging | Drop-in PostgreSQL proxy combining pooling, load balancing, and sharding |
Pricing
Dayflow: Free and open-source (MIT). You can use it with local AI models (Ollama/LM Studio) at no cost. Cloud AI providers like ChatGPT or Claude require their own paid subscriptions. The app itself has no paid tiers.
PgDog: Open source and free to self-host. The company behind PgDog raised a $5.5M seed round, which may fund future enterprise features or managed services, but the core proxy remains free.
Pros and Cons
Dayflow
Pros:
- Automatically captures work activity without manual timers or logs
- Privacy-first with local storage and local AI options
- Open source (MIT) and auditable
- Provides context-rich summaries for standups and reviews
- Lightweight on system resources (100MB RAM, <1% CPU)
Cons:
- macOS only (no Windows/Linux support)
- Requires screen recording permission, which may be restricted in some workplaces
- AI accuracy depends on model choice; local models may be less detailed
- Not designed for team or enterprise time tracking
PgDog
Pros:
- Combines connection pooling, load balancing, and sharding in one tool
- Drop-in replacement for PostgreSQL, no app changes needed
- High performance: 50,000+ transactions/s per thread, 2M+ queries/s
- Supports cross-shard transactions and ACID compliance
- Deployable anywhere (Docker, Helm, binary)
Cons:
- Complex setup for sharding configuration
- No built-in monitoring UI (relies on external tools)
- Requires PostgreSQL expertise to tune and operate
- Not suitable for non-PostgreSQL databases
Verdict
Dayflow and PgDog serve completely different purposes. Dayflow is ideal for individual developers and knowledge workers who want an automated, privacy-respecting work journal to improve productivity and career growth. PgDog is a powerful infrastructure tool for teams that need to scale PostgreSQL with connection pooling, load balancing, and sharding. Choose Dayflow if you need to track and reflect on your daily work; choose PgDog if you manage Postgres at scale.