I really wanted to use Planetscale, but there are two blockers:
- No foreign key support
- No CTE support
I tried using Planetscale knowing that there is no foreign key support because it is fine to me. But I had to stop using Planetscale because of the second. My ORM (ent for golang) relies on CTE so I simply cannot run complicated queries.
So if you are considering Planetscale, test it enough especially if you are using an ORM.
- No foreign key support
- No CTE support
I tried using Planetscale knowing that there is no foreign key support because it is fine to me. But I had to stop using Planetscale because of the second. My ORM (ent for golang) relies on CTE so I simply cannot run complicated queries.
So if you are considering Planetscale, test it enough especially if you are using an ORM.