I have been searching throughout the web for the best way to implement what I need but just cannot find a best solution as there always seems to be some drawback. I'd prefer to do it right the first time and it's been weeks trying to find the best solution.
On my current website, I need to add listings of businesses with their various information such as address, phones, URLs referring to the business, etc. There would be 30+ fields and as you can see with the example of the URLs there can be many URLs which refer to the business.
I'll need another list with its own data which will be a many to many relationship to the businesses.
I know SQL and could easily do this in C# ASP.NET but am trying to find the best way to do it with WordPress. I will be using the Genesis framework if that matters. It appears I have 3 solutions:
- create custom tables in the WP database
- use Custom Post Types with many custom fields
- rely on a plugin
Custom tables: It seems easy to retrieve the custom table info via SQL code but it looks like I would have to create an admin and especially if I want it to appear in the admin dashboard for ease of use to modify the tables.
Custom Post Types: They seem like they might work but then I'd need a way to do the many to many relationship and the solution there seems to rely on a plugin like Posts 2 Posts. Also I'm not quite sure how easily it is all managed since it seems like there would be many WP pages to navigate instead of having perhaps one UI.
Plugin: I have seen some recommended but then you're at the mercy of hoping the author maintains the plugin and then what happens if it breaks hence killing your website.
So to the more experienced WordPress users out there, if you were going to tackle this project, which method would you use? Thanks!