A friend of mine wants to upgrade his computer. He is using an old proprietary tool to manage his clients files and agenda. This tool won't work on a modern OS, he could emulate or virtualise it, but he was never fully satisfied with it. He did not find any software one the market that fits his needs, having some time for a side project he would like to develop his own database. He does not have any programming skills (yet). The data filled in the proprietary software is easily exported as XML files. He would like this new tool to be platform independent.
So, what tool would be best to build a cross-platform client database software with a linked agenda ?
So far I advised him to have a look to Opennoffice.org's Base module, because it fits his skill set.
As he does not need a server running, I would advise against a PHP/MySQL solution, mainly for security reasons (I know it's easy to secure, but he would have to also learn about security).
I would personally get this project done with python and sqlite (adding to the mix wxpython for the looks and sqlalchemy for my SQL allergy), but I fear that he doesn't have enough time for this project to acquire some coding skills in the process.
As a side question, is there some nice resources introducing databases concepts to beginners?