First i just want to say i am not an experienced php programmer, i do however have 4 years of programming experience from .net/c# world. I have built a couple of themes in wp so i have a pretty good understanding of the core functionalities in wp.
Now to the question.
I am building a cruise ship site and i am considering using wordpress as a cms. After looking at how meta info and custom fields are stored i do not think custom post types are the correct way to go for this project.
The case is:
I will be storing cruise lines
Each cruise line has ships
Each ship can be of type river ship or ocean ship,
Each ship has cruise routes,
Each route belongs to a region(example mediterranian)
Each route also has stops
Each stop is connected to a port
Each port is connected to a country
Each country belongs to one or more regions
So there are a few many to many and a few one to many relationships there
I have not thought it throuh fully yet but something like that. many of the tables of course have columns that must be searchable, you get the picture, a search engine for cruises.
I really like wp and pods seems awesome, also i do like a challenge where i could have the chance to learn more php. However it would be nice to get some out of the box functionality when working with the site(im thinking of when adding new cruise routes or boats etc)
How much out of the box functionality would i get from pods setting up this, for all scenarios, insert, update etc?
The search part will of course be a custom solutions with all the filtering queries.
Pods will give you the searching and joins right out of the box. You will need to code your own templates to display and format the data. If you’ve already built some WP themes, you are well on your way to having the skills needed to integrate Pods content into your site.
For all your multi-relationships, pods will definitely make your life easier. You can do this in Pods without writing any custom SQL. From a PHP coding standpoint it is definitely lighter on the custom code than adding and relating your own series of custom post types.