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

There will be no singularity

TIL: BigQuery didn't have native json support until 2022

https://cloud.google.com/blog/products/data-analytics/bigquery-now-natively-supports-semi-structured-data

Google Cloud Blog

BigQuery now natively supports semi-structured data | Google Cloud Blog

With BigQuery’s native JSON support, customers can now write to BigQuery without worrying about future changes to their data.

2K views09:19

There will be no singularity

Еще одна китайская бд. На этот раз HA distributed time series. На гошечке https://github.com/lindb/lindb

+1

https://github.com/CeresDB/ceresdb

GitHub

GitHub - apache/horaedb: Apache HoraeDB (incubating) is a high-performance, distributed, cloud native time-series database.

Apache HoraeDB (incubating) is a high-performance, distributed, cloud native time-series database. - apache/horaedb

2.08K views22:34

There will be no singularity

1.96K views21:03

There will be no singularity

Forwarded from Generative Anton

По прогнозу погоды: дождь из языковых моделек, генерирующих код. Внезапно и неожиданно AWS зарелизил Code Whisperer. Это тоже самое, что и Copilot, только (вроде как) умеет в styleguide’ы проекта смотреть и больше берет из описания и контекста вокруг.

Выглядит неплохо, надо пощупать получше (Copilot смотрел еще в бете, не очень понравилось). Больше картинок с примерами есть в статье Techcrunch’a.

1.79K views11:42

There will be no singularity

Forwarded from DOFH - DevOps from hell

Результаты опроса аудитории StackOverflow по используемым СУБД. Удивляет популярность узкоприменимой SQLite.

Машка с муськой вместе дают огромный перевес. Постгри, конечно, уверенно тащит, хотя раньше никто не верил.

1.99K views07:03

There will be no singularity

Forwarded from dd if=/dev/stuff of=/dev/tg

https://www.learningtypenoscript.com/articles/extreme-explorations-of-typenoscripts-type-system

Learningtypenoscript

Extreme Explorations of TypeScript's Type System | Learning TypeScript

Some of the most creative, wacky explorations of what you can do in TypeScript's type system!

1.69K views18:54

There will be no singularity

Time to update my open source SQL tools collection!

Yet another one SQL killer (modern language for transforming data — a simple, powerful, pipelined SQL replacement). Written in RUST :)

https://github.com/prql/prql

2.14K viewsedited 19:30

There will be no singularity

I call the police!

https://www.twilio.com/blog/sqlite-postgresql-complicated

Twilio

SQLite or PostgreSQL? It's Complicated!

Learn how to benchmark SQLite and PostgreSQL databases.

2.36K views18:51

There will be no singularity

absolutely cursed…

2.68K views05:50

There will be no singularity

+1 mysql based DB:

https://github.com/stoneatom/stonedb

GitHub

GitHub - stoneatom/stonedb: StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart…

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io) - stoneatom/stonedb

2.17K views17:14

There will be no singularity

To distract from the problem, I randomly deleted 5 rows from the table.... :)))

https://www.cybertec-postgresql.com/en/transaction-anomalies-with-select-for-update/

CYBERTEC PostgreSQL | Services & Support

Transaction anomalies with SELECT FOR UPDATE

This article shows how surprising transaction anomalies can happen with SELECT FOR UPDATE and what you can to to avoid them.

2.27K viewsedited 22:10

There will be no singularity

https://simonwillison.net/2022/Jul/9/gpt-3-explain-code/

Simon Willison’s Weblog

Using GPT-3 to explain how code works

One of my favourite uses for the GPT-3 AI language model is generating explanations of how code works. It’s shockingly effective at this: its training set clearly include a vast …

2.09K views19:05

There will be no singularity

Postgres 15 improves UNIQUE and NULL

https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null

1.97K viewsedited 12:19

There will be no singularity

https://edu.postgrespro.com/postgresql_internals-14_part1_en.pdf

2.09K views11:30

There will be no singularity

Forwarded from Nikolay Markov

2.23K views13:58

There will be no singularity

Я тут крутую ORM-ку нашел!.. ... для регекспов ... на расте https://github.com/pemistahl/grex

a better way now…

English to RegEx with Natural Language Processing:
autoregex.xyz

2.38K viewsedited 10:54

There will be no singularity

https://www.timescale.com/blog/state-of-postgresql-2022-first-findings/

Timescale Blog

2.4K views19:11

There will be no singularity

https://pixelspark.nl/2022/making-advanced-bi-queries-childs-play-with-puzzle-pieces

t-shaped.nl

Advanced BI queries using puzzle pieces

1.77K views07:30

There will be no singularity

next year in postgres:

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

X (formerly Twitter)

Noriyoshi Shinoda (@nori_shinoda) on X

PostgreSQL 16 dev: Make subquery aliases optional in the FROM clause.
https://t.co/ozAQEXF8QL

1.69K views09:20

There will be no singularity

~~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

About

Blog

Apps

Platform