![]() ![]() I’ve been playing with ChatGPT code generation to make entire sites with flask, python, html+js+css, backed with SQLite db and it’s amazing. For most instances it's quicker to just learn the framework well and write the code yourself. It was a fun experiment, and I found it useful as a learning/guiding/generation tool, but I won't be using it for general day to day development any more than I currently do. It was also very useful for generating perfectly formatted boilerplate code (some frameworks have CRUD generation built in, but this one did not). It was definitely useful for making sure I was doing it the correct way, kind of like have an expert on call for any questions. In a framework I'm more familiar with I think I could have easily got it done in under 2 hours It took around 5 hours to make the application, with a lot of that time spent sitting waiting for the (sometimes painfully slow) ChatGPT output. I had to be very specific and write a few long and detailed prompts for the more complex parts of a the application. I suspect it was slower than just writing the code/referencing the docs, and would be much slower than someone could do if they were experienced with the two frameworks. I'll write a blog post about it soon, but a quick overview was: I used GPT4 to generate ALL the code for it. Which you can verify by issuing the following command −įinally, you have SQLite command prompt where you can issue SQLite commands for your exercises.I did a similar exercise recently when I needed to make a fairly basic rest API and CRUD frontend using 2 frameworks I wasn't particularly familiar with. The above procedure will end with SQLite installation on your Mac OS X machine. Step 1 − Go to SQLite download page, and download sqlite-autoconf-*.tar.gz from source code section. Though the latest version of Mac OS X comes pre-installed with SQLite but if you do not have installation available then just follow these following steps − The above command will end with SQLite installation on your Linux machine. Step 1 − Go to SQLite download page and download sqlite-autoconf-*.tar.gz from source code section. Following are the following steps to install SQLite − If you do not see the above result, then it means you do not have SQLite installed on your Linux machine. So you just issue the following command to check if you already have SQLite installed on your machine. Today, almost all the flavours of Linux OS are being shipped with SQLite. Step 4 − Add C:\>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3 command, which should display the following result.Įnter SQL statements terminated with a " " Step 3 − Create a folder C:\>sqlite and unzip above two zipped files in this folder, which will give you f, sqlite3.dll and sqlite3.exe files. Step 2 − Download sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip zipped files. Step 1 − Go to SQLite download page, and download precompiled binaries from Windows section. This chapter will take you through the process of setting up SQLite on Windows, Linux and Mac OS X. SQLite is famous for its great feature zero-configuration, which means no complex setup or administration is needed. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |