Latest ENS Registrations

Fetch the latest registrations and their associated Domains. See Connect for setup.

SQL

What is an `ensindexer_0`?

It is the name of an ENSDb Writer Schema, which is a database schema within an ENSDb instance, used to store indexed ENS data from a given ENSDb Writer instance. We use ensindexer_0 as the ENSDb Writer Schema Name in examples on this page, but your ENSDb Writer instance may be configured to use a different schema name. Make sure to replace ensindexer_0 with the actual schema name used by your ENSDb Writer instance when querying the ENSDb instance directly. For example, ENSIndexer allows configuring its own ENSDb Writer Schema Name with the ENSINDEXER_SCHEMA_NAME environment variable.

SQL

SELECT
  d.canonical_name,
  r.start,
  r.expiry,
  r.grace_period,
  r.type as registration_type,
  d.owner_id,
  d.id as domain_id
FROM "ensindexer_0".registrations r
JOIN "ensindexer_0".latest_registration_index lri
  ON r.domain_id = lri.domain_id
  AND r.registration_index = lri.registration_index
JOIN "ensindexer_0".domains d ON r.domain_id = d.id
WHERE r.start <= EXTRACT(EPOCH FROM NOW())
  AND d.canonical = true
  AND r.type <> 'NameWrapper'
ORDER BY r.start DESC
LIMIT 5;

Output

#	canonical_name	start	expiry	grace_period	registration_type	owner_id	domain_id
1	karsten.base.eth	1762698085	1794234086	7776000	BaseRegistrar	0x2426bd7d89230ce5cd4015c47811445b8a6c8f0b	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0xa0cf65983e0b8f2363aaac795c5844c44131ce0b94568e57fcb5e2e5115a87e3
2	urolinkfu.base.eth	1762698015	1794234016	7776000	BaseRegistrar	0x66c52ecef41ee67119cfbcaf88d2097ec1eec5f0	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x1be1354816d460696b36c96b2fa75e3f1fbed97e95720603553d513724d1e233
3	quantumrepeater.eth	1762697939	1794233939	7776000	BaseRegistrar	0x53e1c07bf0282e84fd5b600b2b1f90e8bc14d4f1	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xd06fb94af8abfbe4cfe0a6f5fed589ce5bae7a28bd0347241d0903b3d9893233
4	spirich.base.eth	1762697929	1794233930	7776000	BaseRegistrar	0xe46bc24cd3c5f2f73e8604b994d18675c64e0019	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x94f8855a549a1ba319531b8acb1d0130b6ec095bf27e0de3b84e05207a2b154e
5	hexiuling3.base.eth	1762697917	1794255517	7776000	BaseRegistrar	0x4b2945016ef05155863723cf07740b2d25d5db19	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x0944dfcb1ef210d64d6ac38637c57012fa356831d58d31a6ecc9d18484668cd7

Output matches a point in time snapshot of ENSDb result from our Alpha Sepolia Hosted ENSNode instance. Live output depends on the configuration of your ENSNode instance and also changes that may have happened in ENS since this point in time snapshot example response was captured.

ensdb-sdk (TypeScript)

Connect with ensdb-sdk

See how to connect to ENSDb and get access to the ensDb query builder and ensIndexerSchema schema definition in the Connect example if you haven't already.

TypeScript

import { and, desc, eq, ne, lte, sql } from "drizzle-orm";

const limit = 5;

const recentRegistrations = await ensDb
  .select({
    canonicalName: ensIndexerSchema.domain.canonicalName,
    start: ensIndexerSchema.registration.start,
    expiry: ensIndexerSchema.registration.expiry,
    gracePeriod: ensIndexerSchema.registration.gracePeriod,
    registrationType: ensIndexerSchema.registration.type,
    ownerId: ensIndexerSchema.domain.ownerId,
    domainId: ensIndexerSchema.domain.id,
  })
  .from(ensIndexerSchema.registration)
  .innerJoin(
    ensIndexerSchema.latestRegistrationIndex,
    and(
      eq(
        ensIndexerSchema.registration.domainId,
        ensIndexerSchema.latestRegistrationIndex.domainId,
      ),
      eq(
        ensIndexerSchema.registration.registrationIndex,
        ensIndexerSchema.latestRegistrationIndex.registrationIndex,
      ),
    ),
  )
  .innerJoin(
    ensIndexerSchema.domain,
    eq(ensIndexerSchema.registration.domainId, ensIndexerSchema.domain.id),
  )
  .where(
    and(
      lte(ensIndexerSchema.registration.start, sql`EXTRACT(EPOCH FROM NOW())`),
      eq(ensIndexerSchema.domain.canonical, true),
      ne(ensIndexerSchema.registration.type, "NameWrapper"),
    ),
  )
  .orderBy(desc(ensIndexerSchema.registration.start))
  .limit(limit);

console.log(recentRegistrations);

Output

#	canonicalName	start	expiry	gracePeriod	registrationType	ownerId	domainId
1	karsten.base.eth	1762698085	1794234086	7776000	BaseRegistrar	0x2426bd7d89230ce5cd4015c47811445b8a6c8f0b	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0xa0cf65983e0b8f2363aaac795c5844c44131ce0b94568e57fcb5e2e5115a87e3
2	urolinkfu.base.eth	1762698015	1794234016	7776000	BaseRegistrar	0x66c52ecef41ee67119cfbcaf88d2097ec1eec5f0	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x1be1354816d460696b36c96b2fa75e3f1fbed97e95720603553d513724d1e233
3	quantumrepeater.eth	1762697939	1794233939	7776000	BaseRegistrar	0x53e1c07bf0282e84fd5b600b2b1f90e8bc14d4f1	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xd06fb94af8abfbe4cfe0a6f5fed589ce5bae7a28bd0347241d0903b3d9893233
4	spirich.base.eth	1762697929	1794233930	7776000	BaseRegistrar	0xe46bc24cd3c5f2f73e8604b994d18675c64e0019	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x94f8855a549a1ba319531b8acb1d0130b6ec095bf27e0de3b84e05207a2b154e
5	hexiuling3.base.eth	1762697917	1794255517	7776000	BaseRegistrar	0x4b2945016ef05155863723cf07740b2d25d5db19	8453-0xb94704422c2a1e396835a571837aa5ae53285a95-0x0944dfcb1ef210d64d6ac38637c57012fa356831d58d31a6ecc9d18484668cd7

Output matches a point in time snapshot of ENSDb result from our Alpha Sepolia Hosted ENSNode instance. Live output depends on the configuration of your ENSNode instance and also changes that may have happened in ENS since this point in time snapshot example response was captured.