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
Learn with Me: SQL and Relational Databases

What is SQL?
SQL stands for Structured Query Language. SQL is a programming language designed for managing data in a relational database system (We will get to what that means later). SQL is broken down into four sublanguages:

Data Query Language (D...

Read: https://jakeconrad.hashnode.dev/learn-with-me-sql-and-relational-databases
Connecting the AWS RDS Console to your PostgreSQL Engine

A data base is a standardized collection of data, which is stored and access electronically. With the help of database, data management is easy. Small database can be stored on a file storage, while large database are hosted on computer clusters or C...

Read: https://everythingtechbyisdonobi.hashnode.dev/connecting-the-aws-rds-console-to-your-postgresql-engine
Masonite Project - Factory Tinker Example Tutorial

In this series, we will see a Masonite factory tinker example.
As we know testing is very important part of any web development project. Sometime we may require to add hundreds records in our users table. Also think about if we require to check pagi...

Read: https://blog.popolo.dev/masonite-project-factory-tinker-example-tutorial
Convert database schemas and application SQL using the AWS Schema Conversion Tool CLI

Read: https://aws.amazon.com/blogs/database/convert-database-schemas-and-application-sql-using-the-aws-schema-conversion-tool-cli/
👍2
02 - Database Design

To staff building the different parts of the application we shall first start working on database design, where all the data is stored related to the application. As mentioned earlier we shall be using PostgreSQL to store our data.Following is the i...

Read: https://srikanthvenkata.hashnode.dev/02-database-design
Apache ShardingSphere & openGauss: Breaking the Distributed Database Performance Record with 10 Million tpmC!

Our open source community has cooperated with Huawei’s openGauss to build a distributed solution with Apache ShardingSphere and openGauss.
We tested performance together with openGauss on 16 servers for more than one hour. The results were great: our...

Read: https://distributeddatabase.hashnode.dev/apache-shardingsphere-and-opengauss-breaking-the-distributed-database-performance-record-with-10-million-tpmc
The Best 10 MySQL GUI Clients for Mac OS X

MySQL is a widely used, open-source relational database management system (RDBMS). It is known for its high performance, flexibility, ease of use, security, and speed. MySQL clients are programs that enable you to communicate your databases and manag...

Read: https://catalins.tech/best-mysql-clients-mac
CRUD functions in supabase 👋

Welcome guys to this 2nd blog for supabase and nextjs integration. In this blog, I will be telling you how to create, read, update, and delete data in a subbase with the help of next js.
🤔 If you don’t know how to set up supabase then you can read t...

Read: https://nextdev1111.hashnode.dev/crud-functions-in-supabase
Which one to choose MongoDB or MySQL??

Hey everyone, nice to meet you again. If you wonder which one is better MongoDB or MySQL database, then you are at right place to know about it. I hope you will enjoy this another journey of learning also, so let's start the journey.

What are SQL ty...

Read: https://anubhavg.hashnode.dev/which-one-to-choose-mongodb-or-mysql
Database

Introdaction of SQL

SQL is a standard query language for storing, manipulating, and retrieving data in a database.

Things that SQL can do
CRUD (Create, Read, Update and Delete)

Create
can create a database
create new tables in a database
insert r...

Read: https://yusrastack.hashnode.dev/database
Are you confused about which database architecture to use between SQL and NoSQL? Here is how Presear Softwares can help you!

When it comes to making decisions regarding the correct database architecture, the process might need prior knowledge of the database architectures.
Though the terms Relational Database Management Systems (RDBMS) and the Structured Query Language (SQ...

Read: https://blogs.presear.com/are-you-confused-about-which-database-architecture-to-use-between-sql-and-nosql-here-is-how-presear-softwares-can-help-you
👍1
Database 01

Hello, welcome to my blog again. In this series, I will be writing about databases. 🚀🚀🚀🚀
Introdaction of SQL

SQL is a standard query language for storing, manipulating, and retrieving data in a database.

Things that SQL can do
CRUD (Create, Rea...

Read: https://yusrastack.hashnode.dev/database-01
Creating Cloud-based Customer-Facing Apps with MariaDB, Upsolver and AWS

Read: https://mariadb.com/?p=31345
SQL Queries For Mere Mortals: Thinking In Sets Part 1

What Is a Set, Anyway?

If you remember in high school, you might have studied set theory in a mathematics course. If you were introduced to set algebra, you probably wondered why any of it would ever be useful.
A set can be as little as the data...

Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-thinking-in-sets-part-1
SQL Queries For Mere Mortals: Thinking In Sets Part 2

Sets Continued

In Part One we talk about concept of sets, operations on sets, started with the first one which is intersection.
Now in This part we'll complete our journey in sets by talking about the other two operations which are difference and ...

Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-thinking-in-sets-part-2
Survey of 2,000 IT Professionals Reveals the Importance of Innovation, and Its Challenges

Read: https://www.mongodb.com/blog/post/survey-2000-it-professionals-reveals-importance-innovation-challenges
Бессерверные базы данных: путь в будущее?

Бессерверные сервисы облачных вычислений появились в 2014 году с AWS Lambda, которая позволяла запускать код без выделения серверов или управления ими. AWS Lambda — пример функции как услуги (FaaS), где результат обработки событий не зависит от состояния памяти сервера и содержимого локальной файловой системы. Такие эластичные вычисления позволяли быстро наращивать и высвобождать ресурсы процессоров, памяти и средств хранения без необходимости что-то планировать и предпринимать меры для обработки пиковых нагрузок.
За AWS Lambda быстро последовали решения от Microsoft Azure и Google Cloud. Позже облачные провайдеры начали предлагать и другие услуги в бессерверной форме. Это последний, новый взгляд на облачные сервисы, и на практике бессерверные архитектуры за счет возможностей масштабирования часто обходятся в разы дешевле, чем постоянные сервера, предназначенные для выполнения тех же нагрузок.
Сейчас бессерверных решений все больше, в том числе пару лет назад появились и первые проекты в России. На Хабре о бессерверных вычислениях есть раздел, но куда менее популярный, чем он того заслуживает. Попытаемся это исправить.
Итак, Serverless. Крупным планом.



Читать: https://habr.com/ru/post/664986/
A Developer’s Guide to Complete Aviation Database

Aviation Edge static aviation databases are the ultimate external data for strong aviation-related projects.
An extensive aircraft, airport, city, or airline database can be hard to collect on your own or even find in the first place. You would proba...

Read: https://aviationedgeapi.hashnode.dev/a-developers-guide-to-complete-aviation-database
Association Rule With Rapid Miner

Roger is a city manager for a medium-sized, but steadily growing city. The city has limited resources, and like most municipalities, there are more needs than there are resources.
He feels like the citizens in the community are fairly active in vario...

Read: https://designegycreatives.hashnode.dev/association-rule-with-rapid-miner