SQLite

Introduction While embarking on building any new server application, one of the key requirement is whether it needs durable, persistent storage of data (and in most cases, it does). This is followed by evaluating suitable data store. Likely evaluation criteria is Application’s Requirement (Tolerance for eventual consistency, High Availability etc.), Team’s familiarity, Costs, Tech. support availability and so on. In case of choices in relational databases, typical go to options are MySQL, PostgreSQL or even proprietary databases like Oracle , SQL Server. Seldom one considers SQLite for this purpose. ...

Background I recently came across bounty by Balaji Srinivasan to send Direct Message to all twitter followers. Currently, i do not intend to participate in bounty and this is mere exercise. This is an attempt to write CLI tool in Golang in response to it. For detailed requirements, refer here Approach In Brief, CLI should, accept arguments like Twitter API Key,Auth token, DM Message Download all followers (with profile details) Rank them by Criteria (e.g. Location) Send each follower a DM with provided message (upto daily DM Limit) be easy to use and maintain Notes, Due to Daily DM Limit, Follower details will have to be persisted alongside flag indicating if DM has been sent. SQLIte is used from simplicity perspective. There should be a scheduled job that will send the DM upto daily DM Limit. At the same time, it needs to refetch any new followers and push them in the flow (reconcile). Potentially, this could be extended to other social media providers other than twitter. Milestones, Create code structure Plan is to have separation between CLI & have twitter as go package Accept Arguments and Connect to Twitter Study and complete follower retrieval Ranking of followers Persisting followers Sending DM upto Daily limit Rules, Use golang’s in-built packages as much as possible Every milestone to have associated Unit test cases ...