ypercubeᵀᴹ

Paul's looks like a duck

hey all

Yes, I meant migrating to different dbms.

@SeanGallardy you said they went back to SQL Server so something must have gone wrong ;)

if your application needs features that are not in the target DBMS, you'll be in pain

@SeanGallardy I am a fan of Postgres but migrations don't always work well.

@J.Mini that's a very long drum roll

the Big, the Bold and the Inevitable Shits Ahead

@SeanGallardy so if I understand right, this application is injecting itself into kernel procedures? ugh

@Vérace at 20 years it's a feature, not a bug ;)

@ConcernedOfTunbridgeWells hey, are you still in the far east? ;)

In previous versions, all CTEs were evaluated once.

@Charlieface adding to the encore discussion, Postgres inlines a CTE only if it is referenced only once, it has no volatile functions and is non-recursive. Everything else is materialised / evaluated once (assuming no overrides with [NOT] MATERIALIZED. That is for versions 12+.

Erik, can you share the book where you saw this example? I am interested.

We could make a series. I replaced a Cassandra DB with a SQL Server table, etc.

I wouldn't dare suggest a heavy read for Saturday night, considering the level of alcohol on DBA's bloodstream ;)

@Charlieface indeed there are. I didn't mean comic as bad. More like light read.

Saturday night comic

I replaced Mongo with a single Postgres table

while eating a sandwich

also always wanted to try that rolling down a hill inside a big ball that seems to be a thing in NZ

good to have options for when GAI takes all our jobs

@PaulWhite applying in advance for mayo sorcerer, waiter or any other available position in your shop sir!

with g as (...), gn as (select * from g cross apply (select newid()) as n)  select ... from gn join ...

with g as (...) select *, newid() from g ... ;

@Charlieface maybe a subquery or cte that has 1 row per group and then join to whatever you need

@J.Mini they might ask someone like, the Paul White of Postgres first ;)

shows how much they have progressed, from mixing insert with updates to becoming a DBA ;)

@ErikReasonableRatesDarling that question was from 8 years ago.

@J.Mini looks well researched

and 3 from MathOverflow.

@JohnK.N. I had 5 mails that day

so Brooklyn bridge connects Brooklyn to Manhattan?

@Vérace lies, damned lied and statistics :)

finally, we (our company) researched various options and "zeroed in on using snowflake after considering X, Y and Z". I feel so blissed.

@SeanGallardy there's plenty of water all around :)

or even 10^8000 year bug

@ErikReasonableRatesDarling they were cautious, to avoid the 10k year bug ;)

@AndrásVáczi not sure about tonight, I'm working until late. If you are still in Athens tomorrow, send me a message and we could meet. ypercube @ gmail.com

now and until next weekend

yes, I am

@J.D. no, I didn't;t see it in reddit

@PaulWhite is that Vcore seconds or Vcrore seconds? ;)

Are you qualified to use NULL?

hey all

hi all. I've been away for a while