Best Database for Tracking Hobbies

Reddit Comments Overview

Privacy and Data Security Concerns

• Information about the inBloom database raised privacy concerns, especially regarding children's information like social security numbers.
• Comments highlighted the issue of students' data being used by corporations without proper regulations and raised concerns about potential privacy breaches.
• Some users expressed disappointment in Bill Gates' involvement in the project, questioning the impact on privacy and security.

Databases for Tracking Hobbies

Relational Databases

• SQLite was suggested for storing user preferences and basic information.
• Postgres on AWS RDS was recommended for real-life production databases.
• Supabase and Realm were mentioned as suitable options, considering the free tiers for small-scale use.
• Users also mentioned using MySQL for tracking hobbies in Excel.

Time Series Databases

• InfluxDB or ClickHouse were recommended for time-series databases due to scalability and ease of maintenance.
• AWS Timestream was noted to have performance issues in processing data.
• DynamoDB could also be used, especially for storing current views and long-term logs.

Other Database Recommendations

• Firebase and Realm were suggested for smaller-scale hobby tracking applications.
• Mongodb was proposed for non-relational databases and spatial queries.
• BigQuery, ELK Stack, and tools like Tile38 were mentioned as suitable options for large-scale telemetry data.

Managing Database Structure and Documentation

• Various methods of structuring database documentation were discussed, including using Excel, custom software, and information schema views.
• Users mentioned creating diagrammatic representations, utilizing macros for hyperlinking, and keeping critical documents mirrored for reference.
• Recommendations included using data cataloging tools like Microsoft Purview and third-party services for metadata cataloging.

Personal Hobbies Tracking Tools

• Users shared tools like Brew Tracker, Mead Mate, Brewfather app, and OneNote for tracking brewing recipes and projects.
• Some users preferred using spreadsheets, notebooks, or custom software for their hobby tracking needs.

Specific User Recommendations

• Users offered assistance in porting software to Mac, translating to Spanish, and providing feedback on free inventory and tracking software.
• Suggestions were made for developing software for specific platforms like Mac and focusing on community-oriented projects.

Conclusion

Based on the Reddit comments, SQLite is suitable for basic user preferences, while Postgres on AWS RDS is recommended for real-life production databases. For time series data, options like InfluxDB or ClickHouse are preferred for scalability. Users also mentioned tools like Firebase, Mongodb, and BigQuery for hobby tracking and large-scale telemetry data. It was emphasized to document database structure effectively using tools like Excel, custom software, and data cataloging solutions. Overall, the Reddit community provided a range of database options and strategies for tracking hobbies efficiently and securely.