cardano-db-sync VS blockfrost-js

Do check out cardano-db-sync which has a docker-compose file that utilizes cardano-node.

Where are the instructions for building cardano-db-sync? https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/building-running.md

There are a bunch of examples in the cardano-db-sync repository link to interesting-queries.md

Continuously sync chain to PostgreSQL using official script * https://github.com/input-output-hk/cardano-db-sync.

Your best choice is running a cardano-db-sync and make queries to the postgres database: https://github.com/input-output-hk/cardano-db-sync/

So what did I do so far: I followed this instruction(https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/docker.md) and had a cardano-node, a cardano-db-sync and a postgres isntance running on docker. I was able to successfully connect to the postgres database. However, I was not able to find recent transactions even thought the blockchain was up to date. When I took a close look onto the docker console I saw that the cardano-db-sync_1 process continuously exited with code 126.

https://pool.pm/whales is useful for when whales change their delegation, but what you probably need is cardano-db-sync which basically follows the chain and dumps information into PostgreSQL.

That way you use your own node to conduct the transactions rather than using a service like blockfrost

Nothing against blockfrost.io just wanna know if this is possible/easy

Im trying to get the list of NFTs in a specific wallet, Im using Koios but planning to switch to blockfrost.io but couldn't identify the particular API, any help?

If you don't want to run a Cardano node then you can use Blockfrost

🔹 blockfrost.io announced the availability of two new testnet networks: Preview and Preprod.

Since the start of June, we have been successfully running an early build of the new node (which includes diffusion pipelining and the new Plutus v2 CIPs among other enhancements) as a semi-public Vasil developer testnet (Devnet). We now have some 35 developers from across 27 projects testing their DApps and helping identify any issues, along with 16 stake pool operators (SPOs) supporting. We’re also working closely with some of the leading tool/API providers, including Blockfrost, Cardano Serialization library (EMURGO), and Cardano Multiplatform Library (dcSpark). We want to call out the work of Mlabs and Dquadrant in particular for providing great support throughout the process. This developer testnet stage puts us in a good position when it comes to Plutus code compatibility and functionality. This valuable work will continue on this development testnet over the next few weeks.

Five Binaries is a Prague, Czech Republic based consulting company who have been 100% focused on improving the Cardano ecosystem since day one. The members are all ex-Trezor Suite core developers and previously maintained the backend infrastructure for Trezor Wallet. The team created the first stake pool on the ITN and second on Mainnet,StakeNuts. They also processed the first Shelley Mainnet transaction. The Five Binaries team are also behind the first oracle solution on Cardano, Nut.link, and developed Blockfrost, APIs which are used to access the Cardano blockchain. Regarding usage and adoption, Blockfrost APIs is a core service used by the ecosystem and has a community of over 10,000 developers that have contributed to over 4,000 projects.

You can however call an SC using Blockfrost; this is an Web2-style API designed specifically to interacting with the Cardano network.