Alex3917

worker_processes 1;

user nginx;
error_log  /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;

events {
  worker_connections 1024; # increase if you have lots of clients
  accept_mutex off; # set to 'on' if nginx worker_processes > 1
}

Alex3917

# In .ebextensions/01_celery.config

files:
    "/etc/systemd/system/celery.service":
        mode: "000644"
        owner: celery
        group: celery  
        content: |
            [Unit]
            Description=Celery Service

singerng

Reasonable default configuration for a web app that uses Django and the following dependencies:

• Pipenv: Python package manager
• Gunicorn: WSGI server
• Nginx: Static webserver passing to gunicorn, handling SSL, etc.
• Systemd: Used to load Gunicorn on startup

This is my goto for setting up projects.

shmup

HN thread: https://news.ycombinator.com/item?id=14910561 "How to find a remote job"

• https://unicornhunt.io/ ~ From the peeps behind Silicon drinkabout, it's got a good balance of startups, remotes and SMEs roles.
• I recently created Remote Friendly - https://remotefriendly.work - that is a jobs board for remote jobs. It doesn't have many listings right now as I've consciously chosen not to recycle postings from other boards to pad it out. I usually charge $20 but it's currently free to add a listing (and will be for a while).
• I like https://whoishiring.io/
• For U.S., the one that worked the best for me is https://stackoverflow.com/jobs
• I've also had descent results from the aggregator http://indeed.com
• https://angel.co/jobs
• https://angel.co/salaries
• https://triplebyte.com/

ololobus

CREATE TABLE large_test (num1 bigint, num2 double precision, num3 double precision);

INSERT INTO large_test (num1, num2, num3)
  SELECT round(random()*10), random(), random()*142
  FROM generate_series(1, 20000000) s(i);

EXPLAIN (analyse, buffers) 
SELECT num1, avg(num3) as num3_avg, sum(num2) as num2_sum 
FROM large_test
GROUP BY num1;

AndreasS2501

On Blockchains - Postcapitalism - in response to: Postcapitalism by Jamie Dobson https://www.youtube.com/watch?v=MGdQnL4-H9M

An impossible thought?

But what do we want to think? I think many people want the same thing (see maslov pyramid of needs). But the ever interesting question in the history of humanity was: How to do that so that there exists an equilibrium between all humans (society) and the rest of the planet (nature). Personally I see post-capitalism as a part of a solution for that, but economy is only one thing that should change. To conceive such a complex balance is not a simple thing. Alan Kay often talks about how the internet has some biological ideas in it and yes I think to achieve that balance we need some kind of network organism where everyone is connected and heard. Even nature. So lets focus on that, the impossible thought: How can we live together in peace and prosperity with each other and nature? Sometimes, somehow this reminds me of the https://en.wikipedia.org/wiki/K

simonw

git archive --format=tar.gz -o /tmp/my-repo.tar.gz --prefix=my-repo/ master

More detailed version: https://til.simonwillison.net/git/git-archive

Kartones

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

unruthless

General guidelines for designing HTML email templates.

Questions and comments welcome anytime – thanks for reading!

KEY TAKEAWAY:

• Coding for HTML emails is like coding for Internet browsers from 10 years ago. (It’s the email clients’ — Outlook, etc. — fault.)
• Picture a website from a decade ago: that’s the level of design complexity we can reasonably shoot for.

WIDTH: