This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools Part seven of an eight-part series of blogs
One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most). Comparing the coding skills of two different AI tools SQL programming using AI tools Getting help with Python code using AI tools VBA programming using AI tools Getting AI help with C# programming Writing programs in Office Scripts using AI Writing JQuery or JavaScript code using AI tools (this blog) Conclusion: which AI tools (if any) should you use for which languages?

Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools

Part seven of an eight-part series of blogs

One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).

Comparing the coding skills of two different AI tools
SQL programming using AI tools
Getting help with Python code using AI tools
VBA programming using AI tools
Getting AI help with C# programming
Writing programs in Office Scripts using AI
Writing JQuery or JavaScript code using AI tools (this blog)
Conclusion: which AI tools (if any) should you use for which languages?

Posted by Andy Brown on 07 June 2023

In this blog

JQuery using ChatGPT 4 (time taken: 22 seconds)
Bard and JQuery

AI tools for writing JQuery: ChatGPT and Bard compared

Finally, I thought I'd test to see whether AI tools can help me write JavaScript (although I've chosen the JQuery derivative language, on the grounds that if a tool can write JQuery, it can certainly write JavaScript too).

This is the one that I think could save me the most time, as I find the syntax of JavaScript/JQuery incredibly fiddly, and I find debugging it more difficult than with other languages too.

JQuery using ChatGPT 4 (time taken: 22 seconds)

ChatGPT came up with a nice concise answer to my question:

I particularly appreciate the notes on how this function works, and even a tip for how to get at my browser's development tools!

Bard and JQuery

By contrast, here's how Bard responded to my question:

A longer answer than for ChatGPT, although as we've seen this doesn't necessarily make it a better one!

What I like about this answer is that it gives me a code snippet to try, so that I can test out whether it's correct. Here's the output this program gave when I tried it on an HTML page:

The first two lines are the original table; the second two lines are the unordered HTML list built up by the Bard function.

i think this is the only example where I prefer the Bard code, although a purist would argue it doesn't quite do what it's asked (the Bard version searches a table for elements with a given class name, whereas the ChatGPT one searches individual cells as requested).

Parts of this blog
Comparing the coding skills of two different AI tools SQL programming using AI tools Getting help with Python code using AI tools VBA programming using AI tools Getting AI help with C# programming Writing programs in Office Scripts using AI Writing JQuery or JavaScript code using AI tools (this blog) Conclusion: which AI tools (if any) should you use for which languages?