- Home
- Hire resource
- MySQL / PostgreSQL
Database development: PostgreSQL, MongoDB, Redis & more
The database technologies we use in production. We choose databases based on your data model, query patterns, and scale requirements — not hype. Here's what we use and why.
Free estimate
What are you building?
Tell us what you need — scope and estimate in 24 hours, free.
✓ request received
✓ routed to a senior engineer
✓ estimate en route
Thanks — we'll reply within 24 hours.
In short
Digital Web Weaver designs and engineers databases on PostgreSQL, MySQL, MongoDB, Redis, Elasticsearch, ClickHouse and SQLite, chosen per project by data model, query patterns and scale. Work covers schema design, query optimisation, replication and zero-downtime migrations.
// what we run in production
Our database stack
PostgreSQL
Our default relational database — JSONB, full-text search, and extensions.
MongoDB
Document store for flexible schema and hierarchical data.
Redis
Caching, sessions, queues, and pub/sub messaging.
Elasticsearch
Full-text search, log analytics, and faceted filtering.
ClickHouse
Columnar OLAP for analytics and time-series at scale.
SQLite
Embedded database for edge functions and serverless.
// what we do with databases — not just install and hope
Database expertise
Schema design
Normalisation, denormalisation, and JSONB hybrid patterns chosen for your access patterns.
Query optimisation
Explain plans, index design, and N+1 elimination before it becomes a production incident.
Migrations
Zero-downtime schema migrations with Prisma or Flyway, tested in staging first.
Replication
Primary/replica read scaling and cross-region replication for resilience and speed.
Sharding
Hash and range partitioning for horizontal scale when a single node runs out of room.
Backup & recovery
Automated backups, point-in-time recovery, and tested restore procedures — not just cron jobs.
// when we use each database
Database matrix
Pg
PostgreSQLrelational · defaultMy
MySQLrelational · legacy compatSq
SQLiterelational · edge/embedded
Mo
MongoDBdocument · flexible schemaFs
Firestoredocument · realtime sync
Rd
Rediscache/queue · cache + queuesVk
Valkeycache/queue · OSS Redis fork
Ch
ClickHouseanalytics · OLAPBq
BigQueryanalytics · warehouseRs
Redshiftanalytics · AWS
// stack-databases.faq.md
Database FAQ
Can't find yours? Ask us directly — we reply within 24 hours.
Still deciding? Talk to a senior engineer.
No sales script — a real technical conversation about your project, free.
When do you choose PostgreSQL vs MongoDB?
PostgreSQL for structured relational data, complex queries, and transactions. MongoDB for flexible document data, rapid iteration, and embedded arrays.
Why Redis over Memcached?
Redis supports data structures (lists, sets, sorted sets), pub/sub, persistence, and clustering. Memcached is pure cache with no additional features.
When is ClickHouse the right choice?
When you need analytics over millions of rows — dashboards, time-series reporting, or log analysis. It's 10–100× faster than PostgreSQL for OLAP queries.
How do you handle database migrations safely?
Schema changes via Prisma Migrate or Flyway. Expand-and-contract pattern for zero-downtime. All migrations tested in staging first.
you@dww:~ $ ./contact --database-review
Ready for a database architecture review?
Free scoping and a detailed estimate from senior engineers — within 24 hours. Tell us what you're building and we'll scope the right database for it.
Senior engineers only48-hr matchNo lock-in