Slow progress and fighting with sqlite

Second day at the (home) office was harder than the first. Fiddling with queries on sqlite took up a lot of the day. I have been doing sql for years, but I think I will just have to test the stuff out more thoroughly before I put it into an android program. The cycle between develop, deploy and test is too long and fiddly to be working out why your where clause is eliminating all of your rows.

Outer join -
I added an outer join to my code today. Not exactly rocket science, but very handy all the same. The app I am developing allows people pick 30 day challenges. They enter their progress against these items as they go along. It is supposed to be a way to get into new, productive habits. I got the idea here:

http://www.youtube.com/watch?v=JnfBXjWm7hc

Its early days yet, but I like these kind of apps, so it seemed like as good a place as any to start. The outer join is useful for pulling back the tasks that the user has in their list. It is outer as I want to show them the ones they have progressed on as well as those they have just entered in the app.

ListViews - started watching this today:
http://www.youtube.com/watch?v=wDBM6wVEO70

It is pretty good and I got what I needed (an explanation of how to use getView), so I gave it a miss. Will watch the rest of it soon though. Some tricky bits on getting ListViews working properly and these guys really know there stuff, so worth the time I reckon.

Sqlite does not require column types -
strange but true. After years of typing columns this seems weird, but it works just fine. I tried it out today by taking the type off all of my columns. Works the same as when they were there. Good to have one less thing to worry about.

Sqlite Database browser -
I am using this for all of my querying (except some stuff that I do directly on the device/emulator for which I just use sqlite3 in the shell). It is not as crisp as the pro tools for the big box dbs (SQLDeveloper for Oracle and Query Analyser for SQL Server), but its free and beats the shell.
http://sqlitebrowser.sourceforge.net/

So that's it for now. Layouts are proving to be very tricky. All mine look brutal. When I get to the stage of releasing a commercial app, I will involve a graphic designer, but I still have to be able to implement what he/she gives me, so need to work on this one.
So today's home work is:
Sqlite ins and outs (and just be a bit more careful in future) and
Improve my layouts.

Comments

Post a Comment

Popular posts from this blog

AutoCompleteTextView backed with data from SQLite in Android

Image
This is a handy piece of code. As your database gets bigger you can allow the user to pick the correct value by typing. If the db gets very big, you can always increase the threshold, so that the query does not run until there will be a suitably sized resultset returned. Running it at a threshold of 1 is fine for very small resultsets.  Here is the code you need to back your AutoCompleteTextView with a cursor adapter. @Override protected void onResume() { super.onResume(); text = (AutoCompleteTextView) findViewById(R.id.autoCompleteTextView1); final AdapterHelper h = new AdapterHelper(this); Cursor c = h.getAllResults(); startManagingCursor(c); String[] from = new String[] { "val" }; int[] to = new int[] { android.R.id.text1 }; CursorAdapter adapter = new MyCursorAdapter(this, android.R.layout.simple_dropdown_item_1line, c, from, to); adapter.setFilterQueryProvider(new FilterQueryProvider() { public Cursor runQuery(Cha...
Read more

Building a choropleth map for Irish agricultural data

I wanted to create a choropleth map  using Irish data. The Irish Government has made a large quantity of data available at data.gov.ie. The set I chose was for Bovine TB across Ireland over a number of years. You can get geojson for a variety of countries and Ireland's county boundaries are available. All I had to do was get the data labels to match. In the data some counties are split into 2 parts. I merged and summed these data points to get the choropleth to work with normal county boundaries. You can see the results here . A link to the github is included at the top of the notebook.
Read more

Using Statistics to Hire Developers

The Interview I was interviewing a developer for a mid level position today and he turned out to be not up to scratch. The CV looked pretty good, but when I dug in with some fundamental Java questions he was found wanting. Not an unusual occurrence, but still costly. It took 30 minutes of my time, his time and a number of other people were involved to get the process to this stage. I wondered if there might be a way to remove some of the candidate CVs from the batch before we do the costly part of interviewing. Spam or Ham Classifying CVs could be considered like the Spam/Ham problem. Apache SpamAssassin is a good example of a spam classifier. It can probably be made to classify CVs - or at least try, but it is written in C, I think and that is not my thing any more. This looks interesting, so I forked it, converted it to eclipse and started the process of making it build with Maven. First I am going to try this out with spam and ham email, then will try it for other text p...
Read more