Category: Web Development
Postgresql | How to save default timestamp in unix format instead of yyyy-dd-mm hh:mm:ss
In Postgresql we can save the default timestamp with now() method: CREATE TABLE test ( id serial NOT NULL, name character varying(255), last_modified_time timestamp without time zone DEFAULT now() ) This will save the date timestamp in this format: If
Adding images and links in Jira
Adding images and links in Jira 1. Adding an image in Jira comment: There are two ways using which we can insert an image in Jira: User can specify various attributes to the image such as height, width, horizontal space,
An example of Ajax to display dyanamic images and text on webpage
Whenever the situation occurs to rerender the page contents without reloading the whole page, we use ajax in it. By using ajax we get the response data back in the success function which we will show on the screen. Let’s
AWS | How to share snapshot with another aws account?
1. Log on to AWS console account. 2. Click on Snapshot option:  3. Right Click on the desired snapshot ID and select Modify permissions: 4. Select the option whether to share it publicly or you can share it in
MySQL | Enable/Disable Auto Commit
How to enable or disable autocommit of changes in MySQL using MySQL workbench? Go to Edit->Preferences->SQL Editor->SQL Execution and check your current settings: Also commit/rollback can be done with the buttons on SQL tab:
Salesforce | Set custom RecordType in case of web to lead
Situation: We have a web to lead form and every time we create a lead it always takes “Personal” as record type which is default record type in our org. We want to set another recordType like Agentco or Trucking
AWS | Upgrading mysql version
AWS: Upgrading MySQL version Below are few step to upgrade Mysql version very easily on AWS-RDS: 1. Log on to AWS console. 2. Open AWS RDS from Database section: 3. Click on Instances: 4. Select the Database Instance which you
Configuring Web Distribution and Load Balancer in AWS
Using tools and steps listed below we can implement web distribution and Load balancer in AWS and also this will save cost of buying ssl certificate from CA authorized vendors. Instead, it will use certificates provided by Amazon server. Tools
C# – Convert output of a Web request into an object list
WebRequest gives response in the form of Stream. In order to use it further in the form of c# object, I have used below code: Sample code : WebRequest requestHttp = WebRequest.Create(reqURL); using(WebResponse responseHttpRequest = requestHttp.GetResponse()) { Stream responseStream =