.|'''''| || '|| ||` '|| || . '' || || || || || |''|| || ''||'' ||''|| '|| ||` ||''|, || || || || || || || || || || `|....|' .||. `|..' .|| ||. `|..'|. .||..|'
Ian Eure ieure
ieure
/ whoops.org
Created
February 12, 2014 23:04
ieure
/ fun-with-postgres
Created
July 2, 2014 21:30
This file contains 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
| lmao=# CREATE TABLE "DELETE * FROM users" ("TRUNCATE TABLE" TEXT NOT NULL, "DROP DATABASE" TEXT NOT NULL); | |
| lmao=# INSERT INTO "DELETE * FROM users" ("TRUNCATE TABLE", "DROP DATABASE") VALUES ('lol', 'wtf'); | |
| lmao=# SELECT * FROM "DELETE * FROM users"; | |
| TRUNCATE TABLE | DROP DATABASE | |
| ----------------+--------------- | |
| lol | wtf | |
| (1 row) | |
| lmao=# |
ieure
/ killme.scala
Created
July 3, 2014 20:16
This file contains 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
| // kill me | |
| class KillMeWith[W <: Weapon] extends Death { |
This file contains 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
| (defun sql-connect* (connection &optional new-name) | |
| (interactive | |
| (list (sql-read-connection "Connection: " nil '(nil)) | |
| current-prefix-arg) | |
| nil) | |
| (require 'tramp) | |
| (let ((dir (cadr (assoc 'default-directory | |
| (cdr (assoc connection sql-connection-alist)))))) | |
| (if dir | |
| (let ((default-directory dir)) |
ieure
/ gist:66d73d60ae085be91109
Created
May 26, 2015 15:25
This file contains 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
| fermion!ieure:/tmp/hamms$ pip install hamms | |
| Downloading/unpacking hamms | |
| Downloading hamms-1.3.tar.gz | |
| Running setup.py egg_info for package hamms | |
| Downloading/unpacking flask (from hamms) | |
| Downloading Flask-0.10.1.tar.gz (544kB): 544kB downloaded | |
| Running setup.py egg_info for package flask | |
| warning: no files found matching '*' under directory 'tests' |
ieure
/ gist:9f32c1037e1ff74e2ca7
Created
May 26, 2015 17:03
This file contains 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
| I showed Tim around. Ordination certificates. Membership cards. Nearly | |
| completed mechanicals for the cover of the Neo-American Church | |
| Catechism and Handbook. Michael had just done his original drawing of | |
| The Great Seal, showing a three-eyed toad with the motto “Victory Over | |
| Horseshit” below it, and Wendy was whiting out ink spots and smudges. | |
| “I don’t like your motto, Art,” Tim said, looking over her | |
| shoulder. “Victory? Over? Horseshit?” | |
| “What’s wrong with that?” I asked. |
ieure
/ gist:782495cc5a4b954565ad
Created
June 10, 2015 15:21
This file contains 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
| <SchemaCzar> CHALLENGE QUESTION: what is the precision of a timestamp without time zone ? | |
| <ieure> SchemaCzar, Nanoseconds. | |
| <ieure> SchemaCzar, I know this because JVM timestamps only support milliseconds. So if you have a psql TS column and move that data into the JVM, you lose precision. | |
| <ieure> And this caused Bugs | |
| <SchemaCzar> and I'm trying to use that point to convince my team to convert from timestamp with no time zone to timestamp with time zone | |
| <ieure> SchemaCzar, You're the fucking Schema Czar. Just change it. |
ieure
/ gist:141615
Created
July 6, 2009 19:03
This file contains 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
| ieure!neutron:~/Projects/Cassandra$ nosetests | |
| EEEEEEEEFEFEFEFEFEFEFEFEEFEFEFEFEFEFE | |
| ====================================================================== | |
| ERROR: system.test_server.TestMutations.test_bad_calls | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "/opt/local/lib/python2.5/site-packages/nose/case.py", line 366, in tearDown | |
| try_run(self.inst, ('teardown', 'tearDown')) | |
| File "/opt/local/lib/python2.5/site-packages/nose/util.py", line 453, in try_run | |
| return func() |
ieure
/ gist:141649
Created
July 6, 2009 20:09
This file contains 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
| ieure!neutron:~/Projects/Cassandra$ sh -x bin/cassandra -p cassandra.pid | |
| + '[' x = x ']' | |
| ++ dirname bin/cassandra | |
| + for include in /usr/share/cassandra/cassandra.in.sh /usr/local/share/cassandra/cassandra.in.sh /opt/cassandra/cassandra.in.sh '`dirname $0`/cassandra.in.sh' | |
| + '[' -r /usr/share/cassandra/cassandra.in.sh ']' | |
| + for include in /usr/share/cassandra/cassandra.in.sh /usr/local/share/cassandra/cassandra.in.sh /opt/cassandra/cassandra.in.sh '`dirname $0`/cassandra.in.sh' | |
| + '[' -r /usr/local/share/cassandra/cassandra.in.sh ']' | |
| + for include in /usr/share/cassandra/cassandra.in.sh /usr/local/share/cassandra/cassandra.in.sh /opt/cassandra/cassandra.in.sh '`dirname $0`/cassandra.in.sh' | |
| + '[' -r /opt/cassandra/cassandra.in.sh ']' | |
| + for include in /usr/share/cassandra/cassandra.in.sh /usr/local/share/cassandra/cassandra.in.sh /opt/cassandra/cassandra.in.sh '`dirname $0`/cassandra.in.sh' |
ieure
/ gist:142960
Created
July 8, 2009 16:44
This file contains 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
| .EEEEEEEEFEEEFEEEEEE.EEEEEEEEEEE | |
| ====================================================================== | |
| ERROR: system.test_server.TestMutations.test_batch_insert | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "/opt/local/lib/python2.5/site-packages/nose/case.py", line 182, in runTest | |
| self.test(*self.arg) | |
| File "/Users/ieure/Projects/cassandra-trunk/test/system/test_server.py", line 126, in test_batch_insert | |
| _verify_batch() | |
| File "/Users/ieure/Projects/cassandra-trunk/test/system/test_server.py", line 45, in _verify_batch |
OlderNewer