5 ms·
I do not have a particular project in mind, but think it would be good to have an easily containerizable, replicated OLTP database in my toolkit. I do some work
by caleblloyd 9y ago
I do not have a particular project in mind, but think it would be good to have an easily containerizable, replicated OLTP database in my toolkit. I do some work with Entity Framework Core providers and am thinking about trying to implement a provider for CRDB.
- MycroftH 9y agoThere is already some work towards this with http://www.npgsql.org/ http://www.npgsql.org/ I haven't gone back to try the full entity framework recently, but if you find any bugs, please let us know. If you want to roll your own, we're here to help too.
- manigandham 9y agoCRDB is using the Postgresql wire transport and already works with npgsql + ef core.
- caleblloyd 9y agoAre you sure? I know that the NPGSQL DB driver works with CRDB. Data types, DDL, and supported features are a big part of EF Core providers though. I have not researched it yet but I was pretty sure the NPGSQL EF Core Provider implemetation was just for PG.
- manigandham 9y agoCockroachDB uses the same PostgreSQL wire protocol and SQL dialect so it just looks and works like a pg database. There are some minor differences but DDL and data types are already included in the syntax: https://www.cockroachlabs.com/docs/stable/porting-postgres.html https://www.cockroachlabs.com/docs/stable/porting-postgres.h... It's great if you want to contribute though but I'd recommend just working on the PG EF Core provider which already has some work towards CRDB specific features: https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues?utf8=%E2%9C%93&q=is%3Aissue+cockroachdb https://github.com/npgsql/Npgsql.EntityFrameworkCore.Postgre...
- caleblloyd 9y agoGreat, thanks for the info. I have worked with @roji before on EF Core upstream issues, NPGSQL EF Core is very good. I will reach out to him!