Forwarded from Roman Agabekov
Hey friends,
We built a database performance management tool Releem that helps engineers to keep database servers fast, secure and reliable.
Why Releem:
- Automatic performance tuning
- Fast slow query identification
- Monitoring & tuning in one place
- MySQL / MariaDB & AWS RDS.
- Open-source agent
After few years development we launched on Product Hunt.
If you interested in such solutions, have some questions or feedback appreciate your support❤️ here https://www.producthunt.com/posts/releem
We built a database performance management tool Releem that helps engineers to keep database servers fast, secure and reliable.
Why Releem:
- Automatic performance tuning
- Fast slow query identification
- Monitoring & tuning in one place
- MySQL / MariaDB & AWS RDS.
- Open-source agent
After few years development we launched on Product Hunt.
If you interested in such solutions, have some questions or feedback appreciate your support❤️ here https://www.producthunt.com/posts/releem
Product Hunt
Releem Product Information and Latest Updates (2025) | Product Hunt
Releem makes managing and tuning database servers easy. ⚙️ Automatic performance tuning 🐇 Fast slow query identification ✔️ Monitoring tuning in one place 🔀 MySQL / MariaDB & AWS RDS 🌐 Open-source agent
👍3
There will be no singularity
Days without explanation JOINs via Venn diagrams by data influencers: 0 https://blog.jooq.org/say-no-to-venn-diagrams-when-explaining-joins/
here we go again:
https://www.linkedin.com/feed/update/urn:li:activity:7224013497884454912?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7224013497884454912%2C7224078490243850241%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287224078490243850241%2Curn%3Ali%3Aactivity%3A7224013497884454912%29
(feel free to JOIN this hate speech)
https://www.linkedin.com/feed/update/urn:li:activity:7224013497884454912?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7224013497884454912%2C7224078490243850241%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287224078490243850241%2Curn%3Ali%3Aactivity%3A7224013497884454912%29
(feel free to JOIN this hate speech)
👍2
Forwarded from DataEng
Ребята из Supabase не перестают радовать! 😲
На днях в сети появился новый сервис от Supabase: https://postgres.new. Это data modeling сервис на базе Postgres со встроенным AI ассистентом. Запуск Postgres прямо в браузере возможен благодаря https://pglite.dev/. Это облегчённая версия Postgres, упакованная в WASM.
Целевая аудитория сервиса:
— аналитики данных
— дата инженеры
— студенты, изучающие реляционные базы данных, в частности PostgreSQL
— разработчики, разрабатывающие схемы таблиц
Пример работы с сервисом смотрите на Ютубе.
На днях в сети появился новый сервис от Supabase: https://postgres.new. Это data modeling сервис на базе Postgres со встроенным AI ассистентом. Запуск Postgres прямо в браузере возможен благодаря https://pglite.dev/. Это облегчённая версия Postgres, упакованная в WASM.
Целевая аудитория сервиса:
— аналитики данных
— дата инженеры
— студенты, изучающие реляционные базы данных, в частности PostgreSQL
— разработчики, разрабатывающие схемы таблиц
Пример работы с сервисом смотрите на Ютубе.
👍10
Eyes Wide Shut Data Lineage №1:
DATA LINEAGE IS A LIE
Suddenly discovered that any data lineage tools are missing one important part... Had to fix it 🙂
https://www.linkedin.com/posts/anton-revyako_snowflake-snowflakedatacloud-datalineage-activity-7232405043776282625--ADs/
DATA LINEAGE IS A LIE
Suddenly discovered that any data lineage tools are missing one important part... Had to fix it 🙂
https://www.linkedin.com/posts/anton-revyako_snowflake-snowflakedatacloud-datalineage-activity-7232405043776282625--ADs/
Linkedin
Eyes Wide Shut Data Lineage №1: DATA LINEAGE IS A LIE | Anton Revyako
Eyes Wide Shut Data Lineage №1: DATA LINEAGE IS A LIE
Data people, I have some bad news for you.
The entire concept of column-level data lineage as you know it is a lie. It's broken, and no one is willing to admit it.
This applies across all databases…
Data people, I have some bad news for you.
The entire concept of column-level data lineage as you know it is a lie. It's broken, and no one is willing to admit it.
This applies across all databases…
Friendly reminder:
I have encountered a situation where a query with UNION and UNION ALL resulted in a stable different row order...
UNION is often used for something like this:
It is important that if a record with 'user_input' is found, it should be the first record in the result.
In such a case, add an ORDER BY of this form to the query:
The UNION and UNION ALL operators may order the rows in the final result set in an unspecified order. For example, it may place rows from the second result set before/after the row from the first result set.
I have encountered a situation where a query with UNION and UNION ALL resulted in a stable different row order...
UNION is often used for something like this:
SELECT * FROM (
SELECT id FROM t WHERE name = 'user_input'
UNION
SELECT id FROM t WHERE name = 'default_value'
)
LIMIT 1
It is important that if a record with 'user_input' is found, it should be the first record in the result.
In such a case, add an ORDER BY of this form to the query:
ORDER BY name = 'default_value'
👍3🤔3🤨1