Kdelchev - kdelchev.com
General Information:
Latest News:
Postgres tip: copy table data in csv file 12 Aug 2013 | 05:44 pm
Copy table data into CSV file
Fixing duplicate primary key constraint issue in Postgres 12 Aug 2013 | 03:50 pm
Having error message “PG::Error: ERROR: duplicate key value violates unique constraint “table_name_pkey” DETAIL: Key (id)=(60) already exists.” logically means the primary key in the query you try to ...
How to run rake task inside controller 30 Jul 2013 | 06:44 pm
Short snippet showing how to run Rake task inside your controller
RDBS schema generation tool 11 Jul 2013 | 12:29 pm
I was looking for a tool to generate the schema and model associations for PostgreSQL like in MySQL Workbench, since my first db modelling experience was with the Workbench tool. PostgreSQL is lacking...
Copy multiple files from one folder to another in Linux terminal 5 Jul 2013 | 08:55 pm
Wasn’t asking myself before on how to copy multiple specified files from one directory to another. Copying files one by one is not an option since it requires modifying the command and waiting to fin...
Ruby NET::HTTP requests library cheatsheet 9 May 2013 | 11:10 pm
Nice cheat sheet resource of Ruby HTTP requests is published on rubyinside.com. Since the comments are disabled I decided to add one note here: When using uri = URI.parse("http://google.com/") it is g...
Tools for cleaning your CSS files 17 Apr 2013 | 12:17 am
Two useful tools for analyzing unused CSS and cleaning it. I will sure forget later, so I am adding the links in order to have them: https://github.com/zmoazeni/csscss https://github.com/geuis/helium-...
Upgrade Postgres minor version on Ubuntu 9 Apr 2013 | 12:52 am
I am not a DBA, but recently I have to upgrade Postrges minor version with a security update. This is not either a tutorial or some best practice, but some small snippet of the command you will need, ...
Use Railroady to generate UML diagrams for your project’s controllers and models 20 Mar 2013 | 03:08 am
Introduction Railroady is a Railroad fork, a Ruby On Rails diagram generator for models and controllers. If you are using Rails 2.3.x with Ruby 1.8.7 checkout Railroad gem. Otherwise use Railroady wit...
Connecting Matlab to Postgres database 15 Mar 2013 | 09:50 pm
Assumptions My primary focus is not on Matlab, but I used it for a while in the Uni. I have to support connecting Matlab installed on Windows machine with Postgres 9.2 database. I used the Matlab comm...
