Feedback: Benefits over Azure SQL Edge?

[withinfocus]

Hi there -- I'm an MVP and feedback was requested.

We use Dev Containers today at Bitwarden and aren't sure what this might give us over using the Azure SQL Edge image that's already available (our usage here). We found that Azure SQL Edge worked better on more operating systems as almost all our engineers use Macs with ARM chips, but we made that decision when v2019 was around. Could things have improved with v2022? We're also not using the DACPAC method for migrations and have a custom solution using DbUp.

Interested in any thoughts on how this might improve our current setup.

[croblesm]

Hi @withinfocus!

Thanks for the fantastic suggestion, I have made the change already. I agree with you, the Azure SQL Edge is a better option.

I'm already working on the v2 of these templates, and I believe it would be great to connect with you gather more feedback about running these teamplates on ARM-based machines.

Thanks!

[alecglen]

Hey @withinfocus, @croblesm - I'm trying this out for the first time on an ARM machine and am stuck on an error, not sure if it's a bug or just something off with my setup. Could you please give me some guidance to troubleshoot? I can make a separate issue if you prefer, let me know.

It is stuck on the ./install-dotnet.sh shell script. Log output below.

0.112 Installing .NET 8 (SDK) ...
0.117 --2024-07-31 14:32:34--  https://packages.microsoft.com/config/debian/12/packages-microsoft-prod.deb
0.122 Resolving packages.microsoft.com (packages.microsoft.com)... 13.107.246.38, 2620:1ec:bdf::38
0.194 Connecting to packages.microsoft.com (packages.microsoft.com)|13.107.246.38|:443... connected.
0.249 HTTP request sent, awaiting response... 200 OK
0.266 Length: 4304 (4.2K) [application/octet-stream]
0.266 Saving to: ‘packages-microsoft-prod.deb’
0.266 
0.266      0K ....                                                  100% 86.9M=0s
0.266 
0.266 2024-07-31 14:32:34 (86.9 MB/s) - ‘packages-microsoft-prod.deb’ saved [4304/4304]
0.266 
0.300 Selecting previously unselected package packages-microsoft-prod.
0.337 (Reading database ... 33671 files and directories currently installed.)
0.337 Preparing to unpack packages-microsoft-prod.deb ...
0.340 Unpacking packages-microsoft-prod (1.1-debian12) ...
0.352 Setting up packages-microsoft-prod (1.1-debian12) ...
0.511 Get:1 http://deb.debian.org/debian bookworm InRelease [151 kB]
0.554 Get:2 https://packages.microsoft.com/ubuntu/20.04/prod focal InRelease [3632 B]
0.572 Get:3 https://packages.microsoft.com/debian/12/prod bookworm InRelease [3618 B]
0.630 Get:4 https://packages.microsoft.com/ubuntu/20.04/prod focal/main armhf Packages [22.3 kB]
0.641 Get:5 https://dl.yarnpkg.com/debian stable InRelease [17.1 kB]
0.662 Get:6 https://packages.microsoft.com/ubuntu/20.04/prod focal/main all Packages [2714 B]
0.666 Get:7 https://packages.microsoft.com/ubuntu/20.04/prod focal/main arm64 Packages [63.0 kB]
0.682 Get:8 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 Packages [304 kB]
0.710 Get:9 https://packages.microsoft.com/debian/12/prod bookworm/main amd64 Packages [57.0 kB]
0.714 Get:10 https://packages.microsoft.com/debian/12/prod bookworm/main armhf Packages [8305 B]
0.714 Get:11 https://packages.microsoft.com/debian/12/prod bookworm/main arm64 Packages [11.3 kB]
0.715 Get:12 https://packages.microsoft.com/debian/12/prod bookworm/main all Packages [342 B]
0.724 Get:13 https://dl.yarnpkg.com/debian stable/main all Packages [10.9 kB]
0.727 Get:14 http://deb.debian.org/debian bookworm-updates InRelease [55.4 kB]
0.755 Get:15 https://dl.yarnpkg.com/debian stable/main arm64 Packages [10.9 kB]
0.798 Get:16 http://deb.debian.org/debian-security bookworm-security InRelease [48.0 kB]
0.825 Get:17 http://deb.debian.org/debian bookworm/main arm64 Packages [8688 kB]
1.056 Get:18 http://deb.debian.org/debian bookworm-updates/main arm64 Packages [13.7 kB]
1.079 Get:19 http://deb.debian.org/debian-security bookworm-security/main arm64 Packages [166 kB]
1.845 Fetched 9637 kB in 1s (6609 kB/s)
1.845 Reading package lists...
2.293 W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-armhf/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-arm64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-armhf/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-arm64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.293 W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.299 Reading package lists...
2.814 Building dependency tree...
2.915 Reading state information...
2.991 W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.991 W: Target Packages (main/binary-armhf/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.991 W: Target Packages (main/binary-arm64/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.991 W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/archive_uri-https_packages_microsoft_com_ubuntu_20_04_prod-bookworm.list:1 and /etc/apt/sources.list.d/mssql-release.list:1
2.991 E: Unable to locate package dotnet-sdk-8.0
2.991 E: Couldn't find any package by glob 'dotnet-sdk-8.0'
2.991 E: Couldn't find any package by regex 'dotnet-sdk-8.0'
------
[2024-07-31T14:32:37.608Z] failed to solve: process "/bin/sh -c bash ./install-dotnet.sh     && apt-get clean -y && rm -rf /var/lib/apt/lists/* /tmp/library-scripts" did not complete successfully: exit code: 100

[withinfocus]

@alecglen your arch isn't supported using that package source: https://learn.microsoft.com/en-us/dotnet/core/install/linux-debian#unable-to-find-package

[croblesm]

Hi @alecglen just checking everything went with the issue/workaround reported. Feel free to open a new issue in case you want to follow up something else.

[alecglen]

Hey, yes I did get it working. Thanks for your reply.

[withinfocus]

@croblesm Well ... I didn't know about https://techcommunity.microsoft.com/t5/sql-server-blog/azure-sql-edge-update-september-2023/ba-p/3930827 and Azure SQL Edge has now come up on an issue with Docker: docker/for-mac#7368 (comment). I think the right move is to move off this given the architecture compatibility issues. I had hoped for continued support even implicitly but this seems like a conflict that won't be resolved.