MG

Oryantasyon süreci yeni işe başlayan kişiler için oldukça önemli bir süreç. Bu süreç genel olarak tanışma ve Yazılım Uzmanı olarak çalışacağımız projenin detaylarının öğretilmesi gibi düşünülse de benim görüşüme göre aşağıda belirttiğim aşamaların üzerinden geçmek çok önemli. * Şirketin hikayesi * Projenin hikayesi * Yönetimin hikayesi * Diğer birimlerin hikayesi * Ekip arkadaşlarının hikayesi * Çalışacağınız projenin hikayesi Üniversite son sınıf veya kariyerine yeni başlayacak arkadaşlarım için hazırladığım %5Teknik PodCast serisinin birinci bölümünde Oryantasyon konusu ve önemini ele aldım. Keyifli dinlemeler.

You will need logical operators one way or another when you are querying your database. You can find the syntax in this link to find out about logical operators. I want to tell you something different. $and operator. MongoDB ANDs the filter query by default. But why do you need this operator? 

Assume that you ran the command below:

Find all the movies which rating is 9 and has a Drama Genre

Find all the movies which rating is 9 and has a Drama Genre

Find all movies which have Drama Genre

Find all movies which have Horror Genre

Find all movies which have Horror Genre

Find all movies which genre has Drama and Horror.

You may notice we have a couple of insert methods in MongoDB. You can use .insertOne({}), .insertMany([{},{}]) or you can use .insert(). First two are obvious but the last one seems different! .insert() method inserts the document like other methods but it does not return the ObjectId (or _id). Let’s look at the image below:

You can use insert() method but I think you should not. Because in a real world application you probably want to get inserted _id to continue operation. Maybe you should show the name of the hobby so the user can click on it. If you use insert, you should get the _id manually which is a little tiring operation. So you should use insertOne() or insertMany() operations.

How about if you want to add multiple documents at once. You decided to go with insertMany(). Let's look at the example below:

I inserted two car document with custom _id. Then I decided to go with another insertMany() operation. Careful I didn't change the Mercedes.

MongoDB raised an error for the duplicate key. But also you can see it inserted the first document in the array which is Volvo. MongoDB by default inserts the document until an error occurs and then stops the operation. Ferrari didn’t insert. This is called Ordered Insert

You can skip documents which aren’t able to insert and continue for the rest. You can close/disable Ordered Insert for the command by writing this command:

If you properly installed and started your MongoDB instance we can dive into it and start writing some basic codes. Open your command prompt as usual. Type

mongo

After you connected to mongo, type

show dbs

You should probably see 3 databases which store metadata for us. If you want to connect a database simply type

use shop

You will now work with "shop" database even it doesn't exists. Now you can insert a collection to "shop" database. Type

db.products.insertOne({title:"T-Shirt",price:123.45})

You can omit " around the key, this is a little feature. It is stored with the " anyway. You should see the acknowledge message. If you want to find the data you just inserted type:

db.products.find()

Now you can see the data. Actually this method shows all the data in your collection but you have one right now. If you want to see the data in more readable way you can add

.pretty()

at the and of the find command. You may ask your self: "Am i create my database in command prompt, in year 2018". Shell is very useful and good way to learn new stuff but you need a driver to write code in your favorite programming language which mine is C#. Now, go to mongodb.com and click

docs and than drivers

MongoDB runs on every operating system. Mac OS, Linux, Windows. First, you need to download MongoDB. Go to http://mongodb.com and click the top rightmost button: "Get MongoDB". Click on the "Server" tab and choose your operating system as you wish. I'm a windows user so I choose Windows 64-bit x64 and MSI package. If you downloaded the package, run and install the database. You may install mongo as a service so you don't need to start it every time. Don't worry if you didn't install it as a service, I'll show you how to run it. After you install you may want to add "mongo" to your environment variables. Click windows start menu type "Environment" and click the result. You should see the window shown in the image

Add the path of your MongoDB installation to PATH variable. This is the path to my default installation folder: "C:\Program Files\MongoDB\Server\4.0\bin". So go ahead and add this path to your user variables.

If you able to follow the instructions, you should be good to go. Now open command prompt once again. and type mongo . That’s it. You are connected to MongoDB. 

Stop MongoDB

MongoDB installed as a service to your Windows machine and it’ll start when you open your PC. Let’s stop the service and see how to manually start MongoDB. First of all, stop the MongoDB by typing “net stop MongoDB” in your command prompt. 

Start MongoDB

“mongo” command basically opens a client for you in your command prompt. If you want to start you MongoDB Server you should write “mongod”. After starting your MongoDB instance open another command prompt but don’t close the first one and type “mongo” this time (no “d” at the end). If you want to start your MongoDB with a different data folder you can run this command

mongod --dbpath “C:\data\db”

Hint: If you want to stop your MongoDB instance just press Ctrl+C in your command prompt which we typed “mongod” command.

Hint: If you are getting an error about permission, basically start your command prompt int Admin privileges.

Hint: If you want to start your MongoDB rather than default port which is 27017, you can use this comman: mongod --port 27018 . You can also connect to MongoDB with different port using this command: mongo --port 27018

MongoDB has other products that you can use. You may or you may not use them all. It is all about what you need. So let's look at the diagram:

MongoDB Database This is obvious, the database you want to work on it. It has community edition and has all the features you need for now.

Atlas (Cloud) You can focus your data and all the system and ops related tasks done for you.

