Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add instructions for using MySQL #86

Open
deso2021 opened this issue Nov 11, 2021 · 4 comments
Open

Add instructions for using MySQL #86

deso2021 opened this issue Nov 11, 2021 · 4 comments

Comments

@deso2021
Copy link

data is stored in /db/badgerdb by default?
how to enable store in postgres

@tijno
Copy link
Contributor

tijno commented Nov 11, 2021

i have a postgres run setup here

https://github.com/tijno/bitclout-run

check the progres branch of that repo

@maebeam
Copy link
Contributor

maebeam commented Nov 11, 2021

Use the --postgres-uri flag or POSTGRES_URI environment variable. FYI Postgres is deprecated in favor of MySQL

@maebeam maebeam changed the title how to enable postgres? Add instructions for using MySQL Nov 11, 2021
@deso2021
Copy link
Author

The data in the pg_balances table looks incomplete. After the synchronization is completed, sum is 5786567.577867775,should be 10.8M ?

select sum(balance_nanos)/1000000000 from pg_balances;

@tijno
Copy link
Contributor

tijno commented Nov 25, 2021

@deso2021 there's a remaining issue with negative balances @maebeam is aware off

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants