EVE Technology Lab

I've been playing around with trading spreadsheets on Google Sheets for a while now but, for whatever reason, they tend to have some problems from time to time. I'm unsure if this is due to the Sheets platform or the sheer amount of data I am asking the documents to handle. I've been using the function based Fuzzwork method of importing data, rather than the now borked ImportXML stuff, but I still come across occasional problems.

Anyway, I had a thought about doing it in a MySQL database and building a php front end customise what I want to see and do. Has anyone has any experience of this sort of thing before? I've had a look at a few different methods for importing data (primarily looking at the market orders for a single character at the moment) but my lack of experience/knowledge is tripping me up at the first step.

Any help would be greatly appreciated.

I had a look at this already but I can't figure out how to apply it to what I want to do. I was hoping that someone had done something similar and could provide a little more guidance than a link and some sarcasm.

There's a couple existing PHP libraries already. PhealNG and the one I maintain Yapeal. Both have threads here on the forums where you can find out more plus other info. I strongly suggest not trying to re-inventing the wheel and just using one of them since more projects seem to fail when they try doing it on their own. Plus you might also look around as there are probably some exist apps already that cover what you want to do with marketing APIs etc. Instead of starting from a blank sheet of paper try help one of the other open source or closed source projects that do what you want or could be added to to do so. One of the best ways to learn is working with existing working code and improving it.

Sorry forgot to hit summit yesterday or I'd been the first post here

Yapeal will work quite happily on a hosted server. Just needs php and mysql.