Dhanesh Kasinathan dhanesh-ideas2it
dhanesh-ideas2it
/ sqlit table dump to csv file
Created
August 3, 2016 08:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sqlite> .header on | |
| sqlite> .mode csv | |
| sqlite> .once c:/work/dataout.csv | |
| sqlite> SELECT * FROM tab1; | |
| sqlite> .system c:/work/dataout.csv |
dhanesh-ideas2it
/ installing latest node via binary
Last active
August 18, 2016 06:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Install | |
| wget https://nodejs.org/dist/v6.3.1/node-v6.3.1-linux-x64.tar.xz | |
| cd /usr/local | |
| tar --strip-components 1 -xJf ~/Downloads/node-v6.3.1-linux-x64.tar.xz | |
| //Verify | |
| node -v | |
| npm version |
dhanesh-ideas2it
/ installing maven on ubuntu
Last active
August 18, 2016 06:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo apt-get purge -y maven | |
| wget http://apache.cs.utah.edu/maven/maven-3/3.3.9/binaries/apache-maven-3.3.9-bin.tar.gz | |
| tar -zxf apache-maven-3.3.9-bin.tar.gz | |
| sudo cp -R apache-maven-3.3.9 /usr/local | |
| sudo ln -s /usr/local/apache-maven-3.3.9/bin/mvn /usr/bin/mvn |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://sourcedigit.com/15249-how-to-fix-e-could-not-get-lock-varlibaptlistslock-or-lock-varlibdpkglock-problem/ |
dhanesh-ideas2it
/ docker pg_dump
Last active
August 18, 2016 06:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| docker exec <container_name> pg_dump --column-inserts --data-only <schema_name> inserts.sql |
dhanesh-ideas2it
/ Docker installation on ubuntu 14.04
Last active
August 18, 2016 06:25
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo apt-get -y update | |
| sudo apt-get -y install apt-transport-https ca-certificates | |
| sudo apt-get install linux-image-extra-`uname -r` | |
| sudo apt-key adv --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D | |
| echo "deb http://apt.dockerproject.org/repo ubuntu-trusty main" | sudo tee /etc/apt/sources.list.d/docker.list | |
| sudo apt-get -y update | |
| test: | |
| apt-cache policy docker-engine |
dhanesh-ideas2it
/ docker images save & load
Created
June 17, 2016 09:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| You will need to save the docker image as a tar file: | |
| docker save -o <save image to path> <image name> | |
| sudo docker save -o /home/ubuntu/xenial-java8 xenial-java8 | |
| Then copy your image to a new system with regular file transfer tools such as cp or scp. After that you will have to load the image into docker: |
dhanesh-ideas2it
/ install latest version of git on ubuntu
Created
June 13, 2016 06:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo apt-add-repository ppa:git-core/ppa | |
| sudo apt-get update | |
| sudo apt-get install git |
dhanesh-ideas2it
/ uninstall postgres completely
Created
June 10, 2016 13:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu | |
| 1. apt-get --purge remove postgresql\* | |
| to remove everything PostgreSQL from your system. Just purging the postgres package isn't enough since it's just an empty meta-package. | |
| Once all PostgreSQL packages have been removed, run: | |
| 2. rm -r /etc/postgresql/ | |
| 3. rm -r /etc/postgresql-common/ | |
| 4. rm -r /var/lib/postgresql/ |
dhanesh-ideas2it
/ error: generics are not supported in -source 1.3 maven
Created
June 10, 2016 11:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| add below plugin in pom.xml | |
| <plugin> | |
| <groupId>org.apache.maven.plugins</groupId> | |
| <artifactId>maven-compiler-plugin</artifactId> | |
| <version>3.5.1</version> | |
| <configuration> | |
| <source>1.8</source> | |
| <target>1.8</target> | |
| </configuration> |
NewerOlder