search

probcomp / bayeslite

BayesDB on SQLite. A Bayesian database table for querying the probable implications of data as easily as SQL databases query the data itself.
http://probcomp.csail.mit.edu/software/bayesdb
Apache License 2.0
923 stars 63 forks source link

BQL Cheat Sheet #265

Open marcoct opened 9 years ago

marcoct commented 9 years ago

As discussed with @riastradh-probcomp in https://github.com/probcomp/bayeslite/issues/263 and other issues, there are some details that are not exactly part of the BQL syntax but are important for helping a new user get things done with the current system. I will add this to the bayeslite documentation.

Here's proposed list of content:

  1. A disclaimer that the details below may not be part of the BQL language specification (e.g. the names of the fields returned by ESTIMATE ... FROM PAIRWISE) and are not guaranteed to persist for very long.
  2. The intended semantics of ESTIMATE, INFER, etc., which I don't believe are documented elsewhere.
  3. A list or table making more explicit the space of possible queries.
  4. More detail on what each keyword returns, including the names of the fields.
  5. A list of useful short commands that are not documented elsewhere.
marcoct commented 9 years ago

The workaround for ESTIMATE ... ORDER BY in https://github.com/probcomp/bayeslite/issues/259 should be included in the cheat sheet.

marcoct commented 9 years ago

Branch started here: https://github.com/probcomp/bayeslite/commit/f0c06daf1c86f29200e6b73570b21c57e1c8ad6c

raxraxraxraxrax commented 8 years ago

@marcoct: We would like to get this done by January 5th for the IAP class. Can I collaborate with you on it? Will you be working at all before then? :)

gregory-marton commented 8 years ago

@raxraxraxraxrax notes that there is also some work towards this at https://docs.google.com/document/d/1xaZsBSYyvcM3FY6PMj1xntJKB_QpeY1z3O3JdGZr_0g/edit#