Tech for Freelance Writers: using AI to build a better work tracker
Like all freelance writers, I have to keep track of a lot of work. There are pitches, assignments, records of when and where my work was published, with URLs and — because link rot is a thing — a PDF archive copy.
For a while now all of this has lived in a database. I used SQL at first; the plus points were it’s free and no third party had my data. The downsides were it needed a lot of time and effort to setup and maintain.
Was the effort worth it? No. I can code, sort of, but I’m a writer so that’s where I should focus my time. I use Airtable now, which is not perfect either but, importantly, it’s good enough.
What needed to be better
The underlying design of my database was a little janky, for lack of a better term. I’ve been looking recently at automating as much of the boring busywork of getting details about my writing into the database. For this to really be effective, I need a database that runs smoothly. I need one that is soundly designed.
Just because ChatGPT isn’t good at writing, doesn’t mean it’s useless for writers
ChatGPT is fairly shit at writing (for now) but it can do other things reasonably well. I had heard about programmers using AI to autocomplete lines of code. If I…