Mobile MongoDB Mobile lets you store data where you need it, from iOS, Android, and IoT devices to your backend in the cloud – all using a single database. MongoDB Mobile lets you build the fastest, most reactive, always-on apps.

Compass This is the user interface to manage your MongoDB. Visually explore your data. Run ad hoc queries in seconds. Interact with your data with full CRUD functionality. View and optimize your query performance.

BI Connectors The MongoDB BI Connector lets you use MongoDB as a data source for your BI and analytics platforms. Seamlessly create the visualizations and dashboards that will help you extract the insights and hidden value in your multi-structured data.

MongoDB Charts This is in BETA as I write this article. MongoDB Charts is the fastest and easiest way to create visualizations of MongoDB data. Connect to any MongoDB instance as a data source, create charts and graphs, build dashboards, and share them with other users for collaboration.

Stitch Exposes the full power of working with documents in MongoDB and the MongoDB query language, directly from your web and mobile application front-end code. A powerful rules engine lets developers declare fine-grained security policies.

Allows developers to run simple JavaScript functions in the Stitch serverless platform, making it easy to implement application logic, securely integrate with cloud services and microservices, and build APIs.

Executes functions in real time in response to changes in the database or user authentication events.

Automatically synchronizes data between documents held locally in MongoDB Mobile and the backend database.

What is MongoDB? It is just basically a database. But not like others.  First of all, you should know that the company behind the MongoDB called MongoDB. Same name, no confusion. They also offer some other tools you to use with their database systems like MongoDB Stitch or Atlas. I may examine them later on this article series, why not?

Fun fact: mongo comes from Humongous which means huge; enormous. Because you can store tons of data.

We got another database systems like MySQL or MySQL how MongoDB differs from them. Ok, let's look at the diagram shown below.

In traditional databases like MySQL, you have database and tables in it. Tables have strict definitions, like columns, data types etc. But in MongoDB, we have documents instead of tables and these documents have no schemas. Each document can have different properties so called. Look at the products, one with the title and other with the title and price. Relational databases have a strict rule on data types also. You can't store a string in an int column. But in MongoDB, you can keep any data type in any document. Of course, you will need some structure in your documents to prevent things from getting messy. You can see a sample JSON(BSON) object so-called 'Document'.

Fun Fact: MongoDB converts your JSON object into the Binary format so we refer as BSON rather than JSON. Querying data becomes more efficient in this way.

Every document has keys and keys consists of 'name of the key' and 'value of the key'. You can also keep nested keys in a document. This is the power of MongoDB. You store your data as a whole. This way you can work with the data as a single unit and writing-fetching data becomes super fast and efficient. For the example above you need to write joins in a relational database to fetch users with addresses.

Documents have no schema at all. This means responsibility is on your shoulders. You need to work with the structured data but sometimes you may work on a project that data gets its final situation through the development process. You can add or remove data to your collections anytime you want. You also work with the fewer relations because your object stays as a unit. Like I said before this is where the efficiency comes from. When you want to fetch your data you don't need to go to Table A and join with Table B and so on. All you need to do is get your object like 'Person' which includes all the necessary information. You don't need to merge data most of the time.

Wow, what a big move from Microsoft. Github was one (probably the best) of the best repo for developers and this acquisition will improve GitHub. I saw some of the developers complain about the situation but you should read this letter from GitLab. I’m very excited and willing to see what will change in MS Development tools as well as GitHub. Congrats MS.

Visual Studio 2017

2 years past. Visual Studio 2017 finally released. It is like christmas for the .NET Developers! Looks like microsoft added lots of features especially to Mobile App Development Projects. Now Visual Studio has iOS Simulator. Improvements also made in Cloud Integration. Miscrosoft says:

Built-in tools provide comprehensive integration with all of your .NET Core, Azure applications, services, Docker containers, and more. The experience is so seamless that you’ll feel like you’re working from inside an Azure datacenter.

Installing Visual Studio was a problem. They improved over the years but still tooks too much time. But with the VS2017 they changed the install process. New features:

Installs more quickly with less system impact.

Uninstalls cleanly.

Reduces the footprint of Visual Studio.

Makes it easier for you to select and install just the features you need.

Most of the developers (not all!) dont use test projects but we all know they’r very important. Microsoft also made improvements in testing. Live Unit Testing visualizes unit test results and code coverage live on the editor, as you are coding. They made some changes in debugging habbits also. They introduced Run To Click Debugging.  You can simply click the icon next to a line of code whilst debugging to run to that line. You no longer have to set temporary breakpoints or perform several steps to execute your code and stop on the line you want (thanks MS). There are lots of other improvements and updates, here are some of them:

The GitHub extension for Visual Studio can be selected in the new Visual Studio installer.

Visual Studio has been optimized to reduce startup time and solution load time.

Visual Studio now can monitor extension performance that has an impact on startup, solution load, or editing.

Reload All Projects has been replaced with Reload Solution to support better performance of switching branches external to Visual Studio.

You are now automatically taken to the folder view of your repository after cloning.

A new external service host is being introduced; it will replace VSHub.

Pre-release license expiration messages more clearly communicate the current license state.

The Account Settings dialog is now more accessible to screen readers.

The version control status bar makes it easier to publish local repos to an SCC host and keep track of uncommitted and un-pushed work.

I’ll get as soon as possible and upgrade my Visual Studio 2015 to 2017 and i advice you to do same (i saw developers still on 2010 because they’r too lazy to update their projects. Don’t be of them). Sound good? Go get it from Microsoft. Happy coding!