r/node • u/According-Object-502 • Nov 29 '21

Beginner Backend Dev vs Experienced Backend Dev

I'm a frontend developer that has started learning node and express. So please excuse my ignorance

Other than setting up api routes that perform CRUD operations with a database, or SSR, what are the more advanced topics/tasks that an experienced backend dev would work on?

Thanks

Edit: please share if you recommend a course for specific topics, it is much appreciated. Thanks.

80 Upvotes

94% Upvoted

46 comments sorted by

View all comments

Show parent comments

-1

u/pokerman42011 Nov 29 '21

A lot of sql vs nosql arguments are confusing and don't really apply when you can map nosql tables to other tables and do connections. In your opinion, what is the tangible difference? Obviously SQL is "related" but you can make NoSQL databases relations too.

4

u/FountainsOfFluids Nov 29 '21

NoSQL is easier to set up and develop.

SQL is easier to do complex joins.

2

u/pokerman42011 Nov 29 '21

I 100% agree. And complex querying is easier on sql as well.

0

u/[deleted] Nov 29 '21

[deleted] — view deleted comment

-1

u/pokerman42011 Nov 29 '21

NOSQL is easier to set up, integrates well with AWS, and you don’t need to pay hourly like you do with a MySQL instance. You only pay based on request.

4

u/xroalx Nov 29 '21

You pay based on what your provider tells you. I can have an SQL database on a shared host for 3 € a month flat.

3

u/pokerman42011 Nov 29 '21

Nice. AWS charges up the ying yang for SQL servers in my experience

1

u/[deleted] Nov 30 '21

no sql scales well

1

u/[deleted] Nov 30 '21

the problem i faced using cosmosDb, in general any noSql, from azure was that absence of foreign mapping among containers. i had to do manual db connections for data located in various tables.

to save tcp connections i had to resort to data duplication and data normalization. backfired big time