Skip to content

Instantly share code, notes, and snippets.

Avatar
💩
(╯°□°)╯︵ ┻━┻

Enrique Zamudio chochos

💩
(╯°□°)╯︵ ┻━┻
View GitHub Profile
@chochos
chochos / table_function_no_errors.sql
Created Jul 22, 2019
Version 2 of using a table function instead of a view, this time no errors are thrown anywhere.
View table_function_no_errors.sql
CREATE TABLE foo(
some_id SERIAL PRIMARY KEY,
another INT,
stuff VARCHAR(20)
);
CREATE OR REPLACE FUNCTION insert_crap_into_foo() RETURNS INTERVAL AS
$$
DECLARE
counter INT := 0;
@chochos
chochos / table_function_instead_of_view.sql
Created Jul 22, 2019
Using a table function instead of a view.
View table_function_instead_of_view.sql
CREATE TABLE foo(
some_id SERIAL PRIMARY KEY,
another INT,
stuff VARCHAR(20)
);
CREATE OR REPLACE FUNCTION insert_crap_into_foo() RETURNS INTERVAL AS
$$
DECLARE
counter INT := 0;
@chochos
chochos / issue_with_postgres_views.sql
Created Jul 22, 2019
Cannot alter a column used in a view, need to drop the view first.
View issue_with_postgres_views.sql
CREATE TABLE foo(
some_id SERIAL PRIMARY KEY,
another INT,
stuff VARCHAR(20)
);
CREATE OR REPLACE FUNCTION insert_crap_into_foo() RETURNS INTERVAL AS
$$
DECLARE
counter INT := 0;
@chochos
chochos / PlainThreads.java
Created Oct 17, 2018
Threads & Thread Pool Executors
View PlainThreads.java
public class PlainThreads {
public static void main(String... args) {
for (int i = 0; i < 100; i++) {
new Thread(new Task1()).start();
}
}
}
@chochos
chochos / root types.ceylon
Created Jun 14, 2017
Definition of the root types in Ceylon
View root types.ceylon
//Anything can only have two subtypes: Object and Null
shared abstract class Anything() of Object | Null {}
shared class Object() extends Anything() {}
//Null can only have one instance, called null
shared abstract class Null()
of null
extends Anything() {}
@chochos
chochos / module.ceylon
Created Jun 27, 2016
Using npm from Ceylon
View module.ceylon
module test "0.1" {
import "npm:uuid" "2.0.2";
}
View BraindeadServer.groovy
class BraindeadServer {
int port
private ServerSocket server
String response
void start() {
server = new ServerSocket(port)
byte[] buf = new byte[128]
new Thread({->
@chochos
chochos / Skip.java
Created Sep 24, 2015
Skip `final` in Java
View Skip.java
import java.lang.reflect.*;
public class Skip {
public final String s;
public Skip(String s) {
this.s=s;
}
public static void main(String... args) throws Exception {
Skip me = new Skip("Initial");
View Zurg.ceylon
class Toy(shared String name, shared Integer time) {
string="``name`` (takes ``time``m)";
}
Comparison sortFast(Toy a, Toy b)
=> a.time<=>b.time;
Toy[2] fastestPair([Toy*] gang) {
assert(nonempty g=gang.sort(sortFast),
nonempty r=g.rest);
@chochos
chochos / Permutator.ceylon
Created Sep 2, 2015
Permutator in Ceylon
View Permutator.ceylon
shared class Permutator<out Element>({Element*} source) satisfies Iterable<{Element*}> {
shared actual Iterator<{Element*}> iterator() {
value elems = source.sequence();
if (elems.size>1) {
value arr = Array(source);
value idxs = Array(0..arr.size);
void swap(Integer i, Integer j) {
if (exists ei=arr[i], exists ej=arr[j]) {
arr.set(i,ej);