Sketch

AI

code generation assistant

SHOW HN2023

Legend

Sketch

AI code-writing assistant that understands data content

github.com

#pandas#natural language to code#gpt-3#data analysis#jupyter

252points
49comments
#194of 3,109 in 2023
Top 7%of 2023 by points

How HN took it

MixedNo clear lean

7 positive, 12 neutral or asking, 1 mixed, 9 critical, out of 29 comments about the project. Thread score -0.02.

Idea: 6 for, 0 againstPerformance: 0 for, 4 againstPrivacy: 0 for, 3 againstDesign: 1 for, 1 againstExecution: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful for pandas and data work, copilot-style answers with data context

    From 3 comments
    • This is fantastic and exactly where our team at Shipyard is expecting the data space to go. Context aware, AI driven. Great work on this! We were just talking last week about how…
      blakeburch on HN
    • This is a great demo, OP. I'm wondering about the UX of this vs Copilot. is this basically just a way to get around the fact that you dont have Copilot inside of notebooks? what…
      swyx on HN
    • Damn, this looks pretty useful. I was finding that github copilot was really good at reading a CSV file and writing all the imports from that into migrations for DB import, but…
      jamal-kumar on HN
  • Interesting application of GPT-3

    From 1 comment
    • Great work, and a really interesting application of GPT3. Some time ago I developed Datasloth [1] which might be a nice complementary feature to Sketch. Ping me if you're…
      ibestvina on HN

Objections

  • Sends data or column info to a remote OpenAI API, a privacy concern

    From 4 comments
    • Does using this mean sending all of your potentially private data via an api call to openAI?
      jerpint on HN
    • From https://github.com/approximatelabs/sketch/blob/main/sketch/pandas_extension.py#LL162 it appears that this library is calling a remote API, which obviates the utility of the…
      abrichr on HN
    • Right now, it sends the first five rows of the dataframe:…
      marcosfelt on HN
    • If this is using OpenAI which it seems is what it is using, It is only sending column headers / column names. Not the data. If you are concerned about column names, you could…
      pklee on HN
  • PII check gave wrong answers in a test

    From 2 comments
    • Looks really nice, but I tried it: ``` import sketch import pandas as pd data_pd = pd.read_csv("input.csv", sep=';') print(data_pd) print(data_pd.sketch.ask("Is there any PII in…
      tdebroc on HN
    • Ah yes it displayed the string, thanks! But the result looks wrong with this input: ``` age address 0 34 106 DOYERS ST. 8 ARLINGTON DR. 599 NW BAY BLVD 1 34 694 Short Street,…
      tdebroc on HN
  • Name clashes with Sketch design software

    From 3 comments
    • Cool project, although the name kinda clashes with the well-known https://www.sketch.com/ in the UI/UX design space
      gcatalfamo on HN
    • Very cool demo! Regarding the choice of name, presumably you already know about Sketch, the popular image editing software. I wonder if the image editing guys will in the future…
      jonwinstanley on HN
    • That seems to be a presumption... I just googled "sketch application" or "sketch image editing software" I found sketchpad... alternatively, I found sketch.com, which seems to be…
      Arelius on HN

Requests

  • Chaining queries so prior results give context

    From 1 comment
    • Just played around with this and I think I'll be using it on some research projects! One cool feature would be some sort of chaining, where you could anchor a new query to a…
      marcosfelt on HN
  • Support for R or other ecosystems beyond pandas

    From 2 comments
    • Really cool and helpful. Is there anything similar for R?
      sean_the_geek on HN
    • Damn, this looks pretty useful. I was finding that github copilot was really good at reading a CSV file and writing all the imports from that into migrations for DB import, but…
      jamal-kumar on HN
  • Database connection support

    From 1 comment
    • I don't have any experience with pandas. Can this directly connect to a db and run queries there (video seems to load a csv file).
      allisdust on HN

Questions

  • Does it run locally or send data to a cloud service?

    From 2 comments
    • Does using this mean sending all of your potentially private data via an api call to openAI?
      jerpint on HN
    • Related question: is this done on my machine or do I end up sending possible pii to a cloud service for evaluation?
      harvey9 on HN
  • Which LLM is used?

    From 1 comment
    • Hi, cool stuff! Which LLM is being used in the background? I may have missed that info in the readme. Thanks!
      pfd1986 on HN

Alternatives named

  • Copilot

    From 2 comments
    • This is a great demo, OP. I'm wondering about the UX of this vs Copilot. is this basically just a way to get around the fact that you dont have Copilot inside of notebooks? what…
      swyx on HN
    • Thanks! That is definitely a big part of it, getting to use copilot style answers without having to install any plugins to the IDE (so getting to use this in colab or jupyter…
      bluecoconut on HN
  • TabNine

    From 1 comment
    • I use TabNine [0] for local context aware AI suggestions, and I find it spookily good at guessing what I'm half way through typing. Sadly they've left the Sublime plugin to rot…
      drcongo on HN
  • AirOps Sidekick

    From 1 comment
    • Very promising. I believe the uses of OpenAI that will stick in the long term are like this, and other tools should be experimenting with this kind of integration. Otherwise,…
      mmaia on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/34400443)