Posts

Showing posts from May, 2014

Reading a Sqlite database using client-side javascript

Image
Ever had one of those problems at work that seems almost impossible (i.e. very hard) to solve at first? well i did and not so long ago, and tuns out that there is a solution to it. Problem Read the contents of a  Sqlite  database client-side and present them in an HTML based GUI. So my first reaction was, even if there is a solution to this, it surely cant be very efficient reading an entire Sqlite database client-side? well those were the requirements and there were some genuine reasons to back up those requirements, so i had to stop whinging and direct my efforts towards an actual solution. Solution Turns out that there is a solution for this! Ever heard of  emscripten ? Funnily enough i had used it while doing my research to port the  OpenCV  library to javascript. Anyway there is  sql.js , which is a javascript port of the Sqlite database, which could do what i wanted it to do. The problem is the documentation of ...

Getting to know a completely new programming project

So since Feb this year, i have been assigned on a new project at work. This new project involves working with a variety of independent sub-projects for this client and the sheer variety of the sub-projects can sometimes be overwhelming. What has happened a few times is that, the client starts a new sub-project, hands it to us and says we need this application to do "X". Can you make it do that? So the task is assigned to me and I have a project with no documentation, no instructions but I need to get on with it and solve the issue as soon as i can. So how do i approach this? Since i work on a mac,  which basically has the very awesome terminal that amongst others, has this useful tool called grep.  How do i use it for my needs?  well say i have an  AngularJS  project, stored in a folder projFolder,  and i have no prior knowledge of how it is structured and i have to figure out why a controller does not navigate to route blog after a certain function ca...