Tuesday, January 15, 2019

Important SQL Query - Ready Reckoner

1. For Displaying records:

select * from [table_name];

select * from [table_name] where [field_name]='1';

2. Deleting specific records:

delete from [table_name] where [field_name]>0;

3. Insert Records

insert into [table_name] (field1, field2, field3,...) values (value1, value2, value3,...);

insert into [table_name] values (value1, value2, value3,...);

4. Update Records:

update [table_name] set [field1]=[new_value] where [field2]="1";

Friday, January 4, 2019

Enable offline mode to improve Android Studio speed

If you are starting with Android Studio or have upgraded to the newer version of Android studio, you might experience, the IDE sometimes gets stuck or freezes during the process of compilation.

This might be probably the gradle is working online and trying to download. There are many ways available to boost up the performance of Android Studio, one of them is by enabling Offline Work Mode.

You can achieve significant performance boost by enabling offline mode in Android Studio. Here are the steps to do that:

Please note, I am currently using Android Studio 3.2.1

1. Go to File> Settings.

2. In Settings dialog box, Go to Build, Execution and Deployment section. Under that go to Gradle section.

3. Check the box which mentions "Offline Work" as shown in the below image and click on Apply button.

Gradle Offline Work

4. Next go little below under Compiler section and check for the text input area which mentions "Command-line Options.

5. In the command-line Options type, "--offline" and click on "Apply" button and finally click on "OK" button to save all changes.

Now you should see certain improvement in the performance of android studio.

URL Redirection scenarios to be tested while installing SSL Certificates

If you are trying to install SSL certificates for the first time. Do ensure to test all possible scenarios of URL direction Ensure ht...