DBNess

Keybase proof

I hereby claim:

• I am dbness on github.
• I am dbness (https://keybase.io/dbness) on keybase.
• I have a public key whose fingerprint is 660E B59D 0B1E 88E3 37E4 5BE8 F7C3 0F4E 1E3B B078

To claim this, I am signing this object:

DBNess

Are you good at organizing life? Then do I ever have a challenge for you. I'm looking for a part-time personal assistant. Here are some things I need:

• Scheduling personal and professional appointments and calls.
• Managing speaking event invitations and associated travel plans.
• Helping to organize side projects and volunteers.
• Communicate scheduling and needs to my childcare providers.
• Run small errands as needed.

Because my work, speaking and side projects tend to revolve around software design/development, technology education and diversity within the industry, having an interest and/or experience in these areas would be beneficial. I'm also more than willing to offer mentorship.

DBNess

def child?
  self.connection.select_value("SELECT CASE WHEN tableoid::regclass::text = 'child_table' THEN 'true' ELSE 'false' END as child FROM parent_table WHERE id = #{self.id};")
end

DBNess

kern.sysv.shmmax=974172160
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64
kern.sysv.shmall=974172160

DBNess

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
# "#" anywhere on a line.  The complete list of parameter names and allowed

DBNess

--Updates all serial sequences for ID columns only
CREATE OR REPLACE FUNCTION update_id_sequences()
	RETURNS boolean AS
$BODY$
DECLARE table_record record;
DECLARE table_name text;
DECLARE update_sql text;

BEGIN
FOR table_record IN SELECT pc.relname FROM pg_class pc WHERE pc.relkind = 'r' AND EXISTS (SELECT 1 FROM pg_attribute pa WHERE pa.attname = 'id' AND pa.attrelid = pc.oid) LOOP

DBNess

SELECT datname as database
, procpid as process_id
, current_query
, (current_timestamp - query_start) as duration
FROM pg_stat_activity
ORDER BY database, duration desc