In these tutorials we will show you a way to document your database using Foliant. Right now there are options available for those of you who use PostgreSQL, Oracle, MySQL, MS SQL Server and DBML. If your DBMS is not in the list, send us an issue, we'll do our best to add the support to it as fast as possible.
Generally, we want to keep our docs as close to the code as possible. For documenting the source code of an application we usually can utilize the power of Swagger to generate docs from comments in the sources. Since there’s no Swagger for databases, we had to invent something similar.
We are going to add actual descriptions of the tables and fields using comments. Comment (not to be confused with SQL script
-- comment) is a special entity which in one way or another is present in most DBMSs. They don’t affect the data or table structure, they are only used for documentation purposes. You can add a comment like this:
COMMENT ON TABLE "Clients" IS "Table holding info about the clients"
After describing all your entities inside your database, we need to get all this information for our document. For this we will use Foliant DBDoc preprocessor. It queries the database to get its structure (including the comments) and converts it into Markdown. We can then use this Markdown to generate a static site for our documentation.
First tutorial is about creating a document out of DBML schema. DBML is not a database but a simplified language for describing databases.
The other two tutorials focus on the process of documenting actual databases. We have tutorials for PostgreSQL and Oracle. But the process of documenting other databases is quite similar.