Tools & Resources
I use a range of tools and resources as part of my day job and running Database Star. Here’s a list of what I use.
Productivity
Task Management: Todoist
I use Todoist to manage my to-do list. It’s an app I use daily. I’ve tried other apps but this works the best for me. Available on the web, iOS and Android.
Project Management: Trello
I use Trello to manage my projects, both the projects I am working on and the long-term projects/ideas I have. I like that it’s easy to use, fairly customisable, and uses a Kanban system of cards.
Using a separate system for project and task management works well for me, but others prefer to use the same tool.
Documentation: Notion
Notion is an online Wiki tool that I’ve recently started using and I love it. I previously used Evernote to capture all of my notes and ideas, but I now use Notion. It’s fast, customisable, and easy to use. I use it to capture notes about books I have read, plans for the website, ideas, lists, and much more.
Cloud Storage: Google Drive
I use Google Drive for cloud storage. It’s got a generous free tier and you can pay a small amount to have more storage. I use it to store images (using Google Photos), documents, scanned files, and much more. I like that it’s easy to use and accessible on my laptop and mobile.
Office Applications: Google Docs/Sheets/Slides
Google Drive also comes with a suite of office applications: Docs (word processing), Sheets (spreadsheet), and Slides (presentation). I use these for writing blog posts, creating slides for videos, planning courses and data analysis in spreadsheets (I love a good spreadsheet!). I prefer using it instead of Apple’s range (as I’m on a MacBook) and Microsoft Office.
Password Management: LastPass
LastPass is a tool that stores and manages all of your passwords. You have a single master password to log in to LastPass, and within it all of your other passwords are stored. There’s a browser extension to help you remember and fill out passwords on forms. I love it because I’m terrible at remembering passwords.
Window Arrangement: Divvy
Divvy is a handly tool for Mac that lets you arrange your windows. MacOS doesn’t have keyboard shortcuts to let you snap windows to full screen or side-by-side like Windows does, but Divvy lets you do this easily.
Development
Oracle SQL: Oracle SQL Developer
My Oracle SQL IDE of choice is Oracle SQL Developer. It’s free, runs on Mac and Windows, and does everything I need it to do.
SQL Server: SQL Server Management Studio
When working with SQL Server, the IDE I use is SQL Server Management Studio. I’m sure there are others out there, but I just use this as it comes with SQL Server and it’s convenient.
docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
MySQL: MySQL Workbench
When I work with MySQL, I use MySQL Workbench as an IDE. It’s free and easy to use.
Text Editor: Atom
Atom is a free, open-source text editor available for Windows and Mac. I use it to edit all kinds of files. It’s easy to use, fast, and offers many plugins to help you work.
Other
Backups: Backblaze
I use Backblaze for backing up data on my computer. While I use Google Drive for storing many of my files, and the Time Machine feature in MacOS, I also use Backblaze as a backup solution for peace of mind and an additional backup. It lets you backup files and folders on your computer to their servers, allowing you to restore in the future if you need to.
Reading: Pocket
Pocket is a great app that lets you save articles you find online and read them later (instead of bookmarking them and forget about them). They have a Chrome extension and a mobile app (which also has an easy “reading” mode).
Podcasts: Overcast
Overcast is an iOS app for managing and listening to podcasts. I listen to quite a few podcasts and the Apple Podcast app is not as good as Overcast. I like the queue management feature, the downloading of podcasts, seeing which episodes I have played, and the speed-up feature.