14 points

All the cool kids use Microsoft Access

permalink
report
reply
13 points

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.

permalink
report
reply
10 points

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.,

permalink
report
reply
5 points

thank god postgres is still safe!

permalink
report
reply
5 points

Nobody is dumb enough to insult postgres - we’ll fucking burn you at a stake for heresy like that.

permalink
report
parent
reply

Programmer Humor

!programmerhumor@lemmy.ml

Create post

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

  • Posts must be relevant to programming, programmers, or computer science.
  • No NSFW content.
  • Jokes must be in good taste. No hate speech, bigotry, etc.

Community stats

  • 4.1K

    Monthly active users

  • 1.5K

    Posts

  • 35K

    Comments