About Me - The Short Story

I am a lonely Python/C++ coder with a background in financial markets and an interest in modern art. I am an application-driven guy, not a computer scientist. Sure I have many gaps in my knowledge, but I strive to do my best to fill them. I keep learning new things, listening to smart guys, correcting my mistakes, and pushing myself to the limits. I enjoy it.

I will use this website both as a blog and as a hub to some of my projects. It is written from scratch in Python's Flask, my favourite web-framework.


Setting up PostgreSQL database on Fedora

How to do the initial set up for working with PostgreSQL on Fedora. I will cover the installation, creating a database, and binding that database to a particular non-root user so that it is easy to use. I will also show couple of basic...

databases 
postgres 
fedora 


Creating one to many relationship in Flask-SQLAlchemy

In this post, I want to make clear how to set up a one-to-many relationship in Flask SQLAlchemy. Properly placing the foreign keys and references to the parent tables might be confusing especially at the beginning. At least for me, it was....

databases 
sqlalchemy 
orm 
flask 


Connect java to database (JDBC in 6 steps)

JDBC stands for Java DataBase Connectivity, which is a fancy name for a simple process - connecting a java app to a database. For connecting a java app to a database, you need to perform these steps. 

1] Load and register a driver...

java 
databases 
oracle 
jdbc