Softwr

Databases · head to head

ClickHouse vs Razorpay

ClickHouse logo

ClickHouse

Databases

Fast open-source column-oriented database for real-time analytics

From
Free
Free plan
Yes
Razorpay logo

Razorpay

E-Commerce

Indian payment gateway for domestic and international card, UPI and wallet acceptance

From
On request
Free plan
No

The short version

  • ClickHouse is free; Razorpay prices on request.
  • Only ClickHouse lists column-oriented Storage; only Razorpay lists domestic payment methods.
  • Where ClickHouse falls short: limited multi-row atomic transactions and expensive UPDATE/DELETE operations unsuitable for transactional systems.
  • Prices and features on this page were last checked on 13 November 2026.

Where they differ

Only the attributes on which ClickHouse and Razorpay actually diverge.

Attributes where ClickHouse and Razorpay differ
AttributeClickHouseRazorpay
Starting priceFreeOn request
Free tierYesNo
PlatformsLinux, macOS, WindowsWeb
CategoryDatabasesE-Commerce

Not yet recorded: pricing model for ClickHouse, founded for Razorpay.

What each one covers

Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.

Only in ClickHouse

  • Column-oriented Storage
  • Real-time Analytics
  • SQL Support
  • Linear Scalability
  • Data Compression
  • Vectorized Query Execution
  • Approximate Calculations
  • Kafka

Only in Razorpay

  • Domestic payment methods
  • International cards
  • Payment links and pages
  • Route
  • RazorpayX
  • Subscriptions
  • Smart Collect
  • Dashboard and reporting

What people use each for

The jobs each tool is most often brought in to do.

ClickHouse

  • Business intelligencenot Razorpay
  • Data warehousingnot Razorpay
  • Real-time analyticsnot Razorpay
  • Reportingnot Razorpay
  • Machine learningnot Razorpay

Razorpay

  • An Indian D2C brand needing UPI acceptance alongside cards in a single checkoutnot ClickHouse
  • An Indian SaaS business billing domestic customers on recurring mandatesnot ClickHouse
  • A marketplace that must split each payment between the platform and its sellersnot ClickHouse
  • A business that needs to take payment without building a website, using links and pagesnot ClickHouse

Where each one falls short

Documented limitations, not opinions. Every one is a constraint you would hit in normal use.

ClickHouse

  • Limited multi-row atomic transactions and expensive UPDATE/DELETE operations unsuitable for transactional systems
  • Requires upfront schema design discipline with MergeTree engine choices and sort/partition keys
  • Experimental vector search support, not production-ready for vector operations
  • Different query syntax from standard SQL requiring migration planning
  • Limited JOIN capabilities compared to traditional relational databases
  • Migration complexity with 2-4 weeks estimated for data type mapping and query translation

Razorpay

  • It requires an Indian legal entity and settles only to Indian bank accounts, so it is not an option for a business incorporated elsewhere no matter how many Indian customers it has
  • The transaction percentage applies to the full order value including shipping and tax rather than to the product price, so low margin categories with heavy shipping give up more of their margin than the quoted rate suggests
  • Payment aggregator authorisation sits with the Reserve Bank of India and has been withheld from aggregators before while applications were reviewed, so a dependency exists that no commercial contract term protects you from
  • Default settlement runs on a delayed cycle with faster settlement sold as a paid add-on, so a business that buys stock from its takings either waits for cash or pays extra for it, and that cost belongs in the effective rate
  • International card acceptance is priced higher and requires separate approval rather than being a configuration change, so cross-border revenue takes longer to switch on and earns less per order than a domestic sale

Pricing, plan by plan

ClickHouse

Free

No published plan breakdown. See the ClickHouse review.

Razorpay

On request
  • Domestic PaymentsOn request
    • 2% platform fee per successful transaction across all payment instruments
    • GST: 18% applies on the platform fee
    • No setup fees, annual maintenance charges, or refund fees
  • Corporate CardsOn request
    • 2.15% platform fee per transaction
  • International Payments - CardsOn request
    • Up to 3% per successful transaction
  • International Payments - Bank TransfersOn request
    • 1% per transaction with zero forex markup

Which should you pick?

Choose ClickHouse if

  • You need column-oriented storage.
  • You want to start without paying.
  • You work on Linux, macOS, Windows.
  • You also want real-time analytics.

Choose Razorpay if

  • You need domestic payment methods.
  • You also want international cards.

Questions people ask

Is ClickHouse or Razorpay better?
Neither clearly leads. ClickHouse starts at Free and Razorpay at On request, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
Which is cheaper, ClickHouse or Razorpay?
ClickHouse has a free tier; the other does not. Paid plans start at Free for ClickHouse and On request for Razorpay.
Does ClickHouse or Razorpay run on more platforms?
ClickHouse runs on Linux, macOS, Windows. Razorpay runs on Web.
Can I use ClickHouse for free?
Yes. ClickHouse has a free tier, so you can try it without paying. Razorpay starts at On request.
What is ClickHouse best used for?
ClickHouse is most often used for business intelligence, data warehousing, real-time analytics, reporting. Of those, business intelligence and data warehousing are not what Razorpay is typically brought in for.
What can ClickHouse do that Razorpay cannot?
ClickHouse covers Column-oriented Storage, Real-time Analytics, SQL Support, Linear Scalability. Razorpay covers Domestic payment methods, International cards, Payment links and pages, Route.

Answered from the vendors’ own pages

ClickHouse: What is ClickHouse best used for?

ClickHouse is optimized for analytical workloads on large datasets. It excels at fast aggregations and queries, being 10-100x faster than PostgreSQL on large aggregations.

Source
Razorpay: Can I use Razorpay if my company is not in India?

No. It requires an Indian entity and an Indian bank account for settlement. Overseas businesses selling into India need a different arrangement.

ClickHouse: Does ClickHouse support transactions?

ClickHouse has limited transaction support and expensive UPDATE/DELETE operations. It is not suitable for transactional workloads requiring strict ACID guarantees.

Source
Razorpay: What is the real effective rate?

The domestic percentage on the full order value including shipping and tax, plus higher international rates, plus any charge for faster settlement and dispute handling. Compute it from a month of settlement reports, not the pricing page.

ClickHouse: How does ClickHouse compare to PostgreSQL?

ClickHouse is 10-100x faster for analytics but PostgreSQL is better for transactional workloads. Many teams use both: PostgreSQL for writes via MaterializedPostgreSQL replication to ClickHouse for analytics.

Source
Razorpay: How quickly do I get paid?

On a delayed settlement cycle by default, with faster settlement available as a paid feature. Plan working capital around the default, not the add-on.

Razorpay: What is the main structural risk?

Regulatory. Indian payment aggregators operate under RBI authorisation and have previously been barred from onboarding new merchants. Keep a second processor integrated if payments are business-critical.

Razorpay: Does it support recurring billing?

Yes, built on India's mandate and e-mandate framework, which has its own rules on authentication and notification that differ from card-on-file recurring elsewhere.

Share

Related pages

Other head to heads