Revit API Forum
Welcome to Autodesk’s Revit API Forums. Share your knowledge, ask questions, and explore popular Revit API topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Best Database type for Revit data

3 REPLIES 3
SOLVED
Reply
Message 1 of 4
nick.wostyn
1263 Views, 3 Replies

Best Database type for Revit data

Hi all,

 

This is my first post to this forum, so please don't shoot me if I'm not following some rules 100%.

 

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!

 

Nick

 

Labels (1)
3 REPLIES 3
Message 2 of 4
jeremytammik
in reply to: nick.wostyn

Dear Nick,

 

Welcome to the Revit API forum. No shooting expected here.

 

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.

 

Instead:

 

Go for the much more modern, scalable, minimalistic, low-cost, simple to use, web-adapted NoSQL options instead.

 

Here is my main argument:

 

https://github.com/jeremytammik/FireRatingCloud

 

Best regards,

 

Jeremy

 

 



Jeremy Tammik
Developer Technical Services
Autodesk Developer Network, ADN Open
The Building Coder

Message 3 of 4
nick.wostyn
in reply to: jeremytammik

Dear Jeremy,

 

Thank you for the quick reply!

 

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?

 

Kind regards,

 

Nick

Message 4 of 4
jeremytammik
in reply to: nick.wostyn

To me, that sounds like a good reason to choose MySQL after all.

 

Poor you, you will not be learning anything new...

 



Jeremy Tammik
Developer Technical Services
Autodesk Developer Network, ADN Open
The Building Coder

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk DevCon in Munich May 28-29th


Rail Community