DEV Community

Cover image for Ingest Regulars NFT events into your App!
Sort
Sort

Posted on • Edited on

1 1

Ingest Regulars NFT events into your App!

If you're like us, you've been extremely excited about the launch of Regulars Jobs. Regulars are exciting for a few reasons. First, the art is different than anything else out there (see for yourself). Second, jobs!!! Regulars can work, get on-chain names from NFT owners, and earn $REG tokens from their jobs. Could this be the beginning of a de-centralized sims? It will be interesting to watch the ecosystem around Regulars continue to grow.

Image description

On-chain names

Regulars can get on-chain names, let's create a Sort query to see what users are naming their Regulars!

select
  params[2].value as name,
  params[1].value as token_id,
  transaction_hash,
  timestamp,
from
  ethereum.transaction_log l
where
  function_address = '0x1ffe4026573cead0f49355b9d1b276a78f79924f'
  and name = 'NameChange'
order by
  timestamp desc
limit
  1000
Enter fullscreen mode Exit fullscreen mode

View query results here

Latest Regulars Jobs Minted

select
  params[1].value as regular_id,
  params[2].value as new_job_id,
  params[3].value as company_id,
  params[4].value as sender,
  transaction_hash,
  timestamp,
from
  ethereum.transaction_log l
where
  function_address = '0x7e300bb12e416a9242e17ec44bbd9ae4e97f3f54'
  and name = 'jobIDCreated'
order by
  timestamp desc
limit
  10000
Enter fullscreen mode Exit fullscreen mode

View query results here

Hopefully these queries are enough to get started ingesting Regulars data into your app!

Feel free to ask any questions (or for query help) on our Discord.

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read more →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay