00:00Hello viewers, in this video, I'm going to introduce a piece of software which is absolutely super cool
00:06You could also regard it as a Swiss army knife for developing software, which is called Directus
00:15Here we have the website of Directus, and they claim the backend to build anything or everything, which is, I don't know, you have to dive in yourself, but this is a bold claim
00:29However, it is actually a low-code or even no-code application system, and, um, beyond that, it actually, uh, also gives you a lot of automatically created APIs
00:45And if you scroll through that, there is basically everything mentioned which it does
00:50It has a REST interface, GraphQL APIs, and so on and so on
00:52You can create your own dashboards, you can create flows, whatever strikes
00:58your fancy
01:02Also, it ties in with the most popular JavaScript frameworks, and there is basically almost nothing you can't do with it
01:14Before I really dive into the topic, a short word about memberships for this channel
01:22If you would like to support this channel, you can choose between three membership levels on Patreon, and basically, all of my Patreon members can watch my videos completely free of ads, and I'm also answering all your questions and comments on Patreon with priority
01:39There are two more, uh, and higher membership levels on Patreon Plus and Plus Plus, they give you 10 respectively 25% discount on my consulting rates, and if you would like to book a session with me, there's the booking link in the video description
02:00course, there's also the completely free of charge YouTube subscription to this channel
02:05And if you haven't done so yet, please take your time now and click on subscribe below this video, and also ring the bell so that you are informed each time I'm releasing a new video
02:19And if you like this video while you're watching it, it would be really awesome if you could give me a like because that doesn't only help this video, but the entire channel to position itself better in the YouTube algorithm
02:33That would be really awesome
02:36But now, let's dive in and have a look what Directus is, what it can do, and then later on, how to install it in container manager on our Synology using portainer, make VLANs, and all these nice little things which I've already
02:51introduced to you, and finally, we are going to dive a little bit into Directus and create a few tables, play around with it, and see what we can do within a few minutes
03:06Well, what is Directus? I've already shown you on their web page, uh, their little bit of marketing blur
03:14However, uh, it is already pretty mature
03:17It is currently in version 10.6 of some point release, so you can imagine it has already, uh, proven itself in quite a few applications, and if you would like to, um, actually, uh, have a look, there is also a section of about success stories here, and you can just browse through that
03:39There are really quite a few interesting ones
03:42Beyond that, you can also have a look at what it actually can do and what it can't do, but let's cut a long story
03:51Short, basically Directus is an overlay over basically any database which you want
03:58There's support for MySQL, MariaDB, Oracle, uh, I think even MSSQL, but particularly also Postgress, and this is what we're going to be using later on
04:13You can create your uh data model inside Directus
04:18You can basically also fine-tune what the end user is going to see from authorizations, authentication, uh, over to basically the layout of a little screen where you can already create a low-code or even no-code app straight, straight out of uh Directus without even using any of the frameworks, which is super cool
04:42We're going to have a look at this later on
04:45As you can see, there is quite some extensive information about what it can do
04:50Um, just have a look
04:56yourself
05:02As I said, there are also things like solutions which you can also tap into mostly, but Directus is mostly known as a headless CMS
05:08Yes, you can also use it for that, but really, it goes way beyond the headless CMS
05:14You can do quite a lot of things with it which have nothing to do with a CMS at all
05:21There's also quite some extensive documentation about Directus available, and really, I've seen a lot of documentation
05:32This is really good, so have a dive into it yourself and read up on it
05:37It's really written in a very concise language, which is easy to understand
05:44Of course, if you don't want to host it yourself, you can also subscribe to their cloud offering, which isn't cheap, but since they are targeting bigger companies
05:56As well, it's understandable that they also charge some money for it
06:02In the next section of this video, I'm going to show you what you can do, what you have to do to self-host Directus in the community version on your Synology with everything which goes with it on PostgreSQL
06:20Well, there is a little bit of uh information available about how to self-host Directus
06:30Um, I'm going to quickly try to find this
06:35Yes, I'm on the on the right track
06:39And down here in the Directus docs, you have a section which is called self-hosted, and there is a Docker guide
06:44And um, while it's well written, it basically just gives you a few hints and uh examples what you can do to uh start with Docker Compose
06:57However, as usual, I'm going to go a little bit beyond what they do
06:59And using MCV Lans and paina with Stacks, we're going to make it our own
07:08For that purpose, I have, as usual, done the work for you, and I have prepared the stack script already, which you can see here in my text editor
07:17By the way, I'm using VSCodium
07:20If you would like to also use that, the link is downstairs in the video description
07:26VSCodium, I'm using that because it's basically the complete open-source derivative of Microsoft's VS Code, but it doesn't phone home or download anything from Microsoft, so you have your complete privacy here
07:48Anyways, let's have a look at this Directus script
07:51You can also download it from the link in the video description, and I suggest you do that now and open it in your text editor or file
08:00editor of choice, and together with me, we're going to now look at the changes which you have to do to make it work in your own environment
08:10So, first of all, let me just take this distracting thing away here
08:13Uh, the thing starts with the database section, and they suggest to use PostGIS
08:24Uh, they are supporting basically all long-term releases of any database, so 15 should be okay
08:30Um, then, of course, we want to persist our database data because everything in Directus is stored in the database
08:42So, this is the first point where we have to, uh, go in
08:45Um, as usual, the volume mappings work as follows: the right-hand side is what happens inside the container, nothing to be edited, leave it as it is, and the left-hand side, before the colon, is what we can Change, and where we have to basically provide our own volume
08:54And to do that, it's very easy
09:04You open your browser, you go onto your Synology, quickly log on again
09:14Now, here in DSM, you open your File Station, go to the Docker shared folder, which has been automatically created when you installed the Container Manager image on your Synology
09:27By the way, if you don't know what the Docker and Container Manager stuff is and so on and so on, I've made a video for exactly you guys, which is available here, um, in this video, which is, which is basically everything for newbies
09:42I'm explaining how to prepare your Synology for Container Manager, what Container Manager is compared to Docker, uh, how to prepare everything, like the text editor and SSH
09:54access and so on and so on
09:56Have a look at this
09:59Just come back to here and everything will be clear, clear as mud
10:01All right, we are now in this shared folder
10:04Click on Create and create the main folder for your, uh, Directus installation
10:13Let's call it Directus demo, just like in our, uh, configuration file
10:24Directus, there's a U missing
10:27Okay, so open this new folder by double-clicking on it because we now have to put in a few more subfolders in here
10:35Which ones are these? Just let's go back to the editor
10:42First of all, data for the database
10:46Data, as I said, clear as mud
10:49Create, create folder, data
10:53Now, of course, we need the exact path to this, to this folder
10:57How do we do this in a graphical user interface? That's very easy
11:03You right-click on this line of this
11:06newly created folder, you click on properties, and next to location, you have the complete path
11:11Mark it like I do with a mouse, type command C or control C if you're on Windows, on your on your keyboard
11:22Switch back to your editor, mark everything from here, like I do, up to the code on, and press command V or control V on Windows, and you've basically replaced the string with what you have
11:36Next in the database section is the environment
11:38We have three variables
11:41The user can stay on Directus
11:43You might want to change the password to something a little bit more, not as easy to to to to guess, um, that's of course Directus
11:54And the postgress DB name, this, the name of the database inside post is Directus
12:00So the the first two, you, the first and the last
12:03One, you can leave as you like, uh, if you like
12:04And the password, you might want to change, but please remember it
12:11Oh, well, you will be able to find this in your file anyways
12:16Okay, lastly, in this section, we have to take care of the network section, and this is something I mentioned earlier already
12:25As usual, I'm going to make use of MCV LANs
12:28And if you don't know yet what MCV LANs are, how to configure them, and all the intricacies which come with them, I have made a video about it here, um, which I suggest you have a look at
12:40If you are completely new to Make Vens, it is almost 30 minutes of, uh, of lots of information, but afterwards, you will be, maybe not an expert, but you will know most of the things which are necessary to follow my videos and most of The things which are not immediately obvious right now will be explained there
13:03Please, if you don't know MagV Lans at all, jump into this video and come back
13:09Otherwise, you will miss information which is really important right now, and configuration as well, and nothing will work for you
13:18Now, back to the network section here
13:21Here, at the point IPv4 address, you have to enter an available IPv4 address from the MCVA which you created
13:30If you don't know what's available at this point in time, just go over to your painer
13:38Freshly logged in, it should look like something like this
13:42Click on containers, and if you look here, over on this side, at IP address, you can sort the list by IP address ascending or descending, so pick one of the available IPs
13:55addresses and enter it in this point, this point here
14:00Next, we have the section C, which is Redis
14:04In my opinion, it's not really necessary to persist Redis data, but if you would like to do that, you can do it by unhinging two lines, volumes, and this line here
14:16But then also, please create the appropriate subfolder in the Directus folder on your Synology, otherwise this will not work
14:26Next, of course, like just before with the database, we have to supply an available IP address here from our MC van
14:37Now comes the interesting part with the Directus section itself
14:44I usually leave it like this, with Directus colon latest, because then when I update it or have it pull the image again, I always get the latest version of Directus
14:55Quick word about post
15:07I usually leave the version uh specified because sometimes the update will then, if you put in the latest, a newer postgress version, and this is not, of course, not compatible with what you have there, and then the whole thing will not start, and big problems
15:18All right, let's go back to the the director section here
15:25Uh, next, we get to the port if we are using
15:29And since we are using Mcvan, we or Mvan, we don't need a port mapping
15:35If you don't use Mcvan, of course, you have to enter port mapping obviously
15:41Next, we get to the volumes section, and here we have two subfolders which we still have to create
15:48One is called uploads, the other one is called extension
15:52We let's do that quickly over in DSM
15:57Create extensions, create folder
16:04uploads, there we go
16:12And like before, let's get the folder names by clicking, right-clicking on this, going to properties, and copying out this string next to locations or location
16:20Then go back to your editor and paste this, what you just have in your clipboard, over over this string here
16:35I've done that already, so I don't have to do anything
16:37Um, but yeah, don't forget to do that
16:41Of course, depends on C and database clearly
16:45Now we have, uh, several environment variables which you have to maybe adjust
16:51Definitely the key and the secret
16:55So I'll quickly show, going to show you how you can replace these yourself
17:00In this video, I showed you how to install it
17:03Tools, let's go over to my homepage app
17:07By the way, video is also here, and I'm going to open my it
17:12tools here
17:17Let's now go over to UUIDs and create two
17:21If you don't like what you see, you can click on refresh as many times as you like until you see something which you like
17:27I'm going to use these two
17:33Copy these into my clipboard, go back to my editor, and use this one as the key
17:37Copy, paste as usual
17:42And let's take the second one as the secret
17:46Copy, paste as before
17:50Done
17:53Next, we have several parameters or environment variables concerning the database connection
17:57Just leave the first three as it is given here in the script
18:03However, if you changed anything before in the database section, like user, password, and DB, you will have to adjust it accordingly here in these three variables, which I'm just showing as marked
18:21Then, of course, the Redis and cache section, you can leave that exactly as it is given here
18:28Now, you have the admin email
18:31Please adjust to something which you have, including the email address as well as the password
18:39Now, if you want to send emails from Directus, you can either do that with the classical SMTP parameters
18:45Nothing too strange here
18:50You can really, uh, fill in these parameters if you like, and please remove the hashes, uh, otherwise it will not work
18:56If, if you use Amazon SES like I did, then you can use these three variables, which I'm leaving in here for you to play around with
19:06Um, by the way, if you think these are correct, this is an actual, uh, SES account
19:12It isn't
19:14So please replace these things with, with your own SES account data
19:18Now, there is, uh, a section
19:21called labels, and I'm you
19:25This is used for a thing called Watchtower
19:29And Watchtower, if you don't know it yet, is a tool which can be used to automatically, uh, either inform you about updates to, uh, containers, or actually even perform the updates itself
19:41If you would like to, uh, use Watchtower with label enable, you can put in this label, and it will then automatically update, um, Directus if you like
19:53If you don't like that, just, uh, put hash hashtags in front of both lines and or delete them, whatever
20:05Uh, then Watchtower is out of the scope
20:09Then, of course, the network section here
20:13Supply an available IP address for your, um, Directus service
20:21And here, of course, in the last part here on the networks, supply the correct name of your mcvan
20:27might not be called MVL 200
20:32Well, after everything is done and dusted here, you can type Command A or Control A on your keyboard, which will select everything
20:44Then Command C or Control C to put everything into the clipboard
20:49And now we go over to Paine
20:54Earlier, we looked at our uh container list
20:58Now we go over to stacks and create a new stack
21:02Click on ADD stack
21:06Give your Directus container or Directus stack a proper name, like Directus
21:10I'm going to call it Directus-demo because I already have a productive installation running here
21:19And now, since we have everything in our clipboard, we can go into the web editor and press Command or Control V and paste everything in here
21:30If you want, you can once more go through everything and Check if everything is correct now
21:37Nothing else has to be done except for clicking on deploy the stack
21:42And if you are doing this for the first time, it will take a while until everything has been downloaded from the internet and published and or submitted to the container manager to create the actual containers
21:57So don't worry if this takes a few minutes
22:00It will come back
22:04Once everything has been downloaded and the container is deployed, you will find your Directus stack listed like this
22:15Click on it, and you should see three subcontainers in the state of running
22:20I usually like to have a look into the log files just as a precaution, see if something had, uh, was not, could not be opened, and we will have to find out what the problem might be, but for now, um, we have to take care of this little problem here
22:49The upload directory is not read-writable, and this applies to basically all the subfolders which we just created
22:59This is a little bit of a niggle on Synology because they have, um, a way of supplying permissions on their shared folders, which is not always compatible with all U containers
23:13So, what we have to do is, we have to, we have to open a command line like this, and now we have to log on to our Synology
23:28And now I'm switching over to my shared folder, um, Docker and Directus
23:42So, let's have a look at the permissions which we have here
23:44And as you can see, basically, it is read-writable for everyone
23:50However, there is a little plus at the end, and this indicates that There are special permissions, uh, Force enology on there, which will prevent the whole mechanism from working
24:03So the only subfolder where everything worked is data, because of course, it seems that the PostgreSQL container can deal with exactly these things
24:17So let's correct this for the remaining two folders, which will be a command which is called change mod minus r recursive Triple 7 on extensions, and the same for uploads
24:41And if we look at the permissions now again, the little plus sign has vanished, and we should be able to properly write into these folders
24:47I know Triple 7 is an ugly solution, but I haven't been able to come up with anything better up to now
24:56Should you have a better solution than this, please be so kind and Leave me a comment under the video
25:04So now let's go back to our painter and let's just restart this Directus demo main container
25:16And now, clicking on the log files, this problem should not be there anymore
25:23Let's just watch this happening, and as you can see, the shutdown and restart mechanism worked, and we can now switch over to Directus itself because obviously it's running properly
25:41In the next section, we're going to have a look at Directus's log on and make ourselves at home in this thing
25:49Now, let's have a look at our newly created Directus installation
25:55I hope you remember that the IP address, otherwise, if you don't, just go back to your, um, script, and here at the bottom, you have the IP address of your Directus container
26:07So let's Enter this here: HTTP colon SL1 192.168.20.10 colon 8055
26:21I don't know why they chose 8055, but this is just one of these things
26:28Now we have the login screen, and of course, how do we log in with our admin email and admin password? So this is admin@example.com, and the password was the German word "gim," which means secret
26:51Gim, sign in, and here we are
26:53No, we don't want to save this password
26:56This is just nasty, and this is basically our own Directus installation
27:01We currently don't have any content
27:04We could create something which they call a collection, but basically, a collection is a table in normal database speak
27:14But let's just stay here and uh, click on these on these items here on the left-hand side
27:21We have the user directory of course, we don't have any users except for ourselves
27:26Uh, we can create more users later on
27:32We have a file library, so basically, we can upload and download and, uh, you propagate files just the way we like it
27:42Then we have some, then we have something which is called insights, that is the, yeah, the place, uh, where you can create dashboards
27:54Then we have the link to the Directus documentation
27:57So if you need to, uh, split off to the documentation, you click on here and you can get all the links which you might need
28:03Let's close this again
28:10And lastly, we have what's called settings, and this is basically where lots of things are happening
28:16First of all, let's go to the first one
28:19They want to branch us off into the data model immediately where We can create our collections, but let's postpone this for a few minutes
28:27Let's first have a look at the project settings
28:31Here we can customize quite a few things, which is quite interesting
28:38Like, for example, you can give this a name, Directus demo
28:44Project descriptor: this is a demo for YouTube
28:58Then we can give it a URL, which means it is possible to make this accessible from the outside world, from the internet, directly onto Directus
29:09This is beyond the scope of this video now, but it is possible
29:15Then you can select a default language, of course
29:18English, United States is the default for now, but you have a plethora of other languages which are available, which doesn't necessarily, which doesn't
29:30necessarily mean that the user interface of Directus is translated into all these languages, but you can basically fine-tune your, um, the application which you are creating, um, and use translations into other languages
29:46Here you will later on see where it is used
29:49Then you can give it your own style
29:53You can give this project a particular color, which gives certain accents to it
29:58Let's just use this blue here, and, uh, you can upload a logo if you like
30:03You can give public areas a different, uh, foreground and background color, quite interesting
30:08You can give it a public note, uh, you can customize certain CSS variables, which is brilliant, and of course, you can customize this menu here on the side
30:21Then, of course, there are certain policies in the terms, in terms of security, like for example, password policies, which you can, uh, select here
30:30You can even create your own, uh, then, uh, login attempts
30:3325 is generous, but we are working in a development environment here
30:42So, in a production environment, you might not have 25 attempts
30:47Then, of course, you can have, uh, parameters for files and storage
30:51Uh, if you want to upload pictures, for example, you can and give, uh, give it certain instructions what to do with these files
31:02Now, let's go one step further
31:03Let's have a look at the roles and permissions
31:09Oh, yeah, they want us to save these things
31:11If you change something, there is a, a certain icon up here in the corner
31:16Let's save this, and you can see I changed the color of the, of our project
31:22to blue from this purple, but the rest is still the same
31:25To change these things, you would have to dive into the CSS level
31:30Okay, let's go over to the roles and permissions
31:33Um, this controls basically on a table or collections level, they call it collections, uh, who can do what with the data
31:42So you can create, for example, a new role, let's call it test, and, um, you can say, okay, app access is enabled, so people can access what's, I'm just clicking on that, what's behind this, uh, this cube
32:01Um, you can include certain collections here and give very finely grained, uh, permissions
32:11If you want to enable admin access, so basically this role can almost do everything with the application, you can also enable admin access if you like
32:18Then you can say, okay
32:24These members of this role can only access this app from a certain IP environment
32:31Also possible, you can also say, okay, everybody in this role has to log on with two-factor authentication and so on and so on
32:42Then, lastly, of course, you can add existing users to this role, or even you can create new users from here, which is pretty cool
32:52Then we have things like presets and bookmarks, which is a topic that we can't use right now
32:56We're going to use this once we have a few collections in our system
33:03Then we have custom translations
33:07As I said, we have lots of languages in our project settings, and now we can even create certain keys and values for languages which can be used later on
33:21Then web hooks, which is something where we can Basically, once something happens, you can trigger something in a different application across the internet
33:29For example, you can send notifications or you can trigger workflows in, let's say, n8n or other workflow engines
33:35Absolutely cool
33:40Then, lastly, we have something which is called Flows
33:42This is basically a workflow engine inside Directus
33:48I won't touch it in this video, but yeah, there is lots of documentation about it
33:54It has been newly integrated in Directus in version 10, and there is still lots of development going on, and this is going to be really cool
34:06Other than that, there are two more links which are Directus development based
34:11You can report bugs or request features, which basically links it back into
34:17GitHub
34:22Now, let's have a little look at what we can do with our collections, respectively, the data model
34:28Yeah, let's go over here, click on data model
34:30And what's in database, speaker table is a collection in Directus
34:34So, I'm going to make a very simple example, countries and cities, so that you can see how these also can connect to each other
34:46I'm going to create a collection, and that already says, uh, you create a unique table name
34:54I'm going to say countries
35:01Um, we leave it as it is here
35:05Let's not make things more complicated than they should be
35:06And now let's click on next
35:08Now we have, um, the, the, the option to, uh, create a few standard fields
35:16I usually turn them all on because it's easier to later delete them than to recreate them
35:22They are mostly targeted to as we know, CMS related uh tables, but hey, who cares? Well, a country doesn't need a status, but maybe a sort field I created on
35:37It's always good to know and always good to know who created this thing, when it was last updated, and who did the update
35:45Always a good thing to have in terms of, well, compliance
35:51So now let's click on finish setup and now we have our, yeah, uh, fragment for countries
35:57To make it really a country's table, let's create a field and this should be a normal input field, normal text, and usually a country has a name
36:14Let's call it name and now we can select from different types, but string seems to be correct for a name
36:21Uh, if you want, we can give it a default value, but this is not really necessary, but a name is absolutely required, otherwise we can't have a country
36:31Now, in the user interface, we can, um, give it a placeholder, enter country name
36:39Oh, name, you will see later on what it is
36:44And now, left and right from it, we can actually set icons
36:50But let's, for now, just save this story here
36:52Save
36:55That's already very, very good
36:58Now, let's scroll further down and have a look at the collection
37:00Set up the collection
37:03It's called countries
37:06We can give it a note if you like to see what it is, what it does, whatever
37:08You can enter anything
37:11We can give it a, a certain icon
37:13And here you have lots of icons available
37:21And you can, you can try to select via searching from this list
37:27But let's just do this
37:32This is going to be our icon for the countries collection
37:38We can give it a certain color if We like that
37:41Let's click on this and make it green
37:44Always
37:48Uh, now we have a display template
37:51If you have more fields than what we have here, you can create a certain setup of what is displayed
37:57If we just look at the country's collection in a list view, let's just leave this open for now
38:03We can go further and, uh, give it a collection name in a different language
38:12So, for example, we can create new in the language like German
38:21Or now, let's call it Länder
38:25Singular unit is Land, plural unit is Länder
38:28And Länder
38:31Here we go
38:36Now we have a preview URL
38:41Basically, also similar to the display template is what we can see in, uh, in overview views
38:46We can also select how things are archived
38:50This is beyond the scope of this video, or, uh, how it is sorted
38:52Now we can select a sort
38:56field, but I think the sort field itself is the right one for now
39:04Okay, let's now save this beautiful piece of work and switch over to our content page
39:12And now we have the countries collection here
39:16Of course, nobody's home
39:19Let's now create an item and now enter something like Italy, plus Germany, and not of course, United States
39:29So here we go
39:39And now we have a few countries to work with
39:49Let's take this one step further and add another collection
39:51Let's call that one cities
39:59To now create a new collection, we can create, click on this plus sign
40:02Let's call it cities
40:09Let's enable most of these fields again because we don't need a status
40:17Create a field name, of course, type can be string, default no, placeholder, please enter the city name, no icons
40:26Necessary
40:35Click on save, or we can go one step further and we can continue in advanced field creation mode
40:44Now, we all of a sudden, we can create, enter much more data, like for example, we can give this field a maximum length of 255 characters
40:57Should be a very long city name to go over that
40:59Default value again, no, allow value, not a good idea
41:06And if you want city names to be unique, maybe not in this case, because for example, there is definitely Hiedel in Germany, Hleb in South Africa, and Heidelberg in the United States
41:20So unique is not a good idea here
41:23Let's have a look at what we can enter under field
41:25Uh, we can make it read only, we make it required
41:29Click sounds good
41:32Click good
41:35Uh, we can hide it on the detail
41:38We can translate the field name, for example, if We have again the situation that we want to look at in a different language, uh, like for example, in German
41:57So the field name for name is n
42:02Okay, sorry, it's a little bit trivial, but I just wanted to show off
42:05Now, let's go over to interface
42:10As I said, we have already the placeholder
42:12We can add icons, we can give it a soft limit, we can change the font if we like, um, we can trim start and end if there is anything like spaces or so, um, sometimes a good idea, um, and we can also slugify, but what that means is just beyond the scope now
42:36We can go to the display part, and here can we can, um, change how the value is displayed
42:43Uh, takes us a little bit far away from what I actually wanted to demonstrate, so let's leave it as at, uh, at this point, so that you know it is there and that you can work with it
42:51Then we can validate, of course, according to certain rules, and there are certain conditions which you can also fulfill
43:00But let's leave it as it is
43:02Let's save it
43:04Now we have our city name
43:06Now let's take this one step further, because as I mentioned earlier, a city belongs to a country
43:12Now let's create the appropriate field here
43:15Let's on
43:18Now I clicked on create field and let's scroll a bit further down
43:21And now you see the relational section, and we create something which is called a many to one
43:29One country can have many cities
43:33Let's click on that
43:38Give it, uh, a name like country
43:42Now we have to select the related collection, which is countries, of course
43:48Display template, we only want to see the name of the country and Now we have the option to create items from the interface of cities
43:54This is good
44:00So, basically, if we have a city for which we don't have a country yet, we can create that later on
44:03Or exactly, we don't have to
44:06We can create a new country right now
44:09We can select it, and there are also filter rules, but let's save this right now, right here
44:13So we have our country thingy
44:17Let's have a look at this
44:21Now, in our content section, let's go over to the cities and let's create an item
44:27Let's create, as I said, Heidelberg, and we have to select a country for that, which will be Germany
44:37We can't select two countries, we can only select one
44:41Okay, let's save this
44:48Okay, this is a little bit ugly that we see, instead of the country name, um, the number two, but let's take care of this later on
44:58Let's create a few more cities like New York, and this will be in the United States
45:07Save
45:15And one more, just for Rome, for completeness' sake, which is in Italy, of course
45:23So now we have all these things available
45:27Now, uh, you saw earlier that we could also create a city or country if we are in the city editor
45:38Like, let's create something new, like, um, like Munich
45:42No, Munich is in Germany
45:48Um, let's say London
45:53Let's click here
45:59No, we don't have any Londons here, but we can click on this plus and it goes straight over into the country's editor and say UK
46:04Of course, I could have done it nicer, United Kingdom, and so on and so on
46:07But you see there is a new country here
46:12Okay, first of all, let's change the sequence
46:17First, the city name, and then the Country sounds good for me
46:24Now let's go back to our editor and say, hey, cities, that's nice, but we want to see something else
46:33And to edit our country column, we can click on these three points, say edit field, and now we can go over to display
46:42And now we say related values
46:46And now we get this, uh, uh, new option of display template
46:50And we say name, say yes
46:54And now let's go back
46:58And as you can see, the country name is displayed properly
47:02Now it would be really nice if you could have a list of, um, countries, uh, of, of cities if we have a look at a country
47:12So, but for now, it's a little bit barren
47:18Let's go back here
47:24Let's go to countries and let's create a field
47:31Now, this is the, the other, other way around
47:35We have one to many
47:39So basically, we have one country, many cities
47:43and the collection is cities, the foreign key will be country because both are related via the country key
47:54Uh, uh, and let's just save the story here
48:01Have a look over here, and we have a list of three
48:03Now, instead of these things in brackets, it would be nice if we had the option to see the city names
48:18Let's go back to cities and create one more so that you can see what I actually mean
48:23Let's go to here, let's say Milan, which is also in Italy, of course
48:38Okay, okay
48:40Let's go back to countries
48:41Now you see 3, 5, of course, as before
48:43The sequence is not really what I like, so I just drag the sequence of these fields in this window with the mouse
48:53So it would be nice if there would be now Milan or Rome, comma, Milan
48:59Let's go over here to the countries again, cities
49:04Let's go to edit field display, related values, display template name, save
49:14Let's go back to here and now at least we have something which is called two items
49:21We can click on it and we have a little list saying, in this case, Roman, Milan
49:28Here we can see London and so on and so on
49:34As you can see, this Directus thing gives us lots of options to display our data, to interact with the data, and so on and so on
49:44Let's have one more look at the at our security part, roles and permissions
49:52And now let's have a look at uh our test R, which we created earlier
49:57And as you can see, we have our two newly created tables here
50:00And now I can give defined permissions uh to this role
50:05What can be done with these different tables? For example, I can say the test R can display
50:14cities and countries, but they are neither not allowed to add, to edit, or to delete them
50:22They're also not allowed to share the links for which is pretty astounding, actually, how finally grained we can design our access mode
50:34Also, we had a look at our presets and bookmarks, and as you can see, this is a little bit H
50:41It doesn't say anything, but if we add one field collection, we all of a sudden see for which collection these presets are
50:51And for example, we, we're working with the sequence of these fields in the view for cities and countries
51:04I can say, wait a second, this preset is not for the admin user, it is for all users
51:15So everybody and their uncle will, of course, have this, um, this layout
51:22So basically, I can go as user admin or Jurgen and create my own layout, but I can also make this layout the default layout for everybody else
51:36Also very cool, and we didn't write one single line of code yet
51:40And if you wanted to do that, you could still do this, but this is how far, far we got with just a few mouse clicks
51:51This brings me to the end of this video about Directus
51:56We just scratched the surface of, uh, everything, but you learned how to install it and how to do your first steps on this system
52:02If this video was helpful, or at least entertaining, it would be awesome if you could leave me a like
52:09As I said, this does not only help this video, but the entire channel
52:13As mentioned at the beginning of this video, there are also options how you can support this channel, and that's via Patreon memberships
52:20There are three membership levels, and all my Patreon members can watch my videos completely free of ads, and I am answering all your questions and comments on Patreon with priority
52:34There are also two further membership levels, Plus and Plus Plus, they give you 10% respectively 25% discount on my consulting rates, and if you would like to book a session with me, there is the booking link down in the video description
52:51Of course, there is the completely free of charge YouTube subscription, and if you haven't done so yet, please take your time to click on subscribe right now, and please also ring the bell because then you will be notified each time I release a new video
53:08For this time, thank you very much for watching and see you
53:15[Music] Soon.
