Re: [pysqlite] database locked

Rich Shepard wrote:
> On Tue, 27 May 2008, Eric S. Johansson wrote:
> 
>> I know that SQL light can have multiple tables in one file which contains
>                ^^^^^^^^^
> 
>    The name of the library is SQLite.

Tell that to NaturallySpeaking and no, I don't liking messing up my vocabulary 
and language model with "special words"

>> The question should have been, if I have relatively large data sets, would
>> I be better off having all of my data sets in one database or, having one
>> data set per database?
> 
>    Are the two data sets related or totally independent?

an element of the metadata table is used to generate keys and reputation data in 
the other.

>    You'll probably find it quicker to use the SQL statements to order the
> results, and you can limit the returned set to a certain number of rows.
> But, that depends on how you're accessing the tables and the form of the
> query. YMMV.

ok. thanks

>    There are two aspects of SQL that you might find very helpful to learn.
> The first is the DDL (Data Definition Language). The DDL describes the
> schema (tables and attributes) and usually includes instructions on how to
> normalize data for efficiency. The second aspect is the DML (Data
> Manipulation Language) which is based on the central command, SELECT.
> 
>    FWIW, I started reading SQL and RDBMS books in the early 1980s and found
> most to be very well written and useful. But, I also looked through them to
> find the ones that were most acceptable to me. Also, there's nothing wrong
> with understanding SQL from the 1970s. The fundamentals are still the same.

I will look into those books because I value your advice and your suggestion 
tells me where I may learn something useful.

fwiw, I generate about 100 sql statements a year for my apps.  every time I need 
to do something, I need to go back to the books and relearn it.  It will not 
make me more money if I become deeply knowledgeable.  I know enough so that I 
can create something from your suggestions above but beyond that, I have other 
resources for sql questions (not as I asked here on errors, locking, and 
performance of a specific instance)


for some of us, databases are a tool, not a career.  for us tool users, on would 
think there would be a tool that generates sql templates as a result of we 
diddle around with a gui.  sadly, those of us that need the tool don't have 
enough knowledge about sql to generate the tool and those that know sql have no 
need for it.  :-)