Content Discovery: How to Win the Battle for Attention
Read: https://www.mongodb.com/blog/post/content-discovery-how-win-battle-attention
Read: https://www.mongodb.com/blog/post/content-discovery-how-win-battle-attention
👍1
GROUP BY doesn't sum all numeric rows but... I have a workaround.
Why would you want to sum the numbers of the rows that were grouped by?
The problem:
Let's say we have a database that records the transactions of our user row by row. Like this:
But we don't want or need to display transaction by transaction. It wo...
Read: https://lukasalbus.dev/sqlite3-group-by-with-sum
Why would you want to sum the numbers of the rows that were grouped by?
The problem:
Let's say we have a database that records the transactions of our user row by row. Like this:
But we don't want or need to display transaction by transaction. It wo...
Read: https://lukasalbus.dev/sqlite3-group-by-with-sum
Autonomous Database Newsletter - March 30, 2022
Latest newsletter for Autonomous Database Shared from the ADB product management teams
Read: https://blogs.oracle.com/database/post/autonomous-database-newsletter---march-30-2022-v2
Latest newsletter for Autonomous Database Shared from the ADB product management teams
Read: https://blogs.oracle.com/database/post/autonomous-database-newsletter---march-30-2022-v2
Ecopaynet Chooses MySQL HeatWave Over AWS for Performance and Price
Read: https://blogs.oracle.com/mysql/post/ecopaynet-chooses-mysql-heatwave-over-aws-for-performance-and-price
Read: https://blogs.oracle.com/mysql/post/ecopaynet-chooses-mysql-heatwave-over-aws-for-performance-and-price
Oracle
Ecopaynet Chooses MySQL HeatWave Over AWS for Performance and Price
Ecopaynet's customer success story describes why they chose MySQL HeatWave over AWS to shorten their time to market and benefit from a better price-performance.
Wetin Be Database?
WETIN BE DATABASE?
Database na group of data wey dey well arranged and stored for inside computer.
This Database, dem dey use am store plenty type of different different data, like users information (anybody wey dey use a website, app or software s...
Read: https://hashnode.com/post/wetin-be-database-cl1lwct2m0dpjjvnv9r5xcfcw
WETIN BE DATABASE?
Database na group of data wey dey well arranged and stored for inside computer.
This Database, dem dey use am store plenty type of different different data, like users information (anybody wey dey use a website, app or software s...
Read: https://hashnode.com/post/wetin-be-database-cl1lwct2m0dpjjvnv9r5xcfcw
Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands
In today’s article, we will talk about Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands. Before Switchover, there are a series of checks to see if the system is suitable for Switchover. Some of these controls are general and made for our entire Data Guard Environment, while others are specific to Switchover. …
Read: Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands.
In today’s article, we will talk about Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands. Before Switchover, there are a series of checks to see if the system is suitable for Switchover. Some of these controls are general and made for our entire Data Guard Environment, while others are specific to Switchover. …
Read: Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands.
Угнать за 5 миллисекунд: как мы наладили быструю доставку данных в сложной биржевой системе с помощью Tarantool
Привет! На связи Олег Уткин из отдела архитектуры систем хранения данных Tarantool. Я хочу рассказать, как в ходе проекта для Московской биржи мы консолидировали потоки данных из разных торговых систем и наладили их доставку клиентам. По пути мы собрали много граблей и сделали несколько интересных выводов, которыми я далее поделюсь.
Читать: https://habr.com/ru/post/658251/
Привет! На связи Олег Уткин из отдела архитектуры систем хранения данных Tarantool. Я хочу рассказать, как в ходе проекта для Московской биржи мы консолидировали потоки данных из разных торговых систем и наладили их доставку клиентам. По пути мы собрали много граблей и сделали несколько интересных выводов, которыми я далее поделюсь.
Читать: https://habr.com/ru/post/658251/
👍1
6 reasons why TerminusDB is the right toolkit to build collaborative apps
If you are looking to build collaborative applications where users are a primary source of data and content, then this article explains the TerminusDB and TerminusX features that make them well-suited data management toolkits for building collaborati...
Read: https://hashnode.com/post/6-reasons-why-terminusdb-is-the-right-toolkit-to-build-collaborative-apps-cl1m3u3530eoujvnv2lgh4c2z
If you are looking to build collaborative applications where users are a primary source of data and content, then this article explains the TerminusDB and TerminusX features that make them well-suited data management toolkits for building collaborati...
Read: https://hashnode.com/post/6-reasons-why-terminusdb-is-the-right-toolkit-to-build-collaborative-apps-cl1m3u3530eoujvnv2lgh4c2z
Межкластерная репликация Apache Kafka между тремя дата-центрами
Я Роман Ананьев, NoSQL/Kafka-инженер в Авито. В этом материале расскажу, как мы попробовали использовать брокер сообщений Apache Kafka в трёх дата-центрах и что из этого получилось.
Сначала пробегусь по архитектуре Kafka, потому что она играет роль в репликации между кластерами. Затем коснусь самих способов репликации и расскажу о двух инструментах для неё: MirrorMaker и uReplicator. Основная часть статьи — про нашу реализацию Kafka cluster federation и то, как Kafka размазана на несколько дата-центров.
Читать: https://habr.com/ru/post/651503/
Я Роман Ананьев, NoSQL/Kafka-инженер в Авито. В этом материале расскажу, как мы попробовали использовать брокер сообщений Apache Kafka в трёх дата-центрах и что из этого получилось.
Сначала пробегусь по архитектуре Kafka, потому что она играет роль в репликации между кластерами. Затем коснусь самих способов репликации и расскажу о двух инструментах для неё: MirrorMaker и uReplicator. Основная часть статьи — про нашу реализацию Kafka cluster federation и то, как Kafka размазана на несколько дата-центров.
Читать: https://habr.com/ru/post/651503/
Аварийное восстановление и резервное копирование в облаке
Решения Disaster Recovery восстанавливают работоспособность ИТ-инфраструктуры после сбоя или атаки. Объясняем, как использовать вместе с резервным копированием. Материал будет полезен специалистам, которые начинают работу с облаком и только знакомятся с его возможностями.
Читать: https://habr.com/ru/post/659037/
Решения Disaster Recovery восстанавливают работоспособность ИТ-инфраструктуры после сбоя или атаки. Объясняем, как использовать вместе с резервным копированием. Материал будет полезен специалистам, которые начинают работу с облаком и только знакомятся с его возможностями.
Читать: https://habr.com/ru/post/659037/
MongoDB ASEAN: How the Corporate Sales Team Is Scaling in One of MongoDB’s Fastest-Growing Regions
Read: https://www.mongodb.com/blog/post/asean-how-corporate-sales-team-scaling-one-mongodbs-fastest-growing-regions
Read: https://www.mongodb.com/blog/post/asean-how-corporate-sales-team-scaling-one-mongodbs-fastest-growing-regions
When (and why) not to go serverless
Originally posted at Serverless
There are a lot of people out there championing the serverless movement. Serverless lowers administrative overhead. It takes server maintenance off developers’ plates forever and cuts server costs. The benefits are rea...
Read: https://serverlessinc.hashnode.dev/when-and-why-not-to-go-serverless
Originally posted at Serverless
There are a lot of people out there championing the serverless movement. Serverless lowers administrative overhead. It takes server maintenance off developers’ plates forever and cuts server costs. The benefits are rea...
Read: https://serverlessinc.hashnode.dev/when-and-why-not-to-go-serverless
Scale applications using multi-Region Amazon EKS and Amazon Aurora Global Database: Part 1
Read: https://aws.amazon.com/blogs/database/part-1-scale-applications-using-multi-region-amazon-eks-and-amazon-aurora-global-database/
Read: https://aws.amazon.com/blogs/database/part-1-scale-applications-using-multi-region-amazon-eks-and-amazon-aurora-global-database/
Live Migration from Azure Database for MySQL to MySQL Database Service on OCI
Read: https://lefred.be/?p=5395
Read: https://lefred.be/?p=5395
Day 16/100
Scylla Manager Agent
Reads config from scylla API on start
Listens on Scylla
CPU pinning
Agent conf file etc/scylla-manager-agent/scylla-manager-agent.yaml
Scylla Manager Backup Benefits
Data selection - single table or entire keyspace
deduplica...
Read: https://rawdatareaders.hashnode.dev/day-16100
Scylla Manager Agent
Reads config from scylla API on start
Listens on Scylla
CPU pinning
Agent conf file etc/scylla-manager-agent/scylla-manager-agent.yaml
Scylla Manager Backup Benefits
Data selection - single table or entire keyspace
deduplica...
Read: https://rawdatareaders.hashnode.dev/day-16100
Run SQL Server on macOS + Docker
Intro
If you haven't seen Microsoft's latest Docs site update, you really should check them out. There is a getting started article regarding SQL Server (2017) Containers on Linux and other OSs including Azure. The SQL Server 2019 version article is ...
Read: https://itsjoshcampos.codes/run-sql-server-on-macos-docker
Intro
If you haven't seen Microsoft's latest Docs site update, you really should check them out. There is a getting started article regarding SQL Server (2017) Containers on Linux and other OSs including Azure. The SQL Server 2019 version article is ...
Read: https://itsjoshcampos.codes/run-sql-server-on-macos-docker
👎2
Choosing a Database for Serverless Applications
Originally posted at Serverless
When designing and building an application, one of the key considerations is which database to use. A poor decision here can cost you severely, either by requiring costly ongoing maintenance of a database or by forcing...
Read: https://serverlessinc.hashnode.dev/choosing-a-database-for-serverless-applications
Originally posted at Serverless
When designing and building an application, one of the key considerations is which database to use. A poor decision here can cost you severely, either by requiring costly ongoing maintenance of a database or by forcing...
Read: https://serverlessinc.hashnode.dev/choosing-a-database-for-serverless-applications
How to use MongoDB with Node.js
Introduction
When working with a server, we will always have to save and retrieve data using a database. There are many server-side languages and databases. In this article, we will learn how to use MongoDB with Node.js
MongoDB is a non-relational d...
Read: https://backendbro.hashnode.dev/how-to-use-mongodb-with-nodejs
Introduction
When working with a server, we will always have to save and retrieve data using a database. There are many server-side languages and databases. In this article, we will learn how to use MongoDB with Node.js
MongoDB is a non-relational d...
Read: https://backendbro.hashnode.dev/how-to-use-mongodb-with-nodejs
Import sample database into AWS MySQL using Workbench & Shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with 2 variations: Full dataset (~170 MB) including 300024 employee records and Small dataset (~6 MB) including 10000 employee reco...
Read: https://adelafun.hashnode.dev/import-sample-database-into-aws-mysql-using-workbench-and-shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with 2 variations: Full dataset (~170 MB) including 300024 employee records and Small dataset (~6 MB) including 10000 employee reco...
Read: https://adelafun.hashnode.dev/import-sample-database-into-aws-mysql-using-workbench-and-shell