Skip to content

Instantly share code, notes, and snippets.

@ssinganamalla
ssinganamalla / Node.java
Last active August 29, 2015 14:14
Given a BST and a node (say target), find K nearest neighbors. http://www.geeksforgeeks.org/print-nodes-distance-k-given-node-binary-tree/
package com.mycompany.tree;
public class Node {
public int value;
public Node left;
public Node right;
public int level;
public Node(int value) {
@ssinganamalla
ssinganamalla / renamedb.sql
Created August 27, 2015 01:39
rename database name in postgres
//delete the user sessions
SELECT pg_terminate_backend( pid )
FROM pg_stat_activity
WHERE pid <> pg_backend_pid( )
AND datname = 'oldname';
ALTER DATABASE oldname RENAME TO newname