Skip to content

Instantly share code, notes, and snippets.

View Sykkro's full-sized avatar

Ricardo Sousa Sykkro

View GitHub Profile

Keybase proof

I hereby claim:

  • I am sykkro on github.
  • I am sykkro (https://keybase.io/sykkro) on keybase.
  • I have a public key whose fingerprint is 88F6 E5BB E5A9 1598 00A9 7162 3A7E 51C3 9F10 8986

To claim this, I am signing this object:

@Sykkro
Sykkro / clone.js
Created November 15, 2013 19:28
Clone javascript function
Function.prototype.clone = function() {
var that = this;
var temp = function temporary() { return that.apply(this, arguments); };
for( key in this ) {
temp[key] = this[key];
}
return temp;
};
@Sykkro
Sykkro / select_timestamp.sql
Created November 6, 2013 18:03
PostrgreSQL: display timestamp long value as a human-readable date string
select to_timestamp(timestamp/1000) as date from table;
-- e.g.:
-- to_timestamp(1383760781503/1000) = 2013-11-06 17:59:41+00
@Sykkro
Sykkro / db_backup.sh
Created October 14, 2013 14:27
Backup PostrgreSQL database data
pg_dump --inserts -U [user] -b [db_name] -f [destination_file].sql -h [db_host] -p [db_port]
@Sykkro
Sykkro / dump_schema.sh
Created October 14, 2013 14:15
Dump PostgreSQL database schema (no data)
pg_dump --no-owner --schema-only -h [db_host] -p [db_port] -U [user] -f [destination_file].sql [db_name]
@Sykkro
Sykkro / 1 - archetype
Created July 26, 2013 16:53
Create maven+spring mvc web project
maven-archetype-webapp // [x] Include snapshot archetypes
http://stackoverflow.com/questions/3078438/how-can-i-create-spring-web-project-with-maven-in-eclipse