what I currently have is an array and 2 mappings. mapping 1 is address => struct, mapping 2 is "isActive", array stores all the domains created

so my "deleting" is just deactivating a certain domain

show code

brief expl of the code: its a simplified version of ENS

i need to see the code if you want help

sure, one second

https://github.com/JoaoSantosDev99/Foundry-Boilerplate/tree/master/src

so my deleting is basically just turning a boolean of, but the value stays in the array

Ideally I could rely on events and just have and array save on a database off-chain

That's much worse

I know right

its a name system, those are subnames, deleting is basically just sending back to owner

which is terrible, ideally would just a mapping from address to struct and save the data off-chain on a DB

What I want to achieve is: given a registrar, how many subdomains are in it, basicallt

and use graphql

Graph is free?

thegraph?

The graph you mean?

thegraph uses graphql

I know, but I never used grapgql, I was hopping the graph would help me integrate faster, since they have a bunch of stuff running already under the hood

I guess its the way to go, just emit events on create and delete and have mappings

Yeah

you need to know graphql to use thegraph query

but it is quite easy

yes and no
can't remember the details atm

The graph on has full support on ETH tho, I need for a layer 2

It requires the graph token if I remember that correctly

https://thegraph.com/docs/en/network/benefits/

$0.0002

So not free

Thats robbery

Indeed lol

You can run your own indexer for any blockchain, setup is not "easy" but you will got it without pay anything

I got one running on a layer 2 that is not supported by the graph hosted service

That's the norm, if you run your own instance then it's free