The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Picard Alternatives
Similar projects and alternatives to picard
-
spider
scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
webextension-polyfill-ts
This is a TypeScript ready "wrapper" for the WebExtension browser API Polyfill by Mozilla
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
picard reviews and mentions
-
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.
-
A note from our sponsor - WorkOS
workos.com | 19 Apr 2024
Stats
ServiceNow/picard is an open source project licensed under Apache License 2.0 which is an OSI approved license.
The primary programming language of picard is Haskell.