this post was submitted on 03 Jul 2024
1037 points (98.2% liked)

Technology

60101 readers
2413 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 27 points 5 months ago (2 children)

Abusing Excel as a crappy database is a very real and very widespread problem.

[–] [email protected] 8 points 5 months ago (2 children)

You use what ya got, and you don't buy database software or hire a database guy until you know you need one

[–] [email protected] 4 points 5 months ago (1 children)

But access comes with office, so if you have excel you have at least a software that is intended to be used as a DB (efficacy aside)

[–] [email protected] 14 points 5 months ago (2 children)

Let's be real, using Excel as a makeshift database is probably still better than actually using Access lol

[–] [email protected] 2 points 5 months ago

When I started studying IT at a Berufskolleg (German word, literal transaltion would be something like job college or job school), we started learning about databases by using Access. We were all so happy when we were done with that and just used SQL. I fucking hate Access.

[–] [email protected] 1 points 5 months ago (2 children)

The only use case I can see for Access is when you absolutely must have a database and your company will not provide you a real database solution. I have experience with both, but haven't touched Access in years (and hope to never do so again). To be fair, I also regularly use Excel for things that I should probably be using Word for because it is easier to get formatting right in Excel.

[–] [email protected] 1 points 5 months ago

Have you ever tried just using Markdown?

[–] [email protected] 1 points 5 months ago

And you've never heard of sqlite

[–] [email protected] 1 points 5 months ago (1 children)

Probably true for most companies but I worked at one that had plenty of DB servers and developers, even developed their own database tech. Still, Excelitis as we called it was rampant.

[–] [email protected] 5 points 5 months ago

Nothings more permanent than a temporary solution.

[–] [email protected] 1 points 5 months ago

It can also link nicely over odbc to full databases which are represented a nice tables...with links between sheets...waiiit a second.