adding northwind script for postgresql in chapter 2

[depo101]

Hello Mark J. Price, I hope you are doing well. My recommendation is to add the Northwind script for PostgreSQL in Chapter 2. To accomplish this, you can refer to GitHub repositories or other articles. As a .NET developer, I try to use this technology stack on any Linux distro. Installing MS SQL Server often results in errors on-premises. Therefore, it would be beneficial to include other RDBMS systems like PostgreSQL or MySQL for Linux users. Thank you.

Chapter: 2
Page Number:
Section Title: understanding modern databases
Problem to fix:
Suggested solution: adding postgresql or mysql for linux users
Other useful information e.g. OS, coding tools, and so on: ubuntu 22.04

[markjprice]

I will consider alternatives in future editions but Chapter 2 is specifically about SQL Server, rather like Chapter 3 is about Cosmos DB and not an alternative cloud data store. For Linux users, they can use SQL Server Edge in Docker or SQL Azure.

[markjprice]

Meanwhile, you could try the script for SQLite that will probably work. It can be found in the GitHub repository for my other book here: https://github.com/markjprice/cs11dotnet7/blob/main/sql-scripts/Northwind4SQLite.sql

[depo101]

Hello Mark, Thanks for your replies. I agree with your answers. As a reader and as a developer my choice to run rdms on my machine. So my focus on supporting "Northwind sql script" to other none microsoft systems. If you support other rdbms service for running this script, would be better. Best regards.