I have added a new tool to my collection of non-DB SQL tools on GitHub :

https://github.com/undergrinder/gomoql
A little gomoku game, implemented in pure SQL/plpgSQL

Snowflake WTF #71:
You can name multiple CTEs with the same name, but you can only refer to the first one

For understandable reasons, I come across many articles about data catalogs, lineage, quality, and other related topics. Previously, I used to save all these links in my private chat (on Slack) and then read them (nope).

But recently, Slack warned us that they would ban us as unwanted users.

So now I have to save the links somewhere else. I thought that's a great plan, Walter, to create another channel, and share these links there. In case you're interested, here's the channel:
@allaboutdatbase

(If anyone suggests an avatar, they're awesome. I couldn't bring myself to add screenshots from Meghan Trainor's music video.)

And while I'm at it, let me tell you about a few more channels. After all, we all know that once you start collecting channels, you can't stop:

@nosingularity - all about databases (even more in the channel's chat)

@snowflake_daily - news and articles about Snowflake
@snowflakedbchat and @snowflakedbchat_en - chats about Snowflake
@snowflakejob - Snowflake job openings

@wellfirstofallitsbeautiful - beautiful things

https://twitter.com/nilansaha/status/1621421983953993728

- Railway (Free tier)
- CockroachDB (Free tier)
- mixpanel (Free tier)
- aws S3 (~ $0.60)

Anniversary in one of the repositories... Soon there will be news about dwh.dev :)

Puzzle:

fxtwitter.com/fujii_masao/status/1575449848219783168

Postgres + Openai

1) https://supabase.com/blog/openai-embeddings-postgres-vector

2) https://neon.tech/blog/announcing-pg_tiktoken-a-postgres-extension-for-fast-bpe-tokenization

Яндекс выкладывает в опенсорс одну из основных инфраструктурных BigData-систем собственной разработки — YTsaurus. Это платформа, предназначенная для распределённого хранения и обработки больших данных.

Максим Бабенко, руководитель отдела технологий распределённых вычислений в Яндексе, рассказал историю возникновения YT, а также зачем нужна YTsaurus и где её можно применять.

В Github-репозитории — серверный код YTsaurus, инфраструктура развёртывания с использованием k8s, а также веб-интерфейс системы и клиентский SDK для распространённых языков программирования — C++, Java, Go и Python.

Ссылки на посты на Хабре и Медиуме.

Hey friends!

A lot of you already know (and the rest are about to find out) that my team and I are working on a data observability service for Snowflake analytical database - dwh.dev

I used to post some news here and there, but then we took on a big chunk of work, which I'll tell you about soon.

Since the new website design is not really newsworthy, and we need to keep up our social media activity, we've decided to start publishing articles about all data-like things.

In other words, Андрюха, по коням, у нас like alert, возможно attention whore :)

1) https://www.linkedin.com/feed/update/urn:li:activity:7046032257152626688/

2) https://twitter.com/DwhDev/status/1640278468066791426

Retool выпустила свой self-management PostgreSQL с UI

https://retool.com/products/database

Анонс - https://retool.com/blog/rdb/

Если я правильно понял то по ценам
- бесплатно до 5 пользователей селф-хостед
- SAAS 5 пользователей + обьем данных 5Гб на первый год

#postgresql #admin #saas

- SELECT Without FROM Clause
- GROUP BY Column Alias or Position
- IF [NOT] EXISTS Syntax Support

😱

https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html