Ask HN: What has been your experience with CockroachDB? • Hacker News Board

Re: Ask HN: What has been your experience with CockroachDB?

#41

Post by truth_seeker » Tue, Aug 30, 2022, 11:18 AM UTC

Why don't you try swapping your existing PG server with CockroachDB and see how it goes.

Being a die hard fan of Postgresql for more than 15 years, I think time has come for me to select CockroachDB as new default.

I miss Table Partitioning (only available in enterprise edition ) and Full text search (yet to be built). Also minimum hardware I had to employ was quad core and 8 gigs of RAM.

But other than that everything is so smooth including installation, online documentation. It made me lazy.

Re: Ask HN: What has been your experience with CockroachDB?

#42

Post by sean0- » Tue, Aug 30, 2022, 10:11 PM UTC

truth_seeker wrote: post #41

Why don't you try swapping your existing PG server with CockroachDB and see how it goes. Being a die hard fan of Postgresql for more than 15 years, I think time has come for me to select CockroachDB as new default. I miss Table Partitioning (only available in enterprise edition ) and Full text search (yet to be built). Also minimum hardware I had to employ was quad core and 8 gigs of RAM. But other than that everythi…

regarding FTS: https://github.com/cockroachdb/cockroach/pull/85185 just sayin'.

Re: Ask HN: What has been your experience with CockroachDB?

#43

Post by sean0- » Tue, Aug 30, 2022, 10:20 PM UTC

punkpeye wrote: post #30

All these comments and still no one really talking about their experience... For what it is worth, the biggest put off for me was that they no longer allow to export data in PostgreSQL compatible way, i.e. You are locked in when you start using them.

Why can't you `EXPORT`[1] from crdb and then `COPY FROM`[2] into PostgreSQL?

[1] https://www.cockroachlabs.com/docs/stable/export.html

[2] https://www.postgresql.org/docs/current/sql-copy.html