Categories
Database General

A guide to the main differences between NoSQL vs. SQL databases

A while back here on the blog, our article ‘Some Basic SQL Queries’ provided beginner-friendly commands for building and deploying SQL databases. These databases have long been popular in the programming community as the syntax and storage logic used are straightforward and reliable. It’s no wonder they remain suited for virtually any industry across a wide […]

Categories
General

In-memory databases

Sometimes in programming need to hold many objects and classes into memory, however, this will cause shortage of heap memory or memory leakage eventually. In order to avoid this bad practice and also not using hard disk to save the data due to its low access speed, you can use in-memory databases. There are variety […]

Categories
General

Database design PKID vs GUID

This is an old school debate, actually some people believe GUID is better some have opposite idea. However, each has its own pros and cons which I have listed as much as I could, PKID advantages Easy to rememberIncremental and therefore query speed is fasterCauses less fragmentation in databaseIt is following particular patternUses less storage […]

Categories
General

Some Basic SQL Queries

Today I was looking for a specific paper out of the huge bulk of my notes and I have found notes about SQL paper which I wrote them when I was in level one. Therefore, I organized the notes and prepare a short review of basic SQL queries here. I hope that it will be […]

Exit mobile version