Re: [sqlite] Help with SQLite and VB2010 Express

[Bob Keeland]

Thank you for the reply, it makes more sense now. I'll go to the forum on 
System.Data.SQLite.
BobK

--- On Mon, 1/10/11, Simon Slavin <slav...@bigfraud.org> wrote:


From: Simon Slavin <slav...@bigfraud.org>
Subject: Re: [sqlite] Help with SQLite and VB2010 Express
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Monday, January 10, 2011, 4:49 PM



On 10 Jan 2011, at 9:34pm, Bob Keeland wrote:

> Obviously I don't know what I'm doing with SQLite so I'll ask the question 
> that shows my ignorance.
> What is the difference between what can or should be asked on this list and 
> what should be directed to the System.Data.SQLite forum?

The easiest way is to pretend that the people on this list (the sqlite-users 
one) have never used your operating system or programming language, and the 
people on the System.Data.SQLite forum have never used the advanced features of 
SQLite.  The question you asked refers in detail to .NET, particular setup 
procedures, and OleDB.  None of those things are part of SQLite, and none of 
them can be downloaded from the SQLite home site.  From our point of view, 
they're not really part of the subject matter of this list.

It's possible that you'll find someone on this list who can answer your 
question.  But it's more likely that you'll get better help from the other list 
because those are the people who understand all the technical terms you used.  
Had your question been about the syntax of a SQLite command, this list would be 
better.

>  They seem to have duplicate purposes - helping people who are having 
>problems.

I read quite a few technical fora like that but they don't have much overlap.  
People who read one of the lists won't help me with the subject-matter of 
another list because they just don't know about it, and the question would be 
off-charter anyway.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help with SQLite and VB2010 Express

[Bob Keeland]

Obviously I don't know what I'm doing with SQLite so I'll ask the question that 
shows my ignorance.
What is the difference between what can or should be asked on this list and 
what should be directed to the System.Data.SQLite forum? They seem to have 
duplicate purposes - helping people who are having problems.
 
BobK


> You really don't need to run the msi. You can download the binary
> package and added the dlls as references and start using the
> dataprovider. In the future, this sort of question should be asked in
> the System.Data.SQLite forum.

On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland <keela...@yahoo.com> wrote:
> I've been struggling with how to use SQLite with Visual Basic2010 Express. 
> VB2010 Express does not work with Microsoft Access (which I've used in the 
> past) and so I have to use SQL. I don't feel that I need the capabilities of 
> Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've got 
> System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to SQLite 
> within Visual Basic) from the forum and I've got "SQLite-1.0.66.0-setup" but 
> when I run it I get a message that says that it will switch the OleDB 
> connection in VB2010 to run SQLite instead of Access. Then, it gives me an 
> error message that it cannot read;
>   "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi"
>
> Does anyone know why I get this message? Do I need to buy Visual Studio 2010 
> Professional in order to do database work? Is the VB2010 Express just too 
> limited???
>
> BobK
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Help with SQLite and VB2010 Express

[Bob Keeland]

I've been struggling with how to use SQLite with Visual Basic2010 Express. 
VB2010 Express does not work with Microsoft Access (which I've used in the 
past) and so I have to use SQL. I don't feel that I need the capabilities of 
Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've got 
System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to SQLite 
within Visual Basic) from the forum and I've got "SQLite-1.0.66.0-setup" but 
when I run it I get a message that says that it will switch the OleDB 
connection in VB2010 to run SQLite instead of Access. Then, it gives me an 
error message that it cannot read;
  "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi"
 
Does anyone know why I get this message? Do I need to buy Visual Studio 2010 
Professional in order to do database work? Is the VB2010 Express just too 
limited???
 
BobK
 


  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] beginner

[Bob Keeland]

On SQLite I see lots of complex questions and equally complex answers posted by 
people who obviously know what they are doing. I, however, still need to learn 
the basics of using SQLite. Is there anything like SQLite-Manager that works 
for those of us who still use Microsoft software? I'm considering a dabble with 
LINUX, but have not made the jump yet.
 
Bobby Keeland

--- On Thu, 12/23/10, stormtrooper  wrote:


From: stormtrooper 
Subject: Re: [sqlite] beginner
To: sqlite-users@sqlite.org
Date: Thursday, December 23, 2010, 11:56 AM




Srinidhi,

