SEEKING WORK | PA, USA | REMOTE Open to short-term or long-term. Potentially open to relocation. Email: contact@armichael.com Resume: www.armichael.com/armichael_resume.pdf Hi, I'm Andrew. I have experience doing…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Linux, PostgreSQL, Python, Emacs, Docker +…
Declaring a function with `lambda` prepends runtime nil checks for each argument to the function body (excluding optional args-- specified with a question mark, eg. `?x`-- and variable arguments, eg. `...`[1]). This…
+1. And the subset of those applications concerned with simply converting result sets <-> JSON over HTTP may well even tolerate use of an API generator (eg PostgREST, PostGraphile, Hasura), reducing that thin layer to…
>with an arbitrary function instead of MAX Many systems support user-defined aggregates[0][1] [0] https://www.postgresql.org/docs/current/sql-createaggregate.... [1]…
>functions that take sets as input and produce arbitrarily different sets as output It is possible to return arbitrary sets from functions in many systems-- recent versions of the SQL standard even specify table…
Most (non-gigascale) applications that are non-trivial enough to use a relational database in the first place will benefit from using foreign key constraints (ie delegating enforcement of foreign key relationships to…
>when you do the same in other languages you get... Your result should be unsurprising. Lisps have a minimal syntax that naturally entails high levels of nesting: (s-)expressions being used to represent functions,…
Anecdotal datapoint: after discovering this article a long time ago, I adopted the sleeping posture in figure 2.2 (bring it on, insects) for many years. Mattress topper on the floor-- while traveling, only a folded…
Yeah, this is a thing. To enjoy years of stability on Arch[0]: - occasionally upgrade your system - before upgrading, glance at https://archlinux.org/news/ to see if anything requires manual intervention [0] I use Arch…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: PostgreSQL, Python, Emacs, Linux, GNU Make,…
If you're interested in diagramming system architecture in a top-down fashion, I'll pile on another recommendation to check out the C4 model[0]. As others have mentioned, to effectively communicate a system you must…
Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Python, PostgreSQL, SQL (ANSI, PL/pgSQL, PL/SQL), Emacs, Linux (general sysadmin tasks, shell + coreutils, etc.), Bash, GNU Make, Docker +…
HN in 2023: "Conventional Codetags: a specification for structured TODO comments"
It appears that docker cli will also eventually remove the short option for help. Their reasoning for it is to avoid conflicts with args (eg hostname '-h') in certain subcommands.[0][1] But I don't see why they couldn't…
> local notes solution ... published on the web ... crosslinked Definitely a lot of ways to go about this. If you haven't already, I'd suggest checking out what the creator of org-roam does for publishing his own notes:…
SEEKING WORK | PA, USA | REMOTE Open to short-term or long-term. Potentially open to relocation. Email: contact@armichael.com Resume: www.armichael.com/armichael_resume.pdf Hi, I'm Andrew. I have experience doing…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Linux, PostgreSQL, Python, Emacs, Docker +…
SEEKING WORK | PA, USA | REMOTE Open to short-term or long-term. Potentially open to relocation. Email: contact@armichael.com Resume: www.armichael.com/armichael_resume.pdf Hi, I'm Andrew. I have experience doing…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Linux, PostgreSQL, Python, Emacs, Docker +…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Linux, PostgreSQL, Python, Emacs, Docker +…
Declaring a function with `lambda` prepends runtime nil checks for each argument to the function body (excluding optional args-- specified with a question mark, eg. `?x`-- and variable arguments, eg. `...`[1]). This…
+1. And the subset of those applications concerned with simply converting result sets <-> JSON over HTTP may well even tolerate use of an API generator (eg PostgREST, PostGraphile, Hasura), reducing that thin layer to…
>with an arbitrary function instead of MAX Many systems support user-defined aggregates[0][1] [0] https://www.postgresql.org/docs/current/sql-createaggregate.... [1]…
>functions that take sets as input and produce arbitrarily different sets as output It is possible to return arbitrary sets from functions in many systems-- recent versions of the SQL standard even specify table…
Most (non-gigascale) applications that are non-trivial enough to use a relational database in the first place will benefit from using foreign key constraints (ie delegating enforcement of foreign key relationships to…
>when you do the same in other languages you get... Your result should be unsurprising. Lisps have a minimal syntax that naturally entails high levels of nesting: (s-)expressions being used to represent functions,…
Anecdotal datapoint: after discovering this article a long time ago, I adopted the sleeping posture in figure 2.2 (bring it on, insects) for many years. Mattress topper on the floor-- while traveling, only a folded…
Yeah, this is a thing. To enjoy years of stability on Arch[0]: - occasionally upgrade your system - before upgrading, glance at https://archlinux.org/news/ to see if anything requires manual intervention [0] I use Arch…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: PostgreSQL, Python, Emacs, Linux, GNU Make,…
"You're like a laser-guided missile I can point at technical problems" -- a past employer ----- Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: PostgreSQL, Python, Emacs, Linux, GNU Make,…
If you're interested in diagramming system architecture in a top-down fashion, I'll pile on another recommendation to check out the C4 model[0]. As others have mentioned, to effectively communicate a system you must…
Location: Pittsburgh, PA Remote: Yes Willing to relocate: Yes Technologies: Python, PostgreSQL, SQL (ANSI, PL/pgSQL, PL/SQL), Emacs, Linux (general sysadmin tasks, shell + coreutils, etc.), Bash, GNU Make, Docker +…
HN in 2023: "Conventional Codetags: a specification for structured TODO comments"
It appears that docker cli will also eventually remove the short option for help. Their reasoning for it is to avoid conflicts with args (eg hostname '-h') in certain subcommands.[0][1] But I don't see why they couldn't…
> local notes solution ... published on the web ... crosslinked Definitely a lot of ways to go about this. If you haven't already, I'd suggest checking out what the creator of org-roam does for publishing his own notes:…