Category: “Database”
MongoDB Indexes - Part 2
This is part two of a two-part series on MongoDB indexes. In my previous post, I talked about what indexes are, how they can help us, and some types o...
Continue readingMongoDB Indexes - Part 1
In this post, I will try to explain what indexes in MongoDB are and how they help you improve the performance of your application. We will be talking ...
Continue readingMongoDB One-to-Many and Many-to-Many (Basics)
In my previous post I talked about sub-documents. If you are here, this means you have a compelling reason not to use sub-documents (probably reasons ...
Continue readingMongoDB sub-documents (Basics)
As we all know, MongoDB is a document-oriented database which is a NoSQL database. One of the great features of MongoDB is supporting sub-documents. I...
Continue reading
MySQL Sorting Persian Data
Introduction: When sorting Persian data in mysql, Persian letters (گ,چ,پ,ژ) are not placed in the right order and they will appear after other letters...
Continue reading
Fetching Records from Database
In this post I want to talk about fetching records from your database using SQL Syntax. As always, let's start with an example. Imagine we have one ta...
Continue reading