Azure App Service - has Older Sqlite3 version 3.34.1

Manoranjan Kumar 25

I have created an Azure App Service with below options:

OS: Linux
Runtime: Python 3.11 or Python 3.10
App Service Plan: Free

When I deployed my python flask app on the above app service, I was surprised to find the sqlite3 version 3.34.1 which is pretty old and stale. it dates back to 20-Jan-2021

https://www.sqlite.org/chronology.html

Here is the small code snippet, that I executed on Azure App Service:

import sqlite3
print(sqlite3.sqlite_version)

Usually, sqlite3 is part of the Python's standard library, when I check it inside open-source Python 3.11 has 3.39.4,

Why is this gap on App Service. Do they create a custom python distribution with older sqlite3 version intentionally or where is the gap?

Please help to clarify the doubts. Thanks in advance

EDIT:
Usually, sqlite3 is part of the Python's standard library (.dll), this is the case only for Windows.

Python distribution for Linux does not ship with sqlite3 package as part of its standard library (.so) In other words, On Linux, Python depends on underlying Linux's system wide standard library (.so).

brtrach-MSFT 16,121 Reputation points Microsoft Employee

2023-09-25T01:56:23.27+00:00

@Manoranjan Kumar Please let us know if Andriy's response was helpful by marking it as the answer. If you have further questions or concerns, please reply here to we can assist you further.
Manoranjan Kumar 25 Reputation points

2023-10-06T18:09:23.6466667+00:00
Thank you @Andriy Bilous
for giving us the lead on this issue. I continued conducting further investigations based on your guidance and successfully identified the root cause of the issue. It turns out that Debian 11 Bullseye itself ships with SQLite3 version 3.34.1. This has nothing to do with Azure app service.

To resolve this, I manually upgraded SQLite3 to the latest version. Here are the steps I followed:

Login to the Debian Box

Update the Sources List /etc/apt/sources.list by adding the following repository:
deb http://ftp.debian.org/debian stable main

Run this cmd:
apt update

Check for Upgradable Packages:
apt list --upgradable

Upgrade SQLite3:
apt install sqlite3

As a result, SQLite3 was upgraded from this version 3.34.1-3 to a more recent 3.40.1-2, and this resolved the problem I was facing.

To verify the upgraded sqlite3, I did the following:

(antenv) root@eddb151f2ad9:/tmp/8dbc663a0906d89# python -V Python 3.10.12 (antenv) root@eddb151f2ad9:/tmp/8dbc663a0906d89# (antenv) root@eddb151f2ad9:/tmp/8dbc663a0906d89# python Python 3.10.12 (main, Jul 5 2023, 19:32:53) [GCC 10.2.1 20210110] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 s>>> sqlite3.sqlite_version '3.40.1' >>> exit()

Thank you so much, Keep helping!
Have a great weekend! : )
Edison Phua Xiong Yi 0 Reputation points

2024-01-27T13:26:30.8666667+00:00

Hi @Manoranjan Kumar I followed your instructed but I found out whenever I stop the web app service and restart it goes back to default. How did you keep it from doing this?
Hạt Bí 0 Reputation points

2024-07-11T14:55:16.2233333+00:00
For anyone who has similar questions to @Edison Phua Xiong Yi .
You can add a startup.sh file to your repository and set the startup command in Configuration according to the file path such as my command is ./startup.sh so that azure app runs this scripts whenever the web app restart.

The startup.sh will look like:

if ! grep -q "deb http://ftp.debian.org/debian stable main" /etc/apt/sources.list; then echo "deb http://ftp.debian.org/debian stable main" >> /etc/apt/sources.list fi apt update && apt install -y sqlite3

Accepted answer

Andriy Bilous 11,341 Reputation points MVP

2023-09-16T10:34:21.4066667+00:00

Hello @Manoranjan Kumar

App Service on Linux supports a number of language specific built-in images. Python Dockerfile that is used by Azure App Service Linux is located here.

Base image is mcr.microsoft.com/oryx/python with is modified Debian https://github.com/microsoft/Oryx/blob/main/images/runtime/python/3.11/base.bullseye.Dockerfile

https://github.com/microsoft/Oryx/blob/main/doc/supportedRuntimeVersions.md

Microsoft updates language specific built-in images from time to time, but if the runtime your application requires is not supported or required additional packages are not included in the built-in images, you can deploy it with a custom container.
Please sign in to rate this answer.
S Nik 0 Reputation points

2024-04-30T14:47:51.21+00:00

I ran into the same problem and still trying to understand why would python image contain an older sqlite module which is from pre-python 3.9.

I created a python 3.12 environment and sqlite is still old and breaks the app. I think it's reasonable to expect a relevant versions of the dependent modules instead of going for custom containers route. It seems like an unnecessary complication
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure App Service - has Older Sqlite3 version 3.34.1

0 additional answers

Your answer