Tag: Database
-
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
-
The digital path to growth – sensors and handling data
Posted on September 6, 2021, Level beginner Resource Length medium
There are discussions being held today around hot commodity, "data". Data has also been evolving at an unprecedented pace and affecting our lives directly with its mammoth influence on industries as varied as healthcare, education, banking and finance. By Australian Manufacturing Forum @aumanufacturing.
Tags cio iot analytics big-data data-science management database
-
10 common SQL operations to perform using Pandas
Posted on August 30, 2021, Level beginner Resource Length medium
One of the key features of being a data analyst is to query the data from files, databases etc to perform some data manipulation or visualisation and sometimes it's much better if we can do it directly through code instead of looking into the database tables over and over again.. By Akash Mishra.
Tags database machine-learning big-data data-science python
-
How to use IndexDB to manage state in JavaScript
Posted on July 21, 2021, Level intermediate Resource Length medium
This article explains how to use IndexedDB to store state in a typical client-side JavaScript application. IndexedDB has good cross-browser support and offers at least 1GB of storage. By Craig Buckler.
Tags database javascript frontend web-development
-
ETL pipeline from AWS DynamoDB to Aurora PostgreSQL
Posted on July 20, 2021, Level intermediate Resource Length long
In a world where an ever-increasing amount of data is being gathered, companies often find themselves without the tools to optimally use the often unstructured data they've gathered. By trackit.io.
Tags database big-data cloud aws mysql