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.
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 & Documentation: Notion
Notion is an online tool that I’ve recently started using and I love it. I previously used Evernote to capture all of my notes and ideas, and Trello for project management, 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.
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.
MySQL: MySQL Workbench
When I work with MySQL, I use MySQL Workbench as an IDE. It’s free and easy to use.
I’ve recently started using DataGrip by JetBrains as an SQL IDE. It’s a very good tool, has a lot of features, well-designed, and can access many different vendors (which is helpful as I work with several of them as part of Database Star).
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.
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.
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.