I recommend Sqlite-manager, a free tool which runs inside Mozilla FireFox,
to help build your queries and view the table,rows, etc.

http://code.google.com/p/sqlite-manager/

Keith

-- 
View this message in context: 
http://old.nabble.com/beginner-tp30480116p30523978.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Just compiled SQLite in Visual Studio

[Bob Keeland]

Igor,
 
You seemed to say that the only difference between C and C++ was the ending (.c 
versus whatever C++ uses), but that understanding of what you said was more a 
result of my ignorance of C and C++. Someone pointed out that, if I've gotten 
this right, in Visual Studio the ending controls how the written program is 
compiled. 
 
In general, I guess that C++ is essentially the C language with a whole lot 
added. I'm probably wrong on that interpretation of what was said, but at least 
I do now understand that C and C++ are not the same. Am I still misinterpreting 
this whole thread?
 
Bob Keeland
Forest Dynamics, Inc.

--- On Tue, 11/30/10, Igor Tandetnik <itandet...@mvps.org> wrote:


From: Igor Tandetnik <itandet...@mvps.org>
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio
To: sqlite-users@sqlite.org
Date: Tuesday, November 30, 2010, 8:06 PM


Bob Keeland <keela...@yahoo.com> wrote:
> Oh, from the various replies I see that C++ is a more capable extension of C. 
> Igor was only using a figure of speech, kind of.

Everything I said in this thread so far, I meant quite literally. Which 
expression of mine do you take as a figure of speech?
-- 
Igor Tandetnik


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Just compiled SQLite in Visual Studio

[Bob Keeland]

Oh, from the various replies I see that C++ is a more capable extension of C. 
Igor was only using a figure of speech, kind of. Sorry about the newbee 
question, but thanks for the replies.
 
Bob Keeland

--- On Tue, 11/30/10, Simon Slavin <slav...@bigfraud.org> wrote:


From: Simon Slavin <slav...@bigfraud.org>
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Tuesday, November 30, 2010, 7:10 PM



On 1 Dec 2010, at 1:01am, Bob Keeland wrote:

> OK then I have a newbee question that is actually out of the scope of SQLite. 
> If the only difference between C and C++ is the file extension,

No.

> then what is the difference between C and C++? I'm thinking of adding a 
> language other than the Visual Basic that I kind of know and would like to 
> know the difference. I've been thinking about Java, but am not sure yet.

Argh.  C++ is C, with some additional features added to all object-oriented 
programming and some other stuff.  So every C program is a C++ program, with 
the programmer never having chosen to use those extra facilities.  And every 
C++ compiler can compile a C program.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Just compiled SQLite in Visual Studio

[Bob Keeland]

OK then I have a newbee question that is actually out of the scope of SQLite. 
If the only difference between C and C++ is the file extension, then what is 
the difference between C and C++? I'm thinking of adding a language other than 
the Visual Basic that I kind of know and would like to know the difference. 
I've been thinking about Java, but am not sure yet.
Bob Keeland

--- On Tue, 11/30/10, john darnell <john.darn...@walsworth.com> wrote:


From: john darnell <john.darn...@walsworth.com>
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Tuesday, November 30, 2010, 10:25 AM


Thanks Igor.

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Igor Tandetnik
Sent: Monday, November 29, 2010 7:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio

john darnell <john.darn...@walsworth.com> wrote:
> I just added it to a Visual Studio 8 project, turned off the use of 
> precompiled headers (the project is a C++ project) and
> compiled the SQLite.c file without any errors.

There is no such thing as a C++ project. A project in Visual Studio can happily 
contain both C and C++ files. By default, file extension determines whether the 
file is compiled with C or C++ compiler (.c would indicate C), and this could 
also be overridden in project settings on a per-file basis.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Create Read-only Database

[Bob Keeland]

A second response to this issue orf read-only. For my program the user will 
never directly the database. The user will make selections from the program and 
then the program will query the database. The user will then see how many 
records remain in the database and make selections from other portions of the 
program. The program will then query the database again. In other words, the 
database will be read-only if the user does not really have direct access to 
the database through the program. Does this make sense?
 
BobK

--- On Sun, 10/10/10, Max Vlasov  wrote:


From: Max Vlasov 
Subject: Re: [sqlite] Create Read-only Database
To: "General Discussion of SQLite Database" 
Date: Sunday, October 10, 2010, 1:53 PM


