FB

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.

todoist.com

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.

trello.com

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.

notion.so

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.

drive.google.com

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.

drive.google.com

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.

lastpass.com

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.

mizage.com/divvy/

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.

www.oracle.com/tools/downloads/sqldev-v192-downloads.html

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.

www.mysql.com/products/workbench/

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.

atom.io

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.

backblaze.com

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).

getpocket.com

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.

overcast.fm