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
How to integrate Bytebase for team database cooperation

Suppose you are a DBA (Database Administrator) and want to try Bytebase with an existing project to increase the efficiency of database team cooperation and decrease the possibility of a database outage. After installing it, what should you do?
Shor...

Read: https://devrel.bytebase.com/how-to-integrate-bytebase-for-team-database-cooperation
How to start using Bytebase for team database cooperation

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 cooperation and decrease the possibility of a database outage. After in...

Read: https://devrel.bytebase.com/how-to-start-using-bytebase-for-team-database-cooperation
Remix and creating new posts

Cool, so we just added Postgres to our Remix app. Let's see how we can add new posts to our database via the web interface.
The result of this article will be an excellent web form through which we can add a new post to our Postgres database.
Creatin...

Read: https://h.daily-dev-tips.com/remix-and-creating-new-posts
Tarantool 2.10: сжимаем данные, шифруем трафик, помогаем расследовать инциденты

В Tarantool 2.10 добавили новые инструменты как для Enterprise версии, так и для Community Edition. А еще мы запустили Tarantool по модели DBaaS в облаке VK Cloud Solutions. Далее подробно расскажем про главные обновления: шифрование соединений между репликами и клиентом, сжатие данных в памяти, расширенные возможности аудита и поделимся ссылкой на полный список изменений.


Читать: https://habr.com/ru/post/663240/
What are User-Defined Functions, and what do they have to do with WebAssembly?

When I was first talking with people in the tech sphere about my ideas for Suborbital as a company, the conversations were largely based around the utility and future promise of WebAssembly as a technology. Back in late 2020 I had about a half dozen ...

Read: https://blog.suborbital.dev/what-are-user-defined-functions
Running Database Changes with Zero Downtime

At Lob we receive millions of HTTP requests from our customers daily. Our Print and Mail API facilitates the print and delivery system that is our core product. These requests lead to the creation of new records that represent letters, postcards, sel...

Read: https://lob.hashnode.dev/running-database-changes-with-zero-downtime
Common Database Objects - Series 1 .. n

In the series, I hope to cover some common database objects such as procedures, functions, triggers etc. while also providing frequent real-life scenarios where these objects are used. The scope of this series will be limited to the oracle PL SQL syn...

Read: https://co.hashnode.dev/common-database-objects-series-1-n
Building Together: A Look Into MongoDB’s Newest Location in Barcelona

Read: https://www.mongodb.com/blog/post/building-together-look-into-mongodbs-newest-location-barcelona
Get Started with Autonomous JSON Database

Oracle Autonomous JSON Database (AJD) is a version of Oracle Autonomous Database exclusively for transactions and analytics on JSON data, and includes a MongoDB API.

Read: https://blogs.oracle.com/database/post/get-started-with-autonomous-json-database
👍1
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-transaction-processing
Databases

In this article I'm going to explain in brief some of the fundamental concepts of Database, so if you're a beginner to Database or DBMS this will help you understand the base concepts. Alright, without any further ado let's get started...
What is a D...

Read: https://prit.hashnode.dev/databases
Как 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