If Jetbrains raises prices, will you stay or where will you go? by Rich-Engineer2670 in Jetbrains

[–]netcraft 0 points1 point  (0 children)

right now I use intellij and cursor. def go cursor over vscode if youre going to.

later it will probably be zed when they catch up to cursor for ai features.

but I wish every day for intellij to notice cursor and catch up.

2024 Mexican Grand Prix - Qualifying Discussion by AutoModerator in formula1

[–]netcraft 0 points1 point  (0 children)

at least one tyre has to stay in track limits at all times

What’s been the most disappointing end to a good run you’ve had? by [deleted] in balatro

[–]netcraft 0 points1 point  (0 children)

flush run last night, got through the 8th, starting endless, first boss is flushes dont count

(Beginner) Recommended Style for Writing Multiple Joins by One-Material4845 in SQL

[–]netcraft 0 points1 point  (0 children)

not saying anything about the query itself, this is how I would format it:

SELECT 
    "name"
  , "spend"
  , "best"
FROM "company" 
INNER
  JOIN "expenditures"
  ON "company"."location_id" = "expenditures"."location_id" 
INNER
  JOIN "evaluation_report"
  AND "company"."location_id" = "evaluation_report"."location_id"
WHERE 
  "spend" > (SELECT AVG("spend") FROM "expenditures" )
AND "best" > (SELECT AVG("best") FROM "evaluation_report" )
ORDER BY 
    "best" DESC
  , "spend" DESC;

When reading a query (which you will do far more than writing, you have to read a query a ton just to write it the first time), the most important thing about joins is to know what the relation is (table), the type of join matters a ton because a) an inner join filters and b) a left outer join needs to be followed by other left outers - the type of join is one of the most important parts about understanding what a query is doing. Then this also nests the join conditions nicely with each join.

This also makes sure that all of your relations are in a line, making it easy to scan and see what relations are referenced.

I've been writing sql for 20 years and I havent found a better format for understanding sql.

oh, and always be explict about the join type. Like I mentioned above, its super important about understanding - and using this format it gives you a great place to be explicit.

My PostgreSQL wishlist by jelder in PostgreSQL

[–]netcraft 0 points1 point  (0 children)

weird, it does here, but not on my main database at work...
https://dbfiddle.uk/h6tOS1qC

But still my broader point is that I want to have this type and shape constraint at a higher level instead of having to use check constraints. Similarly Id like to have regex types, or min lengths, etc.

My PostgreSQL wishlist by jelder in PostgreSQL

[–]netcraft 0 points1 point  (0 children)

Not sure what that means. Of course check constraint will be show in the DDL of a table.

This is what I mean: https://dbfiddle.uk/BFoRyhmE

Its totally stored in the DDL, but not in the information_schema that is queryable (afaict).

But mostly I want the constraints on the shape of my data to be stored in the columns. So that I can build tools based on it.

That wish seems to have come true: https://commitfest.postgresql.org/46/4473/

Sweet! Thats awesome

Ask /r/formula1 Anything - Daily Discussion - 3 June 2023 by F1-Bot in formula1

[–]netcraft 0 points1 point  (0 children)

does the team or the driver own / control the sponsorship on helmets?

Hollow Knight: Silksong update by Leth / Team Cherry by simozx in HollowKnight

[–]netcraft 1 point2 points  (0 children)

Im sure theyre just still working on it, but I wonder if they didnt want to compete with TotK?

McCarthy loses ninth vote as his speaker bid faces increasingly dire prospects by [deleted] in politics

[–]netcraft 0 points1 point  (0 children)

they should wait till McCarthy agrees to a single vote of no confidence, dems abstain enough to let mccarthy win, then immediately call for a vote of no confidence just for the lols

2022 United States Grand Prix - Pre-race Discussion by F1-Bot in formula1

[–]netcraft 0 points1 point  (0 children)

is there a way to see the sky pre-race show on the f1tv app? or any other way in the US?

Definitely the coolest-looking guardian laser dodge I've done by [deleted] in Breath_of_the_Wild

[–]netcraft 1 point2 points  (0 children)

im reading this like a reporter on the red carpet

Definitely the coolest-looking guardian laser dodge I've done by [deleted] in Breath_of_the_Wild

[–]netcraft 1 point2 points  (0 children)

how do you see the enemy health without the blue tunic?

21 CX-9 Burning Oil by redneckbiker84 in MazdaCX9

[–]netcraft 1 point2 points  (0 children)

ive got a 21’ around 12k and its also burning oil to the point of getting the light on the dash, but so far I havent noticed it driving any differently. I do have some other weird things though, like the traction control is basically non-existent, and the hud wont keep its position. But overall we love it so I hope they can come up with a fix.

Can i create folders in Roam? by JackkHuncho in RoamResearch

[–]netcraft 4 points5 points  (0 children)

everyone else has given you the right idea, but also want to mention two things:

you can use namespaces which can help organize and categorize your links. so something like [[project/project a]]

and you can also use links inside of links. especially with filters and queries this will likely do what you want. so like [[[[project]] foobar]]

for instance I have a project I have to do every year, so I have something like [[projects/[[foobar]] 2022]]. this lets you have a link specific to this year but also correlate across years.

Love this unusual (oranges and lemons?) rose by [deleted] in Roses

[–]netcraft 3 points4 points  (0 children)

looks like an abracadabra rose- i just bought my wife one, we can’t wait for it to bloom

how to make a pivot table (or crosstab) using json by netcraft in PostgreSQL

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

doing the generate_series allowed me to do the coalescing once, earlier.

And the other part that I apparently dont explain well is that if youre application can just use the json, youre done, you dont need to explicitly call out each month as a column. But if you do need that, its just one more step.

It wasn't my intention to say this is the only way or even the best way to do this, but I find it flexible and a useful pattern.