google : mariadb graph, 1rst link : https://mariadb.com/kb/en/library/oqgraph-storage-engine/

what is the point in asking a question if you won't believe the answer or even spend 5 seconds checking

skullnobrains

if i'm answering a different question, you may consider writing more than a single line for your questions.

the above thread clearly demonstrates your question can be understood in many different ways

marrowyung

ASKER

actually can't see why MariaDB told me a NO.

marrowyung

ASKER

man,

that;s why, confirmed by MariaDB today ! I usually ask multiple source, that's why:

"As described here, OQGRAPH is not officially supported.

https://mariadb.com/ja/en/services/support/support-policies"

they don't support then...

skullnobrains

you read one post from one thread where a guy tried to install the wrong version and deduced that ? ( which i know because the word support only appears once on the link's target )

f you're not willing to spend at least 15mn reading through the docs in order to figure out that sort of stuff, you probably should hire someone to make the decision for you.

but you're actually not entirely wrong : mariadb will provide limited support for backends they do not develop themselves.

also note that you can implement some graph features quite easily : years ago i used a 150 lines long lib that allowed to perform xpath querying on multiple tables structured as a tree and a second rather short lib for inserting while enforcing graph rules. at that time oqgraph did not exist. it was not that painful to code.

marrowyung

ASKER

"you read one post from one thread where a guy tried to install the wrong version and deduced that ? ( which i know because the word support only appears once on the link's target )"

it is the reply from MariaDB. com, we care about support.

"at that time oqgraph did not exist. it was not that painful to code."

good.

skullnobrains

then like every mariadb backend, you'll get limited support from mariadb and full support from the vendor. in this case available from openquery.com

not a problem here, but you're expected to mention you require support when asking for advice. in this case, you merely asked if there was such a tool.

again, you had better describe your project and ask for advice regarding the possible tools.

marrowyung

ASKER

" full support from the vendor."

Vendor here do not support.

they said we better buy support from redhat! as mariaDB bundled in Redhat linux, agree on that ?

" in this case available from openquery.com"

one thing, are you Australian ? seems not ! that openquery.com is based in Australia.

that company is good , They don't show up the FB account they have in the web page.

"again, you had better describe your project and ask for advice regarding the possible tools."

it is not a project yet and we are comparing feature of EACH DB product , will have questions on how to do/workaround on fixing on each of the problem of MySQL and MariaDB. this is the 2x now I have to dig into detail.'

marrowyung

ASKER

so for the work around of graph data, that link above is the ONLY workaround? for MySQL too ?

skullnobrains

Vendor here

i never meant your local vendor. obviously.

are you Australian

not american either. how is that relevant ? nowadays every software product includes knowingly or not collaborations from all over the world.

that company is good , They don't show up the FB account they have in the web page.

i have no idea what that is even supposed to mean. maybe that's because i'm nort a native speaker. are you ?

it is not a project yet and we are comparing feature of EACH DB product

you are currently comparing apples with tomatoes. sql databases are not meant to store graph data. nor json. start by figuring out your needs and pick the right tool for the job. you also need to consider ease of use.

comparing "each db" is a sweet dream. i can probably name at least 10 dbs you never heard of and i'm very far from knowing all of them. there are HUNDREDS of mature database products and many of them have many variants. start by understanding what a row db can do, what is the difference between sql and nosql, what ACID transactions are, what column stores do, what clusterisation techniques are available in each case ( share-all / sharding / ... ) ... at least you'll be able to determine what type of db fits your need.

do you even actually have data in hadoop ? if your goal is to do something with that data, analyzing the structure, size and queries you need to be able to answer is your starting point.

skullnobrains

so for the work around of graph data, that link above is the ONLY workaround? for MySQL too ?

it is the only one i know of. or you can use a lib similar to mine. which was efficient because i did not need all the features a graph has such as unlimited depth path querying.

i don't think it works with mysql at all ( though it probably could should someone bother to compile it but i doubt you'd get support from oracle )

marrowyung

ASKER

"maybe that's because i'm nort a native speaker. are you ?"

I don't understand what it means sorry ! can't you explain ? I need to learn sth from you and I am not a native english speaker !

"you are currently comparing apples with tomatoes."

back to my question, may be i should say do MySQL support graphic data modelling. I am checking also this for other DB. Oracle, DB2 and MS SQL has.

skullnobrains

back to my question, may be i should say do MySQL support graphic data modelling

see my very first answer : mysql does not ( as far as i know ), mariadb does with oqgraph. and it is still pointless to bother about such features unless you need them. and if you do, you probably should use a dedicated piece of software rather than an sql db. i'm out of this thread.