Table of Contents
Help! I’m lost!
But I don’t want to use the Brian Keller VM!
I already have MS RM set-up. What’s the minimal work I need to do to add a DB to my system?
Exercise 1 – Source Controlling your Database
Linking a Database to source-control
Exercise 2 – Getting your Database into the Continuous Integration Process
Part … Read More →
Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback in the form of errors returned. Potential problems with … Read More →
By default the port 80 for http connection is filtered on Redhat 7 as you can only access this port from the actual localhost and not from any other public host. To open a port 80 on RHEL 7 Linux we need to add an iptables rule. For this RHEL7 uses firewall-cmd. First add your … Read More →
Microsoft étant Microsoft, ce n’est absolument pas simple d’accéder à Bash sous Windows 10. Voici les étapes à suivre pour accéder à la précieuse fonctionnalité.
Commencez bien entendu par mettre à jour Windows 10 avec la mise à jour Anniversary Update, disponible depuis le 2 août 2016
Allez dans Paramètres (remerciez au passage Microsoft d’avoir divisé en … Read More →
There are n stairs, a person standing at the bottom wants to reach the top. The person can climb either 1 stair or 2 stairs at a time. Count the number of ways, the person can reach the top.
Consider the example shown in diagram. The value of n is 3. There are 3 ways to … Read More →
Python is strongly typed (i.e. types are enforced), dynamically, implicitly typed (i.e. you don't have to declare variables), case sensitive (i.e. var and VAR are two different variables) and object-oriented (i.e. everything is an object).
Help in Python is always available right in the interpreter. If you want to know how an object works, all … Read More →
Searching element in std::map by Value
External Sorting Criteria / Comparator
External sorting criteria i.e. Comparator
std::map with external sorting criteria i.e. Comparator
So what is Agile ? Agile methodologies were created based on the Agile Manifesto, which contains this set of values and principles:
Individuals and interactions over processes and tools
Working software over comprehensive documentation
Customer collaboration over contract negotiation
Responding to change over following a plan
Agile trait: Production is iterative and incremental. Fully tested, functional chunks of value are … Read More →
A product ownercreates a prioritized wish list called a product
During sprint planning, the team pulls a small chunk from the top of that wish list, a sprint backlog, and decides how to implement those pieces.
The team has a certain amount of time — a sprint (usually two to four weeks) — to complete its work, … Read More →
Simple Way To Use Pivot In SQL Query
This post intends to help T-SQL developers get started with PIVOT queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past.
Let us have a table name Invoice which has … Read More →
When it comes to project management tools, you certainly have a lot of options to choose from, and that’s mostly a good thing. However, sometimes the abundance of choice can backfire, and even entirely halt your efforts.
I mean, speaking about the tools that can be used for project management, we have: JIRA, Anydo, TeamClerk, Remember … Read More →
We willl use PostgreSQL
Download latest stable PostgreSQL RPM for CentOS 7 :
Install this release :
Create a new PostgreSQL database cluster :
We will install Java 8 SDK
Install “java-1.8.0-openjdk-devel” package :
Download SonarQube, and copy it to your server :
User & database
Logon as “postgres” :
Set password (here : ‘sonar’) to this PosgreSQL user :
Start & … Read More →
PL/SQL Cop for SonarQube is a plugin for SonarQube. The plugin analyses SQL and PL/SQL code and calculates various metrics and checks the code for compliance of the Trivadis PL/SQL & SQL Coding Guidelines Version 2.0. Behind the scenes the plugin calls the PL/SQL Cop command line utility for the static code analysis.
A static code analysis is typically initiated as part of an … Read More →
Installing SonarQube on windows machine with Sql Server express as back end is quite simple, but here is some information you should know to avoid some common problem with database layer (or at least avoid problem I had )
Setting up Sonar Qube in Windows is easy, but sometimes you can encounter some problem to have … Read More →
Merging code. Coordinating releases. Determining build status. Maintaining updates. If you know the frustration of these processes well enough that the words themselves threaten a headache, you might want to look into Jenkins CI.
Maintaining any project, especially one developed by several team members concurrently and one that might incorporate many functions, components, languages, and environments, … Read More →
I have talked about Database Change Management using Liquibase. Now, I will talk about the integration with Jenkins CI.
As you can see in the example of my previous post. In the pom.xml there are 3 profiles: update,tag and rollback which will be used by Jenkins. The profile approach will be useful in our integration.
I am … Read More →
Liquibase is a dabasebase chane management tool. Rather than writing SQL directly against the database to create, update or drop database objects, developers define their desired database changes in XML files.
Any change to database are grouped into "ChangeSet", the best practice is one changeset per modification to make roll back easily. Changes to database can … Read More →
1. Install Java
Liquibase 3.x requires Java 1.6+ so lets get that installed first
2. Get the Liquibase Code
I'm just going to install put Liquibase in the home directory for now
3. Install MySQL
4. Install the MySQL connector for Java
5. Create the MySQL database
6. Create a Changelog file
Add the following...
7. Run Liquibase
8. Create a liquibase.properties file
Add the following...
9. … Read More →
If you have had a project with several developers working at a high velocity on different branches you are probably aware of the amount of trouble that a theoretically simple task such as managing the db schema changes can provoke. The main issues occur on a daily-basis at development, less DRY, less agile; also the … Read More →