185
submitted 2 days ago* (last edited 2 days ago) by [email protected] to c/[email protected]
you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 46 points 2 days ago

Maybe use a real database for that? I'm a fan of simple tools (e.g. plaintext) for simple usecases but please use appropriate tools.

[-] [email protected] 15 points 2 days ago

What is wrong with a file for this? Sounds more like a local log or debug output that a single thread in a single process would be creating. A file is fine for high volume append only data like this. The only big issue is the format of that data.

What benefit would a database bring here?

[-] [email protected] 5 points 2 days ago* (last edited 2 days ago)

It's used to export tracking data to analyze later on. Something like SQLite seems like a much better choice to me.

[-] [email protected] 1 points 1 day ago

If it's an export that will be consumed by a separate, unrelated program later, I think a CSV is most appropriate. Databases are persistence tools, not transport.

[-] [email protected] 1 points 1 day ago

It's only intended to be used by the program itself. It's purely storage.

[-] [email protected] 2 points 1 day ago

Ah so it's not really an export, it's just the backing store used by some other (locally-running) program that you're trying to reverse engineer?

In that case yeah an sqlite database is probably most appropriate, though I can see a CSV still being desirable to remove a potential sqlite dependency.

load more comments (14 replies)
load more comments (14 replies)
this post was submitted on 04 Jul 2025
185 points (98.4% liked)

Programmer Humor

24790 readers
495 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS