dchess

I feel like this is what delta lake and ducklake are largely solving for. And then some.

It's not particularly secure but in a pinch I just use the python standard lib server to start an http server in a folder then open up the port with ngrok temporarily to share the file. Security through obscurity for a very discreet time period works.

Sounds like your team/company needs to establish SLAs. When it comes to troubleshooting the important timelines to commit to are communication timelines. First response with X hours. Updates every Y hours/days depending on severity/priority. You'll also want a clear process for establishing the criteria for diagnosing priority and what escalation paths should be when there are roadblocks.

How does this compare to Dokku?[1] I've been using that for a few years now with minimal lift/maintenance. I'm wondering what the trade-offs are of something like this?

[1]: https://dokku.com/

I haven't seen anyone mention: dokku [1], but I've had good luck using dokku droplets on digital ocean for a simple Heroku alternative.

[1] https://github.com/dokku/dokku

The Django Girls tutorial is a nice starter tutorial for beginners.

https://tutorial.djangogirls.org/en/

Have you tried Heroku? Deploying via git is pretty handy. I've mostly moved to using Dokku on the $5 tier of DigitalOcean, but the approach is simple.

What's Yuck about using aliases? I use those extensively. Is that a bad practice?

As someone that works in K-12 technology (and has for 15 years), the real monopolies aren't the tech giants, they're the Pearsons and Houghton Mifflins of the world that buy out competitors and lock school districts into platforms they can't escape without substantial migration costs.

And don't even get me started on the way they have kept education hostage to high stakes tests.

Couldn't agree more. This article fails the "so what" test. What are they recommending be done instead?

I was reminded of this resource as well since it is likewise what I use in training folks to use git. This OPs post seems to be a condensed version of Chris's advice.

I don't see the benefit of putting table names on a different line than the keyword.

How is this:

  FROM
    tablename t
  INNER JOIN
    other_table ot
  ON
    t.id = ot.id

More readable than:

  FROM tablename t
  INNER JOIN other_table ot
    ON t.id = ot.id

I agree with a lot of these recommendations, but this one irks me. Also I'd love if someone could create a nice code-formatter for SQL like Python's Black.

I usually go with one of the following: "Is there a reason you didn't do X?" or "Could you use X here?" or "Have you considered using X?"

I don't. Who knows what that little maniac is up to? I mean, why is he mapping my house?

My dog knows what's up. He is not a fan of Roomba.

Presumably, this is a case of "listen to your body." People's metabolisms work differently and what works for one person may not necessarily work for everyone.

Aspire Public Schools | Data Engineer | Oakland, CA| Full time, ONSITE

Aspire Public Schools operates 40 high-performing, college-preparatory public charter schools serving 16,000 students in under-served communities across California and in Memphis, Tennessee. Founded in 1998, Aspire is one of the nation’s largest open-enrollment public charter school systems serving predominantly low-income students, and delivering a rigorous College for Certain education to students in grades K-12.

We are looking for a mid-senior level data engineer to support our data warehouse and data integration infrastructure. We work primarily in python and MS SQL (with some PostgreSQL for our web apps).

You learn more about the position and apply here: http://jobs.jobvite.com/aspirepublicschools/job/oUSg7fwT

As a programmer approaching mid-life, I haven't found myself succumbing to this crisis. I wonder if that is largely due to the fact that gaining and maintaining expertise in programming is much more akin to these atelic activities he discusses. You can never really be done improving your skills.

Projects come and go, but the buzz and hum of the new is constant and unreachable. For an autodidact like me, the thrill of learning something new is also a process I enjoy.

Does anyone know if this will support running SQL Server Management Studio? That's the only thing keeping me using Linux in a VM instead of as my main.

Seems like the simple, "Nice work!", fits the bill.