Stack Overflow
Stack Overflow

Questions tagged [edgedb]

EdgeDB is a relational database that stores and describes the data as strongly-typed objects and relationships between them. It is built on top of PostgreSQL, inheriting all its core strengths: ACID compliance, performance, and reliability.

It provides a modern query language EdgeQL - which is efficient, intuitive, and easy to learn and provides more consistent semantic than traditional SQL.

EdgeDB is a battery included DB in a sense that it provides straight forward HTTP and GraphQL APIs besides traditional language bindings. It has a built-in support for migrations and allows full introspection of the schema via queries.

23 questions
10
votes
1 answer

Is 35k rows/s slow or fast for EdgeDB?

I'm testing EdgeDB locally, my host is a decent macbook pro and the database runs in docker: version: "3.7" services: edgedb-server: image: edgedb/edgedb ports: - "5656:5656" - "8888:8888" volumes: - type: bind …
Dima Tisnek
  • 11,241
  • 4
  • 68
  • 120
3
votes
1 answer

How to update a nested object in EdgeDB?

Say I have a schema like this: type Foo { required link bar -> Bar; } type Bar { required property baz -> bool; } How do I, knowing the id of a Foo object, update a property of a Baz object it points to? In other words, how do I update…
monomonedula
  • 606
  • 4
  • 17
3
votes
1 answer

Is it possible to use Postgres extensions like postgis directly in edgdedb?

I'm new to EdgeDB and want to use it in my current project. The issue is I'm using the postgis extension extensively right now. I am aware that supporting gis is on EdgeDB's roadmap, but is there a way to use it directly?
omid
  • 702
  • 1
  • 11
  • 21
2
votes
0 answers

How to set tls certificates via environemnt variables to start edgedb using docker-compose?

I need help in starting an edgedb instance using docker-compose.yml version: "3.3" services: edgedb: image: edgedb/edgedb:2.9 environment: - EDGEDB_SERVER_DATABASE=smartdb - EDGEDB_SERVER_PASSWORD=smartPassword -…
Abbas
  • 3,872
  • 6
  • 36
  • 63
2
votes
0 answers

I got an error connecting my edgedb database on my go server

I was working on an example project with edgedb as my database. I ran into some syntax errors but I sorted and fixed all of it and it ran smoothly for about 5 seconds. After that a panic message popped up. 2023/02/13 22:13:04…
Coding with Cyril
  • 53
  • 4
2
votes
1 answer

How to get results with empty link OR specific link in EdgeQL?

If I have this schema: module default { type Publisher { required property name -> str; } type Book { required property name -> str; link publisher -> Publisher; } } With this data inserted: insert Publisher { name :=…
Richard Gieg
  • 1,276
  • 8
  • 17
2
votes
1 answer

Invalid local name: C.UTF-8 even though the collname exist in pg_collation.collname

As this might have something to do with AWS Lightsail, I've cross posted this question on AWS - Click Here I'm trying to create a template database using CREATE DATABASE __edgedbtpl__ OWNER='edgedb' IS_TEMPLATE = TRUE TEMPLATE='template0'…
clamentjohn
  • 3,417
  • 2
  • 18
  • 42
2
votes
1 answer

Define a unique index in EdgeDB

How do you define a unique index in EdgeDB? For simple properties you can add constraint exclusive which implicitly creates a unique index. required property name -> str { constraint exclusive; } However you can't add constraint exclusive to an…
CodesInChaos
  • 106,488
  • 23
  • 218
  • 262
1
vote
1 answer

How to re-initialize EdgeDB database provider with updated configuration in NestJS?

I'm developing a personal project backed by NestJS and EdgeDB. I'd like to take advantage of their new feature called 'access policies' which requires re-initializing a database client with a config that contains current user's ID. Initially I…
Pa Ye
  • 1,779
  • 12
  • 22
1
vote
0 answers

Conditionnaly insert an optional link property inside a for loop

I am using the edgedb typescript client. Here is my simplified schema: type Ratings { property imdb -> float32; } type Movie { required property year -> int16; single link ratings -> Ratings { constraint exclusive; } …
httpete
  • 5,875
  • 4
  • 32
  • 41
1
vote
0 answers

Edgedb back reference one to many links to limit choices on queries

I have a schema looking like this where I abstracted out the contact information: type Address { required property location -> str{ constraint max_len_value(100); }; } type Phone{ required property number -> int32{ constraint…
ccsv
  • 8,188
  • 12
  • 53
  • 97
1
vote
1 answer

EdgeDB efficiently writing many to one functions using link

I am trying to make a one to many links where a user can put in multiple addresses after their name. For example the data can look like this: name: "Robert Cane" address: location: 555 Fake Street description: Primary address …
ccsv
  • 8,188
  • 12
  • 53
  • 97
1
vote
0 answers

EdgeDB timeout with go client

I’m having what seems to be a timeout issue with the go client. Essentially I have a service running in AWS, an endpoint for a heartbeat (that does not connect to edgedb), and an endpoint to list all of a particular object in the DB (“select Foo {…
bmuk
  • 121
  • 5
1
vote
2 answers

Edgedb link update fail - modification of computed link is prohibited

I'm using edgedb with python. My db scheme is type Student { link class -> Class { on target delete allow; }; }; type Class { required property year -> int32; required property name -> str; } I'm running query like this with…
Alexey Sherchenkov
  • 428
  • 3
  • 6
1
vote
1 answer

Computed property based on presence of non-required properties

We know we can create a computed property based on other properties like so as per the docs, type Person { property first_name -> str; property last_name -> str; property full_name := .first_name ++ ' ' ++ .last_name; } I'd like to create a…
jackfischer
  • 86
  • 2
  • 8
1
2