Tagged Questions
22
votes
6answers
2k views
Can you peer review my database design for a school system?
This system has to manage students, teachers, staff and grading. This is for production and is not a school assignment. As such, please let me know if I can improve on any aspect. :)
My main concern ...
10
votes
2answers
228 views
Another way to run reports on a SpiceWorks SQLite database using a linked server in SSMS?
I created a linked server in SSMS so that I could run reports on a SpiceWorks SQLite database. there are a few quirks in the whole system.
These simple queries are becoming some of the most ...
8
votes
2answers
66 views
FizzBuzz in SQLite 2
This query performs a FizzBuzz in SQLite 2.8.17 without creating any tables or sprocs.
First attempt:
...
5
votes
1answer
40 views
Using SQL to reorder items in a list view - is this efficient?
I'm writing an application for work that requires me to process a list of transactions. The list is small (5 records at the most) and I'm required to display that data in an android ...
4
votes
1answer
397 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 ...
3
votes
1answer
35 views
Finding users with the highest Following vs. Friends ratio
I am trying to find the users who have the highest "Following vs. Friends" ratio in my Twitter timeline.
I have a SQLite database of the users in my Twitter timeline and each column contains data ...
3
votes
2answers
173 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
54 views
2
votes
1answer
509 views
Android SQL in its simplest form [closed]
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, ...
