Tag: Database
-
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 mysql 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 mysql 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
-
Pedal to the metal with PlanetScale and Rust
Posted on April 1, 2022, Level beginner Resource Length medium
We wanted our technology choices to support our mission: a greener modern world, supported by a cleaner modern web. To do that, we decided to take a chance on two novel inventions: Rust for our serverless back-end, and PlanetScale for an enterprise-quality database. By Thomas.
Tags app-development cloud programming database
-
Why mutability is essential for real-time data analytics
Posted on February 24, 2022, Level intermediate Resource Length medium
Successful data-driven companies like Uber, Facebook and Amazon rely on real-time analytics. Personalizing customer experiences for e-commerce, managing fleets and supply chains, and automating internal operations all require instant insights on the freshest data. By Dhruba Borthakur.
Tags analytics database big-data cio data-science search
-
Applying test-driven development to your database
Posted on February 20, 2022, Level intermediate Resource Length medium
Test-driven development (TDD) is a popular software development methodology that aims to reduce defects and improve the ease of maintaining code. In this post, you learn how to apply TDD to write queries and expressions with the Fauna Query Language (FQL). By Ron Callahan.
Tags cloud database cicd tdd nosql
-
Building Real-Time ETL Pipelines with Apache Kafka
Posted on February 17, 2022, Level beginner Resource Length short
Whether you're a data engineer, a data scientist, a software developer, or someone else working in the field of software and data - it's very likely that you have implemented an ETL pipeline before. By Stefan Sprenger.
Tags apache database queues messaging big-data
-
Enabling transparent data encryption for Microsoft SQL with Vault
Posted on February 3, 2022, Level intermediate Resource Length medium
Learn how HashiCorp Vault can help secure data in Microsoft SQL Server using a defense-in-depth encryption strategy. By Narayan Iyengar.
Tags database infosec cloud azure
-
How Airbnb enables consistent data consumption at scale
Posted on December 25, 2021, Level intermediate Resource Length long
In this post, we will focus our story on how Minerva drastically simplifies and improves the data consumption experience for our users. Specifically, we will showcase how a unified metric layer, which we call the Minerva API, helps us build versatile data consumption experiences tailored to users with a wide range of backgrounds and varying levels of data expertise.
Tags data-science database cloud python distributed
-
Tiered datastore solution for high data growth MySQL using Distributed SQL Databases (DSQL)
Posted on December 10, 2021, Level intermediate Resource Length medium
Usually, entities like order, order items etc tend to grow substantially year on year as we scale more and serve large customers. Generally, MySQL is the widely used datastore due to its durable & ACID guarantees. While MySQL is a brilliant tech stack, it comes with the overhead of data maintenance. By Manohar K.
Tags cloud database mysql cio distributed
-
Learn more about distributed databases with ShardingSphere
Posted on December 8, 2021, Level beginner Resource Length medium
Apache ShardingSphere is an open source distributed database, plus an ecosystem users and developers need for their database to provide a customized and cloud-native experience. By Trista Pan.
Tags database distributed nosql cio