[Feature]: Add option to delete the database when deleting the CRD

[kevin-messer-jemmic]

Description

Hi @josephaw1022, thanks a lot for creating this.

The database creation works well when creating a CRD file like in the examples but when deleting the CRD file of the database, the database is not being deleted.

Would it be possible to implement such a thing like cloudnative-pg did https://cloudnative-pg.io/documentation/current/declarative_database_management/#deleting-a-database ?

Thanks a lot in advance

Why is this needed?

We use dynamic databases for tests so this would be usefull to delete the file to delete the database.

[josephaw1022]

That's a great idea. Go for it!

[kevin-messer-jemmic]

@josephaw1022 I tried to give it a go but the operator seems broken when using the latest version, master branch in git or latest on docker. The application just hangs after the starts and do not detect any sqlserver being created. I can confirm that it works by reverting back to the version 2025-03-13. Also, on argocd, we cannot see the resources created by the sqlserver so it's not easy to see which resources have been created.

[josephaw1022]

I can look at it tonight and see what I can do

[josephaw1022]

@josephaw1022 I tried to give it a go but the operator seems broken when using the latest version, master branch in git or latest on docker. The application just hangs after the starts and do not detect any sqlserver being created. I can confirm that it works by reverting back to the version 2025-03-13. Also, on argocd, we cannot see the resources created by the sqlserver so it's not easy to see which resources have been created.

https://github.com/DotKube/KubeSQLServer-Operator/pkgs/container/kubesqlserver-operator%2Fkubesql-controller/591981637?tag=2025-11-27

[kevin-messer-jemmic]

@josephaw1022 Thanks for the fixes, I could now tests the changes and I can confirm that it works on my side, but it would be good that you double check it on your side as well.
A PR has been opened with the needed changes : #38

[kevin-messer-jemmic]

Hi @josephaw1022, did you had time to review the pr #38 ? Thanks a lot in advance.