Разбираем древо ArangoDB «по веточкам». Подробный гайд по графовой БД

Давайте честно: совместный доступ к документам — одна из главных «болей» для всех, кто хоть как-то связан с базами данных. Вроде бы оба пользователя могут работать с файлом, но есть один нюанс: например, количество предоставленных доступов может быть больше, чем их есть на самом деле. Или у документа и вовсе появляется несколько владельцев. Для всего этого требуется решение – и мы его нашли! Меня зовут Владимир Ревякин, я старший инженер-программист компании «МойОфис», и вместе с QA-инженером Анной Рукавицыной мы подготовили этот материал, чтобы поделиться опытом реализации функции шаринга данных через графовую базу ArangoDB в рамках разработки платформы Поехали!

https://habr.com/ru/companies/ncloudtech/articles/905598/

#arangodb #базы_данных #базы_данных #тестирование #документы_онлайн #мойофис #мойофис_документы

A thing that I really liked about #ArangoDB was the way its query language worked.

Like, instead of tables and joins, you actually worked with objects and collections. You could do things like "load an object and load its associations into a field of the result as an array" — natively, without any ORMs or such.

I wonder if there's any sort of extension that would let a relational database behave this way.

#SQL #database

Can anyone recommend a comparison of Multi-model #databases? Or even recommend one based on their experience? Currently evaluating #ArangoDB.

Ideally looking for something without vendor lock-in (ie. AWS Neptune is out)
#graphdb #db #datascience #foss #selfhosting

Did anyone fork ArangoDB before it became non-free software? Asking for a friend. It's a pity since it was the only backend option for NetworkX.

https://nx-arangodb.readthedocs.io/en/latest/

#opensource #arangodb

Next-Generation Databases: NewSQL, Distributed SQL, and Beyond

#Database #DevOps #NewSQL #DistributedSQL #NoSQL #GoogleSpanner #CockroachDB #VoltDB #YugaByteDB #Citus #InfluxDB #Neo4j #ArangoDB

https://g.omid.dev/imH3Hv1

A ${deity} pongo por testigo que voy a conseguir entender cómo carajo funcionan las queries en #ArangoDB y así darle la patada a #elasticsearch pero juer lo que está costando 😅

A while ago I discovered #surrealdb and today I took the time to check it out.
Usualy I stick with #arangodb for all my development but there is a good chance this will change in the future.
Not that I'm unhappy using ArangoDB, on the contrary, but SurrealDB just has so much potential.
Intuitive, support for all platforms, even the browser, easy to integrate with most important languages.
I already have an idea of an application I'm going to build upon it.

[BLOG] First steps with a graph database - using Python and ArangoDB #ArangoDB #Graphdatabase #Networkanalysisandvisualization #Python https://cylab.be/blog/299/first-steps-with-a-graph-database-using-python-and-arangodb

[BLOG] Quick introduction to ArangoDB, the multi-model database #Graphdatabase #ArangoDB #JSON https://cylab.be/blog/298/quick-introduction-to-arangodb-the-multi-model-database

Went through a series of side-quests leading to rabbit holes containing kettles of fish to finally get some data from a #webscraper into a persistent database #arangodb. Learned a few things on the way and documented them in a blag post: https://blag.nullteilerfrei.de/2023/10/13/install-nsq-on-debian-with-init-d-and-nginx/

#cryptography #EllipticCurves #nginx #nsq #debian #pyArango #brainpool

And now that I mostly solved it, I'm realizing that it's not the #Clojure way, and that frankly I'd be much better off getting raw #JSON from the #ArangoDB driver and letting the Clojure side handle raw json into Clojure maps (maybe I'll add some validation later)

I'm tinkering with #Clojure and #ArangoDB, and I feel like I spent so much time implementing the driver layer (I had to dig into clj-http and Arango's API and I haven't even implemented transactions!..) that I totally forgot what exactly I wanted to make with it.

Tonight we write our first AQL graph query to display file names of ZIP attachments in the email view! #php #symfony #arangodb join us at https://twitch.tv/larsborn (or https://bonn.live if that's more your jam)!

AQL stands for Arango Query Language and is the "SQL equivalent" for the ArangoDb multi-model database software. At the end of last's stream, ChatGPT (3.5?) just spat out a working draft and today we try to reach parity in understanding AQL.

See you on the tubes!

Tonight we write our first AQL graph query to display file names of ZIP attachments in the email view! #php #symfony #arangodb join us at https://bonn.live (or https://twitch.tv/larsborn if that's more your jam)!

AQL stands for Arango Query Language and is the "SQL equivalent" for the ArangoDb multi-model database software. At the end of last's stream, ChatGPT (3.5?) just spat out a working draft and today we try to reach parity in understanding AQL.

See you on the tubes!

Devrel fail of the day.

#mongodb disables comments on an otherwise, mostly-ok video on design patterns for document stores.

Community feedback would have been great here. I know most of the information applies to #Arangodb which I use.

https://youtu.be/bxw1AkH2aM4

#devrel #mongo

Got arangoimport loading 1M records from a flat EDI text file (CSV with 40 columns basically), and it finished in 8 seconds. 125k/s is very respectable. #arangodb

Still torturing a local deployment of #Arangodb as part of tech evaluation.

Yesterday got a graph building query syntax wrong, wanted to create just 1:1 edges between to document sets, instead it created N*M edges! Well, the machine ran out of disk and the underlying RocksDB halted. I killed the query and it left behind a graph with 2M edges. Deleting edges freed up all disk space.

Today been playing with full text search engine; you have to create views AOT, but it has all the knobs to tweak.

"We developed a #Lisp-like intermediate representation to be able to transport programs into the existing Pregel implementation in #ArangoDB. These programs are executed using the interpreter inside the AIR Pregel algorithm."

https://www.arangodb.com/docs/stable/graph-analytics-custom-pregel.html

This whole rant was brought to you by two recent experiences:

1) I am currently evaluating #Arangodb and find it delightful so far, but there's a huge discrepancy between it's raw performance when interacting with it directly, vs what I get out of the Java and Golang drivers.

2) I wrote a Spring Data Repository abstraction that is tenant-aware, every call of the Crud and JPA repositories take an extra tenant ID, because it's used in a #SaaS app. But I can't be trust it anymore. Too much magic!