Edit: I’ve decided to switch to VSCode for now. So far I’m liking it 
I’ve been using spyder 5 for the past month and although it has worked for a time, now the program is destabilizing by not recognizing modules at random and randomly refusing to exectute almost simple or at times any python code when run.
Are there any good idethat you would recommend as alternatives to spyder that actually work?
I suggest using JetBrains’s PyCharm for Python, which is just the best IDE for it, in my opinion. But please ensure you can apply on legal terms; commercial use requires a paid license.
As an alternative (even though I’m not too fond of it), properly configured Neovim is useful for Python development and debugging. It’s free and open-source and damn customizable. It’s just not my cup of tea.
Honestly, I wouldn’t say I like VSCode, it’s written on Electron and become pretty annoying on large scale projects.
I second PyCharm. It has a very easy user interface to work with and a simplified way to add libraries as it has pip built-in (you don’t need to go to the command prompt to manually type in instructions to add libraries). You select the library to add via a drop down menu, select to add, and it does it for you. So that is a big plus.
I’ve used vi/vim all day every day for the last 35 years but I recommend VS Code for new developers. Unlike PyCharm it can be used for other languages and it also superbly supports Jupyter notebooks (which PyCharm does also but only if you pay for it).
I recommend VS Code as it has LOTS of specific add-ons you can add to make development easier, like viewing SQL databases or SQLite files.
I don’t recognise any of the problems you are describing. Lots of people use Spyder without having such problems. If you are otherwise happy with it as an editor then maybe just uninstall and reinstall. The problem might be something to do with Python environments having different packages installed.
What’s the advantage of using VS Code for Jupyter notebooks and DBs instead of using an IDE + Jupyterlab and DBeaver?
@Lucas_Malor VS Code is free and easy to install so just try it yourself compared to whatever IDE you are asking about. As a vim user I use the vim extension in VS Code and that also works really well in notebooks because you can use vim keys to edit cells and then ESC j/k to move to other cells, etc. Other vim users will understand how nice this is.