u/netcraft

we have been enjoying nobody wants this

planetscale has a 5$ plan, and I believe does everything youre asking for

you dont say how small, but planetscale has a 5$ pg plan thats doing more than I need for one of my small projects

I have one of each and it totally depends on what youre doing with it. there are times where the 14” is perfect - travel, in a car or plane, or if im just watching something in my living room or browsing the web or taking notes. But if im coding or need more than one thing on the screen at a time, I really appreciate the 16”, though even then theres times where I still want an external monitor. If in doubt id go 14”, you can always hook up a monitor but youll end up using it way more

that title is in no way accurate, the judge did not order it built.

the land owner that was trying to sell the land to chick-fil-a sued saying that an initial hearing was rejected for traffic reasons, which at the time was not a valid reason for rejection at that stage of the process. but its been two years, and since then the ordinances have changed where it is now a valid reason. he will get a new hearing, but chick-fil-a wasnt even a party to the suit, theres no guarantee they are even still interested, and theres no expectation that collierville wont just reject it again

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.

cant wait

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

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

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.

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.

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

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

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

no penalty for either driver

https://twitter.com/ChrisMedlandF1/status/1654979254193463298?s=20

Forza Hyrule 5

https://vimeo.com/cityofmemphis

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

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

ah, didnt realize this - thank you!

im reading this like a reporter on the red carpet

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

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.

they still dont know where he is https://twitter.com/mem_policedept/status/1567691061446705153?s=46&t=SItgtIOeIk_QRdfjQYYSeQ

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.