How are AI tools helping solve real, complex, and time-consuming problems faster?

-
Nowadays, almost everyone is either using AI tools or thinking about incorporating them into their daily work. At the same time, many professionals are still hesitant, worrying that AI might replace their jobs. While those concerns are understandable, I believe the bigger risk is ignoring these tools altogether. From my experience, AI isn't replacing engineers—it is helping engineers work faster and focus on solving more meaningful problems. Like any other tool, its value depends on how effectively we use it. The more we learn to collaborate with AI, the more productive and efficient we can become. Here are two real examples from my recent work where AI tools helped me solve complex and time-consuming engineering problems significantly faster. AI helped me audit and upgrade my project's tech stack by checking dependency compatibility and flagging version-specific issues in advance. Instead of manually reviewing every package and verifying the latest compatible versions, I was ...
Post a Comment

LEAST() and GREATEST() - Postgres SQL Amazing But Rarely Known Functions .

-
PostgresSQL is very powerful and one of the world's most advanced open-source relational databases. It gives much more flexibility and customization on query level when you want to perform a complex operation or complex queries on the database. Postgresql provides multiple operators and functions which make even complex operations and complex queries pretty easy and simple. Similarly LEAST() and GREATEST() are functions that make your work very easy and simple.

LEAST() and GREATEST() functions are very useful when you want to operate on different columns within the same row (a record) in a table. LEAST() and GREATEST() compare and find the minimum and maximum value respectively among given columns values in the same row. It's similar to finding a minimum or maximum value from an array of given values.

Here are a few simple examples you can try:
select LEAST(5, 3, 9, 2, 8, 1) and GREATEST(5, 3, 9, 2, 8, 1);
//should give 1 and 9 respectively

In-case of String or Varchar, it gives you results by sorting values alphanumerically:
select LEAST(ball, hockey, football, cricket) and GREATEST(ball, hockey, football, cricket);
//should give ball and hockey respectively.

There are few conditions MUST be satisfied when you are using LEAST() or GREATEST() functions in your query:
1. Columns on which you want to apply function MUST be of same data type OR values MUST of the same type i.e. numeric or string or decimal etc.
2. If there is any column which is having different types of data types among others, you can use casting to convert values to the common data type. like: CAST(column name as datatype)

Use:

There are many use-cases of using LEAST() and GREATEST() in your query when you have to filter records comparing values within a row itself.
 
Consider a case, when you have a car subscription system in which a car can have multiple prices offers base on the subscription term or period. But when you list your cars on the landing page and you have to show the minimum price only among all given offer prices for a car. Given all prices, variation is saved in the same row with other car details.
You can have a query to do that :

select car_name, LEAST(month_price, six_month_price, nine_month_price, one_year_price) from cars;
//given all price having per month value.

In another case, consider database table student_marks in which each subject represented by column i.e. maths, science, history, english, hindi, student_id (foriegn_key).
Now when you have to find student list with their least and maximum marks in any subject, you can write your query like:

select student_id, LEAST(maths, science, history, english, hindi) as least_marks, GREATEST(maths, science, history, english, hindi) as maximum_marks from student_marks;

Similarly can find student having merit in all subject.

select student_id from student_marks where LEAST(maths, science, history, english, hindi) > 60;

I hope when you come across any similar situation like this, these functions LEAST() and GREATEST() will help you a lot to keep code clean and simple.

Feel free to leave your comments as feedback or in case you have any queries.




A man with small desires, likes things in simple conditions, loves god creation, feels pleasure to help someone needy.
Professional: Software Developer (PHP) (5+ yrs) with good hands in latest technologies and Frameworks like Laravel Cakephp 3, CodeIgniter, Wordpress, Core PHP, MySQL, PgSql, jQuery.

Comments

Post a Comment

Popular posts from this blog

Differences between json and jsonb - JSON data type in PostgreSQL

-
You may have read differences between PostgreSQL datatypes JSON and JSONB. If not, let see the difference between both theoretically and practically. Although, both json and jsonb are types of PostgreSQL JSON datatypes and accepts almost same format as input values i.e. json. But still there are some difference which one must know to efficiently use or can choose from both json and jsonb.  The main different is how they actually store data; the json data type stores input value as it is but  jsonb stores value in a decomposed binary format which lead to difference in  efficiency .  Jsonb is slower as compare to json while saving the input values because of converting json values to binary format before saving. Jsonb fast in processing the data because no re-parsing needed as compare to json datatype which needs processing function to re-parsing on every execution. Few other differences between json and jsonb are: Jsonb supports indexing which is advantage over j...
Read more

Laravel Validation - Unique rule with multiple column and condition.

-
Today I am going to share, How we can use Laravel validation rule `unique`. If you have worked with laravel and familiar with laravel validation, you must know what does 'unique' rule checks. If not let me give here a brief about this. In simple words, It is similar to a unique key constraint applied to a column in the database table. 'Unique' rule check there is no similar value exists in the given database table column, to value matching with the provided input value. The general format of the rule is: unique:table //when input name is similar to column name OR unique:table,column OR unique:Model,attribute Examples: 'email' => 'unique:users' //here users is table name OR 'email' => 'unique:c,email_address' //can give custom column name. OR 'email' => 'unique:User,email'  //here User is a model class This is a very simple usage ...
Read more

Using Virtual Columns in Laravel - Accessors and Appends

-
What are virtual columns?  While developing any web application sometimes we need virtual columns - columns don't actually exist in our DB table, but we drive them from other columns. Why we need them? For example, generally, we use first_name and last_name  in the  users table. But sometimes we also need user's complete name i.e. full_name . There is no benefit of saving full_name in user table if we have already first_name and last_name in the table OR even if we have full_name  as a column in our table then there is no benefit of saving first_name and last_name in the table. So in a scenario like this, we prefer to use the virtual column. Using Virtual Columns in Laravel Considering the first case, in Laravel to get virtual column i.e.  full_name  from the users table will have Accessors. Accessors are methods defined automatically called by Eloquent when select is called on that particular column. Let take an example here: To get full_...
Read more