JSONB (JSON Blob) datatype in Postgres is used to save JSON data. We can search on JSONB type of column after creating an index on it.
Usage in PostgreSQL:
1. Create table and index
CREATE TABLE tests
id integer NOT NULL,
email citext NOT NULL,
address jsonb NOT Read more…
Handling content and image sharing with twitter and google plus share buttons in wordpress
To achieve dynamic content(including image) sharing from a website with share buttons (or links) for share and likes on social sites like twitter and google plus, wordpress requires somewhat more specific functions while creating plugin Read more…
To create a new customized plugin with email functionality and sending a pdf file as attachment requires some simple lines of code with TCPDF library file inside the library directory of moodle. And for performing file operations, filelib.php reference is required. For creating pdf file from HTML content, append Read more…
In software testing, we have various way to identify the bug/defect. Some of them are as given below:
1. Severity Wise:
* Major: When defect affects major functionality. Example: Suppose a Logo text is not Proper that will be affect the company work.
* Minor: When defect Read more…
Google reCaptcha is a free service API provided by Google to protect your site from unauthorized access, abuses and spam. The API uses advanced risk analysis technique to distinguish among a human being and a bot. The reCaptcha API comes in the form of a widget and it can be Read more…
Semantic tags in HTML 5: Semantic tag introduces meaning to the web page rather than just presentation. like and tags are not semantic tags because these are just used for content presentation in the browser.
These are list of semantic tags:
// we should use this tag Read more…
Follow the below steps for the integration of Salesforce and Google drive (to select files from local and upload to Google drive using Salesforce code):
1. Open Google Drive console. Here is the link for console:
2. Select a project. If you Read more…
Let’s say our business hours are from 9am to 6pm (Monday to Friday) and if Lead is created at 5pm on Monday an email alert should be sent to LeadOwner at 12am on Tuesday.
You can set your business hours in Salesforce under Company Profile.
Above requirement can be Read more…
Description: If any customer has been charged for multiple times for the same month then there is an option in chargify to refund back for a particular transaction. So, if we want to refund for duplicate transaction, we can do that from our chargify account by logging in as merchant Read more…
When we need to sort an HTML table on click of any of its column headers then we can use sortable.js:
Download library file sorttable.js.
Add this js file to the current page.
Add sortable class to the table for which sorting is required.
If you Read more…
In wordpress, a child theme is a theme that inherits the functionality and styling of its parent theme.
Child themes are the recommended way of modifying an existing theme (like inheritance in object oriented programming). If we have any theme and we want to modify its header or any other Read more…
Fatal Error on website whenever we were pushing any code change to our website hosted on heroku.
We were suddenly facing a fatal error (error 500) on our website. After making debugger on, it displayed the following error :
After exploring about it, we found that it was due to the Read more…
How to send email using google api (gmail) in cakephp 2.x?
Answer: When you send email using google api, you’ll need:
1. Cakephp 2.x
2. A Google account with Gmail enabled.
3. PHPMailer Library.
Download PHPMailer library from below link:
After downloading Read more…
In one of our projects we have multiple groups of checkboxes and corresponding divs with id as checkbox label. Now we want our checkboxes to perform AND and OR logic .
<div id=”_Java_less than 1500_Basic_Dennis Ritchie” class=”6″ style=”display:none;”> Read more…
MySQL access Denied for user while Username and password is correct.
I got this error when I named one of my table columns as “order” which is also a mysql keyword. When tried to rename it, I got the following error on execution.
ERROR 1045 (28000): Access denied Read more…
Steps to create the communities in Salesforce:
1. Click on Setup:
2. Under customize click on communities. Click on all communities:
3. Click on New community button:
4. Choose your template according to your requirements. There are 5 templates provided by salesforce. In this example, I have chosen Read more…
1. Create apex class that you want to call (it should be declared global):
Global class Test
Webservice static void testMethod()
Note: Webservice method must be static:
Global class Test
Webservice static void testMethod(String IDD)
2. Goto–>Setup–> Read more…
While designing RESTful web services in a Spring-based web application, we may have a requirement that some web services should be allowed to run only from specific IP addresses. Spring framework provides a simple procedure to verify if the incoming IP address in available in the whiteList Address list Read more…
You may face this exception sometimes in Salesforce:
System.LimitException: Too many SOQL queries: 101
There can be multiple reasons for this exception:
Check if SOQL queries are not written in loops
Check if DML are not called inside a loop.
Check if large number of workflows for field update Read more…
Performance testing is used to determine that the web application under test will satisfy high load. Apache Jmeter can be used to analyze overall server machine performance under heavy load.
Apache Jmeter Performance test includes:
* Load Test
* Stress Test
Creating a Performance Test Plan in Jmeter
We are going to Read more…