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
Изучение структуры файла с цифрового кардиографа, извлечение и анализ данных кардиограммы

Четыре года назад я уже писал статью на тему обработки кардиограммы. Тогда я показал, как можно перевести бумажную кардиограмму в цифровой формат 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
Внедрение Postgres из Docker в Kubernetes

Создание контейнера для базы данных отнюдь не является излишеством. На самом деле, это позволит вам привнести все преимущества контейнеров в вашу БД.

Мы рассмотрим, как создавать контейнеры Postgres с помощью Docker и перезапускать их без потери данных, а в конце статьи с помощью нестандартного метода (использующего ConfigMaps и StatefulSets) мы развернём внутри подов Kubernetes — Postgres.


Читать: https://habr.com/ru/post/662784/
Why You Should Avoid Offset in Your DB Queries

We often use offset or skip in our database queries to fetch paginated data. This helps in implementing server-side pagination where it is not convenient to fetch all the data at once for performance reasons.
Real-world use cases for this might be wh...

Read: https://rrawat.hashnode.dev/why-you-should-avoid-offset-in-your-db-queries
Day 41/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Multi-Leader Replication

Multi-datacenter operation - we have a database with replicas in several different datacenters. With a normal leader-based repl...

Read: https://rawdatareaders.hashnode.dev/day-41
Factors to consider when choosing a SQL client

Working with SQL through the command line can be tedious and difficult. But interacting with your data doesn't have to be that way. Instead, you can use a SQL client.
A SQL client is a front-end application that uses the services provided by a databa...

Read: https://arctype.hashnode.dev/factors-to-consider-when-choosing-a-sql-client
Announcing Spatial Studio 22.1

Oracle Spatial Studio is a no-code web tool for working with the Spatial features of Oracle Database. For general information about Spatial Studio and to get started, please click here. The latest release, Oracle Spatial Studio 22.1, introduces important new capabilities. In this post we explore several of these new capabilities.

Read: https://blogs.oracle.com/database/post/announcing-spatial-studio-221
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