Have Buckets or Not?

Have Buckets or Not?


  So with accounting on computers, there is a question to have buckets or not when doing the database fields.  A bucket is used for accounting and financial reports such as total sales, etc.  There is usually a different bucket for each time period you need, such as January Total Sales or First Quarter Sales.  Why use buckets at all?  Answer - for speed for doing the daily, monthly, quarterly, and annual reports.

Choices:

    No - Reasons: 1) Just calculate it when the need arises in the future, rather than update the total field as each transaction hits.  2) Risks conflicts of trying to write the new value of the total field simultaneously when lots of concurrent transaction. 3) Calculation errors could happen by overlooking a particular transaction and accounting hates mismatches.

    Yes, Live - 1) Bucket total is up-to-date and current. 2) Faster than gathering the correct transactions and summing them.  

     Yes, But Periodically - Usually do the calculation and update the total field on close of a business day when the transactions are finalized.  How this is done is by having a Business Day table with Id, Business Date (no time), and a bunch of buckets that you want to track.  Then the Transaction table has the transaction information plus Business Date.



     

Comments

Post a Comment

Popular posts from this blog

GHL Email Campaigns

GHL Email Campaigns Options  Option 1)    Tag free - Contacts > Quick Search box > filter data clicking to select > "Add to Automation" button > pick automation.  Option 2)   Automations > Workflows tab > pick workflow > start workflow with trigger component > click on it > pick "Contact Tag" >  "Add Filters" button > on filter add one that is "Tag Added" > pick which  type of tag. What Are The Tags 1) Settings > Tags > list of tags How to Add Tags 1) Bulk - Contacts > Quick Search box > filter data clicking to select > "Add Tag" button > pick tag 2) Single - Add tag when add contact 3) Bulk - ( Only Admin ) - In file to import, put Tags in column - Contacts > Import Contacts button > Contacts > decide columns. Everyone seems to tag the import with date AND tag it cold or hot if they can. 4) 
Read more

JSON Web Tokens

Image
 JSON Web Tokens (JWT)   A JSON Web Token (JWT) is commonly used for authentication and authorization in web applications and APIs. Essentially, JWTs encode info about a user or entity into a JSON object, which is then digitally signed and/or encrypted.  A JWT consists of three parts, separated by dots (.):  1. Header: Contains metadata about the token, such as the signing algorithm (e.g., HMAC SHA256, RSA SHA256) and the token type (JWT).  2. Payload: Contains the claims, which are statements about an entity (e.g., user ID, role, expiration time).   3. Signature: Verify that the JWT sender is who they claim to be and that the message hasn't been tampered with.  How it works:   Authentication: A user logs in, and the server creates a JWT containing user info and other relevant claims.    Token Transmission: The server sends the JWT to the client (e.g., browser).    Subsequent Requests: The client includes the JWT in the au...
Read more

Extras for New .NET Projects

Extras for New .NET Projects https://www.youtube.com/watch?v=QRgtcbxJlo0&ab_channel=MilanJovanovi%C4%87 1) solution editor config By clicking solution > right-click > Add >  New EditorConfig menu option. 2) solution Build file By clicking solution > right-click > Add >  New XML file > then name Directory.Build.props  3) solution Packages file By clicking solution > right-click > Add >  New XML file > then name Directory.Packages.props  then take any Nuget packages and copy to this file in the <ItemGroup> area. Change PackageReference to PackageVersion. 4) add SonarAnalyzer CSharp for code quality 5) add Docker support By clicking project of Web.Api then right-click > Add > Docker Support. 6) add container orchestration support By clicking project of Web.Api then right-click > Add > Container Orchestrator Support. 7) add .NET Aspire container orchestration support By clicking project of Web.Api then...
Read more