On Sun, Oct 10, 2010 at 9:31 AM, Joshua Grauman  wrote:

> I have a database that I want to be only read-only. I read in the
> optimization FAQ that this will make sqlite not create a journal and so
> run faster. I changed the permissions of my database file in Linux
> (removed the write permission), and sqlite was still able to create a new
> table. Since this file should never be written I also want to get an error
> if it is by some fault in a querry I write. So any ideas about how to make
> this entire database read-only? Is there a way to do this in sqlite
> itself? Thanks!
>
>

Did you try sqlite3_open_v2 with SQLITE_OPEN_READONLY flag?

Also if you're not content with this option, you can always open the file
(just as a general file) prior to sqlite with a "deny write" option. I'm
aware of such feature in Windows/Win32, I'm sure a similar option should
exist in Linux. In this case any attempt to write will lead to OS-level
error that finally will be passes as some sqlite error to your code.

Max Vlasov
maxerist.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Create Read-only Database

[Bob Keeland]

This inability to have a read-only database with SQLite is unfortunate. In most 
cases I'll agree that a database should be something that can be updated, but 
there are cases in which the user will, in the vast majority of cases, not have 
the knowledge to update the database. 
 
A program that I am working on is mostly a 'fill the database' job for me. 
Writing the code will be somewhat minimal. For the user it will be a search the 
database for an answer that is seemingly unrelated to the database. From the 
user's perspective they just make selections from listed options and the number 
of options (selections) is reduced. What the user wants ideally is to be left 
with only one selection - that will be their answer. They really don't care how 
they get to that point. If a person updates the database they will probably 
make the overall program unusable.
 
Bob Keeland

--- On Sun, 10/10/10, Roger Binns <rog...@rogerbinns.com> wrote:


From: Roger Binns <rog...@rogerbinns.com>
Subject: Re: [sqlite] Create Read-only Database
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Sunday, October 10, 2010, 2:04 PM


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 10/10/2010 11:53 AM, Max Vlasov wrote:
> Also if you're not content with this option, you can always open the file
> (just as a general file) prior to sqlite with a "deny write" option. I'm
> aware of such feature in Windows/Win32, I'm sure a similar option should
> exist in Linux. In this case any attempt to write will lead to OS-level
> error that finally will be passes as some sqlite error to your code.

Actually Linux/Unix does not have such deny mode options.  Additionally
locking is cooperative not mandatory.

There are two reasons for this.  Historically Unix has always been
multi-user and having the ability to deny other users/programs access to a
file that they have permissions for would cause far more harm than good.

The second is that system data has traditionally been stored in plain text
files - things like /etc/hosts for name to IP address mappings and
/etc/passwd for the user password database.  If any program could deny
access to those for any other program/user then it would be a trivial denial
of service attack.  See the Unix Hater's Guide (free PDF online) for more
details of Unix locking.

Going back to Joshua's original question, by default a SQLite database is
not read-only even if you think it is.  The major reason is that even if you
wanted to use it read-only, the previous program may have had it open for
writing, and may have crashed in the middle of a transaction.  Consequently
the reader needs to fix the database using the journal to get it back into a
correct state which involves writing.  Heck even while you have it open and
idle, a writer could have started a transaction and crashed requiring recovery.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkyyDkQACgkQmOOfHg372QQEGQCcDEK20d0jgCe1YfGLMxTT7erc
4tAAn0HBEZhM1rFpot6K+ORNTMquyZyo
=iHyP
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

Yes, I got an email from Olaf, and I will definitely take any help I can get. 
Such help from the VBForum was instrumental in my program for reading EXIF data 
from digital photographs.
 
Bob

--- On Sun, 9/12/10, Bart Smissaert <bart.smissa...@gmail.com> wrote:


From: Bart Smissaert <bart.smissa...@gmail.com>
Subject: Re: [sqlite] New to SQLite and I have a question
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Sunday, September 12, 2010, 11:28 AM


To use SQLite in classic VB or VBA you need this free wrapper:
http://www.thecommon.net/3.html
I have been using it for a few years now (in a commercial application)
and it is fast and easy plus excellent support from the author Olaf
Schmidt.

RBS


