3 ms·
Indeed, I am a dev that codes Ruby on Rails and Python apps with PostgreSQL (and MySQL a while ago). I was reviewing a book and just used a Libreoffice spreads
by csdreamer7 7y ago
Indeed, I am a dev that codes Ruby on Rails and Python apps with PostgreSQL (and MySQL a while ago).
I was reviewing a book and just used a Libreoffice spreadsheet for vocab terms. One column for the word, one column for the description. Wrote a macro and made a button on the spreadsheet to sort the words for me.
A lot easier than making a CRUD interface ontop of a Base database. If I want to add a third column, categories, I can just enter the word and press enter for the next row. No need to jump between interfaces that need to save and error check.
Plus I can just export the data to a CSV and that a custom app, like a flashcard app, can test me randomly on.
Or can I just make a macro that does that for me?
- iudqnolq 7y ago> A lot easier than making a CRUD interface ontop of a Base database. Making an interface for a few columns of a few hundred rows sounds like the classic NCIS hacker line "let me quickly code a GUI in Visual Basic to run that IP address check".
- csdreamer7 7y ago> Making an interface for a few columns of a few hundred rows sounds like the classic NCIS hacker line "let me quickly code a GUI in Visual Basic to run that IP address check". I can understand that, but keep in mind; I add a new line at the end of the spreadsheet for every new vocab word that is highlighted by the book. I had to look over to make sure I got everything so the words need to be sorted. So I had to select everything in the menu -> two clicks, then click sort->another two clicks. For every few words... It was much easier just to make a button into the spreadsheet that does this for me. One click. It was also a perfect excuse to learn about macros. If you ask 'what's the point?' for every fun little technology you learn about-you will become depressed fast.