DATABASE DESIGN – Telegram
DATABASE DESIGN
1.41K subscribers
2.09K photos
3 videos
5.35K links
Лучшие материалы по работе с хранилищами данных на русском и английском языке

Разместить рекламу: @tproger_sales_bot

Правила общения: https://tprg.ru/rules

Другие каналы: @tproger_channels

Другие наши проекты: https://tprg.ru/media
Download Telegram
Building a CRM Web App With Python

What motivated me build this web app is my desire to be able to have a personal form app built with my own desired questions and database structure.
It took me a while to finally put this few lines of code together, but i am glad i did.
This CRM Web ...

Read: https://designegycreatives.hashnode.dev/building-a-crm-web-app-with-python
Build an Admin Panel using Redshift and Appsmith

Introduction
Different organizations rely on admin panels to manage, read and mutate data stored in their database. An admin panel is a console used to control features configurations of an application and manage content in that application. Admins i...

Read: https://appsmith.hashnode.dev/build-an-admin-panel-using-redshift-and-appsmith
How to connect Supabase and Nextjs

👋beautiful people in this first tutorial of connecting next js and supabase.
Step1: Go to supabase.com and click on start project and then this 👇page will appear.

You can be signing by creating GitHub account on github.com and then go back to supa...

Read: https://nextdev1111.hashnode.dev/how-to-connect-supabase-and-nextjs
D’Enterprise Account Executive à Regional Director : comment Lucile Tournier a accéléré sa carrière en France

Read: https://www.mongodb.com/blog/post/lucile-tournier-regional-director-france
How MongoDB Could Have Changed Star Wars and Saved the Jedi

Read: https://www.mongodb.com/blog/post/how-mongodb-could-have-changed-star-wars-saved-jedi
From Enterprise Account Executive to Regional Director: How Lucile Tournier Has Accelerated Her Career with MongoDB France

Read: https://www.mongodb.com/blog/post/enterprise-account-executive-regional-director-lucile-tournier-accelerated-career
Achieve cost-effective multi-Region resiliency with Amazon Aurora Global Database headless clusters

Read: https://aws.amazon.com/blogs/database/achieve-cost-effective-multi-region-resiliency-with-amazon-aurora-global-database-headless-clusters/
Jobs 3E May 2022 Senior Enterprise Data Architect

Role
Verisk 3E is looking for an experienced Enterprise Data Architect to join the team. Although our preference would be for someone to sit locally with the team in Carlsbad, CA, fully remote candidates based in the United States will be considered....

Read: https://kb.mdmdm.org/jobs-3e-may-2022-senior-enterprise-data-architect
How Oracle builds REST APIs on top of SQL

While SQL may appear on just about every list of skills an IT professional today should strive to attain, SQL isn't always the best way to interact with your data.

Source: insights.dice.com
Using SQL assumes you actually have access to a database......

Read: https://thatjeffsmith.hashnode.dev/how-oracle-builds-rest-apis-on-top-of-sql
April Round-up: Multiple Widget Reflow, Readable URLs, More Product Updates

If you’ve followed Appsmith for a while, you know that we can do a lot in 30 days!
I am here to give you all the deets; follow along!
Introducing Multiple Widget Reflow
We’ve received a lot of positive feedback on our new drag and drop experience. Us...

Read: https://appsmith.hashnode.dev/april-round-up-multiple-widget-reflow-readable-urls-more-product-updates
Correlation With Rapid Miner

Sarah is a regional sales manager for a nationwide supplier of fossil fuels for home heating.
Recent volatility in market prices for heating oil specifically, coupled with wide variability in the size of each order for home heating oil, has Sarah con...

Read: https://designegycreatives.hashnode.dev/correlation-with-rapid-miner
SQL FUNCTION WHERE(How to get the rows you want)

Here are examples of SQL Where Function
Matching Values

Case

Clause

Matching Values Inexactly

Matching On Calculations

Matching Text Value Inexactly With LIKE

Link To Dataset For Practice

Read: https://designegycreatives.hashnode.dev/sql-function-wherehow-to-get-the-rows-you-want
👎1
Мигрируем БД в продакшене без даунтайма

В этой статье мы рассмотрим основные принципы миграции БД без даунтайма и дадим быстрые рецепты для наиболее распространенных случаев.


Читать: https://habr.com/ru/post/664028/
When Disaster Strikes: Production Troubleshooting

Tom Granot and myself have had the privilege of Vlad Mihalcea’s online company for a while now. As a result we decided to do a workshop together talking about a lot of the things we learned in the process. This workshop would be pretty informal ad-ho...

Read: https://talktotheduck.dev/when-disaster-strikes-production-troubleshooting
How to use Bytebase to coordinate multi-tenancy database schema change

If you haven't set up Bytebase for your team, please refer to How to start using Bytebase for team database collaboration
We already learn the basic SQL review process in Bytebase in How to use Bytebase to facilitate SQL review process (UI workflow)...

Read: https://devrel.bytebase.com/how-to-use-bytebase-to-coordinate-multi-tenancy-database-schema-change
Кастомизируем дашборды в Grafana для инженеров по холодоснабжению ЦОДа

Система мониторинга инженерной инфраструктуры – это нервная система дата-центра. С ее помощью инженеры вовремя видят неприятные симптомы на графиках и предотвращают проблемы в работе кондиционеров, бесперебойников, сетевых устройств и других элементов инженерных систем.

Наша система мониторинга на базе Nagios развивается вместе с сетью дата-центров, и мы уже много рассказывали о ее работе (например, в этом цикле). Но нет предела совершенству, и чем дальше, тем больше хочется улучшить что-то еще: добавить новый “разрез” анализа, взглянуть на оборудование под другим углом.

В этой статье расскажем, как и для каких задач наши инженеры создают кастомные дашборды с помощью графического плагина FlowCharting для Grafana.


Читать: https://habr.com/ru/post/664460/
Build a solution for data migration between on-premises and Amazon Aurora databases hosted in isolated VPCs using AWS DMS

Read: https://aws.amazon.com/blogs/database/build-a-solution-for-data-migration-between-on-premises-and-amazon-aurora-databases-hosted-in-isolated-vpcs-using-aws-dms/