YAML is not a good format for this. But any line based or steamable format would be good enough for log data like this. Really easy to parse with any language or even directly with shell scripts. No need to even know SQL, any text processing would work fine.
CSV would be fine. The big problem with the data as presented is it is a YAML list, so needs the whole file to be read into memory and decoded before you get and values out of it. Any line based encoding would be vastly better and allow line based processing to be done. CSV, json objects encoded into a single line, some other streaming binary format. Does not make much difference overall as long as it is line based or at least streamable.
Never said it had to be a text file. There are many binary serialization formats that could be used. But is a lot of situations the overhead you save is not worth the debugging effort of working with binary data. For something like this that is likely not going to be more then a GB or so, probably much less it really does not matter that much if you use binary or text formats. This is an export format that will likely just have one batch processing layer on. This type of thing is generally easiest for more people to work with in a plain text format. If you really need efficient querying of the data then it is trivial and quick to load it into a DB of your choice rather then being stuck with sqlite.
export tracking data to analyze later on
That is essentially log data or essentially equivalent. Log data does not have to be human readable, it is just a series of events that happen over time. Most log data, even what you would think of as traditional messages from a program, is not parsed by humans manually but analyzed by code later on. It is really not that hard to slow to process log data line by line. I have done this with TB of data before which does require a lot more effort to do. A simple file like this would take seconds to process at most, even if you were not very efficient about it. I also never said it needed to be stored as text, just a simple file is enough - no need for a full database. That file could be binary if you really need it to be but text serialization would also be good enough. Most of the web world is processed via text serialization.
The biggest problem with yaml like in OP is the need to decode the whole file at once since it is a single list. Line by line processing would be a lot easier to work with. But even then if it is only a few 100 MBs loading it all in memory once and analyzing it all in memory would not take long at all - it just does not scale very well.
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?
I said editor, not an OS that lacks a decent editor :)
What editor is more feature-rich then vim? Out the box it is lacking some sane config but it is one of the more powerful and flexible editors out there - more then a rival for any modern IDE.
Vims defaults are quite crap overall. It is why everyone needs 100s of lines of configs and many plugins to turn it into something decent. Well worth the setup but it could go a long way to making things nicer to use out the box.
Nobody sane uses vim as an IDE
Huh? Many people do this. With the right plugins and config it is just as capable as any IDE.
The problem is ides inlining only part of the error and generally skip all the helpful text on how to fix the error.
That is the type of thinking that causes a massive amount of CVEs in those languages.
Hey, the design specs never said the program shouldn’t blast out and air raid siren at full volumn every time the user clicks a button. Cannot be a bug, must be user error.
But there are more numbers between 0 and 1 then there are whole numbers. So are the countable many angles or uncountably many?
‘I never thought leopards would eat MY face,’ sobs woman who voted for the Leopards Eating People’s Faces Party. - Adrian Bott
Lizards are not dinosaurs.
I never argued that. Only pointing out its decent into fascism. All bets are off at that point as to what will happen to its industries.
They were a beneficial strategy. They made Trump and his buddies massive amounts of money from manipulating the stock market. They were even bragging about it after the fact.
Oh, you meant for the country and its people… Nah, that was never the point. If they were thought out at all it was only how it benefits Trump and his buddies.
Trump is supposed to be in office for only 4 years, at best,
That assumes America is still a democracy in 4 years. We are only a few months in and it is already not looking great.
Once had a missing semi colon at the end of a c header file. The compiler kept complaining about the c file and never mentioned the header. Not all errors lead you to the right place.
Though most of the time people just don’t read them. The number of problems I have solve for people by just copy pasting the error they gave me back to them…
Cannot remember if the study was stupid or if peoples interpretations of it where. But when covered up else where you will lose a lot of heat through your head. More so then if just an arm or just a leg was exposed as with your arms and legs your body will slow down blood flow through them to try and converse your core temperature - it cannot do that with your head.