picard
lux
Our great sponsors
picard | lux | |
---|---|---|
6 | 6 | |
321 | 4,908 | |
2.5% | 0.6% | |
0.0 | 2.2 | |
6 months ago | about 1 month ago | |
Haskell | Python | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
picard
-
Thoughts on using GPT tools with databases
This is an active field of research. You might want to look at the main challenge dataset for it : https://yale-lily.github.io/spider. It would be interesting to use ChatGPT's model as a pre-processor and then feed its output in to a more finetuned model like PICARD.
-
It’s Like GPT-3 but for Code–Fun, Fast, and Full of Flaws
We tried using OpenAI/Davinci for SQL query authoring, but it quickly became obvious that we are still really far from something the business could find value in. The state of the art as described below is nowhere near where we would need it to be:
https://yale-lily.github.io/spider
https://arxiv.org/abs/2109.05093
https://github.com/ElementAI/picard
To be clear, we haven't tried this on actual source code (i.e. procedural concerns), so I feel like this is a slightly different battle.
The biggest challenge I see is that the queries we would need the most assistance with are the same ones that are the rarest to come by in terms of training data. They are also incredibly specific in the edge cases, many time requiring subjective evaluation criteria to produce an acceptable outcome (i.e. recursive query vs 5k lines of unrolled garbage).
-
[D] Discussion about fine tuning language models for generating SQL queries
Hi again! This is a surprise, we chose Apache 2 precisely so that businesses could use our code without legal problems or costs, see https://github.com/ElementAI/picard/blob/main/LICENSE. The only things that are excluded are liability and warranty. It is what it is :)
- Do you see SQL being under threat in any way as a way of querying databases? I know it's possibly a dumb question but wondering.
lux
- Name of library that creates multille charts quickly
-
lux VS Rath - a user suggested alternative
2 projects | 12 Jan 2023
- Mito – Excel-like interface for Pandas dataframes in Jupyter notebook
- Do you see SQL being under threat in any way as a way of querying databases? I know it's possibly a dumb question but wondering.
- Lux - A Python API for Intelligent Visual Discovery
- Python API for Intelligent Visual Data Discovery
What are some alternatives?
lux - 👾 Fast and simple video download library and CLI tool written in Go
ydata-profiling - 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames.
spider - scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge
cyberdrop-downloader - Cyberdrop.me album downloader written in Go
webextension-polyfill-ts - This is a TypeScript ready "wrapper" for the WebExtension browser API Polyfill by Mozilla
pandas-profiling - Create HTML profiling reports from pandas DataFrame objects [Moved to: https://github.com/ydataai/pandas-profiling]
webextension-polyfill - A lightweight polyfill library for Promise-based WebExtension APIs in Chrome
dtale - Visualizer for pandas data structures
dataprep - Open-source low code data preparation library in python. Collect, clean and visualization your data in python with a few lines of code.
mito - The mitosheet package, trymito.io, and other public Mito code.
qgrid - An interactive grid for sorting, filtering, and editing DataFrames in Jupyter notebooks