Automate Amazon RDS for PostgreSQL horizontal scaling and system integration with Amazon EventBridge and AWS Lambda
Read: https://aws.amazon.com/blogs/database/automate-amazon-rds-for-postgresql-horizontal-scaling-and-system-integration-with-amazon-eventbridge-and-aws-lambda/
Read: https://aws.amazon.com/blogs/database/automate-amazon-rds-for-postgresql-horizontal-scaling-and-system-integration-with-amazon-eventbridge-and-aws-lambda/
Azure SQL Database Tools Part 4: Other Platform Tools
Until now, we’ve been looking at tools from a specific developer or platform. We covered ApexSQL, dbForge, and native Azure tools. In this final list, we’ll be going through tools from different developers and they won’t be from one specific company ...
Read: https://arctype.hashnode.dev/azure-sql-database-tools-part-4-other-platform-tools
Until now, we’ve been looking at tools from a specific developer or platform. We covered ApexSQL, dbForge, and native Azure tools. In this final list, we’ll be going through tools from different developers and they won’t be from one specific company ...
Read: https://arctype.hashnode.dev/azure-sql-database-tools-part-4-other-platform-tools
Loading a Heroku PostgreSQL Database with Data
Recently, I needed to get a PostgreSQL database running on Heroku with some sample data. Here's what I had to do to make it happen - and some of the limitations I discovered in Heroku's PostgreSQL offering.
Heroku versus...well, everything else
Firs...
Read: https://jayallen.hashnode.dev/heroku-postgresql-importing-data-sql
Recently, I needed to get a PostgreSQL database running on Heroku with some sample data. Here's what I had to do to make it happen - and some of the limitations I discovered in Heroku's PostgreSQL offering.
Heroku versus...well, everything else
Firs...
Read: https://jayallen.hashnode.dev/heroku-postgresql-importing-data-sql
Why Redis is the new best database ?
Redis is a simple in-memory key value database mainly used for caching. Redis used to be a simple in-memory database. Now Redis is much more than that. Thanks to Redis modules, apart from the simple data structures such as strings, sets, maps, stream...
Read: https://samthomas.hashnode.dev/why-redis-is-the-new-best-database
Redis is a simple in-memory key value database mainly used for caching. Redis used to be a simple in-memory database. Now Redis is much more than that. Thanks to Redis modules, apart from the simple data structures such as strings, sets, maps, stream...
Read: https://samthomas.hashnode.dev/why-redis-is-the-new-best-database
Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update
Since Apache ShardingSphere 5.0.0-Beta version included DistSQL, it made the project increasingly loved by developers and Ops teams for its advantages such as dynamic effects, no restart, and elegant syntax close to standard SQL.
With upgrades to 5.0...
Read: https://apacheshardingsphere.com/your-guide-to-distsql-cluster-governance-capabilityapache-shardingsphere-feature-update
Since Apache ShardingSphere 5.0.0-Beta version included DistSQL, it made the project increasingly loved by developers and Ops teams for its advantages such as dynamic effects, no restart, and elegant syntax close to standard SQL.
With upgrades to 5.0...
Read: https://apacheshardingsphere.com/your-guide-to-distsql-cluster-governance-capabilityapache-shardingsphere-feature-update
Build an Open Source app with PlanetScale in July, and compete for $20,000 in cash prizes and swags! 🎉
Who's ready for Hashnode's next Hackathon? 🎉
We are excited to announce that we're partnering with amazing folks at PlanetScale for the July Hashnode Hackathon, Yay!!!
About PlanetScale
PlanetScale is a database for developers, scalers, creators, ...
Read: https://townhall.hashnode.com/planetscale-hackathon
Who's ready for Hashnode's next Hackathon? 🎉
We are excited to announce that we're partnering with amazing folks at PlanetScale for the July Hashnode Hackathon, Yay!!!
About PlanetScale
PlanetScale is a database for developers, scalers, creators, ...
Read: https://townhall.hashnode.com/planetscale-hackathon
Backfilling an Amazon DynamoDB Time to Live attribute using Amazon EMR: Part 2
Read: https://aws.amazon.com/blogs/database/part-2-backfilling-an-amazon-dynamodb-time-to-live-attribute-using-amazon-emr/
Read: https://aws.amazon.com/blogs/database/part-2-backfilling-an-amazon-dynamodb-time-to-live-attribute-using-amazon-emr/
Как BI «купается» в озёрах данных: практика платформы «Форсайт». Часть 4 (заключительная). Кэширование — нужно или нет?
Всем привет.
Мы завершаем цикл статей о том, как BI-платформа «Форсайт» работает с данными в связке «BI+Data Lake». В этом посте мы поговорим про правильные и уместные применения кэша при работе платформы. Расскажем, чем отличается адаптивный in-memory куб и внутренний файловый MOLAP-сервер в платформе «Форсайт». Поясним, как работает персональный и кросс-сессионный кэш. Определим рекомендации, в каких случаях можно и нужно использовать технологию in-memory в BI-платформе. Также мы будем вам благодарны, если в конце статьи вы проголосуете и укажете, был ли вам полезен подобный цикл статей. Добро пожаловать под кат.
Читать: https://habr.com/ru/post/674462/
Всем привет.
Мы завершаем цикл статей о том, как BI-платформа «Форсайт» работает с данными в связке «BI+Data Lake». В этом посте мы поговорим про правильные и уместные применения кэша при работе платформы. Расскажем, чем отличается адаптивный in-memory куб и внутренний файловый MOLAP-сервер в платформе «Форсайт». Поясним, как работает персональный и кросс-сессионный кэш. Определим рекомендации, в каких случаях можно и нужно использовать технологию in-memory в BI-платформе. Также мы будем вам благодарны, если в конце статьи вы проголосуете и укажете, был ли вам полезен подобный цикл статей. Добро пожаловать под кат.
Читать: https://habr.com/ru/post/674462/
Another reason why you may be facing ORA-03150: end-of-file on communication channel for database link
The Setup
We have an Oracle server with database links created to multiple database servers. The target servers also being Oracle. There is a stored procedure written which queries the data present in certain tables in these linked servers and essent...
Read: https://pavanandhukuri.com/another-reason-why-you-may-be-facing-ora-03150-end-of-file-on-communication-channel-for-database-link
The Setup
We have an Oracle server with database links created to multiple database servers. The target servers also being Oracle. There is a stored procedure written which queries the data present in certain tables in these linked servers and essent...
Read: https://pavanandhukuri.com/another-reason-why-you-may-be-facing-ora-03150-end-of-file-on-communication-channel-for-database-link
Querying Databases - SQL vs NoSQL
Transitioning to a NoSQL database can be daunting for folks who have spent the better part of their coding journey dabbling in RDBMS systems (like yours truly :)). Which is what inspired this article. If you are one of those who can whip up an SQL qu...
Read: https://divyakblogs.hashnode.dev/querying-databases-sql-vs-nosql
Transitioning to a NoSQL database can be daunting for folks who have spent the better part of their coding journey dabbling in RDBMS systems (like yours truly :)). Which is what inspired this article. If you are one of those who can whip up an SQL qu...
Read: https://divyakblogs.hashnode.dev/querying-databases-sql-vs-nosql
How to use GraphQL Dataloaders in NestJS
So you've just finished coding your nice, shiny new GraphQL API in NestJS. You launch it into production and... it's a bit sluggish. And there seem to be a lot more queries in the database logs than you'd expect. What's going on?
The N+1 Problem
Let'...
Read: https://eoin.ai/how-to-use-graphql-dataloaders-in-nestjs
So you've just finished coding your nice, shiny new GraphQL API in NestJS. You launch it into production and... it's a bit sluggish. And there seem to be a lot more queries in the database logs than you'd expect. What's going on?
The N+1 Problem
Let'...
Read: https://eoin.ai/how-to-use-graphql-dataloaders-in-nestjs
❤1
The 4.5 Kinds of DevTool Platforms
One of the most immediate problems I encountered when starting to work and invest in devtool startups was my lack of a good mental model for assessing them.
I think I have finally found one, and I call it The 4.5 Kinds of Devtool Platforms:
Context
...
Read: https://dx.tips/platform-kinds
One of the most immediate problems I encountered when starting to work and invest in devtool startups was my lack of a good mental model for assessing them.
I think I have finally found one, and I call it The 4.5 Kinds of Devtool Platforms:
Context
...
Read: https://dx.tips/platform-kinds
How to use Amazon RDS and Amazon Aurora with a static IP address
Read: https://aws.amazon.com/blogs/database/how-to-use-amazon-rds-and-amazon-aurora-with-a-static-ip-address/
Read: https://aws.amazon.com/blogs/database/how-to-use-amazon-rds-and-amazon-aurora-with-a-static-ip-address/
🕺You want to present your insights right from inside Azure SQL Database? Then this video is for you!
See how here
Read: https://jiteanalytics.hashnode.dev/you-want-to-present-your-insights-right-from-inside-azure-sql-database-then-this-video-is-for-you
See how here
Read: https://jiteanalytics.hashnode.dev/you-want-to-present-your-insights-right-from-inside-azure-sql-database-then-this-video-is-for-you
Database Indexes Explained
Have you wanted to improve the query performance? Or have you faced any situation where the indexes you added weren't used? Read further to know.
Note - Although most of this can be generalized, this post is specific to Postgres.
Database indexes are...
Read: https://joeljacob.hashnode.dev/database-index-explained
Have you wanted to improve the query performance? Or have you faced any situation where the indexes you added weren't used? Read further to know.
Note - Although most of this can be generalized, this post is specific to Postgres.
Database indexes are...
Read: https://joeljacob.hashnode.dev/database-index-explained
Amazon RDS Performance Insights supports additional performance history retention periods
Amazon Relational Database Service (Amazon RDS) Performance Insights now allows you to choose retention periods for your performance history that range from one month up to 24 months. You can also use the RDS Performance Insights free tier, which inc...
Read: https://dominguezdaniel.hashnode.dev/amazon-rds-performance-insights-supports-additional-performance-history-retention-periods
Amazon Relational Database Service (Amazon RDS) Performance Insights now allows you to choose retention periods for your performance history that range from one month up to 24 months. You can also use the RDS Performance Insights free tier, which inc...
Read: https://dominguezdaniel.hashnode.dev/amazon-rds-performance-insights-supports-additional-performance-history-retention-periods
Changing electrs's Database Backend (Part 1/7)
Introduction
In this series I'm going to talk about my project in Summer of Bitcoin.
This is the first part of what's gonna be seven blog posts about my progress through the project.
I'm going to explain what is it that I aim to achieve and my though...
Read: https://blog.khaledemara.dev/changing-electrss-database-backend-part-17
Introduction
In this series I'm going to talk about my project in Summer of Bitcoin.
This is the first part of what's gonna be seven blog posts about my progress through the project.
I'm going to explain what is it that I aim to achieve and my though...
Read: https://blog.khaledemara.dev/changing-electrss-database-backend-part-17
HarperDB: a Modern Tool for Fullstack Development
If you're looking for a new database for your next web development project, you may be wondering which DB will work best for you and your team. While having so many options is excellent, weighing the benefits and drawbacks of each type of database ca...
Read: https://theankurtyagi.hashnode.dev/harperdb-a-modern-tool-for-fullstack-development
If you're looking for a new database for your next web development project, you may be wondering which DB will work best for you and your team. While having so many options is excellent, weighing the benefits and drawbacks of each type of database ca...
Read: https://theankurtyagi.hashnode.dev/harperdb-a-modern-tool-for-fullstack-development
PostgreSQL Antipatterns: куда крутить NULLS
Периодически приходится разбирать случаи внезапного промаха запроса мимо "вроде бы подходящего" индекса - а все дело оказывается в чуть-чуть не той сортировке.
Читать: https://habr.com/ru/post/675580/
Периодически приходится разбирать случаи внезапного промаха запроса мимо "вроде бы подходящего" индекса - а все дело оказывается в чуть-чуть не той сортировке.
Читать: https://habr.com/ru/post/675580/
DICOM: цифровые снимки в медицине — ликбез для системного администратора
Одним из самых компьютеризированных разделов медицины является радиодиагностика. Медицинские исследования генерируют большое количество данных, которые затем обрабатываются передовыми методами визуализации, 3d-реконструкции по срезам и даже машинного обучения. Этот топик призван помочь системным администраторам погрузиться в тематику передачи и хранения медицинских изображений.
Фото автора
Читать: https://habr.com/ru/post/217761/
Одним из самых компьютеризированных разделов медицины является радиодиагностика. Медицинские исследования генерируют большое количество данных, которые затем обрабатываются передовыми методами визуализации, 3d-реконструкции по срезам и даже машинного обучения. Этот топик призван помочь системным администраторам погрузиться в тематику передачи и хранения медицинских изображений.
Фото автора
Читать: https://habr.com/ru/post/217761/