LowEndBox - Cheap VPS, Hosting and Dedicated Server Deals

SQL vs. NoSQL – Which is Better?

Tags: , , , , , , , , , Date/Time: October 2, 2021 @ 3:41 pm, by raindog308

In the world of database systems, SQL has been the king since it took off in the early 80s.  It was conceived, developed, and codified in the 1970s but really hit its stride once developers had worked out the kinks and it rapidly overtook earlier, hierarchical DB systems like IMS. In the 21st century, NoSQL […]

The Elephant in the Room: PostgreSQL 101 – Setup and How to Guide

Tags: , , , , Date/Time: March 9, 2021 @ 6:47 am, by raindog308

MariaDB and PostgreSQL are the two leading SQL databases. Both adhere to many ANSI SQL standards, but these ANSI standards don’t specify all behaviors. The SQL statement themselves (such as SELECT, INSERT, UPDATE, and DELETE) are the areas where they have the most commonality. Where they differ the most is in their DDL (data definition […]