Another overly busy week so far:
- Loading all Revit 2021 SDK samples
- Loading The Building Coder samples and labs
- What database is best for Revit data?
On Monday, I discussed my struggles to successfully compile the Revit 2021 SDK samples.
The next step for me is always the installation of RvtSamples to load all the SDK samples into Revit for easier access for testing.
Since the Revit SDK includes 190 separate Visual Studio projects, you can imagine the work it would take to load them individually.
RvtSamples reads a text file listing the external command data and assemblies to load and makes them all available in one fell swoop.
Inclusion of additional files is supported, and I use that for The Building Coder samples and training labs.
Setting up the correct paths for all the SDK samples is often significant work, because the Revit development team make modification that require attention and do not keep RvtSamples.txt up to date.
The fixes I applied can be examined in the RevitSdkSamples list of releases.
Once I have the official SDK samples installed, I also migrate and add a number of additional samples to the collection of external commands loaded by RvtSamples:
- The ADN Revit API training material (nowadays DAS, by the way)
- The Xtra labs (comprising the former plus their older incarnation)
- The Building Coder samples
That task is now completed as well.
There is not that much more to say about it, really.
The migration was straightforward, and the installation as well.
You can examine the exact required steps by analysing the GitHub commits and diffs.
I thank Naveen T Kumar for his support migrating the official DAS Revit API training material.
Question: My question is about choosing a database type for exporting my Revit data.
I'm not a database expert, but I know that the following types exist: MySQL, PostgreSQL and NoSQL.
I would like to program something that exports my data from Revit to a database for further use (creating BoQ, ...)
However, I don't know which database type is best suited for exporting my data to?
Should I use MySQL, PostgreSQL or NoSQL?
You're probably thinking "well it depends on what you want to do".
But the thing is that I can't tell all the future use cases at this time, I just want to have a database with all of my Revit data so that I can do pretty much what I want with it in the future.
Any advice on this topic?
Thanks a lot in advance!
Answer: Good question! Thank you!
The best database for storing a Revit BIM model is the Revit database in the RVT file format.
Unfortunately, you have no direct access to the underlying data, so that won't help resolve your question.
You are basically answering your own question quite well, I think.
It depends on what you want to do. It also depends very much on your past experience, your personal preferences and your future plans.
I am not a professional programmer or a database expert, so you should take any advice I give with many grains of salt.
I would advise: avoid traditional SQL!
Unless you are an expert on that or have other pressing reasons to choose it.
Go for the much more modern, scalable, minimalistic, low-cost, simple to use, web-adapted NoSQL options instead.
Response: The only issue I'm having is that we would also like to link some of our internal databases to the Revit database.
The internal databases are MySQL, so is it possible to link a NoSQL database to a MySQL database?
Answer: To me, that sounds like a good reason to choose MySQL after all.
Poor you, you will not be learning anything new...