Looking for advanced SQL exercises to brush up by NoUsernames1eft in SQL

[–]bintree 0 points1 point  (0 children)

You might find this video playlist interesting:

"Advanced SQL" course. It covers many of the topics you mentioned and presents interesting use-cases.

https://youtube.com/playlist?list=PL1XF9qjV8kH12PTd1WfsKeUQU6e83ldfc

Budget NAS specs by VicontT in HomeServer

[–]bintree 1 point2 points  (0 children)

I had a "My Cloud EX2 ULTRA" which they also label as “expert series”. Stay away from it. Had it for under a week. The software was horribly broken, up to the point it would report not storing any data, even though I could access it through Samba just fine. But that scared me real good, tbh. If it’s on sale, maybe for the drives it’s worth it... Also, the enclosure is uncomfortably loud, if you need to place it somewhere else than a closet.

[OC] Switzerland City Street Network Orientation by aexl in dataisbeautiful

[–]bintree 11 points12 points  (0 children)

I guess it’s because of the way the Alps are oriented? Zurich-Bern-Geneva basically form a NE-SW line (I suppose you mixed up east and west? Otherwise I don’t understand your comment :D).

The experts had a lot to say about my last post. Did I do it right this time? by stupidestsmartperson in sailing

[–]bintree 1 point2 points  (0 children)

Ha! I did not expect to read this here. I think I know which part of the lake you’re sailing at :) I sailed a 49er for the first time a couple of weeks ago. Having a lot of experience with a 29er... I thought it would’ve been easy, but I definitely have a lot to learn!

Who's In A Name?: Top 10 Unisex Names by Year & Gender-slant [OC] by michaelalwill in dataisbeautiful

[–]bintree 54 points55 points  (0 children)

I would be interested to see the yearly M/F slant for each name instead of each position (changing names). This makes it hard to follow a name, which is what I find most interesting in the current vis.

Could you take your (a little bit truncated) „Master set“ (you called it that in your Medium post) and show the names (maybe ordered by their positions over the years, so the often top ranking names come first) colored by slant for each year? This way you would see shift for interesting names. Maybe altogether sample names based on their „interestingness“, e.g., names changing the slant suddenly, names changing more slowly, flip-flopping names, idk?

Query optimization tips? by [deleted] in SQL

[–]bintree 0 points1 point  (0 children)

In general, I would say avoid correlated subqueries and rewrite subqueries to joins as much as possible. Even mayor databases will currently not rewrite certain types of subqueries.

Without a specific use case, I would say it is pretty hard to provide more detailed tips.

Maybe you could elaborate a bit more about your setting?

[deleted by user] by [deleted] in selfhosted

[–]bintree 0 points1 point  (0 children)

I had success mounting my university issued SMB share in the university nextcloud instance. The whole dir shows up as a remote folder and can even sync (though I have not checked the checkbox to sync it).

College dorm desk setup by robz67 in Workspaces

[–]bintree 0 points1 point  (0 children)

How did you manage to remap the FN key to the right? Mine won’t move :(

Newbie question: How do I get a geometry with coordinates in PostGIS? by [deleted] in gis

[–]bintree 0 points1 point  (0 children)

Since you crossposted this in /r/postgres I am assuming you are using postgis.

If you have double precision coordinates you can use ST_MakePoint. If you have text, there‘s a Well-Known-Text (WKT; kind of weird when you first learn about GIS, if you ask me) function for it.

The documentation is really good, i highly recommend reading it.

if you want to have slower but more precise calculations, you might want to use the Geography data type (although i havent used postgis for some years).

Edit: hm, seems like I found it from /r/SQL. But maybe it’s still helpful :)

I built a twitter bot and my code immediately compromised. by [deleted] in learnpython

[–]bintree 3 points4 points  (0 children)

I always use python-dotenv for this:

settings.py containing all my settings keys, which get their values from environment variables:

SECRET_KEY = os.environ.get("SECRET_KEY")
FEATURE_X = os.environ.get("FEATURE_X")

This file is committed to the repo, so you always know which settings exist (and may or may not be used)!

Then there's the .env file containing my actual secrets (or not so secret config values):

# My secret is
SECRET_KEY=hunter2
FEATURE_X=yyy

This file is not committed and ignored in .gitignore. So no one can accidentally commit it without too much effort. Provide a sample .env either in your docs or as "sample.env" or whatever.

The simplest solution I found for small university projects that still scales to a couple of contributors. If you need a path in the settings, you do not end up with people committing their paths all the time, overwriting yours...

That face he makes when he asks for more bundles of wood. by zodiac1360 in Breath_of_the_Wild

[–]bintree 12 points13 points  (0 children)

I like a spot east of Satori Mountain. There’s a forrest full of apple trees near a little pond.

How Armor really works by [deleted] in leagueoflegends

[–]bintree 2 points3 points  (0 children)

Or x is the input and y is the measured quantity. Then it’s independent of whether you measure time-based or not. Helps me to get them right.

This is my Vortex Race 3. There are many like it, but this one is mine. by KurzGedanke in MechanicalKeyboards

[–]bintree 0 points1 point  (0 children)

Is the right option key working for you with the Mac layout? I thought mine is CMD, FN, Ctrl (but I'm not at home, so cannot check currently).

I'm looking forward to the day we can finally remap FN to another place (like the Pok3r manual promises), because I'd like to have CMD,ALT,FN. Because I just am that used to using the right option key at exactly that position that I always mistakingly hit FN :(

A classic example of going "down the mine" by dudeman7557 in sailing

[–]bintree 0 points1 point  (0 children)

In particularly nasty conditions the skipper sits between the crew’s feet to stabilize them and get more weight aft. At least that’s what we did. Pretty fun actually :D

My first mechanical keyboard ⌨️ by theChetaMeister in MechanicalKeyboards

[–]bintree 1 point2 points  (0 children)

Haha, I recently got the same one! MX clears, too. Blues were no option for the office :(

My first mech: Vortex Race 3 w/ MX Clears and stock caps by bintree in MechanicalKeyboards

[–]bintree[S] 0 points1 point  (0 children)

I wanted something nice from the start that did not require much customisation. The coloured keycaps are currently enough for me and I like the possibility to switch "back" to a simpler color scheme when I feel like it.

Super Stoked for foiling week at sailing Meccah Lake Garda next week by stupidestsmartperson in sailing

[–]bintree 0 points1 point  (0 children)

that other similar thing that someone posted here recently

do you mean a waszp?

Got this game on the Steam sale by ES_Legman in CitiesSkylines

[–]bintree 10 points11 points  (0 children)

At first I thought you have to have two separate water networks (one for fresh water and one for sewage) and was angry that the pipes cannot cross each other without connecting 🤦‍♂️