8 points

My old ass crying in MS Access

permalink
report
reply
2 points

one of our partners we have to integrate with at work sends us reports in ms access format. it’s not fun, especially when everything is running in lambda and there doesn’t seem to be any good libraries for reading ms access files that would easily run in lambda.

permalink
report
parent
reply
13 points

Don’t be gross, use CSV files

permalink
report
reply
3 points

CSV is great but the byte loss on numbers is sometimes gruesome.

permalink
report
parent
reply
7 points

I mean it’s a simple file format so it’ll perform better because it doesn’t have to decode any complex formats or protocols.

Big O? Never heard of it!

permalink
report
parent
reply
13 points

“I have to make a brochure for the printing shop and I’d like to compose it in Excel”

“There are actually five rules…”

“In Powerpoint?”

“Make that six.”

permalink
report
reply
15 points

Except PowerPoint is actually quite nice to make quick, easy and good looking visualizations and brochures without having to deal with Word

permalink
report
parent
reply
5 points
*

I can personally attest to entire universities advocating for student use of powerpoint for all sorts of printshop work to include thesis and capstone presentation posters for conferences :)

For people who don’t want to spend time learning yet another single-purpose application, it works quite well

permalink
report
parent
reply
4 points

Use Libreoffice Draw

permalink
report
parent
reply
11 points

Well, Word isn’t really a good choice either.

permalink
report
parent
reply
2 points

It’s the most approachable for most people. For real graphics design more professional tools are available

permalink
report
parent
reply
8 points

Kind of related question: Is it okay for me to use JSON as a small DB? I just store basic blog page data there.

permalink
report
reply
4 points

TinyDB literally does this. in general its more of does this work for my use case and am i aware of its limitations.

permalink
report
parent
reply
3 points

If it works then it works.

permalink
report
parent
reply
1 point

yep, though IO might bottleneck you at some point, and then you can happily switch to mongoDB

permalink
report
parent
reply
1 point

then you can happily switch to mongoDB

permalink
report
parent
reply
10 points

I mean it will work, but for a blog I’d store the pages in markdown files, to make it easier to edit. For context, look into how Hugo works

permalink
report
parent
reply
3 points

I thought of that as well. I might switch to that. It will make the organization better anyways.

permalink
report
parent
reply
4 points
*

A few circumstances to consider…

If it’s just your own little tool and you don’t intend to share it with others: do whatever you want. SQL or NoSQL or JSON, it doesn’t matter. Use your own judgement.

In my experience tho most homegrown JSON-based “databases” tend to load all data into the memory, simply because they are very simplistic (serialize everything into JSON and write to disk, deserialize everything into a struct). If your dataset is too big for that, just go straight for a full-fledged database.

permalink
report
parent
reply
13 points
*

My 5th rule would be “no ‘fix my IT problem without me telling you what the error message says’”. Because fuck that

permalink
report
reply
11 points

Error 0x2e8da08150469

permalink
report
parent
reply
7 points

That would be something I could google. So not completely useless.

permalink
report
parent
reply
1 point

How about “An error message on my screen”?

permalink
report
parent
reply

Memes

!memes@lemmy.ml

Create post

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

Community stats

  • 13K

    Monthly active users

  • 12K

    Posts

  • 259K

    Comments