PHPnews.io

Overview for 'database'


An Introduction to MongoDB

Written by Sitepoint / Original link on Feb. 24, 2020

MongoDB is a cross-platform, open-source, NoSQL database, used by many modern Node-based web applications to persist data.In this beginner-friendly tutorial, I’ll demonstrate how to install Mongo, then start using it to store and query data. I’ll also look at how to interact with a Mongo database …



Visualizing missing data in databases

Written by code-diesel / Original link on Nov. 28, 2019

Missing data in databases can cause bugs in applications or incorrect calculations. Recently, while working on a RETS application, I needed to ensure that not many missing values were encountered in one of the MySQL tables. Although one could easily write a SQL query to find the percentage of missi…