Search code examples
sqlgraph-databasesvertexorientdb

What is the difference between INSERT and CREATE VERTEX in OrientDB?

I've recreated my database as a graph instead of a document database, as it represents a social network. However, I'm unsure as to what the difference is between a vertex and an ordinary record. I'm still able to use INSERT, which is very useful because of the UPSERT option, and the CREATE VERTEX options doesn't have that option.

Additionally, I'm wondering if I do, in fact, need to use CREATE VERTEX, if an UPDATE VERTEX will be available.

Solution

  • There's no so much difference between CREATE VERTEX, and INSERT in the underling implementation but is strictly suggested to use CREATE VERTEX, because it can do additional check! as well as all specific sql operation like DELETE VERTEX!

    for the UPSERT in the CREATE VERTEX will be really nice submit a feature request :)