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

2010-09-15 Thread Mike Owens
FWIW, there is a second edition of the Definitive Guide to SQLite,
apparently coming out in Nov:

http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/1430232250/

Allen Grant is the author doing the work. I don't have any details other
than that. I hear he's a good guy for the job though.

-- Mike

On Sun, Sep 12, 2010 at 2:53 PM, Bob Keeland <keela...@yahoo.com> wrote:

> 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
>
___
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

2010-09-12 Thread 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

2010-09-12 Thread 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

2010-09-12 Thread Rich Shepard
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


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

2010-09-12 Thread Bart Smissaert
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  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


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

2010-09-12 Thread 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

2010-09-12 Thread 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

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Sam Carleton wrote:

> If you need to learn the basics of SQL, I would highly recommend the book SQL
> For 
> Smarties.
> It covers all the basics and a lot more.  I also have his book Trees and
> Hierarchies in SQL for
> Smarties,
> but this assumes you already know the basics.

   Anything written by Joe Celko is worth reading.

Rich
___
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

2010-09-12 Thread Rich Shepard
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


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

2010-09-11 Thread Jay A. Kreibich
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


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

2010-09-11 Thread Sam Carleton
Bob,

If you need to learn the basics of SQL, I would highly recommend the book SQL
For 
Smarties.
It covers all the basics and a lot more.  I also have his book Trees and
Hierarchies in SQL for
Smarties,
but this assumes you already know the basics.

Once you understand SQL, SQLite is REALLY easy to use, all I have ever used
is the docs on the web site and it has been outstanding!  Mind you, I am
using the C interface.

Sam Carleton
___
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

2010-09-11 Thread 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

2010-09-11 Thread 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


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

2010-09-11 Thread Olaf Schmidt

"Bob Keeland"  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


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

2010-09-11 Thread Simon Slavin

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] New to SQLite and I have a question

2010-09-11 Thread 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