Sentiment Analysis on Twitter Data with R

Hello fellow ninjas!

Autostarting Pentaho Server with systemd

Pentaho Server is a Business Intelligence server that allows you to design, create and…

Postgres CRUD operations with Python Part 1: [Create Table]

PostgreSQL [the most advanced open source db] is one of the most popular databases out there and almost everyone I know uses it for something. Be it data warehousing or just creating simple web apps, this right here is one freaking awesome dB.

Tunneling you VNC connection over SSH

There are two ways you can connect to a remote Linux server:

Disabling SELinux

Postgres CRUD operations with Python Part 2: [Insert]

Howdy fellow ninjas!

I trust the previous part of the series turned out well for you.

The main reason for having a table is to be able to store data so we’ll do an insert and test out…

Postgres CRUD operations with Python Part 4: [Delete]

Hello there, hope the series is going quite well for you. If you have been stuck at any point or either [Disagree with any of the techniques used | have a better way | or simply wanna chat], feel free to drop a comment and am happily…

Extracting Year, Month and Day from date field in SQL

Howdy fellas!

In most SQL tables, you’ll get a date field that looks like ‘2019–01–01’ which is a date type or ‘2019–01–01 00:00:00' which is a timestamp.

Postgres CRUD operations with Python Part 3: [Update]

Yaaay! We made it to part 3!

We have already seen how to create a table and insert a row in the table. Now let's say you do an insert about Red Velvet cakes and then realize you wanted to talk about passion…

How to use sudo without having to keep entering a password