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
Hot Swapping Data Models

Patrik: "So, we need to track where our employees work. Can we do that?"Devin: "Like, just what store each person works at? Not too hard. Does anyone work at more than one store? Like a regional manager or something?"Patrik: "No. That's not possible....

Read: https://www.kallmanation.com/hot-swapping-data-models
Understanding Sql Join

Introduction
I'm writing this blog post to show you what I have learnt so far about SQL JOIN from the freeCodeCamp's 2022 Become-a-Dev New Year's Resolution Challenge. I believe you will enjoy it.
So, whether you are an outright beginner or someone h...

Read: https://michaelobi.hashnode.dev/understanding-sql-join
Understanding SQL Server PIVOT and UNPIVOT with example

PIVOT and UNPIVOT are relational operators for converting table expression into another. If we want to turn the unique row values of a column into multiple columns we use the PIVOT operator. And when we want to converge multiple columns to column row...

Read: https://mssqlserver.dev/understanding-sql-server-pivot-and-unpivot-with-example
What is Firebase Cloud Storage? How to use it in your web project?

This is part two of a three blog series on Firebase basics. In this one, we will read about Cloud Storage.
Firebase Cloud Storage allows you to upload and distribute user-generated information like photographs and videos, allowing you to incorporate...

Read: https://slowbro.hashnode.dev/what-is-firebase-cloud-storage-how-to-use-it-in-your-web-project
Introducing Supabase: The new open-source Firebase alternative

Supabase? The open-source Firebase alternative?!
This is an Extra Ordinary Claim because it requires Extra Ordinary Evidence
"Supabase VS Firebase"
Supabase VS Firebase
1. Features




SupabaseFirebase



DatabaseDatabase

AuthenticationAuthenticatio...

Read: https://omardevblog.toolsandapps4us.site/supabase
Google Cloud Platform Database Services Decision Tree in 75 Words

Now that you have decided to host your data on Google Cloud Platform (GCP), you have one more thing to worry about... Which GCP offering suites your use case at the cheapest possible cost? Thus, I present to you a decision tree chart I drew while tak...

Read: https://blog.mathsend.com/google-cloud-platform-database-services-decision-tree-in-75-words
How to choose the right database for your project?

Choosing the right database is one of the most important decisions you have to make when starting a new project. It should be the first building block when deciding on the tech stack.
Nowadays, you have a lot of choices than the usual RDBMS (MySQL o...

Read: https://blog.kibibyte.in/how-to-choose-the-right-database-for-your-project
How to Choose The Right Database for Your Application

Introduction
Choosing which database to use is one of the most important decisions you can make when starting working on a new app or website.
If you realize down the line that you’ve made the wrong choice, migrating to another database is very costl...

Read: https://apoorvtyagi.tech/how-to-choose-the-right-database-for-your-application
An open-source tool to seed a development database with real data

A bunch of contributors and myself have created RepliByte - an open-source tool to seed a development database from a production database.
Features 🔥

Support data backup and restore for PostgreSQL, MySQL, and MongoDB
Replace sensitive data with fa...

Read: https://hashnode.com/post/an-open-source-tool-to-seed-a-development-database-with-real-data-cl372ak9m04kkmqnvhjw9htuv
An ORM can bite you

Object Relational Mappers (ORMs) are widely used in software development to abstract database operations in our application code by providing a layer between object-oriented programming language and tables in a database. However we should be consciou...

Read: https://jorzel.hashnode.dev/an-orm-can-bite-you
Interacting with Database in Go

In this article I would like to write about how can the model layer interact with the database. In this case I will use a PostgreSQL database.
There are a couple things we need to do to connect to a database in our application.
Driver
The first thin...

Read: https://renatobogar.me/interacting-with-database-in-go
👍1
Understanding Data Transfer Objects (DTO) and Data Validation in TypeScript (NestJS).

Data Transfer Objects (DTOs) are the basis of data validation in NestJS applications. DTOs enable various layers of flexible data validation in NestJS.
In this publication, you will take a deep dive into data transfer objects, discussing validation ...

Read: https://davidekete.hashnode.dev/understanding-data-transfer-objects-dto-and-data-validation-in-typenoscript-nestjs
Migration In Laravel

Overview
Migration in Laravel makes it possible to create tables in your database without using your database manager. This can be done right within your terminal with the use of laravel artisan command, php artisan make:migration. Migration in larav...

Read: https://kindnesso.hashnode.dev/migration-in-laravel
Kaggle like a King

Kaggle is been here for quite a while now and we all know its like gold mine when it comes to working with data-science projects and in many cases we prefer to use google drive to access our data sets.
so, today we shall look at how can one access ...

Read: https://waleed.hashnode.dev/kaggle-like-a-king
Introduction to Airflow

In my previous blog, I briefly introduced apache airflow and mentioned how the tool can be used to orchestrate tasks however I did not set it up locally. This was a deliberate attempt to discuss the tasks I'd like to orchestrate before installing the...

Read: https://kingmoh.hashnode.dev/introduction-to-airflow
Upgrade Cloud SQL Postgres version using Google Database Migration Service(DMS)

Background
A few days ago, I came across an interesting blog post from Google Cloud. In the blog, it used Google Database Migration Service(DMS) to upgrade underline Postgres version in Cloud SQL instance. I found it is interesting and decided to hav...

Read: https://derrickqin.com/upgrade-cloud-sql-postgres-version-using-google-database-migration-servicedms
Локальный или облачный сервер: плюсы каждого выбора

Еще 20 лет назад, когда только запустили первое облако LaaS, многим казалось, что облачный и локальный сервер – это как небо и земля. Спустя время опросы показывают, что пользователи перестали замечать разницу между двумя средами. А выбор сервера по большей части зависит от потребностей конкретного бизнеса. Кто-то сразу останавливается на одном из вариантов, а кому-то приходиться пройти немалый путь, чтобы найти свое. Хочу, чтобы у Вас сразу сформировалось четкое представление о двух средах, поэтому прошу под кат.


Читать: https://habr.com/ru/post/665620/
Designing Data-Intensive Applications CH7 - Transactions Part I

Hello guys, today's article is going to be about chapter 7 from the book 'Designing Data-Intensive Applications' by the brilliant Martin Kleppmann. This chapter talks about transactions in a database, without further or do lets dive right in.
The cha...

Read: https://hewi.hashnode.dev/designing-data-intensive-applications-ch7-transactions-part-i
Starting a new chapter: RelationalAI

Some of you may have seen one of my recent tweets that left a big question hanging in the air: Dude, what are you doing next??
I'm excited to announce today is my first official day working at RelationalAI! I've walked through a lot of the story here...

Read: https://quinnj.hashnode.dev/starting-a-new-chapter-relationalai
Transactional REQUIRES_NEW considered harmful — Spring/Java transaction handling pitfalls

Databases and Transactions are great, Spring is great, Kotlin/Java are great (ofc. Kotlin is better 😉), simplifying transaction-handling is great. But as we all know, simplifying things almost always creates some new pitfalls if the things that were...

Read: https://engineering.cloudflight.io/transactional-requires-new-considered-harmful