jgcasta

#!/usr/bin/python
#-*- coding: utf-8 -*-

'''
    Jose Gomez Castano
    jgcasta@gmail.com
    
    Socket server to receive binary data and parse the content as integer and string values

    Sample packet 030b94 received is decoded as decimal string values

jgcasta

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

jgcasta

git add .
git commit -m "commit messge"
git push origin master


git tag -a 0.1.0 -m "tag message"
git push --tags

# delete local tag

jgcasta

Configuration

sudo nano /etc/systemd/system/app.service

Edit file content

[Unit]
Description=APP name service

jgcasta

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:util="http://www.springframework.org/schema/util"
	xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
      http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd">

	<bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location">

jgcasta

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

jgcasta

#!/bin/bash          

#
#  createvm.sh
#
#	ver 1.0
#
#	Jose Gomez Castaño jgcasta@gmail.com
# 
#	Create a Virtual Box Machine in the createPath directory with the name given in name variable. 

jgcasta

#Simple MongoDB Security Tutorial

###1 - Start mongod without any "security option"

$ mongod --port 27017

jgcasta

wget https://www.python.org/ftp/python/3.6.0/Python-3.6.0.tgz
tar xvf Python-3.6.0.tgz
cd Python-3.6.0
./configure --enable-optimizations
make -j8
sudo make altinstall
python3.6

jgcasta

#!/usr/bin/env python
# -*- coding: utf-8

'''
	GEt TLE orbital elements for a Satellite

	@author Jose Gomez Castaño jgcasta@gmail.com
	@version 1.0.0

	@precondition username and password to login into www.space-track.org website is needed