Questions tagged [cardano-db-sync]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
15 views

How can db-sync "match" a data_hash to specific outputs?

Looking at the db-sync schema, I see the tx_out table has a data_hash column, but I can't make sense of why this column is not on the tx table instead. From the Alonzo CDDL, I can see the scripts are ...
user avatar
1 vote
1 answer
12 views

How can I see if an UTxO holds an NFT in the postgres DB?

Is it possible to find out if an UTxO on the tx_out postgres table holds an NFT? OR in generell which kind of asset this UTxO holds? Thank you!
user avatar
-1 votes
0 answers
23 views

Problem with db-sync

I have a quick question, I had a situation occur today when experimenting with options for getting all utxos from an address. Using the CLI directly it returned 20 utxos, but when I queried using db-...
user avatar
0 votes
0 answers
17 views

Anyone interested in reviewing / testing new Cardano data intelligence platform?

I recently completed & deployed the BETA release for a data intelligence application built specifically for the Cardano Blockchain. Would anyone be interested in helping review / test? If yes, ...
user avatar
0 votes
1 answer
32 views

GraphQL syncing takes too much time

Hello everyone I did follow this guide to run GraphQL with docker-compose: https://github.com/input-output-hk/cardano-graphql However, inputoutput/cardano-db-sync:12.0.0 is syncing super slow ...
user avatar
1 vote
2 answers
18 views

How to Run A DB Sync Server On Daedalus?

So I have been trying to do some fun things with Daedalus, and realised I should be able to query the node from it. This makes me wonder how to set up a limited database / querying system for my own ...
user avatar
0 votes
1 answer
22 views

Can the price of a Dex pair be tracked using the data in cexplorer / db-sync?

Is there a way to query the price of a pair that's on a dex independent of the dex? For example: MIN/ADA or others? I am trying to see how the data in the cexplorer database could be used to do this.
user avatar
1 vote
1 answer
14 views

How to convert some of the db-sync data types/columns to C# data types?

Specifically, I am using the Npgsql lib in a C# console app, and am reading data just fine so far for the obvious types like bigint, uinteger, boolean, etc. - but for a few different types/columns in ...
user avatar
0 votes
1 answer
15 views

What is the total size of cexplorer on Postgres?

I have a relay node fully synced with the tip of the mainnet chain and DB-sync filling the Postgres database. DB-sync is currently syncing on epoch 321 and the database takes 103 GB of disk space. I ...
user avatar
  • 35
0 votes
0 answers
28 views

How can I Convert BlockFrost API Code to Dandelion API?

I have somehow managed to get a lot of code for BlockFrost API, however, I want to build some free applications for people to monitor blockchain data from a website dashboard. To take advantage of the ...
user avatar
0 votes
1 answer
28 views

Is the Transaction Hash from block frost the same as the transaction id?

