3
votes
2answers
148 views

How to optimize and shorten this SQL query?

I'm doing a sort of exercise where I'm given a question, and I have to answer it by writing a sql query using a database that I was given. This is the question: What is the cheapest fare for a ...
2
votes
1answer
375 views

Android SQL in its simplest form

I thought I would just post a really simple wrapper for those who don't want to implement the retarded SqliteOpenHelper, which is really, really stupid. Below is a class to open/create a database, ...
3
votes
1answer
325 views

Clumsy PHP5 code reading from an SQLite3 database

Some time ago I wrote myself a simple blog. The index page is generated with PHP5, using an SQLite3 database via the variable id handed to it via the URL. The SQLite database contains a table called ...