pocketnetteam / pocketnet.core

Decentralized social network based on the blockchain
https://pocketnet.app
Apache License 2.0
114 stars 28 forks source link

`First` field in main.Transactions table sqlite db #367

Closed andyoknen closed 1 year ago

andyoknen commented 2 years ago

Adding a "First" label to an object initialization transaction (account, content, or action) can help with complex selections.

For example, for accounts, the "first" entry will help you quickly get the registration date and the presence of a referral.

It is reasonable to add the index "Id"."First" together with the field.

lostystyg commented 1 year ago

Implemented via https://github.com/pocketnetteam/pocketnet.core/pull/360/commits/6e65ba67923eabe38965bdbdf1d8c5e6352603c8 and merged in #360 for 0.21 branch. Implemented for feature/db_optimizations branch here