When making an API (HTTP) Get request to the blockfrost API service, you can specify an address and get the transactions at the address (https://docs.blockfrost.io/#tag/Cardano-Addresses/paths/~...
user avatar
1 vote
0 answers
24 views

How to Count plutus transactions?

i'm connected to the cardano-db-sync, someone knows how to count the ammout of transactions that use plutus script? i'm using two methods here select block.epoch_no, count(distinct tx.id) as ...
user avatar
3 votes
1 answer
35 views

How to calculate Sundaeswap TVL using DB-sync?

I'm trying to do an exercise where I see if I can calculate Sundaeswap TVL using DB-Sync. Below is what I have managed to pull out from the database so far regarding Sundaeswap. However for the UTXOs ...
user avatar
  • 223
0 votes
2 answers
25 views

Best ways to create UTxO snapshots at epoch boundary

I would like to create snapshots of the set of UTxOs at the end of each epoch for a particular address. What would be best ways to do something like that? Constraints/ Ideas The current tools I am ...
user avatar
0 votes
1 answer
19 views

How to query for active pool stake for an epoch from cardano-db-sync

I’m attempting to get the active stake value from cardano-db-sync for a pool at a specific epoch so I know how much stake it had for the next snapshot. I’m currently using the following query SELECT ...
user avatar
2 votes
2 answers
43 views

Understanding this transaction - why isn't it spending the full amount?

I'm doing some analysis on Db-sync and I came across a situation where it appeared the full EUTXO at an address was not being spent so wanted to see what I was misunderstanding. Here is the first ...
user avatar
  • 223
1 vote
1 answer
34 views

What is the numerator (supply) when calculating the pool saturation level?

The pool saturation level is calculated by dividing supply by the K parameter. What exactly constitutes supply in this equation? We have the following pots of Ada (from the db-sync ada_pots tables): ...
user avatar
  • 83
1 vote
1 answer
46 views

Mainnet genesis block output off by 1,000,000 Lovelace + what is the test Ada from mainnet genesis?

I have been studying utxos on the mainnet and have run into some interesting inconsistencies. If you run this query against cardano-db-sync's cexplorer database: select sum(value) from block inner ...
user avatar
  • 83
1 vote
4 answers
82 views

DB Sync deleting blocks up to slot operation running for 10+ hours

I recently created a new server and install of Cardano node and db sync (1.34.1 & 12.0.2) on same machine. I implemented the snapshot restore to bring the Postgres DB up to EPOCH 325 and was able ...
user avatar
0 votes
1 answer
50 views

cardano db-sync won't authenticate to postgres?

Trying to get db sync to do the initial database setup. I have this running on another ubuntu 20 box, and I trying to recreate it from scratch with all of the same versions and this time I am getting ...
user avatar
  • 253
0 votes
0 answers
9 views

When to divide Multi asset Qty by 1m and when not?

I'm working with querying Cardano onchain data using DbSync and finding that a multi asset quantity of say 10,000,000,000 Sundae tokens equates to 10,000 Sundae tokens as seen on the blockchain ...
user avatar
  • 223
0 votes
2 answers
24 views

Uninstalling Nix after Node, Db-sync & Postgres Installation

I have installed via Nix a cardano node, DB-sync and Postgres on a single server. My plan is to pass my Postgres data into an Apache Kafka cluster. My node is synced to tip and DB-sync is on epoch ...
user avatar
  • 35
2 votes
2 answers
110 views

Disk Space of Cardano node & Cardano DB-sync

I recently installed the Cardano node and Db-sync and Postgres using nix. I use a server with 97 GB of space, node version 1.34.1 and DB-sync version 12.0. The node took about 70 GB after fully synced ...
user avatar
  • 35
0 votes
1 answer
37 views

Is it me or is the tx_in table completely unnecessary in dbSync?

If I've understood the dbsync schema properly then the tx_in table is completely unnecessary. The two fields (tx_in_id & redeemer_id) should just be brought into the tx_out table and left null ...
user avatar
  • 223
0 votes
3 answers
124 views

setting postgresql for db-sync

I have followed the instructions bo build both the cardano-node and cardano-db-sync in the same folder. I managed to fully sync the node, which is running when attempting to use dbsync. When I try to ...
user avatar
  • 151
0 votes
1 answer
68 views

Cardano DB Sync - RTS Options

After successfully with previous question, where I tried to make cardano-node and cardano-db-sync run as a services, I tried to play around with +RTS ... -RTS option on cardano-db-sync, specifically ...
user avatar
  • 45
1 vote
1 answer
40 views

Missing datums in db-sync

From time to time I encounter transactions which contain UTXOs associated to script addresses with datum hashes for which no corresponding entries are available in the datum table of a fully-synched ...
user avatar
  • 113
1 vote
1 answer
77 views

I hear that Daedalus Is a Full Node Does That Mean I Can Set Up a DB Sync Server On Top of It?

The Daedalus wallet is said to be a full node wallet. Does that mean I can set up something similar to blockfrost on top of it? If so how?
user avatar
3 votes
1 answer
125 views

Cardano DB Sync as Service (running on background) on Ubuntu

Linux/Ubuntu - Cardano newbie, want to ask things around! :) At the moment, I'm successfully installed cardano-node and can make it run as a service (pulling data automatically on the background), by ...
user avatar
  • 45
1 vote
0 answers
26 views

Stream/Query transaction price history of an asset

Is it possible to get the transaction incl. price history of an asset e.g. (SundaeSwap) using blockfrost or cardano-db-sync? If yes, is it also possible to stream this value from block to block?
user avatar
  • 433
0 votes
2 answers
72 views

how to convert an "asset32type" to string?

i want to convert an "asset32type" to a string, reason being the datatype in the "name" column of dbsync's multi_asset table is "asset32type". what is an "...
user avatar
  • 55
0 votes
0 answers
23 views

Can I manually install cardano-graphql using local data?

I'm running a relay node and have dbsync pushing data into postgresql. To build the graphql data, do I have to use the weekly restore snapshot as described in the github page for cardano-graphql or ...
user avatar
0 votes
2 answers
52 views

How to Remove Burned NFTs from SQL Output

I am querying the Cardano Postgres DB and can't figure out how to remove NFTs (multi-assets) that have been burned. In the SQL query below, I am selecting the mint transactions for an asset ...
user avatar
  • 1
0 votes
2 answers
93 views

