Readit Newsfangpenlin commented on AMD YOLO geohot.github.io//blog/je... · Posted by u/trulyrandom
I heard that Nvidia's graph cards are the best in the class in terms of power consumption vs TFLOP ration. I wonder what's the number of AMD vs Nvidia? I would like to see the number because power consumption is going to take a big portion of AI training. In comparsion, hardware might not be that expensive in the long run.
fangpenlin commented on My Beancount books are 95% automatic after 3 years (2024) fangpenlin.com/posts/2024... · Posted by u/leonry
Lovely, now LLM can hallucinate how much I spent or earned in a month, or year.
For a usecase like this, a local running model would be ideal. I won't like to share my personal accounting books with LLM either.
fangpenlin commented on My Beancount books are 95% automatic after 3 years (2024) fangpenlin.com/posts/2024... · Posted by u/leonry
Then you are slowly building a database engine.
When do you split the files? How do you track which data resides in which files? Does one file represent one kind of data (table)? Does it reflect data within a given time range? Do you sometimes need to retrieve data that crosses file boundaries?
You quickly lose the simplicity inherent in saving to just a single file.
Which is where Sqlite shines. It's a single file. But with a full, user defined schema. And can update it and query it incrementally, without having to read and write the entire thing frequently. It handles all of that complexity for you.
Some people, myself included, prefer text-based files as a user interface. Like, some Vim users won't leave their Vim session forever and would like to do everything in it. While SQLite is immortal software and will probably be there forever, using it means changing the UI/UX from text files to SQL queries or other CLI/UI operations. I think it's a preference for UI/UX style instead of a technical decision. For that preference of UI/UX, we can push on the technical end to solve some challenges.
fangpenlin commented on My Beancount books are 95% automatic after 3 years (2024) fangpenlin.com/posts/2024... · Posted by u/leonry
would using sqlite have been inline with the file-over-app philosophy?? I'm thinking yes.
If there's anything like immortal software, SQLite is definitely on the list