What is the difference between INSERT and CREATE VERTEX in OrientDB?
graph-databases, orientdb, sql, vertex
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 :)
Problem
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.