cardano-db-sync error

When following the instruction here https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/building-running.md I get an error at the last line PGPASSFILE=config/pgpass-mainnet db-sync-node/...
user avatar
  • 253
0 votes
0 answers
27 views

cardano-db-sync table link diagram?

Is a diagram showing cardano-db-sync table links available? i'm aware of the schema.md file, was after something more visual.
user avatar
  • 55
1 vote
3 answers
57 views

About slot battles and db sync

I wanted a way to check if a pool is having some sort of slot dispute with somebody else's pool for the right to mine a block. I couldn't find a solution for that, maybe using dbsync I don't know ...
user avatar
1 vote
1 answer
26 views

Query next epoch from postgresql

How can I get the next Epoch.No using Postgresql. If I use 'SELECT no FROM epoch ORDER BY no desc limit 1' , it returned last epoch/currentEpoch, if I want to receive the next Epoch.No, what should ...
user avatar
  • 11
1 vote
1 answer
139 views

Stake pool blockchain sync is incredibly slow

Has anyone synced a node lately? It has been 3 days and I've only reached 75% of the tip. This is much slower than a few months ago. I'm currently only connected to the IOHK North America relay with a ...
user avatar
0 votes
1 answer
72 views

cardano db sync stuck at epoch 299

I have been stuck at epoch 299 for a long time now, it randomly stops around hash e15.. or sometimes gets lucky and stop at around e1f... I have 16g ram, 16g swap, i7 octa core, ubuntu 20.04.2 lts my ...
user avatar
0 votes
0 answers
113 views

version `GLIBC_2.33' not found

trying to install nix (on a clean fedora 35 server), getting this error, help! /nix/store/sbbifs2ykc05inws26203h0xwcadnf0l-glibc-2.32-46/lib/libc.so.6: version `GLIBC_2.33' not found (required by /usr/...
user avatar
  • 55
3 votes
2 answers
260 views

Cardano Node + DB Sync + Graph QL vs. Blockfrost API

I've been contemplating the value of essentially running all your own infrastructure by deploying Cardano node, along side DB Sync and exposing it through Cardano GraphQL. I like the idea of building ...
user avatar
0 votes
1 answer
157 views

How to search for an NFT asset name?

Let's say, I have created an asset with name 'xyz' and I want to search for all the nfts with this asset name on the chain. How and where do I do that ?
user avatar
2 votes
1 answer
338 views

Extracting metadata info of cardano tokens

I am currently working with cardano-db-sync and I am doing research to extract the metadata of all the native tokens. I found out the policy id and asset name can be extracted from cardano-db-sync but ...
user avatar
2 votes
2 answers
173 views

Sync DB mainnet stuck

I used the great guidance on https://developers.cardano.org/docs/get-started/running-cardano to step by step sync with the Cardano mainnet. Everything went fine and i was almost done untill 2 weekish ...
user avatar
  • 21
3 votes
1 answer
94 views

Why my cardano-node is now running a strange loop after an upgrade to a higher version?

Lately, after a node upgrade to a higher version (1.30.1), my Block-Producing (BP) node will "stay" in the "start" phase for about 45 minutes making a strange loop by switching to ...
user avatar
2 votes
1 answer
168 views

Listing all cardano tokens using cardano db sync

I am currently starting out with cardano db sync and wanted to ask if it is possible to obtain all native and nft tokens and their metadata using cardano db sync? could someone guide me? I can't seem ...
user avatar
3 votes
3 answers
101 views

Cardano db sync sender and receiver address confusion

I am needing help with this. i queried the rows whose tx_id = 133903 from tx_out table from postgres. select * from tx_out where tx_id = 133903; and i got two rows having two different index 0 and 1. ...
user avatar
2 votes
1 answer
211 views

Mainnet – How to fix a frozen DB syncing?

I've been trying to sync with the Cardano blockchain in order to use CLI wallet on macOS Big Sur 11.6. But syncing is frozen at epoch 289 on block 6,236,059. cardano-cli query tip --mainnet { &...
user avatar
  • 1,617
2 votes
1 answer
143 views

Query all the transaction details from a given block using cardano db sync

Can someone help out with how can i query the transaction details from a block using cardano db sync table? I actually need fields like epoch no, date of transaction, stake address, pool and the ...
user avatar
  • 111
0 votes
0 answers
21 views

cardano-cli query return epoch = null

When I run cardano-cli query tip --testnet-magic 1097911063 I recieve: { "epoch": null, "hash": "b89d3cdc3ca3e16b6a065668b878116b297a788bfce29f904d4840cf2b69fd34", "...
user avatar
  • 101