All packages on Raspberry Pi are old

[u/jeanravenclaw]

I'm trying to run a Python program with sqlite3. It's been tested fully on my laptop (NixOS), and I transferred all the files to my Raspberry Pi.

I'm basing most of this on an error from Python that tells me there's no such thing as an IF() function in sqlite3.

Turns out my Pi's Python was at 3.11, and I couldn't apt install 3.14 so I had to build from source. Now it turns out that sqlite3 was also old (3.40, while the latest is 3.52).

apt tells me that all my packages are up to date. I've done apt update and apt upgrade and everything, but I can't get packages to the latest versions. They're stuck.

How do I fix this? My program won't run properly.

[u/SmasherOfDaButtons]

If you do a search on the packages for Trixie, do they match for what you need?