We have a class/table with a binary property. We use ORecordBytes to set the data for a document. Inserting records into the class/table is working fine, the question is about the removal of such a record. When deleting the document, the binary data referenced in it is not removed automatically, there is a separate call (ORecordBytes::delete) required. I would assume there is a way to achieve the same by just deleting the document but I have not seen any info on this in the OrientDB documents. Thanks for any hints on this.

Post has attachment

Post has attachment
At Arcade we love data, but sometimes data doesn’t love us....

Arcade Analytics
Arcade Analytics

Post has attachment
UTN checker
UTN checker

I am new to OrientDB and working on database encryption.
Can anyone please guide me about followings:
How to encrypt database in OrientDB? and more importantly, can we execute quires on the encrypted database?

I tried to enable AES encryption but didn't see any encryption outcome. At the end, it allows database connection, where contents are unencrypted even with an incorrect encryption key.

According to the documentation, I performed following steps to enable database encryption:

------- create database with key1 ------
config set storage.encryptionKey Ohjojiegahv3tachah9eib==
create database remote:localhost/databases/encrypted-db root 12345 plocal document -encryption=aes

CREATE PROPERTY Customer.id integer
CREATE PROPERTY Customer.name String
CREATE PROPERTY Customer.age integer

INSERT INTO Customer (id, name, age) VALUES (01,'satish', 25)
INSERT INTO Customer SET id = 02, name = 'krishna', age = 26
INSERT INTO Customer CONTENT {"id": "03", "name": "kiran", "age": "29"}
INSERT INTO Customer (id, name, age) VALUES (04,'javeed', 21), (05,'raja', 29)



------- open encrypted database with key2 (different from key1) ------
config set storage.encryptionKey Ohj11iegahv3tac1111111==
CONNECT remote:localhost/databases/encrypted-db root 12345

OrientDB will show original data of Customer CLASS.

I like to build a Form generator based on the OrientDB schema. Something to build forms easily and make those accessible to enter data, something like Rails Generator, yeoman but with the simplicitu of K2.

What is the best approach to achieve this?

Post has attachment

Post has attachment
When you have to change to OrientDB?

Coming from MySQL / MariaDB / PostgreSQL / Oracle or MongoDB, when you see following happening:

- Your number of columns increase, bitfield like columns are massively increasing

- You’re desperately trying to move bitfields into a separate table

- Use of temporary tables for different representations of your data increases

- You feel you have to reorganize your database schema all the time and you’re afraid of breaking your mission critical applications

- Group relationships become increasingly complex or even impossible to describe with tables

- When you have to replicate more and more data in different tables and you have to preserve consistency

- When even your incremental hot backups begin to become complicated and time consuming

- When you need plenty of triggers, server side scripts to ensure consistency, replication and secure hot backups

- When your SQL statements become increasingly complex

- When execution times explode

- Replication, hot backup collides with triggers

- You have lost overview and you are no longer sure about, that you have really backup'ed all data in a consistent way.

- Restore tests on a regular basis are showing up inconsistent data, that need to be repaired manually

- Your database has become so huge, that frequent reorganisations of the (B-tree) data on disk no longer possible.

- You have no idea, on what platter your data resides and what exactly needs to be restored in case of disk failure

- Administration and maintenance costs explode, your're asking for better administration tools

- You need more performance and hardware/license costs begin to explode, but you don’t see any other choice

- You already have thought about using Azure Cosmos DB, Google Spanner or Amazon DynamoDB but you don't want to give away your data into U.S. clouds

Then it’s time to migrate to OrientDB at very moderate full enterprise licensing costs.

If you need a highly sophisticated HTML5 GUI, see also open sourced KeyLines: https://youtu.be/rQ-CbUWwUso

Have fun!

(And no, i am not related to these companies)


We have a number of queries that use a LET statement to bind context variables to conditions. During a review of those queries, we identified a few of them where the LET statement could be avoided by redefining the conditions. When running performance tests with those modified queries against OrientDB 2.2.16, we saw that the queries without the LET statement significantly outperform the ones with the LET statement: e.g. a query without the LET statement took 0.177 seconds to return the data while the one with the LET statement took 1.566 seconds for the same data. This is quite a gap. We were then looking for hints in the documentation for recommendations on when to use a LET statement and what the price for using it may be (that is in execution time) but we could not find anything. Is there any information available on this?



Post has attachment
Wait while more posts are being loaded