G’day Pedro!
Welcome to MODx
I think you would be able to achieve all the above with MODx, although it may require a little custom coding depending on your setup and what you are trying to achieve.
Here are some suggestions which I’m sure someone else will elaborate on. Note that there are many ways to accomplish things in MODx so you’re not limited to these either.
My business is about publishing event programs online & the data involved requires a relational structure of 9 tables
Can such a structure be created or emulated with MODx? (So far the best I’ve made out is that it would likely be done using TV’s)
Have a look at the existing
ChurchEvents package, and also the tutorial on
Custom DB tables. Must admit, it will seem like pretty heavy going until you are more familiar with MODx.
Can I give access for content creation & editing through the front side of my site?
Can the ability to create various content types be to restricted by user type? (such as events only being created by even organisers & not end users)
Can content editing be restricted to the user who created it & site admins?
You can certainly create your own front-end editing pages without letting your editors anywhere near the manager interface. Have a look at
NewsPublisher as a starting point.
You can handle the viewing and editing permissions through
Form Customisation.
Are the mechanisms I can put on the editing pages so users can link content items (assigning a venue to a performance for example) without the user having to use MODx tags?
You can use TVs with select menus, checkboxes, etc pre-populated by @SELECT queries if you wish. See
TV Input Types
As for JSON, I can’t say I’ve used it but I’ve seen some discussion about it before. I think there is a JSON package floating around out there too.
Finally, if you haven’t already, have a look here at the
Revolution Docs. Particularly the sections on Administering, Developing and Case Studies.
With a Drupal background you’ll be familiar with CMS but you’ll need to spend a bit of time getting to know how MODx works. A little perseverance and I’m certain you’ll end up pleasantly surprised with the power and flexibility of this system. You’l also soon work out how helpful these forums are too!
Cheers
Luke