On Sat, Sep 11, 2010 at 9:27 PM, Bob Keeland <keela...@yahoo.com> wrote:
> Hi all,
> I am new to using SQLite but think that it may be good for a project that I'm 
> working on. I do my programming in Visual Basic and don't know any C\C++. Is 
> there any problem with connecting with SQLite from Visual Basic?
>
> Basically my program will conduct repeatitive searches on a database based on 
> user input. In most cases the search will be on one variable (one column) at 
> a time. The database will be relatively small with less than 3000 records and 
> perhaps a couple hundred columns. For each query of the database I need to 
> keep the records that match and eliminate all other records. A followon 
> search will just search the records remaining from the previous search. Of 
> course I could have the user select several variables and then do a more 
> thorough search, but for my data that would not work in a lot of cases.
>
> With enough queries (sometimes just a few and sometimes a lot) the number of 
> remaining records will approach 1. The one remaining record will contain the 
> information that the user will be looking for. There will not be any adding, 
> deleting, or modifying records. This will justy be a tool for finding 
> information based on variables related to the wanted data. The database is 
> plant characteristics data and the program will be used by plant ecologists 
> to determine the species of plant in hand. There are lots of books that help 
> users do this, but the books use dichotomous keys and the same thing could be 
> done, in some respects easier, in a program, especially if the program could 
> eventually be written for a smart phone. I've had good luck with a similar 
> program on PDAs.
>
> My main question - Does this sound like SQLite would be appropriate? I've 
> been using Access as my database up to now. If SQLite sounds appropriate can 
> anyone recommend a good book on SQLite? Any help or suggestions welcome (even 
> if the answer is go away).
>
> Bob Keeland
> Forest Dynamics, Inc.
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

Rich,
 
It is good to hear from another ecologist. You will probably understand my need 
(desire) to make an electronic plant key. I've had to carry Too Many large and 
heavy plant keys with me in the field. Something on a PDA or a smart phone 
would be much easier to carry and probably appreciated by many. But not really 
appreciated much by the general public.
 
When I ran the stepwise regression analysis for my masters degree in the mid 
1970s I was using a mainframe computer and punch cards. You sure don't see 
those much anymore. I probably still have the book SAS76 somewhere.
 
Bob

--- On Sun, 9/12/10, Rich Shepard <rshep...@appl-ecosys.com> wrote:


From: Rich Shepard <rshep...@appl-ecosys.com>
Subject: Re: [sqlite] New to SQLite and I have a question
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Sunday, September 12, 2010, 12:01 PM


On Sun, 12 Sep 2010, Bob Keeland wrote:

> Access may not be the best database for my programs, but then again my
> needs are not that great. I just need to search a database and then search
> the results of the first search, then search the results of the second
> search, etc. That sounds simple to me, but I'm an ecologist not a
> professional programmer.

Bob,

   I, too, am an ecologist, but I've been coding applications since 1972. :-)
FORTRAN, C, and now Python.

   I'll suggest a SQL language book as your first purchase. Your description
above suggests that nested sub-queries in the SELECT statement are what you
need to learn.

   Learn SQLite, too, and you won't go wrong as your needs grow.

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

Jay,
Thanks for the reply. I'll have to reconsider my book purchase.
By the way, I love the quote at the bottom of your email. As a professional 
scientist I've found that when I try to explain what I do most people's eyes 
tend to glaze over, etc. 
 
My step-son is a computer chip designer. When he starts talking about what he 
does MY eyes tend to glaze over, etc.
 
Bob Keeland

--- On Sat, 9/11/10, Jay A. Kreibich <j...@kreibi.ch> wrote:


From: Jay A. Kreibich <j...@kreibi.ch>
Subject: Re: [sqlite] New to SQLite and I have a question
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Saturday, September 11, 2010, 10:30 PM


On Sat, Sep 11, 2010 at 06:27:16PM -0700, Bob Keeland scratched on the wall:
 
> The Definitive Guide to SQLite by Mike Owens

  Good, but older.  Doesn't cover some of the newer features, including
  many of the _v2() interfaces.  
  
  Covers SQL and basic database theory.  Although this spends a little
  time on non-C APIs, VB is not one of the languages that is covered.

  Known for having a sub-standard index.

> Using SQLite by Jay A. Kreibich 

  Very new.  Also covers SQL, as well as database design theory, but I
  must admit that it only covers the C APIs.  Very large reference
  section.

  As you might guess, this is a personal favorite.

> The SQL Guide to SQLite by Rick F. van der Lans 

  This only covers the SQL language used by SQLite, it does not cover
  the library or APIs.

  I have not had a chance to look at this yet, but my other van der Lans
  books are quite good, and I expect this to be a very good book as well.


   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

Mike,
 
Thanks for the info. I'll go ahead and get the Mike Owens book to start with. 
Other books may follow.
Yes, I live in Microsoft's world, but not by choice. I worked for the federal 
government for 25 years and was at the mercy of people higher up on the food 
chain most of the time. For example I was forced to give up WordPerfect for 
Microsoft Word. I have NEVER liked Word, but was forced to change. Oh Well!
 
Access may not be the best database for my programs, but then again my needs 
are not that great. I just need to search a database and then search the 
results of the first search, then search the results of the second search, etc. 
That sounds simple to me, but I'm an ecologist not a professional programmer.
 
Thanks again.
Bob Keeland

--- On Sun, 9/12/10, Rich Shepard <rshep...@appl-ecosys.com> wrote:


From: Rich Shepard <rshep...@appl-ecosys.com>
Subject: Re: [sqlite] New to SQLite and I have a question
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Sunday, September 12, 2010, 10:08 AM


On Sat, 11 Sep 2010, Bob Keeland wrote:

> While I greatly appreciate the help I've gotten on SQLite in general, I
> still wonder about the last part of my questions below. Can anyone
> recommend a good book for learning to use SQLite? What about these that I
> found on Amazon.com

> The Definitive Guide to SQLite by Mike Owens

   Outstanding for understanding SQLite and how it works.

> Using SQLite by Jay A. Kreibich

   I've not read Jay's book so I cannot comment on the focus.

> The SQL Guide to SQLite by Rick F. van der Lans

   Rick's book (and I reviewed/proof-read several chapters) focuses on the
