I worked on one where the columns were datanasename_tablename_column
They said it makes things “less confusing”
I mean, I totally agree with you. But that also kinda ignores all the useful things a dog can be trained to do.
She’s a witch, get h… Whisper whisper really? Whisper whisper whisper oh, sorry, wrong page. Pulls out new page
She’s an abortion patient, get her!
It’s less the calculations and more about memory bandwidth. To generate a token you need to go through all the model data, and that’s usually many many gigabytes. So the time it takes to read through in memory is usually longer than the compute time. GPUs have gb’s of RAM that’s many times faster than the CPU’s ram, which is the main reason it’s faster for llm’s.
Most tpu’s don’t have much ram, and especially cheap ones.
Reasonable smart… that works preferably be a 70b model, but maybe phi3-14b or llama3 8b could work. They’re rather impressive for their size.
For just the model, if one of the small ones work, you probably need 6+ gb VRAM. If 70b you need roughly 40gb.
And then for the context. Most models are optimized for around 4k to 8k tokens. One word is roughly 3-4 tokens. The VRAM needed for the context varies a bit, but is not trivial. For 4k I’d say right half a gig to a gig of VRAM.
As you go higher context size the VRAM requirement for that start to eclipse the model VRAM cost, and you will need specialized models to handle that big context without going off the rails.
So no, you’re not loading all the notes directly, and you won’t have a smart model.
For your hardware and use case… try phi3-mini with a RAG system as a start.
I’m not saying it’s broken, but it has some design choices and functions that makes even Whatsapp a better choice for privacy minded people. Like rolling their own crypto and not having e2ee as default.
Koboldcpp is way easier. Download exe, double click exe, open gguf file with the AI model, click start.
Then put on your robe and wizard hat
So you’re saying it’s already feature complete with most json libraries out there?
Hilarious for a system which main point / feature is photo backup