Tag: Database
-
Faster MQTT data collection with InfluxDB
Posted on November 11, 2022, Level intermediate Resource Length long
Native MQTT eliminates the need to write custom code, orchestrate additional technology layers or incorporate additional hosting services. By By Jason Myers.
Tags database app-development web-development devops
-
Azure PostgreSQL Flexible Server exciting new backup and restore enhancements
Posted on October 17, 2022, Level beginner Resource Length medium
Backup and restore are key pillars for business continuity and disaster recovery offerings for Azure Database for PostgreSQL Flexible Server. We're excited to announce new features including Fast Restore, Geo Restore and Custom Restore Points to allow you more fine-grained control on your DR plan to achieve the RPO and RTO objectives. In this post we'll share an overview of each of these new features. By Varun Dhawan.
Tags database azure mysql devops
-
Postgres: Better message queue than Kafka?
Posted on October 13, 2022, Level intermediate Resource Length long
Today author is going to talk about why they made the unconventional decision to build thier logging system on top of Postgres, what worked well, what didn't work well, and how they did it. By Pete Hunt.
Tags apache mysql app-development database messaging
-
Reducing graph complexity using Go and transitive reduction
Posted on September 19, 2022, Level intermediate Resource Length medium
Directed acyclic graphs (DAGs) serve a wide variety of applications in computer science, biology, sociology, and other fields that involve complex networks. While these graphs often contain a large number of edges, some of the edges might be redundant, making computations unnecessarily expensive and the graph structure harder to understand. By Dominik Braun.
Tags apis app-development performance golang database
-
Delta Lake and MinIO for multi-cloud data lakes
Posted on August 31, 2022, Level beginner Resource Length medium
Delta Lake is an open-source storage framework that is used to build data lakes on top of object storage in a Lakehouse architecture. Delta Lake supports ACID transactions, scalable metadata handling and unified streaming and batch data processing. By Matt Sarrel.
Tags cio big-data cloud database data-science
-
Seven ways to reduce MySQL costs in the cloud
Posted on August 30, 2022, Level beginner Resource Length medium
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see the immediate effect of those savings, which is what this article will focus on. By Peter Zaitsev.
Tags mysql cio devops cloud database
-
Data Manipulation with functional programming and queries in Ballerina
Posted on August 18, 2022, Level intermediate Resource Length medium
As an adept at Functional Programming (FP), I feel at ease with expressing my data manipulation logic by chaining high order functions like map, filter, and sort operating on arrays and maps. Ballerina, being designed as a Data-Oriented programming language, supports this FP style of coding. By Yehonathan Sharvit.
Tags app-development programming database functional-programming mysql
-
Introduction to Apache Spark and its Datasets
Posted on August 15, 2022, Level intermediate Resource Length medium
In this article, we will introduce you to the big data ecosystem and the role of Apache Spark in Big data. We will also cover the Distributed database system, the backbone of big data. In today's world, data is the fuel. Almost every electronic device collects data that is used for business purposes. By Abhishek Jaiswal.
Tags big-data data-science database miscellaneous
-
Expanding the CAP tradeoff frontier at scale
Posted on August 14, 2022, Level advanced Resource Length medium
Distributed systems must balance their needs for high availability and low latency with consistency guarantees; providing a mostly hit happy path for requests enables these systems to push the boundaries of this tradeoff. By Audrey Cheng.
Tags database big-data data-science performance devops
-
Hidden gems of Google BigQuery
Posted on August 9, 2022, Level intermediate Resource Length medium
BigQuery is amazing. It is one of my favorite tools within Google Cloud. Luckily, it looks like Google feels the same and, to the joy of BigQuery fans, keeps adding new features there. By Artem Nikulchenko.
Tags golang app-development database miscellaneous gcp
-
Scaling up and load balancing your PostgreSQL Cluster using Pgpool-II
Posted on July 12, 2022, Level intermediate Resource Length medium
PostgreSQL's speed, robustness and security makes it suitable for 99% of the new-age applications. Today, let's deep dive into how you can enable scalability and load balancing of your PostgreSQL cluster using Pgpool-II. By Azman Agung Nugraha.
Tags database performance software-architecture mysql
-
Working with a JSONB array of objects in PostgreSQL
Posted on July 7, 2022, Level intermediate Resource Length medium
Get, add and remove JSON objects from an array. By Rob Tomlin.
Tags json database mysql app-development