BLOG

Multipurpose data access with SQL++ reduces multi-database complexity

Read More
CHALLENGES

Legacy databases vs. Couchbase

When you switch from legacy databases to Couchbase, you can use SQL++ for familiar query access, store data as JSON (avoiding restrictive relational data models), and build new features with our multi-model services.

CHALLENGE #1
Rigid data models slow down dev cycles

Rigid data models hinder agility. App objects that are split into tables must be reassembled.

Learn more
CHALLENGE #2
Apps perform poorly

Relational modeling requires many reads/writes with no built-in managed cache.

Learn more
CHALLENGE #3
New requirements increase tools and costs

Bolted-on tools add work. Caching, analytics, mobile, vector, and AI increase setup and maintenance.

Learn more
CHALLENGE #4
It’s hard to scale deployments with HA

Legacy DBs scale poorly. They’re difficult, costly, and prone to 2 a.m. weekend downtime headaches.

Learn more
FEATURES

Key features of Couchbase vs. legacy databases

  • What’s included
  • SQL
  • ACID transactions
  • Flexible JSON
  • SQL++ (SQL for JSON)
  • Built-in caching
  • Multipurpose data access
  • Built-in horizontal scaling
  • Couchbase
  • check
  • check
  • check
  • check
  • check
  • check
  • check
  • Legacy databases
  • check
  • check
  • Limited
  • cancle
  • cancle
  • cancle
  • cancle
CUSTOMERS

What customers are saying

  • "Couchbase is a trifecta of value. We get more features, save time, and spend less money all at once."
    Philip Lupercio, VP of Technology, BroadJump
    500% query performance improvement
    50% reduction in storage needs
  • "We are able to put data to work in a more efficient way, and we have built a strong foundation for the future."
    80% more efficient change management
    50% boost in response time
  • "Couchbase puts us in a good place to really achieve our goal of a perfect customer experience."
    Scott Carney, Director of Software Development, Comcast
    40M+ documents
    61K users
CODE SNIPPET

Couchbase's SQL++ is compatible with SQL and adds extra functionality for JSON data


SELECT u.name, AVG(o.total) AS avgOrderTotal
FROM users u
JOIN orders o ON u.userId = META(o).id
WHERE u.membershipLevel = 'Gold' AND u.status = 'active'
GROUP BY u.name


SELECT u.Name, AVG(o.Total) AS AvgOrderTotal
FROM Users u
JOIN Orders o ON u.UserId = o.UserId
WHERE u.MembershipLevel = 'Gold' AND u.Status = 'active'
GROUP BY u.Name
Try SQL++ in your favorite IDE

Couchbase IDE plugins help you migrate, navigate data, develop SQL++, and more.

Plugins And Integrations
RESOURCES

Learn more about working with SQL and JSON

Whitepaper
Moving from relational to NoSQL
Read the whitepaper
Datasheet
SQL++: The power of SQL meets JSON flexibility
Read the datasheet
DOCUMENTATION
Run your first SQL++ query in Couchbase
Read the docs
See All Resources
Start building

Check out our developer portal to explore NoSQL, browse resources, and get started with tutorials.

Develop now
Use Capella free

Get hands-on with Couchbase in just a few clicks. Capella DBaaS is the easiest and fastest way to get started.

Use free
Get in touch

Want to learn more about Couchbase offerings? Let us help.

Contact us