Skip to content

Instantly share code, notes, and snippets.

View papandreou's full-sized avatar
💭
🤗

Andreas Lind papandreou

💭
🤗
View GitHub Profile
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active November 14, 2024 09:13
Useful PostgreSQL Queries and Commands
-- 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%'
@tmpvar
tmpvar / gist:821964
Created February 11, 2011 05:25
changes to jsdom since last release (0.1.23)
[test] added test for env method (hij1nx)
[text] formatting updates (hij1nx)
[test/api] added env export to easily set up a dom+resource environment/closure, detatched tests added not complete (hij1nx)
FIXED: undefined reference (parent) (Elijah Insua)
DocumentType.toString: Generate a valid <!DOCTYPE> string in all cases where the DocumentType is valid. Won't include the internal subset (yet). Also, if the full DOCTYPE string is already known, just return it immediately without all the fuss of generating one. (Daniel Cassidy)
Having a doctype is not a requirement for removing namespaced attributes (Sam Ruby)
Fix broken bugfix URL. (Daniel Cassidy)
adding Daniel Cassidy to the contributers (Elijah Insua)
Fix createEntityReference to behave correctly when the document has no doctype (fixes failing test case nodenormalize01). (Daniel Cassidy)
createDocument: don't create a doctype automatically. If the caller doesn't pass in a doctype, create a document with no doctype. (Daniel Cassidy)