Databases - TopAnswers

Andriy M replying to Jack Douglas

When you look at the map to see who is at war with whom, I can see why!

Jack Douglas

it's interesting to get your first-hand insight!

Jack Douglas replying to Andriy M

I find it easy to forget how huge Ukraine is too

Andriy M replying to Jack Douglas

Thinking about it, it's what we've already had since 2014, which was when the war actually began.  Only at that time it was much less prominent and covered less area, hence the sense of normality was easier to maintain.  Even here in Ukraine, many lived as though nothing was happening.  "Yeah, we have some conflict in the eastern part, yeah, Russia's annexed Crimea, but other than that everything's fine, nothing to worry about."  I have to admit that was very close to my way of thinking during those years.  Partly the reason was that the conflict wasn't officially called a war, it was just an anti-terrorist operation.  But for the people in Donbas it was as much an actual war as it's been for everyone since February 24th.  Even so, most of Ukraine isn't occupied or near the front lines, so life must go on (as much as possible, yes).

Jack Douglas replying to Andriy M

It's odd thinking about normal things going on during the war but of course they just have to I guess, as much as possible.

Andriy M replying to Jack Douglas

No idea, but it's possible that some might be.  A new academic year has recently begun, after all.

Jack Douglas replying to Andriy M

Are lots of Ukrainians learning SQL right now? Seems unlikely but db<>fiddle has had 16k variations of https://dbfiddle.uk/vJq1ro34 run in the last week, which makes me curious.

Jack Douglas replying to Paul White

Cool, thanks @Paul

Paul White

Tested ages ago but forgot to say: it's fine, thanks.

Paul White

Thanks will check later

Jack Douglas replying to Paul White

should be fixed now Paul, though there is a chance other things got broken in the process (as all the engines have been rebuilt from scratch)

ypercubeᵀᴹ

heh, super!

Jack Douglas replying to ypercubeᵀᴹ

Just for you @ypercubeᵀᴹ : https://dbfiddle.uk/?rdbms=postgres_15 :)

Jack Douglas replying to Paul White

thanks Paul, I will look into that

Paul White

Just says "run failed"

Paul White

Also the AdventureWorks sample database on SQL Server 2019 instances of db<>fiddle seems to be broken

ypercubeᵀᴹ

https://www.postgresql.org/about/news/postgresql-15-beta-2-released-2479/

ypercubeᵀᴹ

@JackDouglas, in case you haven't noticed, Postgres has released 15 Beta 2

ypercubeᵀᴹ

hi all

Andriy M

Would really like to just reach out and hug you or shake your hand. You hang on tight there, mate

Andriy M replying to FoggyFinder

Wow, I had no idea you were from Ukraine as well.  And from Kharkiv no less.  I was scared witless just hearing explosions *near* our city.  What you must be going through, I can't even imagine.

Paul White

It's kind of amazing to me that people in areas like this still have internet access

Paul White

> According to the local police, 209 people had been killed as of 7 March, including 133 civilians. In addition, 443 people, including 319 civilians, had been wounded.

Paul White

@@@ wikipedia 837cbf123c919a5a39148a1e6f9fd6ef16e583e7e7d21ebef56e8b42d5e83ff7 4uKk "Battle of Kharkiv (2022)" "The Battle of Kharkiv is an ongoing military engagement taking place in and around the city of Kharkiv in Ukraine as part of the Eastern Ukraine offensive during the 2022 Russian invasion of Ukraine. Kharkiv, located just 32 kilometres (20 mi) south…"

Paul White

also

Paul White

@@@ wikipedia 70d0d831c20ee4ccf2f076823bd9084a87194c8c9222c8dba6a60ec38a627521 4wMH "Kharkiv" "Kharkiv, also known as Kharkov, is the second-largest city and municipality in Ukraine. Located in the northeast of the country, it is the largest city of the historic Slobozhanshchyna region. Kharkiv is the administrative centre of Kharkiv Oblast an…"

Paul White

I was confused for a while thinking Kharkov and Kharkiv were separate places

Paul White replying to FoggyFinder

What's the situation there?

FoggyFinder replying to Andriy M

good luck. I'm from Kharkiv btw

Andriy M replying to Josh Darnell

✌

Josh Darnell

Words fail me.

Josh Darnell replying to Andriy M

💙💙💙

Andriy M replying to John K N

Thanks John. I and my friends and relatives are indeed okay so far, thank God.

John K N replying to Andriy M

Nice to see you're doing ok.

Andriy M replying to Anonymous 2315

Hey there Vérace! Nice to hear from you brother, and thanks

Andriy M replying to FoggyFinder

I'm in the south of Ukraine, in a city currently occupied by the enemy.

Anonymous 2315 replying to Andriy M

Hi Andriy - it's Verace here. Your long-lost adopted Irish brother here wishing you all the best under the current circumstances!

FoggyFinder replying to Andriy M

I meant city

Andriy M replying to FoggyFinder

Ukraine

FoggyFinder

@Andriy where are you from?

Anonymous 2307

Does anybody havr solution on this?

Anonymous 2307

PLSQL - Display Dept Head for Employees with Manager as NULL
Write a PLSQL block to fetch the  Active employees who has joined on or  after 01/01/2000.

Anonymous 2307

Hi

Andriy M

Yep. I have no doubt that every sensible person in the world who knows about what's happening here does. Thanks Paul.

Paul White

Really hope the situation resolves soon with minimal loss of life

Paul White

Ha ha I can imagine yes. Glad to hear you are personally ok and retaining your sense of humour

Andriy M

Just trying to entertain myself with bad puns

Andriy M

Sorry, don't mean to offend or upset anyone who might actually have suffered from Covid

Andriy M

One surprising positive thing that came of our situation is that people seem to have stopped talking so much about Covid. I was starting to grow quite sick of it, honestly

Paul White

Quite well thank you