Software engineering and personal development

Tag: sql

How to find the PostgreSQL version that you are using

Image source: https://docs.datadoghq.com/integrations/postgres/

If you are actively using Rails for developing your projects, then it’s likely that in at least one of your projects you are using PostgreSQL as the database technology. You have already added the pg in your Gemfile and have already started to use it. Then your client asks you about the version of PostgreSQL that you are using, and you may be confused for a bit about it, as you aren’t sure.

Continue reading

How to Print “Hello World” in Top 12 Most Popular Programming Languages

Img source: yen.io

When you start programming, the first thing you usually do is you start by printing something. If you have started to learn from a book, or a tutorial, chances are that the string used in the example was “Hello World”.

One repository on GitHub is dedicated to collect as many such printing examples in as many programming languages as possible. It includes a lot of languages.

I recently prepared a list of how you can do those prints in the top 12 most programming languages (based on GitHub and Tiobe) that you can go and read here.

It includes examples in Java, C, Python, C++, C#, Visual Basic .NET, JavaScript, PHP, Objective-C, SQL, Ruby and Matlab.

If this is something that grabs your interest, you can go and read the article here.

An SQL cheatsheet with some of the most common queries that you may need

Img source: udemy.com

As one of the most famous languages out there that developers use all the time, knowing at least a few things about SQL can be quite helpful. Of course, you can refer back to one of its online documentations, or check up at w3schools.com, but you may also prefer a quick cheat sheet that you can use to refresh up your knowledge or learn something that you may have not learned before. A relatively new Github repository, at least at the time of this writing, has been created, which has some of the most common SQL commands that you may use in your daily tasks. Continue reading

Create great database schemas very intuitively using DBDesigner

Img source: red-gate.com

One of the most important parts of developing a project is the necessity to have a clear picture in mind about the end goal. Namely, knowing the target audience that this project has and the features that it will include. This means that we need to make sure we are informed as much as possible about the business logic, and then be able to do the implementation of all the features as needed.  Continue reading

© 2024 Fatos Morina

Theme by Anders NorenUp ↑