I'm required by my GIS Master's program to create an online portfolio of my work. As I learn new mapping technologies and software I'd like to share my knowledge through a blog. I've decided to go with WordPress, but this is my first project on the platform.
I've already developed a very basic php application that queries a mySQL database of my past academic coursework. When the page loads all of the data is displayed in a table, however, there's a selection box where you can filter the data (with ajax) by the College that offered the course.
I'd like to integrate this functionality into a WordPress site so that it fits nicely into the main content area of a template. I think this type of functionality would be helpful to others in the future so I'd like to make this my first plug-in.
There seems to be several different ways to store custom data (post meta, options, custom table) in the WordPress database, but I'm looking for some guidance for my use case. Obviously with my working prototype using custom tables would be the easiest to implement, but I might lose functionality that goes along with the core WordPress API.
I only have about 150 rows of data so I can't imagine indexing would be much of a concern. Eventually I'd like to add an admin side to the plugin, which would allow uploading a file (CSV?), and adding/removing a single course.