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 […]
Category: General
A category for general database related topics.
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 […]
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 […]
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 […]