5 min read
ClickHouse for analytics: when PostgreSQL is no longer enough
When reports slow your main database, analytics moves to ClickHouse. We cover how it differs from PostgreSQL, how to store events and how to deliver data.
- Databases
- Analytics
(Tag)
Databases
Databases in products: PostgreSQL, MySQL, Redis, ClickHouse — choosing, designing and tuning.
- All articles
- MVP 5
- Laravel 3
- Node.js 2
- Project estimation 7
- Nuxt 1
- SEO 5
- Working with vendors 6
- Team 5
- Architecture 7
- Backend 11
- Development process 13
- Product 7
- Security 6
- Frontend 7
- Vue 1
- React 3
- Databases 4
- AI 7
- API 4
- News 2
- Mobile 4
- Startups 3
- Performance 6
- Python 2
- Support 3
- Analytics 3
- SaaS 2
- FinTech 3
- E-commerce 2
- QA and testing 3
- DevOps 4
- Automation 2
- EdTech 2
- Technical debt 1
5 min read
Redis in a web project: what it is for and when you do not need it
Redis speeds up caching, sessions, queues and rate limits, but it does not replace your database. We cover use cases, memory settings and when you do not need it.
- Databases
- Performance
5 min read
PostgreSQL indexes: how to find and speed up slow queries
How to find slow queries with pg_stat_statements, read an EXPLAIN ANALYZE plan and choose the right index — with examples and a table of index types.
- Databases
- Performance
5 min read
PostgreSQL or MySQL: which database to choose for a new project
Our default for a new product is PostgreSQL, but MySQL still has strong use cases. We compare features, hosting and the cost of switching later.
- Databases