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

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.

no time to explain, just follow dwh.dev on linkedin!

https://www.linkedin.com/company/dwhcorp

One optimization story:
- AssemblyScript (WASM) with recursive calls: 40 sec
- JavaScript with recursive calls: 20 sec
- JavaScript with stack instead of recursive calls: 2 sec

By the way, Postgres developers say that v8 is the fastest engine for UDF

Final stop!
Posgresql. WASM. Browser.

https://www.crunchydata.com/blog/learn-postgres-at-the-playground

When you want to make sure your primary key is really really really unique (valid in PostgreSQL) by Lukas Eder

“Every decade, another hyped-up database technology comes along that claims SQL is terrible, slow, or impractical,” Pavlo says. “Over time, the conventional wisdom comes back to realizing that [SQL] is a good idea, and everyone returns to it.”

https://spectrum.ieee.org/the-rise-of-sql