MSSQL

I'm working on a project where I need to both send real-time updates for specific data sets, along with providing notifications to the users after long-running processes have been completed (SSE).

The project is using .NET Framework, AngularJS, & MSSQL. I understand that SignalR is nice as a polyfill for .NET and you can scale with a backplane, but I was wondering if there was a more efficient/effective technology for this?

Hi All,

I have an application form employment details, and mostly the data is text & animations. Earlier it was with the MSSQL database. Now I have to migrate it to either PostgreSQL/DynamoD or MongoDB. Could you please help me to choose the correct DB to get the best fit and also can the possibility to migrate from MSSQL the Old records?

Data Types: Text, Animations Source Database: MSSQL Destination Database::? ( DynamoDB/MongoDB/PostgreSQL)

Thanks

I am considering which chat solution to choose between CometChat and SendBird, for our new app. The condition is, the app is going to run in a private network and has to connect with MSSQL. Any advice on other things I have to consider before choosing one, or is there another chat service you would recommend? Thank you!

Which tools should be use to migrate MSSQL database to PostgreSQL database ?

MSSQL to PostgreSQL database migration can be done through Flyway? Please advise the steps if possible.

We are planning to migrate one of my applications from MSSQL to MySQL. Can someone help me with the version to select?. I have a strong inclination towards MySql 5.7. But, I see there are some standout features added in Mysql 8.0 like JSON_TABLE. Just wanted to know if the newer version has not compromised on its speed while giving out some add on features.

We are going to develop a microservices-based application. It consists of AngularJS, ASP.NET Core, and MSSQL.

We have 3 types of microservices. Emailservice, Filemanagementservice, Filevalidationservice

I am a beginner in microservices. But I have read about RabbitMQ, but come to know that there are Redis and Kafka also in the market. So, I want to know which is best.

Investigating Tortoise ORM and GINO ORM...

I need to introduce some async ORM with the current stack: Tornado with asyncio loop, AIOHTTP, with PostgreSQL and MSSQL. This project revolves heavily around realtime and due to the realtime requirements, blocking during database access is not acceptable.

Considering that these ORMs are both young projects, I wondered if anybody had some experience with similar stack and these async ORMs?