I implemented something similar for a 3M/day ad tech platform. We created a few materialized views for my boss, myself, and the DevOps team to monitor, instead of querying over 100 tables. I used stored procedures in PostgreSQL, which made it fast, efficient, and non-blocking also not to mention we avoided setting up complex Grafana/UI in admin dashboard, boss: i want to know x, y ,z, okay -> tableplus, -> export csv boom!
Readit Newsal3rez commented on You Should Add Debug Views to Your DB chrispenner.ca/posts/view... · Posted by u/ezekg
al3rez commented on I tried every todo app and ended up with a .txt file al3rez.com/todo-txt-journ... · Posted by u/al3rez
Is this a joke?
AI helps but isn’t needed: With Cursor/Claude Code or Neovim + Supermaven, I can write my entire day’s schedule in 5 minutes. The AI completes my sentences, predicts meeting times, memorizes how I write tasks.no when you use todo.txt with Cursor/Supermaven in Neovim you can jsut write everythign and type everything out (as it adapts to your writing style) so it takes me less than few minutes to write my notes, todos etc. why is it joke?
So I watched the "Tetris" movie and it was amazing!
I got itchy to build the tetris game in php and see how fast we it can turn out and specially the line clearning and the algos used, how can this be better? I am not a fluent PHP developer I used PHP mainly from high-school and recently been building apps using Laravel for clients (I am a experienced dev though)
So feel free to roast it.
al3rez commented on Journaling using Nix, Vim and coreutils tangled.sh/@oppi.li/journ... · Posted by u/icy
it's a nice hackery thing to do, but i am too old and tired to use it hehe, i prefer my todo.txt
i am using wayland on fedora 42 + kde, it's fine what are you talking about? if you stop running sway/hyrpland rices you'll be fine.
al3rez commented on I tried every todo app and ended up with a .txt file al3rez.com/todo-txt-journ... · Posted by u/al3rez
al3rez commented on Ask HN: What makes a good take-home coding assignment? · Posted by u/hubraumhugo
I had an interview a while back that I really liked:
A pair programming session on a home assignment (it was a Java banking app) with 2–3 bugs and missing features. This allows the interviewer to see the candidate’s problem-solving skills and how quickly they can find, fix, and add features.
A take-home assignment with a static JSON file containing products, where the developer is asked to build both a front end and a back end around it. This lets you assess their systems thinking — do they overcomplicate things, chase the latest tech, or make wise, pragmatic decisions? During the interview, you can also expand the scope of the assignment, e.g., What if this needs to be production-ready? What would you add?
I’ve done over 100 of these in the last 10 years.
al3rez commented on I tried every todo app and ended up with a .txt file al3rez.com/todo-txt-journ... · Posted by u/al3rez
I went through something similar. I do use Logseq now, but for many, many years I found a notes.txt or todo.txt file in my home directory to be an excellent solution. I typically just write the date at the top of the file and put the notes underneath. A huge benefit is that I can trivially keep these under git. I keep them in my dotfiles repo so they can be easily synchronized to all my devices. A couple of shortcuts makes it quite fluid:
A bash alias so I can run `todo` and have the file open:
alias todo='nvim "$HOME/.todo.txt"'
inoremap <Leader>date <C-r>=trim(system('date "+%a %B %e, %Y %H:%M:%S %p"'))<CR>
nnoremap <Leader>date :put=trim(system('date \"+%a %B %e, %Y %H:%M:%S %p\"'))<CR><ESC>I have this in tmux opening a flaoting window with neovim and <leader>g to search by tags which opens quickfix pane
al3rez commented on I tried every todo app and ended up with a .txt file al3rez.com/todo-txt-journ... · Posted by u/al3rez
I've had a plain TODO.txt file for over 20 years so I agree with all the benefits the author mentioned. However, I don't like it because without an app, there's no runtime loop to notify and alert me of what's coming up.
This means I don't have "ambient awareness" of what's going on unless... I open the TODO.txt file ... manually scan it... then rescan it again and again multiple times per day. It's really tedious and inefficient to manually re-read the same items again. Offloading repetition like that is what computers are good for. I just don't have a good app at the moment to turn my TODO.txt into something I don't have to manually eyeball all the time.
So even though I have a tasks in my TODO.txt, a lot of things still falls through the cracks because I forget I need to do them.
If you have the type of brain that has a built-in "6th sense" of tasks that need to get done, a lightweight-no-runtime TODO.TXT will work fine for you. But it's definitely inadequate for me and I need to fix that.
EDIT replies to "use calendar for reminders" : Yes, that's a workaround but I've resisted doing that because I wanted the utopia of my TODO.TXT file being the Single-Source-Of-Truth instead of manually copying items to Google Calendar. (Yes, I know that "perfection is the enemy of the good" and all that.) The way other people do it is they make Google Calendar itself the SSOT. But that defeats the purpose of the freeform flexibility of the TODO.TXT that has all the notes, etc in addition to tasks.
I want my TODO.TXT to be a unified view of everything I want to do in life and splitting some items off into Google Calendar is just more digital housekeeping I wanted to avoid.
The way I'd prefer to use Google Calendar is via the developer API to programmatically add entries that's based off of my TODO.TXT. E.g. : (https://developers.google.com/workspace/calendar/api/guides/...)
... but that requires an active runtime loop ... like a Python script constantly scanning my TODO.TXT and then automatically populating the Google Calendar. I just haven't gotten around to coding that yet. Yes, the irony is that meta-task to enhance my TODO.txt is already in my TODO.txt.
i realized either it's pen & or paper or .txt this was a 10+ year experiement and i wasted alot of time finding and building workflows and none of them sticks more than .txt file (i also had a more automated version of it in macos using .txt file and macros that time blocked my calendar but it was too restrict)
nothing falls my mind i can just add #note #<project> #idea or whatever consistent tagging or subnotes i can do the todo.txt and it'd be easier to even feed it to chatgpt/or what everllm to even remind of my most important ones in the future and send me notification in telegram or something.