Recently I had written a thin wrapper around getziptastic’s API and I wanted that to be availble as a pypi package. What is PyPI? From the official website: PyPI — the Python Package Index The Python Package Index is a repository of software for the Python programming language. Written something cool? Want others to be able to install it with easy_install or pip? Put your code on PyPI. It’s a big list of python packages that you absolutely must submit your package to for it to be easily one-line installable. ...

BackDrop: So recently I was building a Calculator using tkinter. I wrote a blog post for the same some time back. Now I thought, how awesome it would be if I could distribute it to my friends and let the use it. Problem was that some of them not being CS grads would not know head or tails about how to run it! So I thought the best way and the easiest way was to convert the pyCalc.py into a .exe file. ...

BackDrop: Everybody at some time of their life as netizen would have seen something like this How about we create one? Well recently when I was building a Calculator app, I wanted a gif image to be there in the README.md so as to show the usage of the app. I wrote a How hard can Building a calclator be right? for the same some time back. Did some googling and found out byzanz-record as the tool perfect for me ...

BackDrop: So I was reading about this wonderful module called tkinter some days back. And man was I not sucked into it! Sure, we do have some very good GUI modules like PyQT, wxPython, PySide. And I don’t deny the fact that some are way better than tkinter. But one advantage which makes tkinter stand out from the crowd is that, it comes pre-packaged with the python package. What I mean by that is you don’t have to install anything to run and write GUI’s with it and run my Calculator program for instance. ...

Intro : DBPedia Spotlight can be queried over the API which they provide. But for our convenience, it is not always possible to do so. So setting it up locally was the best solution. You can run DBpedia Spotlight from the comfort of your own machine in one or many of the following ways: Web Service (no installation needed). We offer a WADL service descriptor, so with Eclipse or Netbeans you can automagically create a client to call our Web Service. See: Web Service JAR. We offer a jar with all dependencies included. You can just download it and run from command line. See: Run from a Jar Maven. Our build is mavenized, which means that you can use the scala plugin to run our classes from command line. See: Build from Source with Maven Ubuntu/Debian package. We are also starting to share our downloads as debian packages so that anybody can just install DBpedia Spotlight directly from apt-get, Synaptic or their favorite package manager. See:Debian-Package-Installation:-How-To WAR Files/ Tomcat. DBpedia Spotlight is also build as a WAR file. You can use it through Apache Tomcat. We would be doing it the JAR way. ...

Intro : So why should we be interested in CGI which stands for common gateway interface. Well for instance, try to recall the websites that you have been in the last 1 hour. Now out of those websites, some where static and some were dynamic. The latter would mean that the contents of that website kept changing in real time. CGI scripting is helpful when you want to generate content from the data residing in a database. This is not only convenient but also cuts a lot of time. ...

Intro Have you ever wanted to create a webpage or process user input from a web-based form using Python? These tasks can be accomplished through the use of Python CGI (Common Gateway Interface) scripts with an Apache web server. CGI scripts are called by a web server when a user requests a particular URL or interacts with the webpage (such as clicking a “Submit” button). After the CGI script is called and finishes executing, the output is used by the web server to create a webpage displayed to the user. ...

Intro : I have recently started using Oracle 11g and boy, doesn’t it come with enough problems already!! However, it may be due to my undying allegiance to mysql and sqlite. But whatever be the case. Here are some of the things which I found would be useful to a first time user of Oracle 11g. I will try to update it when I find something useful. If you haven’t already installed Oracle 11g. I wrote a small article on how to do so sometime back. ...

Intro : Well as luck would have it, we were having our Database labs in ORACLE 11g as part of the coursework. And I must admit, I still have my love for mysql. I installed it on my system(after a lot of trials!) this way. Next part of this article Pre-requisites: JAVA should be installed and the environment variable for it should be set. Check it by doing {% highlight bash %} tasdik@Acer:$ java -version java version “1.7.0_79” OpenJDK Runtime Environment (IcedTea 2.5.5) (7u79-2.5.5-0ubuntu0.14.10.2) OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) tasdik@Acer:$ echo $JAVA_HOME /usr/lib/jvm/java-7-openjdk-amd64 tasdik@Acer:~$ {% endhighlight %} ...

Intro : SQLite has limited ALTER TABLE support that you can use to add a column to the end of a table or to change the name of a table. If you want to make more complex changes in the structure of a table, you will have to recreate the table. You can save existing data to a temporary table, drop the old table, create the new table, then copy the data back in from the temporary table. ...