All the cool kids use Microsoft Access
Not going to lie. I have made it really far using Google sheets as a database until I had to move to a full DB. Google Sheets is just an interface to a Google run DB anyways. A lot of the time I would just load sheets(tables) into data structures from a SQL library and use it like a regular database.
I use Google sheets on my personal projects.
- tracking expenses
- tracking my ride logs from my ev
Google app script pickup email received from banks and update the transaction automatically. I modify it using web based form of needed.
The ev company has api. It will be called on periodic basis to get the ride details and update the sheets. I use telegram api to interact, by triggering the api webhook, getting charts, etc.,
Initially I setup OCR to extract the ride information, so the process was like
- send an image that has ride details to a telegram bot
- the bot saves the image in Google drive
- the image would be opened in docs
- the text would get extracted and stored in Google sheets as data
- edits can be done using telegram webapp
- sheets provide charts for analysis
- built a process using sheets to handle telegram bot for maintaining users, approvals, etc.,
It would be hard if I have used any other services… setting up OCR preparing charts etc.,
thank god postgres is still safe!