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
Calendar In Linux

In today’s article I will talk about Calendar In Linux. You are running a Linux operating system and if you want to query the operating system whether the time is correct, a few commands will help you. You can see the month, year, day, hour, minute and second information with the date command.   If …

Read: Calendar In Linux.
Day 3/100

Deltalake - [ Intro and Quick Start ]
key features -

ACID transactions
schema enforcement on writes
Unification of batch and streaming - A table in Delta Lake is a batch table as well as a streaming source and sink.
Time travel
Supports merge, upd...

Read: https://rawdatareaders.hashnode.dev/day-3100
Warehousing with Google’s Big Query

Data, in the modern world, is decentralized and is being generated and collected at a record pace. To ensure that this data is collected and processed in a manner that enables businesses and organizations to achieve their business goals, specialized ...

Read: https://anujsyal.com/warehousing-with-googles-big-query
Миграция из Office 365: задачи, способы и сроки

После мартовского заявления Microsoft о приостановке новых продаж в России клиенты задумались о рисках использования облачных продуктов корпорации. Пока функциональность закупленных лицензий сохраняется. Но российские компании опасаются, что санкции могут усилиться.

В статье разберем, какими способами мы предлагаем нашим клиентам минимизировать риски использования Office 365. Сейчас этот офисный пакет входит в состав подписки Microsoft 365 и включает Word, Excel, PowerPoint, Outlook/Exchange, OneDrive, Teams и еще несколько приложений.


Читать: https://habr.com/ru/post/657203/
😁1
Resources to Learn SQL from Scratch

SELECT howdy_greeting
FROM introductions;
1 row selected
Howdy! I've taken a tiny hiatus blogging due to my classes this semester - but, I have returned! 🤩
And I have returned with...
drumroll
... a golden list of resources to use if you're learnin...

Read: https://laylacodes.hashnode.dev/resources-to-learn-sql-from-scratch
MySQL waits and CPU

Read: http://datavirtualizer.com/?p=6395
Using TMDB - The Movie Database

It's my Learning Time. I Learned about creating movie websites like Netflix and others. (PS. I Don't Provide Movie Files - I am Against Piracy 😁).
On that Website Developing time, I need movie details. not One, not Two, not something like 100, but I...

Read: https://sahal.hashnode.dev/using-tmdb-the-movie-database
MySQL -> what to do with NESTING_EVENT_ID

Read: http://datavirtualizer.com/?p=6425
It’s fine, Rewind: Revert a migration without losing data

Read: https://planetscale.com/blog/its-fine-rewind-revert-a-migration-without-losing-data
Installing Docker And SQL Server 2017 On LinuxVM In Azure

In today’s article, I will talk about Installing Docker And SQL Server 2017 On LinuxVM In Azure. After the announcement that SQL Server 2017 is running on Docker, I was working on docker and today I will tell you “Installing Docker and SQL Server 2017 on LinuxVM in Azure”. I have a LinuxVM on Microsoft …

Read: Installing Docker And SQL Server 2017 On LinuxVM In Azure.
PostgreSQL CRUD operations with C# and Dapper

In a previous article, we've seen how to perform simple CRUD operations on a Postgres database by using Npgsql, a library that allows you to write and perform queries to be executed specifically on a PostgreSQL database.
In this article, we will take...

Read: https://code4it.hashnode.dev/postgresql-crud-operations-with-c-and-dapper
Okta – Percona’s statement

Read: https://www.percona.com/blog/?p=80442
Day 5/100

Delta Lake [Part 3] -
Delta table Streaming
Delta Lake is deeply integrated with Spark Structured Streaming through readStream and writeStream along with following features,

Coalesce small files
Maintains Exactly-once processing
Discovering new file...

Read: https://rawdatareaders.hashnode.dev/day-5100
MariaDB Java Connector 3.0.4 now available

Read: https://mariadb.com/?p=30703