Migrate to postgres - Githubissues

block-core / blockcore-indexer

Blockcore Indexer scans the blockchain of Blockcore-derived chains and stores transaction information in a MongoDB database with REST API available for Block Explorers to use.

MIT License

20 stars 21 forks source link

Migrate to postgres #216

Closed theDRB123 closed 1 month ago

theDRB123 commented 1 month ago

Description

The PR aims to implement support for storage in PostgreSQL

Changes

Added EFcore to be used as the ORM
Implemented additional classes in Blockcore.Indexer.Core/Storage/Postgres

Added PostgresStorageOperations & PostgresData
Database types declared in PostgresDBContext
Storage/DatabaseRegistration is changed to inject postgres Dependencies
BlockRewindOperations for postgreSQL

Using PostgreSQL for storage

Install PostgreSQL 16
Create server
In Appsettings ->
- Change the DbType to PostgreSQL
- Add the required connection string for the postgre server