Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

The question is ambiguous does he want all the Fred Smiths or just a specific Fred Smith? For example, do we have a case of mistaken identity? How many Fred Smiths are out there? Or does he want All the records for a specific person named Fred Smith? If it is a specific person, is there a

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

You didn't provide the data set, so it'll be a guess. You'll need to look at the data and do some mental work on comparing what you expect versus what your query result comes back with, and prove what is in the database is what your query is EXACTLY asking for. (Returning on last names of

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

First, you have to "verify" that the database itself is sufficiently normalized and that it is anomoly free. This is a purely algebraic / mathematical operation and is a pre-requisite to any further verification. If the database is not properly normalized, or has other anomolous behaviour,

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

On 8 Dec 2014, at 2:24am, Dwight Harvey wrote: > I know very little and Databases are complex and intimidating. > > I figured out how to run queries but I don't know if they are > correct/accurate, as in what I requested from the 'RUN' results? > > How

[sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

I am a student with no Tech or IT background what so ever. I am new to Databases and IT in general. I am taking an accelerated class in database basics and within the last three weeks I just learned what databases were. I know very little and Databases are complex and intimidating. I figured

Re: [sqlite] Artificially slow VACUUM by injecting a sleep() somewhere?

On 8 Dec 2014, at 12:43am, David Barrett wrote: > Other alternatives we're considering are to fork and nice the process, or > to call ioprio_set() directly, but I'm curious if there's a simpler way to > do it. Thanks! VACUUM does the same job (in a very different way)

[sqlite] Artificially slow VACUUM by injecting a sleep() somewhere?

Hi! I have a large database, and running the VACUUM pragma hammers disk IO so badly that it dramatically affects performance on the box. I'm not in a hurry for the results, so I'm curious if you can think of a way using the API (or any other way) to essentially "nice" the process by inserting a