NEW BOT Телеграм, страница

~~SQL-WTF~~ SQL-TIL

A few words about this.
At this moment, you must specify an alias for all sub-selects in FROM clause.
It's valid for PostgreSQL and MySQL.

In Snowflake you can skip it. But under the hood Snowflake name it automatically as "values". So, you can't use more than one unnamed sub-select in FROM clause, because "values" will conflict. And yes, you can address it as "values".*

Btw, there are some more "automatic aliases" in Snowflake:
- "VALUES" (capital letters, not the same) for values()
- "STAGE" for stages
- "LIST_DIR_TABLE" for directory tables

Absolutely insane behavior with sub-selects (named or unnamed) in the best and most popular DB in the world (he-he) - SQLite!

select * from (select 1) a, (select 1) b
Try to guess without tests (post your version in the comments)

Сингулярности не будет (18+)

next year in postgres:

https://twitter.com/nori_shinoda/status/1549683794780622848

1.74K viewsedited 15:55

There will be no singularity

2K views15:59

There will be no singularity

HAXE in a new way:
https://github.com/pfusik/cito

GitHub

GitHub - fusionlanguage/fut: Fusion programming language. Transpiling to C, C++, C#, D, Java, JavaScript, Python, Swift, TypeScript…

Fusion programming language. Transpiling to C, C++, C#, D, Java, JavaScript, Python, Swift, TypeScript and OpenCL C. - fusionlanguage/fut

2.32K views16:52

There will be no singularity

~~SQL-WTF~~ SQL-TIL snowflake edition.

In Snowflake, you can create tables, stages, and functions temporarily.
Temporary objects remain visible in the current session only and disappear after the session ends.

The unusual behavior is that you can create a temporary object with the same name as an already existing object.

So, all existing objects linked with it will be relinked to the "new" temporary object. For e.g. all views dependent on the original table will depend on the temporary table.

More than it!

The permanent table created after the temporary table with the same name stays invisible in the current session too :)

3.14K views12:52

There will be no singularity

OMG
https://github.com/oguimbal/pg-mem

Well ... then it's time to remind you about my collection of open source SQL-tools:
https://github.com/antonrevyako/useful-links/blob/master/opensource-sql-tools.md

GitHub

GitHub - oguimbal/pg-mem: An in memory postgres DB instance for your unit tests

An in memory postgres DB instance for your unit tests - oguimbal/pg-mem

2.23K views19:14

There will be no singularity

2.06K views15:38

There will be no singularity

https://github.com/losfair/mvsqlite

GitHub

GitHub - losfair/mvsqlite: Distributed, MVCC SQLite that runs on FoundationDB.

Distributed, MVCC SQLite that runs on FoundationDB. - losfair/mvsqlite

2.17K views07:06

There will be no singularity

JUG Ru Group's SmartData is back!

The conference for data engineers will take place in October.

Would you like to give a talk there? If you have interesting cases or you want to share your experience of nontrivial solutions, apply for participation.

You will confirm your expertise, get to know other experts and get feedback from the participants. The Program Committee will help to prepare for the talk: schedule a personal curator, conduct a review of the material and organize rehearsals.

On the website, you will find a list of topics you can talk about. If you have another topic, send your suggestions; they will be considered.

And if you just want to participate in SmartData 2022, tickets are already on the website.

2.19K views14:27

There will be no singularity

https://github.com/orioledb/orioledb

GitHub

GitHub - orioledb/orioledb: OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)

OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) - GitHub - orioledb/orioledb: OrioleDB – building a modern cloud-native storage engine (....

2.01K views10:30

There will be no singularity

https://github.com/IvorySQL/IvorySQL

GitHub

GitHub - IvorySQL/IvorySQL: Open Source Oracle Compatible PostgreSQL.

Open Source Oracle Compatible PostgreSQL. Contribute to IvorySQL/IvorySQL development by creating an account on GitHub.