This episode can also be watched on Youtube.
In this episode, I experimented with a hybrid approach, combining both video and audio updates to ensure that podcast listeners receive the same information as those watching on YouTube. I provide an accountability update, discussing the goals I've set for the next two weeks and reflecting on past performance. My main focus is getting organized, from using Notion for project management to improving my podcasting process. I also share some surprising analytics and discuss future plans for my various projects, including a personal chatbot and data management tools. Your feedback is welcome as I continue to iterate and evolve.
Hello, and thank you for listening. This podcast, I decided to iterate and evolve and try something new. So normally I just record the audio and YouTube creates a video for me, for my channel, this time I've also prepared some updates on the video and I'm trying to do this hybrid so people listening on the podcast should have all the information that the people watching the podcast on YouTube have. They just have more visual aid.
That's the goal because today I'd like to do a accountability update. So the first one, and the goal is to set goals for me for the coming two weeks. And after two weeks reflect on that and by sharing it on the podcast, I hope to have those goals more anchored and to have more motivation to complete them. I copied a free template from slides go to have something kept to keep going.
Ideally, I would have done this live all in one go, just sharing my desktop, having a camera on my face.
But I don't have all the equipment yet and I don't really have the time. And I figured I'd just evolve this shortly or in small steps. So I'm using, I created a slide deck. I'll just talk that over and I also visually described slides. So as an introduction, this is the accountability update. No green screen yet. That's for me, that's a requirement for having a camera, also having a proper camera and probably going to try to do that using my smartphone, but having a green screen because I don't really have a space in my home to do recording.
So for this podcast, the accountability update, I first like to go into describing the schedule that I thought of for the podcast. I like to short shortly go over some numbers because this morning I checked some analytics and statistics and I was surprised that's probably not something that I'm going to include regularly because sharing analytics and showing numbers are mostly vanity from the person sharing them and that's not my goal, but if it fits into the story, I might share them.
Past accountability is part of the contents, I guess for now that's just a placeholder and also for the future, the accountability for the coming two weeks. I mentioned that for the schedule of the podcast, I think I'm going to do two week iterations, so in the first week I'll do an accountability update and in the second week I'll do a topic or a project update or something similar and after
that, so the third week would again be an accountability update, so that would give me two weeks to do the things that I set for myself for the coming two weeks and that will allow me to reflect on that and how it went and what I could have done better and those kinds of topics. I'll also be sharing the accountability summary, I'll set that on debuggingdan.com.
Currently I've only shared the podcasts there and the transcripts, but I'll also update or set the accountability updates there and making them easy to find for anyone interested. Numbers for the projects and the podcast, I'll shortly go over them. Numbers, as I mentioned, this will probably not be a regular thing, but this morning my wife asked how are the numbers for the podcast and my feeling for this podcast is I'm basically doing it and there's not really someone listening, but when I looked at the analytics, I was surprised to see the numbers, there were like 113 unique listeners in July, 35, something like that in August, that really surprised me and the peak in July is probably from the Reddit post I shared where I got some feedback, so there were people that didn't react with
a comment, but obviously I guess they did listen, which is cool. So for me, that is, it was really motivational and this is a vanity metric, I won't be looking too much into it, but I found it cool.
For the sites or the project sites that I have, I have a analytics platform that I self-host and as you can see here, these are the different sites that I host to different projects, so you don't see a lot of big visitor numbers here. And so that's what I'm trying to change by learning SEO. And for Teletron, sometimes it gets a new account, but I think those are mostly spam people because they don't react to the emails and they don't use it.
For Founder Tooling, I was surprised to have 25 visits because I only shared it in the notes for the podcast, but I guess people found it and there were even people that left their contact emails for updates, so I was also surprised by that and it's cool. So I chose that sharing works.
Since this is an accountability update, I also included the slide already for fast accountability.
So this is the point where I would be talking about what I plan to do in the past two weeks and whether I was able to do those or not, and if not, why not. But I haven't set any goals yet, so this is just for the template. For the future, I'd like to do these two things.
So the coming two weeks, and the context is this week, I have a normal work week, the coming week, and in the week after that, I have four days off with my entire family. So not only my own family with the four of us, but also my brothers and sisters and my parents because we're celebrating an anniversary, but we're going somewhere. So I probably will not have time for those four days to really work on it, but I do have the weekends before it, the Friday and the weekend after it. So it will probably not really impact my schedule and hopefully it will even get me in a more relaxed and creative mindset by having some time off.
So the things that I'd like to do in those two weeks are these four. I'd like to get organized for the past week. I haven't been able to do programming. Really, I haven't been able to get other stuff done. I'm recording this podcast on Monday morning while I normally want to do publication of the podcast on Monday morning at seven. That's how I schedule it and I normally edit it in the afternoon, but I'm now doing the recording before work and I will probably do the editing and some of the video editing this afternoon after I'm ready with work. So it will probably be online on Monday evening, at least in my time zone, Central European time. And I need to sit down and get organized for also these accountability things to get them more fleshed out in more detail. So what exactly does that mean when I want to have something done? What does that entail?
And I might even add that to the blog post. And I also need to look into for the podcast itself, how to not have YouTube automatically import this audio recording from the podcast feed, but I have to manually upload this video. I need to do the video editing, which I don't really have a lot of experience with, but it's not that complicated. It's just probably cutting stuff, exporting the audio, improving the audio, importing it back again, something like that. That's what I'm looking for.
I need to get organized and get stuff done better.
The second item is my Notion to-do project. So what I've built, I used to track to-dos in Notion, and then I would create small chunks of works for projects. And instead of having those to-dos for each project, I interchange them with each other on a big list. And what I did, I created the front end for that using the Notion API. And the Notion SDK for Node. And on top of that, I've created a UI to kind of plan those tasks. So what I normally did, I did them from, the idea was that I did them from top down. First complete the top item and then the one below it. And I would be doing prioritization by moving them in a list in the order. But I'm doing, currently I'm doing two things, too many things at the same time. So I now also created a UI option to create a block, for example, or this weekend or this week, and I can add tasks from the specific Notion pages from those to-do blocks. I can add to that planning and I can also add some manual items. So for example, in the weekend, I want to do some side project stuff, but maybe I also need to mow the lawn.
Mowing the lawn is not a project that I track in Notion, but I can add that manually and it just stored within the application itself. That's what I want to finish. I'm still working, it's mostly done. I'm still working on some syncing stuff, tweaking some UI. You can open it at todo.debuggingdan.com, but there's no GUI or an explanation there, or there is a GUI, but there's no real explanation on how to get it, get it functional and the structure of the database, stuff like that, and that's
what I want to add at a later iteration.
The third item is watch your numbers. That's what I've been working on to create, easily create tables and charts from data, for example, the number of registered users, and I got in it as far
for myself to import my SQL data and also import external JSON. You can then format it and you can have it sent to you on a regular schedule. And I just need to start dogfooding it, so I kind of completed it before the vacation, before my holidays. Then I figured, well, I'm going to add all kinds of tables and charts in there, so I can do that during my days off and configure that, but I didn't do it. And yesterday I wanted to do it for one project and then it didn't work, so I need to do some small bug fixes and just start entering the data there.
And in the past week, I also encountered a project called AnyQuery. Someone create a CLI interface and also something that can be run as a server using, and you can access it using my SQL syntax.
And it's called AnyQuery and it would expose all kinds of different data sources and would allow for plugins to be used. It's created in Go, which I don't know, so I cannot really create my own plugins.
But if I integrate AnyQuery as a data layer, I might be able to easily unlock or simply unlock different data sources using AnyQuery. So once I have the code for AnyQuery, I only need to modify it for the
different data sources and that would allow me to quickly and easily allow more data sources for watch and numbers.
And finally, AspireDan, that's the personal chatbot that I've been working on that allows you to keep you on track for your goals, so that kind of also ties into organize together also with the notion to do, so the topic for this accountability update is mostly about getting organized, is that it will ping
you at an interval, hey, I wish you set a goal, how are you progressing on your goal, and the idea is that it can provide you with helpful tips, but it will also be more stern if you have no updates on the goal and it will tell you, hey, you set a goal, you discussed it with me and you haven't done something for it in a week while you mentioned that you wanted to have it done in a week or you wanted to have an update every day, you need to get working on it, for example. That's what I wanted to do with it. And also I want to start using it for myself, find out if it really works. And for me, this is the first project really with side projects, really with AI using GPT-4.0 mini and currently it's using a Telegram bot and at some point I'll create a web API or a web UI or even a native app or a react native app, which I haven't done before, but that's really a use case that would be fitting.
That would really make a difference compared to web page to have it on your
phone. Those are the things I want to do in the coming two weeks. I might even have to find a way to update you on the program.
So I might do that on the blog post or I'll probably also do it on Twitter. I need to find a way to maybe visualize that and properly make it pleasing to look at, I think. And so I'm going to look into that, I think updating the blog post and updating it on Twitter and creating some kind of visual, I like that. So I guess I'll add that also to the to-do list.
Getting organized, that's the goal.
That's the podcast for today. For those of you watching via YouTube, thanks for watching those of you listening. Hopefully this was followable or followable. I don't think that's English. Hopefully it was still clear. If you have any feedback, things that could be better, just let me know. Reach out to me on X or YouTube or the website. Thanks for listening.
Have a nice day.