Questions tagged [memgraphdb]

Use this tag for questions related to Memgraph streaming graph database.

Memgraph is an open source graph database built for real time streaming data, compatible with Neo4j. It is an in-memory graph database that uses Cypher as a query language. Memgraph can be extended with graph algorithms that are part of Memgraph Advanced Graph Extensions (MAGE). Graphs can be visualized using Memgraph Lab application.

390 questions
1
vote
1 answer

Is it possible to store big integers in Memgraph?

I want to store pretty big integers (30 digits). I can’t store it in Memgraph integers which are 64 bit integers, or in floats without losing precision. Is there a way that I can use to store large integer numbers in Memgraph?
ShymPi1999
  • 51
  • 3
1
vote
1 answer

How can I limit the Memgraph memory limit when I use Docker?

I know that I can limit the whole Docker memory usage by changing some WSL2 settings. I've read about that in https://itnext.io/wsl2-tips-limit-cpu-memory-when-using-docker-c022535faf6f and I've seen a question about this already on Stackoverflow…
ShymPi1999
  • 51
  • 3
1
vote
1 answer

How can I see which nodes are duplicates?

I'm trying to create a constraint with this Cypher query: CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE; But I get the error: Query failed: Unable to create unique constraint :Person(name), because an existing node violates it. How can…
ShymPi1999
  • 51
  • 3
1
vote
1 answer

How to do find weakly connected components using Cypher?

I'm trying to "translate" this Cypher query that uses NetworkX into pure Cypher. Can this even be achieved? MATCH (n)-[e]->() WITH collect(n) AS nodes, collect(e) AS edges CALL wcc.get_components(nodes, edges) YIELD * RETURN n_components,…
MasaZo
  • 43
  • 5
1
vote
1 answer

Can I expand all nodes in Memgraph lab?

My query returns quite large number of nodes, but I'd like to expand them anyway. Is there Expand all command in Memgraph Lab? I can't find one.
Taja Jan
  • 942
  • 1
  • 1
  • 11
1
vote
1 answer

Replica in SYNC WITH TIMEOUT returns 0 for TIMEOUT

I have Memgraph 2.2.0 (Docker using memgraph-platform image) running on Windows based computer. When registering a REPLICA instance with the SYNC WITH TIMEOUT mode, then showing REPLICA instances' details, the TIMEOUT for that instance is 0. Here is…
MasaZo
  • 43
  • 5
1
vote
1 answer

Variable expand by default is using DFS, wouldn't it be better if a user code explicitly specify?

Inside Memgraph, variable expand by default is using DFS, wouldn't it be better if a user code explicitly specify what's the expansions policy? I've found the following example MATCH (x {id: 587})-[edge_list:Type *dfs..10]-(y {id: 963}) RETURN *; in…
MasaZo
  • 43
  • 5
1
vote
1 answer

How can I free memory in the running Memgraph instance?

I know that by setting the --memory-limit flag in the Memgraph configuration file (/etc/memgraph/memgraph.conf) I can set the maximum amount of memory that a Memgraph instance can allocate during its runtime. I've limited the amount to a pretty low…
Juliette Gia
  • 126
  • 6
1
vote
1 answer

What's the default expansion policy in the variable expand case?

What's the default expansion policy in the variable expand case when using Memgraph? When I have a query MATCH (x {id: 587})-[edge_list:Type *dfs..10]-(y {id: 963}) RETURN *; I'm using DFS algorithm. I explicitly tell to use DFS. Which algorithm is…
EWoodAv
  • 15
  • 4
1
vote
1 answer

How can I see the exact Docker image that I'm using?

I have a fresh install of Docker on Windows 11. I've updated WSL2. In PowerShell I've run the command to install Memgraph Platform: Windows PowerShell Copyright (C) Microsoft Corporation. All rights reserved. Install the latest PowerShell for new…
KWriter
  • 1,024
  • 4
  • 22
1
vote
1 answer

How to obtain database info and statistics using mgconsole?

When I use Memgraph Lab I can see the database statistics at the top of the window. How can I obtain info such as Memgrph version, number of nodes, relationships, etc. when I'm using mgconsole?
Taja Jan
  • 942
  • 1
  • 1
  • 11
1
vote
1 answer

How to read Memgraph process environment variables from a query module?

I'm developing a query module. I need to use some environment variables. I want to configure the module without hardcoding values inside the module. What can I do? I'd like to avoid reading values from external text files. Is there a way to access…
Juliette Gia
  • 126
  • 6
1
vote
1 answer

Are composite indexes supported in Memgraph?

Can I create index on more than one property for any given label? I am running query like: MATCH (n:Node) WHERE n.id = xyz AND n.source = abc; and I want to know whether I can create multiple property indexes and if not, is there a good way to…
KateLatte
  • 611
  • 1
  • 12
1
vote
1 answer

How to import CSV file (LOAD CSV) from a remote location?

I have my CSV data stored on a server that can be accessed via the internet. There is no authorization needed for access to that file. At the moment, I use scp and some crone jobs to copy that file to my Memgrpah server. Then I import data using…
KWriter
  • 1,024
  • 4
  • 22
1
vote
1 answer

Are subqueries supported in Memgraph?

I am using Memgraph Platform 2.6.4 and I want to call a subquery within a query. For example: UNWIND [0, 1, 2] AS n CALL { RETURN 'hi' AS returnValue } RETURN returnValue I couldn't find anything like that in Memgraph documentation, but saw it in…
KateLatte
  • 611
  • 1
  • 12