After renew interested and some users getting very confused as to how to use the Database manager, the 2020 webinar video was re-released on the forum.
However this was a very early release of Database Manager and had much missing functionality and alluded to possible additional features in the future, some of which have been added, others still not completed.
As a consequence George asked me to do an updated tutorial on the database manager and here it is.
This video is an update of the original 2020 database manager presentation given by George.
In this video we discuss:
- Overview of the Database Manger and intro to the knex framework
- what has changed (or not) since the original release in 2020)
- Adding/ removing tables
- Creating relationship through reference fields
- Using database templates
- Managing data with the database manager
- Database seeds
- What to do if things go wrong
Members attention is also drawn to two prequels
Database Connections explained
Managing Database connections via $_ENV variables
and sequels
Joins, Sub Tables and Multi References demystified
How to use INNER, LEFT adn RIGHT joins to find data present or abscent