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
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
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
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
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
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
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
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
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
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/
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
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
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
Ahmed Samir
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 ...
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 ...
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
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/
Бессерверные сервисы облачных вычислений появились в 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
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
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
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
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
Oracle
In-Place Upgrade for Database Cloud Service (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
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
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
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