Full-stack dev quiz question #62
Do you know how to prepare update and rollback SQL scripts with Liquibase that can be provided to a DBA? Check sixty second question of full-stack dev quiz to verify that.
Generate SQL script from Liquibase changelog file
Liquibase is a tool to automate database upgrades starting from a script, through testing, till a deployment to production. However, sometimes we want to take care of deployment ourselves. In that case, the possibility to generate an SQL script is extremely useful.
Full-stack dev quiz question #61/span>
You may create a primary key in a few different ways using Liquibase. Do you know which Liquibase changes support autorollback and which don't? Check sixty first question of full-stack dev quiz to test your knowledge.
Create and manage primary keys
Creating a table is one of the most basic elements of Data Definition Language (DDL). Or a phrase commonly used would be better. There is no useful relational database without tables. Even though tables are very common, creating them isn't the most straightforward operation you can think of. One of the reasons is a primary key. How to create a table with a primary key? How to add or modify a primary key later when a table already exists?
Will AI steal job from software developers?
In November 2022, Open AI released ChatGPT 3. It quickly went viral. Social media is still massively flooded with screenshots and screencasts from the chat. Until now I calmly observed the situation sitting in the corner. But I have recently watched a non-technical video in which the speaker shared his opinion that now developers will lose their jobs, as now ChatGPT can do their tasks. The speaker was not an IT expert in any sense, but that was his impression, and he was sure about what he was saying.
Besides exchanging JSON objects in a request or a response body, REST API can also use files. Doing so is not a big deal when the files are small. Things get a little bit more complicated when we have to respond with a big file. No one wants to keep in memory a few hundred megabytes of data waiting on the client to slowly download it. It must be streamed.
Full-stack dev quiz question #60/span>
Spring REST controller may send a serialized object, raw data or a file. Do you know how to define a file name in that third option? Check sixtieth question of full-stack dev quiz to verify if you know the answer.
Besides working on JSON objects, Spring Boot application can also make files available for downloading via REST API. We can build an application that exposes endpoints that can be used to download raw files, images, CSV files etc. We are not only limited to well-defined objects serialized to a JSON format. See how to do that.
Liquibase published a promotion for a Liquibase Certified Associate Exam. Regular price is $150, so if you use Liquibase, you might be interested in using the coupon and passing the exam.