Selfhosted

39937 readers

381 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam posting.
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago

MODERATORS

[email protected]

Self hosted AI to train on an existing database (lemmy.world)

submitted 11 months ago by [email protected] to c/[email protected]

3 comments fedilink hide all child comments

I have a SQL database, and a schema document that goes with it, is there any kind of AI I can self host and train it on this data?

The goal would be to ask it simple questions like “from which table in [dbname] can I find a list of products I’ve sold in the last x days”

Would be even better if I could ask it to write some queries to find exactly what I’m after.

What kind of hardware would I need to run something like this, if it exists?

top 3 comments

sorted by: hot top controversial new old

[–] [email protected] 4 points 11 months ago

Vector embeddings with ChromaDB. Basically you pre compute the word embeddings of every row / table / whatever granularity you want and then stick that into a vector DB. Then you do an embedding computation of your query and compare similarity. You can either return the table / row / whatever you want that’s most similar (“semantic search”) or you use that as context for an LLM (“RAG”)

[–] [email protected] 2 points 11 months ago* (last edited 11 months ago)

You could use something like https://huggingface.co/defog/sqlcoder-34b-alpha / https://github.com/defog-ai/sqlcoder however I haven’t used this one myself but it builds up on CodeLlama model so the quality should be good. I haven’t seen other models specifically for SQL queries yet.

Edit: it includes all the hardware requirements and some demo examples in the links

[–] [email protected] -3 points 11 months ago

New Lemmy Post: Self hosted AI to train on an existing database (https://lemmy.world/post/9013086)
Tagging: #SelfHosted

(Replying in the OP of this thread (NOT THIS BOT!) will appear as a comment in the lemmy discussion.)

I am a FOSS bot. Check my README: https://github.com/db0/lemmy-tagginator/blob/main/README.md