aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
AgeCommit message (Collapse)Author
2023-01-11-no dropChristian Grothoff
2022-11-27-db tests pass againChristian Grothoff
2022-11-27more work on SQL refactoringChristian Grothoff
2022-11-27more sql refactoringChristian Grothoff
2022-11-27more work on SQL refactoringChristian Grothoff
2022-11-27more sql refactoringChristian Grothoff
2022-11-27intermediate step in major SQL refactoring (not done at all)Christian Grothoff
2022-03-31remove built sql files from vcMarco Boss
2022-03-31add shard init for shard nodeMarco Boss
2022-03-31add sharding logicMarco Boss
2022-03-27-remove tiny field, no longer neededChristian Grothoff
2022-03-27towards removing tiny bitChristian Grothoff
2022-03-26change sharding strategy for refund tableChristian Grothoff
2022-03-26add partitions to new p2p tablesChristian Grothoff
2022-03-24rework deposits sharding, towards making aggregator faster (not necessarily ↵Christian Grothoff
done)
2022-03-24first draft of service API for p2p paymentsChristian Grothoff
2022-03-23more skeleton logic for P2P operations on DBChristian Grothoff
2022-03-23revise P2P signatures and signing schema to address recently discovered ↵Christian Grothoff
design concern resulting in the split of the purse key into purse-contract and purse-merge keys
2022-03-22-fix drop SQL issue: drop functions properlyChristian Grothoff
2022-03-22implement helper functions for p2p signatures, clean up existing signature logicChristian Grothoff
2022-03-20ideas for mbossChristian Grothoff
2022-03-20add p2p tables from dd13Christian Grothoff
2022-03-19more work on recoup_by_reserve: add new materialized index to avoid hitting ↵Christian Grothoff
all partitions for the query
2022-03-19add missing index, move indices closer to table generationChristian Grothoff
2022-03-18add deposits_by_coin table to speed-up certain queries (in theory)Christian Grothoff
2022-03-18add selection by shard, ignore KYC in revocation test aggregationChristian Grothoff
2022-03-18change table structures again to shard better by coin_pub and not use ↵Christian Grothoff
known_coin_id so much
2022-03-17-remove dead field, return h_commitment_age to auditorChristian Grothoff
2022-03-17-misc fixesChristian Grothoff
2022-03-14attempt to make GRID5K_MARCO_OPT superfluousChristian Grothoff
2022-03-05work on global fee structureChristian Grothoff
2022-03-05refactor /wire to include logic to return the wad fee (for W2W payments)Christian Grothoff
2022-03-03use 32 byte hash for hpayto, use that for joins on queries to better align ↵Christian Grothoff
queries with partitions
2022-03-02include partitioning logic in dbinitMarco Boss
2022-03-01stay with partitions for now - find shards on dev/boss/shardingMarco Boss
2022-03-01tested shard creation locallyMarco Boss
2022-03-01prepare sharding / partitioning initMarco Boss
- create exchange-0001.sql with functions to create all tables and partitions / shards - create exchange-0002.sql for the master db
2022-02-28-work on test_sync.sh, incompleteChristian Grothoff
2022-02-28cleaner sqlMarco Boss
2022-02-28get test-auditor and #7181 to passChristian Grothoff
2022-02-27towards adding shard/partitioning init functionalityMarco Boss
2022-02-26add index on wire_targetsMarco Boss
- better performance on local db - many queries use wire_target_serial_id as join condition -> discussion use this as shard key?
2022-02-24Fix ON CONFLICT statements for distributed tablesMarco Boss
2022-02-24-on conflict exampleChristian Grothoff
2022-02-24-fix aggregator with deferred constraintChristian Grothoff
2022-02-24-unique constraint is crucialChristian Grothoff
2022-02-22[age restriction] progress 16/n - refresh/reveal/link testsÖzgür Kesim
Age restriction works now with withdraw, melt/refresh/reveal and link, including tests. However, there is still a problem with the tests: The melting operation "refresh-melt-failing-age" that should fail (because of conflict), but currently fails for other reasons. I decided to disable that particular test (and the next) and submit the patch I have so far.
2022-02-17-migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS IDENTITY ↵Christian Grothoff
instead of BIGSERIAL
2022-02-17-use age_maskChristian Grothoff
2022-02-17-fix CS nonce reuse check logicChristian Grothoff