Tag: Database
-
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
-
How does an SQL injection attack work? Examples & types
Posted on December 6, 2021, Level intermediate Resource Length medium
A SQL injection (SQLi) attack is one of the most threatening issues for data integrity and confidentiality today, allowing attackers to access secure data where they are not authorized. In this article, we discuss SQLi and how these attacks work, with types and examples. By Al Mahmud Al Mamun.
Tags servers mysql database miscellaneous cloud cio distributed
-
How Uber migrated financial data from DynamoDB to Docstore
Posted on December 5, 2021, Level intermediate Resource Length medium
Introducing Quantum Serverless, a new programming model for leveraging quantum and classical resources. By Blake Johnson, Ismael Faro, Michael Behrendt, Jay Gambetta @ibm.com.
Tags database cloud software-architecture distributed
-
Dealing with eventual consistency and idempotency in MongoDB projections
Posted on November 21, 2021, Level intermediate Resource Length medium
Auditability, diagnostics, time travelling are usually the first mentioned features when speaking about Event Sourcing. All of them are great, but to me, projections are the real killer feature of an event-driven approach. Why? By Oskar Dudycz.
Tags cloud database streaming nosql cio queues
-
Transitioning from MySQL to MongoDB
Posted on November 7, 2021, Level beginner Resource Length long
This article will not discuss the different types of database systems, like RDBMS and so on. We will, however, focus on two concepts: SQL Databases and NoSQL databases. By @peteradeojo.
Tags nosql database software mysql devops
-
Swiftly search metadata with Amazon S3 serverless architecture
Posted on October 31, 2021, Level beginner Resource Length medium
As you increase the number of objects in Amazon Simple Storage Service (Amazon S3), you'll need the ability to search through them and quickly find the information you need. By Jiwan Panjiker, Haider Naqvi, and Muthuvelan Swaminathan.
Tags serverless app-development database cloud cio
-
Paginations 1.0: Time series collections in five minutes
Posted on October 28, 2021, Level intermediate Resource Length medium
As someone who loves to constantly measure myself and everything around me, I was excited to see MongoDB add dedicated time-series collections in MongoDB 5.0. Previously, MongoDB had been great for handling time-series data, but only if you were prepared to write some fairly complicated insert and update code and use a complex schema. In 5.0, all the hard work is done for you, including lots of behind-the-scenes optimization. By John Page.
Tags nosql app-development database web-development
-
Hosting SQLite databases on Github Pages
Posted on October 25, 2021, Level beginner Resource Length medium
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a database, you either need to write a backend (which you then need to host and maintain forever) or download the whole dataset into the browser (which is not so great when the dataset is more than 10MB). By phiresky's blog.
Tags database app-development mysql javascript
-
Everything I learned in my 1st year as a SWE: GraphQL
Posted on October 12, 2021, Level beginner Resource Length medium
A beginner's crash course in GraphQL & REST APIs. In this series, I'll be sharing all the tools and technologies that I've picked up in my first year in the hopes of helping other entry-level engineers on their journey. By Camila Ramos.
Tags devops cloud nosql database
-
Postgres full-text search: Search engine in a database
Posted on October 9, 2021, Level intermediate Resource Length medium
So when we say PostgreSQL is the "batteries included database," this is just one reason why. With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro. By Kat Batuigas.
Tags database search microservices nosql software-architecture cloud mysql
-
How we shipped PostgreSQL 14 on Azure within one day of its release
Posted on October 4, 2021, Level intermediate Resource Length medium
In this blog post, you'll first get a glimpse into some of our favorite features in Postgres 14. These include connection scaling, faster VACUUM, and improvements to crash recovery times. By Ozgun Erdogan.
Tags devops how-to learning azure database cloud