Databases - TopAnswers

Sam

Hi,  
Does anyone know sql can help me with a question? I want to know how to check active IDs from six months ago in one single statment as an attribute, something like lag()?

Anonymous 11737

I am using mysql 5.7 version

Evan845

Hello

ypercubeᵀᴹ

[PostgreSQL 16 Released!](https://www.postgresql.org/about/news/postgresql-16-released-2715/)

Andriy M

Morning

PeterVandivier

o/

Josh Darnell

Morning

Andriy M

Morning everyone

Jack Douglas

Morning all :)

John K N

Me: Nice to see you! To see you?  
Audience: ...Nice!   
(- Bruce Forsyth)

Josh Darnell

Morning

PeterVandivier

Morning

Andriy M

Morning

John K N

Morning

Andriy M

Hi guys.  Someone found an issue in my SO answer and posted a [better one](https://stackoverflow.com/a/75035802/297408).  Would be great if you could vote it up to make it more visible. Hopefully the OP notices and changes their choice too, although they don't seem to have been around lately.

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