3 ms·

The CockroachDB team are doing great work no doubt, but I wish they'd stop leaning on the whole "Postgres compatible" thing. Its not and there's no clear roadm

The CockroachDB team are doing great work no doubt, but I wish they'd stop leaning on the whole "Postgres compatible" thing. Its not and there's no clear roadmap for it to be. I'm not talking about obscure edge-case stuff here, I'm talking about some pretty major low-hanging fruit that is there is Postgres and not there in CockroachDB. Anyone who thinks they can magically drop Postgres for Cockroach will be sorely disappointed. And yes I've raised it with CockroachDB salesdroids when they've "reached out" and all I get in return is the digital equivalent of a shoulder shrug.

gizmodo59 5y ago
I often see these “I raised this to sales team… but they are not listening”. The cost of the sales team (including sales engineers) working on an opportunity is not low. If you have a use case and explain to them how you want to use their product (and if you are serious enough to buy it at the end of evaluation if it satisfies your requirements. You must also have influence in your company to make decisions. Some random startup with little cash to spend on software is not going to get you far) then they will surely try to address each of your specific issues. If not they may tell you it’s not a good use case. Just saying something about compatibility doesn’t really give them (or any Enterprise software vendor) to really hear you. This is not to say all companies are like that but that’s how it works in general in enterprise software. Every conversation is part of a Salesforce stage (whether we like it or not)
- RedShift1 5y ago
  > If not they may tell you it’s not a good use case. That may is key here. I've never had a sales guy say ok this doesn't fit. They will go to great lengths to fit their square peg into your round hole.
  - gizmodo59 5y ago
    That’s the job of sales engineer too in many cases. But a good account executive will tell you upfront if it’s not a good use case. If not you won’t buy at the end of evaluation and that has consequences for them (Companies need to predict quarterly revenues and by betting on a bad use case that person will have a bad projection of sales for that quarter or year which will ultimately be bad for them)
jshen 5y ago
Examples?
- ledgerdev 5y ago
  listen/notify edit: https://github.com/cockroachdb/cockroach/issues/41522 https://github.com/cockroachdb/cockroach/issues/41522
- tyingq 5y ago
  There's a list here: https://www.cockroachlabs.com/docs/stable/postgresql-compatibility.html https://www.cockroachlabs.com/docs/stable/postgresql-compati...
- boiler_up800 5y ago
  There is some Yugabyte marketing material that lists: - expression based indexes - partial indexes - table functions - stored procedures - multidimensional arrays - triggers - user defined types - temporary tables - row level security - column level privileges - extensions As being areas where cockroach is not pg compatible. That said, besides temporary tables I would consider all of these to be more advanced features.
  - dap 5y ago
    I’m not sure about that list. I’ve used partial indexes and users defined types with CockroachDB
  - vvern 5y ago
    Expression-based indexes were added in the previous release. Partial indexes have been around for two releases. Those two combine pretty well. Temp tables exist and have existed for two years, but the implementation is not very good; they’re essentially regular tables which get cleaned up. UDFs exist in terms of enums but not records. Functions, procedures, and triggers are next up.
- candiddevmike 5y ago
  Triggers for me, though you could argue those could/should be baked in the queries.

gizmodo59 5y ago

I often see these “I raised this to sales team… but they are not listening”. The cost of the sales team (including sales engineers) working on an opportunity is not low. If you have a use case and explain to them how you want to use their product (and if you are serious enough to buy it at the end of evaluation if it satisfies your requirements. You must also have influence in your company to make decisions. Some random startup with little cash to spend on software is not going to get you far) then they will surely try to address each of your specific issues. If not they may tell you it’s not a good use case. Just saying something about compatibility doesn’t really give them (or any Enterprise software vendor) to really hear you. This is not to say all companies are like that but that’s how it works in general in enterprise software. Every conversation is part of a Salesforce stage (whether we like it or not)

RedShift1 5y ago
> If not they may tell you it’s not a good use case. That may is key here. I've never had a sales guy say ok this doesn't fit. They will go to great lengths to fit their square peg into your round hole.
- gizmodo59 5y ago
  That’s the job of sales engineer too in many cases. But a good account executive will tell you upfront if it’s not a good use case. If not you won’t buy at the end of evaluation and that has consequences for them (Companies need to predict quarterly revenues and by betting on a bad use case that person will have a bad projection of sales for that quarter or year which will ultimately be bad for them)

jshen 5y ago

Examples?

ledgerdev 5y ago
listen/notify edit: https://github.com/cockroachdb/cockroach/issues/41522 https://github.com/cockroachdb/cockroach/issues/41522
tyingq 5y ago
There's a list here: https://www.cockroachlabs.com/docs/stable/postgresql-compatibility.html https://www.cockroachlabs.com/docs/stable/postgresql-compati...
boiler_up800 5y ago
There is some Yugabyte marketing material that lists: - expression based indexes - partial indexes - table functions - stored procedures - multidimensional arrays - triggers - user defined types - temporary tables - row level security - column level privileges - extensions As being areas where cockroach is not pg compatible. That said, besides temporary tables I would consider all of these to be more advanced features.
- dap 5y ago
  I’m not sure about that list. I’ve used partial indexes and users defined types with CockroachDB
- vvern 5y ago
  Expression-based indexes were added in the previous release. Partial indexes have been around for two releases. Those two combine pretty well. Temp tables exist and have existed for two years, but the implementation is not very good; they’re essentially regular tables which get cleaned up. UDFs exist in terms of enums but not records. Functions, procedures, and triggers are next up.
candiddevmike 5y ago
Triggers for me, though you could argue those could/should be baked in the queries.