News for hackers. Stuff that matters.

thecalebf

thecalebf on Hacker News

Re:Valve New Employee Handbook (2012) [pdf] on Friday August 23, 2024 @10:30AM (#41329352)
the graphics in it make it so much better

Show HN: SmolCopilot – 360M LLM writing assistant in the browser

Posted by thecalebf on Tuesday August 20, 2024 @05:18PM
from the show-hn dept.

https://github.com/cfahlgren1/smol-copilot

Hey! I've been really intrigued about small, on device models recently.This project was to explore that a small base model running in the browser as a Co Pilot-like writing assistant. You can check out the demo here: smol-complete.vercel.app.Smal, on device models have a lot of advantages with low latency, cost, privacy (a big one), and being task specific. The demo will definitely repeat...

( Read More... | no comments | 5 points | on HN )
Re:Show HN: I Made a Chrome Extension to Query Hugging Face Datasets w... on Wednesday July 24, 2024 @09:58AM (#41057197)
The Chrome Extension is open source and is powered by DuckDB WASM which loads the parquet conversion of the datasets as views so you can query them with SQL.

Here's the repo: https://github.com/cfahlgren1/hf-data-explorer

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @12:05PM (#39263527)
Yes please do! Looks awesome, would love to help any way I can as well.
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @12:04PM (#39263511)
Sorry, it seems complicated. Since it is a finetune of Deepseek-Coder, I had to include their license.

Deepseek is pretty open, just says not to use it for: - military purposes - exploiting vulnerabilities etc.

Just trying to include as much information as possible from the initial base model.

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @11:28AM (#39262979)
Yes it is designed for users without SQL knowledge, however, it can still perform fairly well with questions on the difficult side (for non technical users) with queries having multiple joins, aggregations, ratios, and subqueries.

Next step is fine tuning and leveraging larger models that can handle very complex questions, reasoning, and data schemas since this is only a 7B.

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:56AM (#39262496)
Currently Postgres yes, already working on a dataset with more DDLs like MySQL, DuckDB, MSSQL, etc for a second iteration.
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:54AM (#39262465)
Neat, would you ever use a local model for that if it could work with ORMs?
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:49AM (#39262389)
That is really interesting. I took note of this. That would be really cool!
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:48AM (#39262364)
Great call out. Will definitely focus on that in the next iteration!
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:47AM (#39262351)
No, those are benchmark, evaluation questions. The fine tune dataset was a custom, synthetically generated dataset of ~20k PostgreSQL Text to SQL pairs covering different SQL categories and question types.

I mention a little more about it here https://x.com/calebfahlgren/status/1754247740291207198?s=20

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:41AM (#39262289)
Updated the title since it may have been confusing, appreciate the feedback!
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:39AM (#39262270)
Not yet, planning to build an open source, local, CLI tool that utilizes natural-sql though!
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:38AM (#39262260)
Sure, there is a blog post with some other examples of the first model iteration with more complex, multipart questions. https://www.chatdb.ai/post/naturalsql-vs-sqlcoder-for-text-t...

I will update that to be a more truly difficult question. Appreciate the feedback!

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:25AM (#39262164)
Thanks! Yes, that was an earlier iteration. The v1 is here https://huggingface.co/chatdb/natural-sql-7b. Plan to push to Ollama soon and build an open source free tool around it.

Would love to hear about what you are building!

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model on Monday February 05, 2024 @10:14AM (#39262057)
Would love thoughts!

Here is the HF page: https://huggingface.co/chatdb/natural-sql-7b

Re:Vanna.ai: Chat with your SQL database on Sunday January 14, 2024 @08:30PM (#38996358)
Very neat! I am building something very similar, called ChatDB.ai

Show HN: Query CSV files in the browser with SQL

Posted by thecalebf on Wednesday June 28, 2023 @09:07AM
from the show-hn dept.

https://www.chatdb.ai/tools/query-csv-with-sql

Hey everyone, I am Caleb.Was really excited to release this free tool for other data enthusiasts out there to be able to query data really easy.No Snowflake or software install necessary. Built it to work directly in the browser with the DuckDB WebAssembly library and deployed to Vercel with Next.js

( Read More... | no comments | 2 points | on HN )
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Tuesday September 13, 2022 @01:17PM (#32827288)
Hey, interesting. Make sure you have a home opened and it should populate with the charts. If that doesn't work feel free to send me an email at caleb at homescope.io and I can help you out :)
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Monday September 12, 2022 @11:37AM (#32811936)
Thank you. Let me know if it meets your needs :)
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Monday September 12, 2022 @12:13AM (#32806018)
The extension isn't storing any data from Zillow. Bigger Pocket's proprietary calculator pulls the data from Zillow as well. I think as long as you aren't storing or trying to make it proprietary it is better.
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Sunday September 11, 2022 @06:09PM (#32803754)
Also if Zillow is hiring new grad engineers reach out :)
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Sunday September 11, 2022 @05:45PM (#32803578)
Thanks for the tips!
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Sunday September 11, 2022 @04:33PM (#32803016)
Let me know if you have all the tools you need :). Always open to add things to help make finding deals easier!
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Sunday September 11, 2022 @04:15PM (#32802895)
Hey there, yes the only thing collected is authentication so email password signing in via Firebase. It isn’t used in any way other than auth. Hope that answers your question!
Re:Show HN: I built an extension for analyzing rental properties in Zi... on Sunday September 11, 2022 @03:56PM (#32802709)
This tool is more for smaller investors not really massive funds or companies like Blackstone.

Older »