3 ms·
There are lots of people who use Excel spreadsheets as databases. Just as there are lots of people who use Word for nothing more than editing (sometimes rich) t
by jcranmer 7y ago
There are lots of people who use Excel spreadsheets as databases. Just as there are lots of people who use Word for nothing more than editing (sometimes rich) text.
- csdreamer7 7y agoIndeed, 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.