MySQL is arguably the most popular and common RDBMS. The last major release was MySQL 5.7, back in 2013. As you probably heard, MySQL 8.0 was released to the public, and with it there are some very exciting new enhancements. MySQL 8.0 can be downloaded from MySQL's official website. So without further ado, let's dive into listing the… Continue reading MySQL 5.7 vs MySQL 8.0 – What’s new in MySQL 8.0?
This post's contentWhat's an ORM?Comparing Django vs SQLAlchemyActive Record vs Data MapperWorking with Complex QueriesPrimary Key Automatic GenerationAutocommitSupported DatabasesLearning CurveCommunity SizePerformanceSummary What's an ORM? Before going into the difference between Python's ORM frameworks (Django and SQLAlchemy), let's make sure we fully understand the use of ORM frameworks in general. ORM stands for Object Relational Mapping. Looking… Continue reading Django vs SQLAlchemy – Which Python ORM is better?
This post's content#1 - Introduction to Programming Using Java, 7th Edition#2 - What’s New in Java 8#3 - Think Java#4 - Java a Beginners Guide#5 - Java Application Development on Linux I'm a big fan of learning from your coworkers and peers, as they probably possess knowledge you won't find in any book. Said that, I wouldn't count on learning everything… Continue reading Best Free Books for Java Programming 2017
This post's contentASP.NETNetworkingWindows FormsWCFWPFSummary .NET Framework is a programming infrastructure created by Microsoft and is used by millions of programmers world wide, programming in popular languages such as C#. Recently, Microsoft announced the release of .NET Framework 4.7 with some exciting enhancements and improvements. The goal of this article is to list the advantages in… Continue reading What’s new in Microsoft .NET Framework 4.7?
It's only been six months since Google released the beta of their new tool OSS-Fuzz, and it's already proving itself as an amazing tool, both for open source application developers and the communities that are using and supporting them. OSS-Fuzz's goal is to to make common software infrastructure more secure and stable. Google initiated this effort… Continue reading You’re using unsafe open source libraries – Google uncovers 1000 bugs
This post's contentHello WorldApril FoolFrom C++ to PythonThe Classic OneThe Anti Gravity Comics When a programming language is open source, funny and interesting stuff happen. Usually, it means that the contributing community will add funny and special easter eggs and hidden features to the language (though without adding any risk to production usages of course). Python… Continue reading Top 5 Python Easter Eggs and Hidden Features
This post's content#1 - Javascript#2 - Java#3 - Python#4 - PHP#5 - C##6 - C++#7 - R#8 - Swift#9 - C#10 - Ruby#11 - GoReferences The way I look at it, programmer's source of truth is StackOverflow, and it's been this way for years now. Therefore, I did some research over there and looked into… Continue reading Top 10 Programming Languages for May 2017
This post's contentROW_NUMBER FunctionExample:The results:RANK FunctionExample:The results:DENSE_RANK FunctionExample:The results:Summary PostgreSQL offers several ranking functions out of the box. Let's look into the differences and similarities between three of them: RANK(), DENSE_RANK() and ROW_NUMBER(). For the sake of comparison, we'll work with the following demo table and values: ROW_NUMBER Function This is the simplest of all to understand. This function will just… Continue reading RANK vs DENSE_RANK vs ROW_NUMBER in PostgreSQL
This post's contentQuestion 1 - Is your data model static or dynamic?Question 2 - What's your project's main use case?Question 3 - Are you using complex stored procedures?Question 4 - Are you using database-specific functionality?Summary The title might have hinted you that I'm going to diss ORMs and preach against using them at all cost. Well,… Continue reading I followed Hibernate ORM to hell and came back alive to tell about it
Database administrators and programmers are often in a situation where they need to open or edit a large SQL file. These files are often created using the mysqldump utility, when generating cold backups of the database. The common simple text editors such as Notepad and Notepad++ will not be able to properly open large SQL files,… Continue reading How to open and edit a large 250GB SQL file in Windows?