textSQL
textSQL copied to clipboard
caesarHQ
There's a lot of data we want to integrate. But for now, it's mostly limited to queries about race, age, gender, population, and crime of zip codes/cities/counties/states. We should add...
Currently, users have no easy way of getting additional data about a highlighted region when they hover over it. Mapbox supports showing a popup on hover ([link here](https://docs.mapbox.com/mapbox-gl-js/example/popup-on-hover/)): Expected behavior...
So we don't have to worry about having an exhaustive blacklist of bad/modifying sql statements
Don't want to let user input mess with table permissions on our side. Alternatively, we could just fix this at the session level with ```SET SESSION TRANSACTION READ ONLY;```
- Added formatting of numbers, percentages, title in the data - Added code for button to contribute data which can be used later once the form is ready
Add middle step to prompt LM to return relevant tables to answer a given natural language query.
Create a dev database + frontend + backend for testing new features/datasets.
Prompt LM to use markdown to indicate code text. Currently, we take text before ';' and after ':' from the LM response to extract the SQL query.
FYI - I have disabled Mapbox rendering for now to allow easy testing of the plotted bar charts. Will reenable + clean up some code before merging. Won't work on...
- Add basic eslint config - Add lint command `npm run lint` or `npm run lint src/App.js` Will eventually need a hook to enforce eslint before committing
