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
Как serverless-технологии помогают снизить нагрузку на разработчиков

Используйте serverless-технологии, чтобы разработчики сосредоточились на написании кода, а продукт вышел на рынок быстрее и дешевле.

Читать: «Как serverless-технологии помогают снизить нагрузку на разработчиков»
How to use Bytebase to facilitate SQL review process (UI workflow)

If you haven't set up Bytebase for your team, please refer to my previous article:
How to start using Bytebase for team database cooperation
2 Roles - Project Owner & Developer
Now we have a project prepared in Bytebase, and we have

Adela as Projec...

Read: https://devrel.bytebase.com/how-to-use-bytebase-to-facilitate-sql-review-process-ui-workflow
Day 37/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II ] Distributed Data

why we distribute a database across multiple machines
Scalability - data volume, read/write load grows more than what a single machine can handle
Fault Tolerance/ H...

Read: https://rawdatareaders.hashnode.dev/day-37
👍1
The easiest way(s?) to get started with Oracle

When someone tells me they are learning SQL or are taking a database class, I get very excited and can't wait to hear about their journey.
In case you think that sounds really weird, I was a lost Computer Science student myself back in the day, unti...

Read: https://thatjeffsmith.hashnode.dev/the-easiest-ways-to-get-started-with-oracle
OCI Tagging Enhances Cloud Governance

As enterprises expand their cloud footprint, enforcing corporate compliance standards can become challenging. Oracle Cloud Infrastructure provides the tools & best practice processes to implement cloud governance across OCI resources.

Read: https://blogs.oracle.com/database/post/oci-tagging-enhances-cloud-governance
Get Started with Autonomous Database

This simple guide provides you with 7 important links that will help you get started with Oracle Autonomous Database. You will learn how to provision and load the cloud database, analyze data using SQL, graph, spatial and machine learning, and so much more.

Read: https://blogs.oracle.com/database/post/welcome-to-autonomous-database
How to start using Bytebase for team database collaboration

Suppose you are a DBA / Database Administrator (or other roles related to database) and want to try Bytebase with an existing project to increase the efficiency of database team collaboration and decrease the possibility of a database outage. After ...

Read: https://devrel.bytebase.com/how-to-start-using-bytebase-for-team-database-collaboration
Изучение структуры файла с цифрового кардиографа, извлечение и анализ данных кардиограммы

Четыре года назад я уже писал статью на тему обработки кардиограммы. Тогда я показал, как можно перевести бумажную кардиограмму в цифровой формат PCM данных, отрыв затем её в звуковом редакторе. Мне было интересно воспроизвести, послушать и оценить, как это будет звучать. В этот раз предстоит не менее интересная задача. Необходимо разобраться в структуре файла кардиограммы, переписанного с цифрового кардиографа, и извлечь из него всю информацию о кардиограмме в понятном для пользователя виде.


Читать: https://habr.com/ru/post/663608/
What are🤯 Main Memory, Stack, RAM, ROM, secondary Memory SSD and else? complete answer

Memory and Storage in electronics
Electronics have two main types of memory Main and secondary.
The primary use of Main(Primary) Memory

is to store the data of task👨🏾‍🏭 that is working currently, as Main memory is very close to CPU(Processor) 🖥...

Read: https://abhayprajapati.hashnode.dev/what-are-main-memory-stack-ram-rom-secondary-memory-ssd-and-else-complete-answer
Automate interval partitioning maintenance, and monitoring in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL

Read: https://aws.amazon.com/blogs/database/automate-interval-partitioning-maintenance-and-monitoring-in-amazon-rds-for-postgresql-and-amazon-aurora-postgresql/
BungkusIT uses Amazon QLDB and VeriDoc Global’s ISV technology to improve the customer and delivery agent experience

Read: https://aws.amazon.com/blogs/database/bungkusit-uses-amazon-qldb-and-veridoc-globals-isv-technology-to-improve-the-customer-and-delivery-agent-experience/
Building a blog with Reactjs and RestDB.io.

When building apps that require a backend, we spend much time setting up a server and database, writing APIs with which the frontend can send and receive data to and from the backend. With RestDB, you can easily spin up a server, and create a databas...

Read: https://origho-precious.hashnode.dev/building-a-blog-with-reactjs-and-restdb
Oracle Database World '22 Presentations Available On-Demand

All the latest Oracle Database World 2022 (ODW'22) are now available for replay on-demand on YouTube (with no registration required)!

Read: https://blogs.oracle.com/database/post/oracle-database-world-22-presentations-available-on-demand
I have tables, but I want JSON, CSV, and yes...Excel!

After 20 some years in the database world, I know at least two things:

the database is almost always the best place to store your data
developers and analysts want Excel files, CSV, or JSON

I don't want to argue the first point. There is plenty to ...

Read: https://thatjeffsmith.hashnode.dev/i-have-tables-but-i-want-json-csv-and-yesexcel
Day 39/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Implementation of Replication Logs
Statement-based replication

In the simplest case, the leader logs every write request (statement) that it executes an...

Read: https://rawdatareaders.hashnode.dev/day-39
The first day of learning MongoDB

Before We Begin
So this is my summary for the playlist of introduction to a MongoDB, at this post we will interact only with the pure environment so you could implement it in any web framework.

Download
1- Download MongoDB
Note
Download the latest ...

Read: https://hamdysaad.hashnode.dev/the-first-day-of-learning-mongodb
Working with SQLAlchemy

Create an engine

Create session

Create a table

Migrate


Getting Started
Open your code editor (vs code)
save the file students.py
navigate to the directory of students.py from the terminal on your vs code

HOW TO CREATE AN ENGINE
from the termina...

Read: https://rukayat-balogun.hashnode.dev/working-with-sqlalchemy
Любопытные и неочевидные особенности при работе со Snowflake

Без долгих вступлений, сразу к делу.

Знаете ли вы, что в Snowflake можно создавать объекты с пустыми именами? Например: CREATE DATABASE ""; CREATE SCHEMA ""."";

Это работает на момент публикации и потенциально создаёт массу проблем для внешних систем, которые не ожидают такого поворота. Также это обычно приводит в восторг админов DWH.

Более интересные и практичные советы под катом.


Читать: https://habr.com/ru/post/663922/
Polymorphic Relationships: A database relationship your college probably won't teach you

Introduction
Most of the colleges with computer science course have a subject called Database Management system or DBMS where you are taught topics like Entity Relationships, Normalization, Relational Algebra, SQL, etc. Recently, I came across a new ...

Read: https://blogs.aayushkurup.dev/polymorphic-relationships-a-database-relationship-your-college-probably-wont-teach-you
Day 40/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Reading Your Own Writes

Many applications let user submit and view the data immediately such as comment section.
So if the write goes to the leader and...

Read: https://rawdatareaders.hashnode.dev/day-40