Next, I'm learning NodeJS and I'm thrilled with it, but I found my first stone in the path, accessing a relational database using some ORM (precisely to access PostgreSQL).
At first I thought about using SequelizeJS , I even found it well documented and promising, but I found his query a bit complex.
A simple condition like this:
title LIKE 'Boat%' OR description LIKE '%boat%'
turns into:
$or: [
{
title: {
$like: 'Boat%'
}
},
{
description: {
$like: '%boat%'
}
}
]
}
So I decided to go for the alternative, which would be EdgeJS . Then I would create a CLR Blibioteca in C # using Repository Pattern that accesses data with the Entity Framework, where all methods would have a signature similar to the following:
async Task<object> MethodName(object input);
And by NodeJS, would only create a module that would serve as a proxy for this Library.
As a .NET developer, using the CLR Library seems easier for me to maintain, but I would like to have a broader view of what the pros and cons of this strategy would be. Is it a good choice? or am I showing myself a lazy programmer?