search

AlisdairO / pgexercises

PostgreSQL Exercises web site code
Other
400 stars 62 forks source link

Searching for key concepts would be helpful! #18

Open jondkinney opened 8 years ago

jondkinney commented 8 years ago

Thanks for putting this resource together!! It'd be super helpful to have a search capability on the site where I could type in something like limit and find any exercises that would cater to that SQL skill. I'm planning on using this to help my dev team level up on their "raw sql" skills so we can more easily performance tune some of our Rails apps. Alternatively if the exercise descriptions somehow mentioned which operator/skill they address we could use the built in find feature of most browsers to look for what we need. Maybe if there was a separate outline view page with that manually added those annotations to start? I might be able to help contribute to this request as well, but wanted to ping you on here first to see if it's on the roadmap.

AlisdairO commented 8 years ago

Hiya - glad you're finding it useful! I could imagine that something like this might be helpful, although I had previously envisaged pgexercises more as a step-by-step affair. That being said, a search/annotation would still be useful to go back and brush up on stuff.

Sorry for my rather tardy response - I'm in the middle of emigrating, and my time is extremely tight right now. If you wanted to flesh out an outline of an implementation for this, I'd certainly seriously consider it. Please don't take any periods of silence for lack of interest over the next little while :-)

dissolved commented 4 years ago

If I can find some free time, I may PR tags for concepts. Ultimately, going through in tutorial fashion was great! But I also want to go back and find all examples that illustrate certain things... so for example, any exercises with a subquery would be tagged with subquery, etc.