Tag: 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 sql
-
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 sql
-
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 sql app-development
-
What MongoDB teaches us about database trends
Posted on June 7, 2022, Level beginner Resource Length medium
Back in June 2014, the top five most popular databases were exactly the same as June 2022: Oracle, MySQL, Microsoft SQL Server, PostgreSQL and MongoDB. The difference is their relative popularity: PostgreSQL and MongoDB have been gaining in popularity relative to the relational incumbents. By Matt Asay.
Tags cloud nosql microservices database
-
AIOps with Azure Metrics Advisor
Posted on June 4, 2022, Level intermediate Resource Length long
AIOps is a term introduced by Gartner in 2016, referring to AI for IT Operations. It combines big data and machine learning to automate IT operations processes, including event correlation, anomaly detection, and causality determination. By ODSC Community.
Tags cloud devops azure database big-data
-
Migrating to utf8mb4: MySQL things to consider
Posted on May 1, 2022, Level intermediate Resource Length medium
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. By Sveta Smirnova.
Tags sql web-development app-development database
-
MySQL 8: Password verification policy
Posted on April 28, 2022, Level intermediate Resource Length medium
The artcicle discusses the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced. By Brian Sumpter.
Tags sql database cio infosec devops
-
Oracle NoSQL Database Cloud Service - 10 Minutes to Hello World using .NET framework
Posted on April 18, 2022, Level intermediate Resource Length medium
In this post, author will show hello world examples coded in the .NET framework and show how easy it is for developers to get started with the Oracle NoSQL Database cloud, and if you are a .NET developer and already have access to the Oracle Cloud, he believes you will be up and running in 10 minutes or less by using the Oracle NoSQL Database Cloud service with the .NET SDK. By Dario VEGA.
Tags database cio management nosql analytics big-data
-
Archive DynamoDB items to S3 automatically
Posted on April 5, 2022, Level intermediate Resource Length medium
Storing data like JSON logs in DynamoDB is a great idea as DynamoDB is very scalable. In addition, it is easier to transfer data into a DynamoDB table using for example Lambda and AWS SDK. Also, it makes analyzing the logs easier for example the AWS Console offers great filtering options to search for specific so-called table items. By Martin Mueller.
Tags aws serverless learning nosql database