Have you ever accidentally edited a column and lost data? Truncated a table with millions of records? Deleted a whole database? No one should endure the stressful moments of trying to figure out how recent your latest backup is. It's way too easy to irreversibly damage a raw database. It also has helpful tools for cropping and resizing. Directus lets you see all of your files, manage assets in the filesystem, or even save them to the cloud service of your choice. And it takes a script/app to get files there in the first place. Sure, you can store BLOBs of file data directly in the database, but you typically don't even get a thumbnail preview. So you'll see John Smith – NYC Office (Accounting) instead of 64009. Directus handles all those native relationships, but gives you context about each item you're working on. Working with primary keys is time consuming and it's easy to forget what you're looking at when you're nested 3-4 levels deep. in fact it makes managing data a lot easier in certain cases as we'll see below. But a thin veil of aesthetics never hurt any one. There are many advantages to wrapping your database with Directus, below we outline several of the most notable:Įngineers love that databases are essentially a grid of raw data. You data is always completely pure and portable so you can come and go from Directus at will. Or, if you ever want to take your data elsewhere, just delete those Directus system tables and your content remains in a pristine SQL database with no hint that Directus was ever there. This decoupled approach means that you can easily install Directus on top of an existing SQL database to get started. are all stored in completely separarate tables from your content. More importantly, all the Directus "stuff" such as settings, revisions, preferences, permissions, comments, etc. You are in total control of your data, including how it's organized, stored, and optimized. That means you do not need to shoe-horn your project architecture into a predefined CMS schema. you are actually just creating tables, columns, etc in a custom SQL database. When you create Directus collections, fields, defaults, datatypes. One of the most unique concepts of Directus is that it aims to be a pure SQL database wrapper. For example, you could relate a single author to all of their books instead of typing the same author's name into each of their books. If you're confused by "relational", it just means that you can add an item in the database once, and then relate it to many other items. To use their existing database schema and contentĭirectus has been built to support the most common type of relational database: SQL (Structured Query Language).The full power of SQL queries via direct database access.Data transparency, portability, and security.Significant performance optimizations and indexing.A pure/custom database model that fits their needs.This makes it an ideal solution for projects that would like: Think of it like a database client (eg: phpMyAdmin, Sequel Pro, etc) only safe and intutiive enough for non-technical users. Instead of creating a proprietary one-size-fits-all data architecture to store your content, Directus "mirrors" whatever is in your actual SQL database. It's kind of like a very powerful spreadsheet. The Database is the container for your entire Directus project. If you're looking for the current Directus 9 documentation, go here: # Database You can continue to add or delete tables, modify the existing tables, and alter table relationships until the new database diagram is complete.These are the docs for Directus 8, a legacy version of the platform. The tables are displayed graphically in the new database diagram. Select the required tables in the Tables list and click Add. In Object Explorer, right-click the Database Diagrams folder or any diagram in that folder.Ĭhoose New Database Diagram on the shortcut menu. Additionally, you can modify indexes and constraints. Using database diagrams you can create and modify tables, columns, relationships, and keys. Database diagrams graphically show the structure of the database. You can use Object Explorer to create new database diagrams. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |