Databases · head to head
ClickHouse vs Razorpay

ClickHouse
Databases
Fast open-source column-oriented database for real-time analytics
- From
- Free
- Free plan
- Yes

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.
| Attribute | ClickHouse | Razorpay |
|---|---|---|
| Starting price | Free | On request |
| Free tier | Yes | No |
| Platforms | Linux, macOS, Windows | Web |
| Category | Databases | E-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
FreeNo 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.
SourceRazorpay: 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.
SourceRazorpay: 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.
SourceRazorpay: 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.
Related pages
Other head to heads
- ClickHouse vs Apache Druid
- ClickHouse vs SingleStore
- ClickHouse vs Amazon Redshift
- ClickHouse vs TimescaleDB
- ClickHouse vs Tinybird
- ClickHouse vs Timeplus
- ClickHouse vs StarRocks
- ClickHouse vs Presto
- ClickHouse vs DuckDB
- ClickHouse vs DataStax
- ClickHouse vs dbt
- ClickHouse vs EMQX
- ClickHouse vs FaunaDB
- ClickHouse vs Firebase Realtime Database
- ClickHouse vs Apache Pinot
- ClickHouse vs Firestore
- ClickHouse vs Apache Doris
- ClickHouse vs Cassandra
- ClickHouse vs Klarna
- ClickHouse vs BigCommerce
- ClickHouse vs Heartland Retail
- ClickHouse vs Authorize.net
- ClickHouse vs Braintree
- ClickHouse vs Mollie
- ClickHouse vs Stripe
- ClickHouse vs Square
- ClickHouse vs Poshmark
- ClickHouse vs NCR Voyix
- ClickHouse vs Checkout.com
- ClickHouse vs eBay
- ClickHouse vs Bluepark
- ClickHouse vs Drip
- ClickHouse vs Ecwid
- ClickHouse vs Etsy
- ClickHouse vs Gumroad
- ClickHouse vs Inventory Lab
- Razorpay vs Apache Druid
- Razorpay vs SingleStore
- Razorpay vs Amazon Redshift
- Razorpay vs TimescaleDB
- Razorpay vs Tinybird
- Razorpay vs Timeplus
- Razorpay vs StarRocks
- Razorpay vs Presto
- Razorpay vs DuckDB
- Razorpay vs DataStax
- Razorpay vs dbt
- Razorpay vs EMQX
- Razorpay vs FaunaDB
- Razorpay vs Firebase Realtime Database
- Razorpay vs Apache Pinot
- Razorpay vs Firestore
- Razorpay vs Apache Doris
- Razorpay vs Cassandra
- Razorpay vs Klarna
- Razorpay vs BigCommerce
- Razorpay vs Heartland Retail
- Razorpay vs Authorize.net
- Razorpay vs Braintree
- Razorpay vs Mollie
- Razorpay vs Stripe
- Razorpay vs Square
- Razorpay vs Poshmark
- Razorpay vs NCR Voyix
- Razorpay vs Checkout.com
- Razorpay vs eBay
- Razorpay vs Bluepark
- Razorpay vs Drip
- Razorpay vs Ecwid
- Razorpay vs Etsy
- Razorpay vs Gumroad
- Razorpay vs Inventory Lab