SQL language as used in SQLite. It is a great complement to Mike Owens'
book. (As noted above I have no knowledge of Jay's book.)

   You might also want to read Rick's 'Introduction to SQL, 4th Ed.' which is
more general (and a lot longer) than the SQLite-specific book. He covers
time-based queries in the book which is rarely seen in SQL texts yet
commonly used in business databases.

> I only know a little about SQL in general and even less about SQLite, and
> I could probably use help. I learned how to program in Visual Studio.NET
> 2003 from a book Sam's Teach Yourself Microsoft Visual Basic.NET 2003. I'm
> now using Visual Basic 2010 Express (and have ordered a book on it).

   You work in Microsoft's world so I have nothing to offer for help. But, I
will tell you (having dealt with clients who try to use Access) that that is
a flat-field data base while SQLite is relational. Depending on your
application you'll almost certainly need the latter.

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

While I greatly appreciate the help I've gotten on SQLite in general, I still 
wonder about the last part of my questions below. Can anyone recommend a good 
book for learning to use SQLite? What about these that I found on Amazon.com
 
The Definitive Guide to SQLite by Mike Owens
Using SQLite by Jay A. Kreibich 
The SQL Guide to SQLite by Rick F. van der Lans 
 
I only know a little about SQL in general and even less about SQLite, and I 
could probably use help. I learned how to program in Visual Studio.NET 2003 
from a book 
Sam's Teach Yourself Microsoft Visual Basic.NET 2003. I'm now using Visual 
Basic 2010 Express (and have ordered a book on it).
 
Bob Keeland


--- On Sat, 9/11/10, Olaf Schmidt <s...@online.de> wrote:


From: Olaf Schmidt <s...@online.de>
Subject: Re: [sqlite] New to SQLite and I have a question
To: sqlite-users@sqlite.org
Date: Saturday, September 11, 2010, 6:00 PM



"Bob Keeland" <keela...@yahoo.com> schrieb

> I am new to using SQLite but think that it may be good
> for a project that I'm working on. I do my programming
> in Visual Basic and don't know any C\C++.
> Is there any problem with connecting with SQLite from
> Visual Basic?
No.
Though the links Simon gave you, are for wrappers which
"connect" you to the (VB).NET world.
If it is "classic VB" you're using (up to VB-Version 5/6) -
then you can also take a look at the COM-Wrapper-
section in the SQLite-wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

>...
>
> My main question - Does this sound like SQLite would
> be appropriate?
Yes, from what you wrote, there should be no problems -
does not seem like a "heavy scenario" - and could even
fit into memory completely (at least on Desktop-Systems),
and SQLite supports "InMemory-Mode".

As to expanding your solution to Handheld-Devices ...
SQLite is working fine there (although many Devs
prefer working at the lower "C-language-level" then) -
but as far as I know, Robert Simpsons .NET-wrapper
(http://sqlite.phxsoftware.com) should work there
as well... as long as you're targetting devices, which
support the .NET-mobile framework (then you
could work further with your language-binding as
long as it is the VB.NET-basic-dialect and not
VB-Classic).

A broader approach, to bring your "search-services"
to these devices would be a "Web-hosted one",
since most of the newer Smartphones come with
a decent Browser (and often with permanent Internet-
connection nowadays).

> I've been using Access as my database up to now...
As said, if VB.NET, then http://sqlite.phxsoftware.com
is a good recommendation (working over ADO.NET)...
and in case we're talking about VB-Classic and
existing experience with "normal (COM-) ADO" - then
my wrapper at: http://www.thecommon.net/2.html
is probably the one with the greatest resemblance
to ADO-behaviour - not much to learn anew.

But if your GUI (for the Desktop-Version) is not too
complex, I'd develop a "unified solution" (for both,
Desktop and HandHeld) as a WebApp ...


Olaf



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New to SQLite and I have a question

[Bob Keeland]

WOW! I asked for help and it seems that I got a library. Thanks for the 
information. This will obviously take me some time to study, but it looks like 
I may be heading in the right direction. Now I just have to come up with the 
information that will go into the database (whether it would be SQLite, Access, 
or whatever). The data for the database will much more difficult to come up 
with than writing the code for the program. Thanks a lot for the help.
 
Bob Keeland

--- On Sat, 9/11/10, Simon Slavin <slav...@bigfraud.org> wrote:


From: Simon Slavin <slav...@bigfraud.org>
Subject: Re: [sqlite] New to SQLite and I have a question
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Saturday, September 11, 2010, 5:00 PM



On 11 Sep 2010, at 9:27pm, Bob Keeland wrote:

> I am new to using SQLite but think that it may be good for a project that I'm 
> working on. I do my programming in Visual Basic and don't know any C\C++. Is 
> there any problem with connecting with SQLite from Visual Basic?

You'll need to pick a way of accessing it.  A quick Google gives me

http://www.kirupa.com/net/sqllite_vb_pg1.htm

http://sqlite.phxsoftware.com/

http://sqlite.phxsoftware.com/forums/t/1033.aspx

Your description of the project doesn't suggest any reason why SQLite would be 
worse than any of the alternatives.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] New to SQLite and I have a question

[Bob Keeland]

Hi all,
I am new to using SQLite but think that it may be good for a project that I'm 
working on. I do my programming in Visual Basic and don't know any C\C++. Is 
there any problem with connecting with SQLite from Visual Basic?
 
Basically my program will conduct repeatitive searches on a database based on 
user input. In most cases the search will be on one variable (one column) at a 
time. The database will be relatively small with less than 3000 records and 
perhaps a couple hundred columns. For each query of the database I need to keep 
the records that match and eliminate all other records. A followon search will 
just search the records remaining from the previous search. Of course I could 
have the user select several variables and then do a more thorough search, 
but for my data that would not work in a lot of cases.  
 
With enough queries (sometimes just a few and sometimes a lot) the number of 
remaining records will approach 1. The one remaining record will contain the 
information that the user will be looking for. There will not be any adding, 
deleting, or modifying records. This will justy be a tool for finding 
information based on variables related to the wanted data. The database is 
plant characteristics data and the program will be used by plant ecologists to 
determine the species of plant in hand. There are lots of books that help users 
do this, but the books use dichotomous keys and the same thing could be done, 
in some respects easier, in a program, especially if the program could 
eventually be written for a smart phone. I've had good luck with a similar 
program on PDAs.
 
My main question - Does this sound like SQLite would be appropriate? I've been 
using Access as my database up to now. If SQLite sounds appropriate can anyone 
recommend a good book on SQLite? Any help or suggestions welcome (even if the 
answer is go away).
 
Bob Keeland
Forest Dynamics, Inc.


  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users