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

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

Notarize documents on the Ethereum Blockchain

Read: https://aws.amazon.com/blogs/database/notarize-documents-on-the-ethereum-blockchain/

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

AND/OR/NOT - How To Get The Rows You Want More Precisely

AND - Ranges
Between Operators


Multiple Conditions


OR - Being Flexible


Brackets

Read: https://designegycreatives.hashnode.dev/andornot-how-to-get-the-rows-you-want-more-precisely

In-Place Upgrade for Database Cloud Service (DBCS) VM DB Systems

In-Place Upgrade for Database Cloud Service (DBCS) VM DB Systems

Read: https://blogs.oracle.com/database/post/in-place-upgrade-for-dbcs-vm-db-systems

What’s the Database Plus concept and what challenges can it solve?

Background
For a long time, unification or fragmentation were the two most popular predictions for the future of databases. With the advance of digitization, a single scenario cannot meet the needs of diversified applications — making database fragme...

Read: https://distributeddatabase.hashnode.dev/whats-the-database-plus-concept-and-what-challenges-can-it-solve

Java and MySQL - A JDBC Introduction

Java DataBase Connectivity (JDBC)
What is JDBC?
Java Database Connectivity is a tool or an application programming interface
(API) that establishes a connection between a standard Database (say MYSQL) and a Java Application that intends
to use that d...

Read: https://rosekamallove.hashnode.dev/java-and-mysql

Integrating GitLab with Bytebase to Version Control Database Schema Similar to Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-to-version-control-database-schema-similar-to-code

Integrating GitLab with Bytebase to Version Control Database Schema along with Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-to-version-control-database-schema-along-with-code

PostgreSQL Antipatterns: когда мешает внешний ключ

Внешние ключи (foreign keys) - мощный и удобный механизм контроля логической целостности данных в базе. Но он бывает не только лишь полезен, и может неплохо пригрузить вашу БД.

Внимательный взгляд на план запроса поможет избежать многих проблем - как при чтении из базы, так и при вставке в нее.


Читать: https://habr.com/ru/post/665118/

Shared Responsibility: More Agility, Less Risk

Read: https://www.mongodb.com/blog/post/shared-responsibility-more-agility-less-risk

Integrating GitLab with Bytebase for Version Control in Database Schema and Source Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-for-version-control-in-database-schema-and-source-code