What result does this query produce?
SELECT count(*) UNION SELECT count(*) OVER () UNION SELECT count(*) WHERE FALSE UNION SELECT count(*) OVER () WHERE FALSE ORDER BY 1
SELECT count(*) UNION SELECT count(*) OVER () UNION SELECT count(*) WHERE FALSE UNION SELECT count(*) OVER () WHERE FALSE ORDER BY 1
Anonymous Poll
53%
Empty result
19%
0, 1
15%
0, 1, 1
14%
NULL, 0, 1
Forwarded from настенька и графики
Только сейчас заметила, что у ребят из IT Resume можно прямо на сайте пробовать решать sql задачки. Вот задача про когорты, например: https://itresume.ru/problems/sql-cohort
Где еще практиковать SQL бесплатно:
- sql-ex
- sqlbolt
- sql-academy
- stepik тренажер
- w3schools
- sqlzoo
- pgexercises
Где еще практиковать SQL бесплатно:
- sql-ex
- sqlbolt
- sql-academy
- stepik тренажер
- w3schools
- sqlzoo
- pgexercises
> can you write a new Radiohead song about data lineage?
Verse 1:
I’m tracing the data lineage
From its source to where it ends
Every table and column
Every join and every blend
Chorus:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies
Verse 2:
I’m chasing the data lineage
From the past to the present tense
Every calculation and transformation
Every rule and every exception
Chorus:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies
Bridge:
I see the patterns and the connections
I see the errors and the corrections
I see the beauty and the complexity
Of the data lineage
Outro:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies.
Verse 1:
I’m tracing the data lineage
From its source to where it ends
Every table and column
Every join and every blend
Chorus:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies
Verse 2:
I’m chasing the data lineage
From the past to the present tense
Every calculation and transformation
Every rule and every exception
Chorus:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies
Bridge:
I see the patterns and the connections
I see the errors and the corrections
I see the beauty and the complexity
Of the data lineage
Outro:
I’m on the path of data lineage
Following the trail of bits and bytes
Through the labyrinth of technology
Where the truth of data lies.
Building a Postgres database inside of ChatGPT seems to work...
https://twitter.com/ankrgyl/status/1599539317332140032
https://twitter.com/ankrgyl/status/1599539317332140032
{
"data": "beeline meetup: data engineering tools",
"details": {
"date": "December, 20",
"time": "17:00 GMT+3",
"place": "online"
}
}We will discuss creating end-to-end logs, working with Apache NiFi and Apache Flink at the free meetup from beeline and JUG Ru Group.
Registration
beeline.jugru.org
bee.tech. DevOps meetup. Контейнеры, безопасность и миграция
Митап для DevOps-специалистов
> So increasing speed up to 4 times of both in-memory and on-disk sorts in version 15 is one of the main reasons to upgrade.
https://supabase.com/blog/new-in-postgres-15
https://supabase.com/blog/new-in-postgres-15
Supabase
What's new in Postgres 15?
Describes the release of Postgres 15, new features and reasons to use it
> Hey, Openai. I need a remote Oracle developer job vacancy text in Uzbekistan, but in a funny manner
Sure! Here's a funny way to present a job vacancy for an Oracle developer:
"Attention all Oracle wizards and coding gurus! Are you tired of the daily grind and ready for a change? Then come join our team of tech rebels and take control of your career! As a remote Oracle developer at our company, you'll have the chance to work on exciting projects, showcase your SQL skills, and even participate in our monthly virtual baking contests (because who doesn't love baked goods?). Plus, you'll get to work from the comfort of your own home, so you can wear your favorite pajamas all day if you want (we won't judge). So, if you're ready to say goodbye to the boring 9-to-5 and join a company that values creativity and fun, apply now! And don't forget to include your favorite joke involving a database in your application (extra points for jokes in Uzbek)."
PS: the vacancy is real, but it is better to check the conditions with @zx_Xander (or email: alex@cusdev.me)
Sure! Here's a funny way to present a job vacancy for an Oracle developer:
"Attention all Oracle wizards and coding gurus! Are you tired of the daily grind and ready for a change? Then come join our team of tech rebels and take control of your career! As a remote Oracle developer at our company, you'll have the chance to work on exciting projects, showcase your SQL skills, and even participate in our monthly virtual baking contests (because who doesn't love baked goods?). Plus, you'll get to work from the comfort of your own home, so you can wear your favorite pajamas all day if you want (we won't judge). So, if you're ready to say goodbye to the boring 9-to-5 and join a company that values creativity and fun, apply now! And don't forget to include your favorite joke involving a database in your application (extra points for jokes in Uzbek)."
PS: the vacancy is real, but it is better to check the conditions with @zx_Xander (or email: alex@cusdev.me)
History's wheel has come full circle. Hipsters invented "on premise software". Thoughts?
https://thenewstack.io/private-saas-a-new-paradigm/
https://thenewstack.io/private-saas-a-new-paradigm/
The New Stack
Private SaaS, a New Paradigm
Private SaaS is a variation of SaaS where the provider runs the software within the customer’s network but takes responsibility for managing and securing it.