[sqlite] New Delphi SQLite data access components

[Denis Yanov]

Devart company released new SQLite Delphi data access components named LiteDAC 
2.6. 

List of improvements and fixes:

- RAD Studio 10 Seattle is supported
- INSERT, UPDATE and DELETE batch operations are supported
- Now Trial for Win64 is a fully functional Professional Edition
- Now at automatic refresh of Detail dataset the OnBeforeOpen event is not 
called
- Now the Direct mode is based on the SQLite engine version 3.8.11.1
- The EnableSharedCache option of the Connection component for non-Windows 
platforms is added
- Generating conditions for filtration when using similar field names and 
aliases in TCRDBGrid is fixed
- SQLMonitor behavior on using similar objects is fixed
- Bug with endless reconnection in assigned connection is fixed
- Bug with editing Blob and Memo fields used in local filter is fixed
- Bug with a null CURRENT_TIME value on MacOS, iOS & Android in Direct Mode is 
fixed
- Bug with handling DATETIME fields with milliseconds is fixed
- Bug with attaching a database containing international characters in the 
encryption key is fixed
- Bug with database encryption in Direct Mode on MacOS is fixed
- Bug with the "Unable to open database" error when using a temp database on 
Android is fixed
- Bug with CRBatchMove component when using complex table names is fixed
- Bug when calling SQL for trigger creation is fixed
- Bug with detecting AutoInc fields on mobile platforms is fixed

More info Download LiteDAC 2.6

Re: [sqlite] New to SQLite Question - References

[Simon Slavin]

On 1 Nov 2012, at 2:53pm, Ryan Kool  wrote:

> Can you give suggestions on where to look for information on connecting to
> a SQLite database from within a Java application?

They're usually called 'wrappers'.  Google the two words

Java SQLite

and pick one.

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

[sqlite] New to SQLite Question - References

[Ryan Kool]

Hello All,

Can you give suggestions on where to look for information on connecting to
a SQLite database from within a Java application?  I'm new to both Java &
SQLite and am wondering where is the best place to start?  I have been
programming in C++ a long time using SQL Server so I'm not a novice
programmer, just a novice Java guy & SQLite newbie, trying to learn new
stuff.

Thanks in advance,

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

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

[kp2011]

Now I understand better , I need the ado net for vs2008
I have a version but it does not find my table (thats the only error so far)

this is what I have 
System.Data.SQLite.dll 1.0.66.0
883 KB (904,704 bytes)
modified ‎Sunday, ‎April ‎18, ‎2010, ‏‎1:58:58 PM
‎Original filename SQLite3.DLL 3.6.23.1


and the GetSchema(SQLiteMetaDataCollectionNames.Tables) comes back with
"table" as the table name
which is not correct

Does anybody body what I need for sqlite for vs2008?

Thanks 
Ken


Joe Mokos wrote:
> 
> Is it possible you're trying to load a 64 bit .dll with a 32 bit .exe?  Or
> visa versa.
> 
> Joe Mokos
> Sr. Software Engineer
> OPNET Technologies, Inc.
> jmo...@opnet.com
> (603) 598-2582  x377
> 
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kp2011
> Sent: Wednesday, May 04, 2011 3:18 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] new to sqlite rec'd BadImageFormatException error
> 
> 
> this is the vb net code I was running
> 
> Dim f As New OpenFileDialog
> f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
> If f.ShowDialog() = DialogResult.OK Then
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLite.SQLiteCommand
> SQLconnect.ConnectionString = "Data Source=" & f.FileName
> &
> ";"
> SQLconnect.Open() this line produces the error
> 
> this is the error 
> An attempt was made to load a program with an incorrect format. (Exception
> from HRESULT: 0x8007000B)
> BadImageFormatException was unhandled 
> 
> do you know what did I do wrong?
> Ken
> -- 
> View this message in context:
> http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp
> 31544682p31544682.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
> 
> 

-- 
View this message in context: 
http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp31544682p31551696.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

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

[kp2011]

I got it passed this error by using different SQLite library and the ADO.NET
provider(an older one) 
its a bit confusing for a newbie. what is the newest I could use for vb net
2008?



Filip Navara-3 wrote:
> 
> What platform is set as target for the VB.NET code (x86 / x64 / Any CPU)?
> Which build of the SQLite library and the ADO.NET provider are you using?
> 
> On Wed, May 4, 2011 at 9:17 PM, kp2011 <kpaul...@nwrain.com> wrote:
>>
>> this is the vb net code I was running
>>
>> Dim f As New OpenFileDialog
>>            f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
>>            If f.ShowDialog() = DialogResult.OK Then
>>                Dim SQLconnect As New SQLite.SQLiteConnection()
>>                Dim SQLcommand As SQLite.SQLiteCommand
>>                SQLconnect.ConnectionString = "Data Source=" & f.FileName
>> &
>> ";"
>>                SQLconnect.Open()     this line produces the error
>>
>> this is the error
>> An attempt was made to load a program with an incorrect format.
>> (Exception
>> from HRESULT: 0x8007000B)
>> BadImageFormatException was unhandled
>>
>> do you know what did I do wrong?
>> Ken
>> --
>> View this message in context:
>> http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp31544682p31544682.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
> 
> 

-- 
View this message in context: 
http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp31544682p31550866.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

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

[kp2011]

I tried several different sqlite.dlls now it works
Thanks






kp2011 wrote:
> 
> this is the vb net code I was running
> 
> Dim f As New OpenFileDialog
>     f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
> If f.ShowDialog() = DialogResult.OK Then
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLite.SQLiteCommand
> SQLconnect.ConnectionString = "Data Source=" & f.FileName
> & ";"
> SQLconnect.Open() this line produces the error
> 
> this is the error 
> An attempt was made to load a program with an incorrect format. (Exception
> from HRESULT: 0x8007000B)
> BadImageFormatException was unhandled 
> 
> do you know what did I do wrong?
> Ken
> 

-- 
View this message in context: 
http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp31544682p31545950.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

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

[Joe Mokos]

Is it possible you're trying to load a 64 bit .dll with a 32 bit .exe?  Or
visa versa.

Joe Mokos
Sr. Software Engineer
OPNET Technologies, Inc.
jmo...@opnet.com
(603) 598-2582  x377

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kp2011
Sent: Wednesday, May 04, 2011 3:18 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] new to sqlite rec'd BadImageFormatException error


this is the vb net code I was running

Dim f As New OpenFileDialog
f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
If f.ShowDialog() = DialogResult.OK Then
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLite.SQLiteCommand
SQLconnect.ConnectionString = "Data Source=" & f.FileName &
";"
SQLconnect.Open() this line produces the error

this is the error 
An attempt was made to load a program with an incorrect format. (Exception
from HRESULT: 0x8007000B)
BadImageFormatException was unhandled 

do you know what did I do wrong?
Ken
-- 
View this message in context:
http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp
31544682p31544682.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

[sqlite] new to sqlite rec'd BadImageFormatException error

[kp2011]

this is the vb net code I was running

Dim f As New OpenFileDialog
f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
If f.ShowDialog() = DialogResult.OK Then
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLite.SQLiteCommand
SQLconnect.ConnectionString = "Data Source=" & f.FileName &
";"
SQLconnect.Open() this line produces the error

this is the error 
An attempt was made to load a program with an incorrect format. (Exception
from HRESULT: 0x8007000B)
BadImageFormatException was unhandled 

do you know what did I do wrong?
Ken
-- 
View this message in context: 
http://old.nabble.com/new-to-sqlite-rec%27d-BadImageFormatException-error-tp31544682p31544682.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

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

[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

[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

[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

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

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

[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

[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

[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

[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

[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

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

[Olaf Schmidt]

"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

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

[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

[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

Re: [sqlite] New to SQlite

[Plopes]

Thank you so much for your help


- Original Message - 
From: "Roosevelt Anderson" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Thursday, September 25, 2008 11:10 AM
Subject: Re: [sqlite] New to SQlite


> If you are using the ADO.NET 2.0 provider from
> http://sqlite.phxsoftware.com/, then it won't work with Visual Studio
> 2003. This is because Visual Studio 2003 uses .Net 1.1 not .Net 2.0.
> If you wish to use the phxsoftware data provider try downloading
> Visual Studio Express 2005 or 2008 from Microsoft, they are both free.
>
> http://www.microsoft.com/express/product/default.aspx
>
> On Thu, Sep 25, 2008 at 9:42 AM, Plopes <[EMAIL PROTECTED]> wrote:
>> I am new to SQlite and just migrated to vb.net from vb6
>>
>> I cant find a step by step tutorial on how to add sqlite to vb.net
>>
>> i downloaded the sqlite wrapper but on the sqlite designer installation 
>> screen
>> an option should show "Visual Studio 2003"
>> i get a blank screen
>>
>> so i am not sure how to proceed
>>
>> is it because i have version 2003 of visual studio?
>>
>> Please help
>>
>> Thank you
>>
>> Paulo Lopes
>> ___
>> 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

[Roosevelt Anderson]

If you are using the ADO.NET 2.0 provider from
http://sqlite.phxsoftware.com/, then it won't work with Visual Studio
2003. This is because Visual Studio 2003 uses .Net 1.1 not .Net 2.0.
If you wish to use the phxsoftware data provider try downloading
Visual Studio Express 2005 or 2008 from Microsoft, they are both free.

http://www.microsoft.com/express/product/default.aspx

On Thu, Sep 25, 2008 at 9:42 AM, Plopes <[EMAIL PROTECTED]> wrote:
> I am new to SQlite and just migrated to vb.net from vb6
>
> I cant find a step by step tutorial on how to add sqlite to vb.net
>
> i downloaded the sqlite wrapper but on the sqlite designer installation screen
> an option should show "Visual Studio 2003"
> i get a blank screen
>
> so i am not sure how to proceed
>
> is it because i have version 2003 of visual studio?
>
> Please help
>
> Thank you
>
> Paulo Lopes
> ___
> 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

[Plopes]

I am new to SQlite and just migrated to vb.net from vb6

I cant find a step by step tutorial on how to add sqlite to vb.net

i downloaded the sqlite wrapper but on the sqlite designer installation screen
an option should show "Visual Studio 2003"
i get a blank screen

so i am not sure how to proceed

is it because i have version 2003 of visual studio?

Please help

Thank you

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

Re: [sqlite] New to SQLite...............2....3..4 Thank you

[Witold Czarnecki]

You should read SQLite docs: http://www.sqlite.org/docs.html and faq: 
http://www.sqlite.org/faq.html . TCL interface to SQLite is documented here: 
http://www.sqlite.org/tclsqlite.html

I hope it will help to start.
Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, February 23, 2005 9:56 PM
Subject: Re: [sqlite] New to SQLite...23..4 Thank you


Thank you for that. I like what I am reading there. Still, TCL is 
mentioned together with SQLite. Is TCL an alternative to look into?
Best regards
Jan

- Original Message - 
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...23


There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from 
exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}

?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3..4 Thank you

[Jan Ekström]

Thank you for that. I like what I am reading there. Still, TCL is mentioned 
together with SQLite. Is TCL an alternative to look into?
Best regards
Jan

- Original Message - 
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...23


There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from 
exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}

?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3

[Witold Czarnecki]

There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}
?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3

[Jan Ekström]

Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}
?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2

[Ulrik Petersen]

Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2

[Jan Ekström]

I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
jan
- Original Message - 
From: "Cory Nelson" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 3:47 PM
Subject: Re: [sqlite] New to SQLite.

Try the SQLite command shell.
On Tue, 22 Feb 2005 14:22:28 +0100, Jan Ekström <[EMAIL PROTECTED]> wrote:
Is there a best way to administrate SQLite?
Do I use PHP, TCL C or .?
Sincerely
Jan Ekström


--
Cory Nelson
http://www.int64.org

Re: [sqlite] New to SQLite.

[Cory Nelson]

Try the SQLite command shell.


On Tue, 22 Feb 2005 14:22:28 +0100, Jan Ekström <[EMAIL PROTECTED]> wrote:
> Is there a best way to administrate SQLite?
> Do I use PHP, TCL C or .?
> Sincerely
> Jan Ekström
> 
> 


-- 
Cory Nelson
http://www.int64.org

[sqlite] New to SQLite.

[Jan Ekström]

Is there a best way to administrate SQLite?
Do I use PHP, TCL C or .?
Sincerely
Jan Ekström

Re: [sqlite] new to sqlite

[Roger Binns]

  i am new to sqlite...
  getting problem to for c interface to sqlite and retrove result...
  using suse linux...
  
 hoping ur cooperation.
http://www.catb.org/~esr/faqs/smart-questions.html
Roger

[sqlite] new to sqlite

[ajit mote]

  

hello,
   i am new to sqlite...
   getting problem to for c interface to sqlite and retrove result...
   using suse linux...
   
  hoping ur cooperation.

  Thanking U.
 

Re: [sqlite] New to Sqlite

[Michael Keilhofer]

Brad,
I found the problem and if I'd learn how to read :-) I wouldn't have sent 
the email. Now I know that nothing coming back means that all is OK and 
anything coming back means an error.

Thanks,
Michael
At 10:31 AM 1/3/2005, Brass Tilde wrote:
> My initial question is this: I have a set of SQL statements in a file that
> builds my desired database. In reading the command line options for
sqlite3
> it appeared the ".read" command would read this file and execute the
> statements in the file specified.
> Yet when I do that, I see the statements come flying across my command
> window but there's nothing to indicate success or failure
After running the script, can you select from the tables created?  There
should be nothing in them, of course, but you should be able to execute a
"select * from ;" without generating an error.
IME, the SQLITE3.EXE program reports errors when it can't create the tables,
or encounters problems, so no message should mean success.
> and the database file I specified stays at zero length. So obviously
> that doesn't work.
Not so obvious to me.  Are you looking at the file size while the
SQLITE?.exe program still has the file open, or *after* exiting the SQLITE
command line back to your shell?
> Can anyone please tell me if there is any way to perform the batch
> processing of the SQL statements in my file?
Unless I'm misunderstanding what you've done, what you've done works for me.
It's how I check the validity of my creation, and other, scripts.
Brad

Re: [sqlite] New to Sqlite

[Brass Tilde]

> My initial question is this: I have a set of SQL statements in a file that
> builds my desired database. In reading the command line options for
sqlite3
> it appeared the ".read" command would read this file and execute the
> statements in the file specified.

> Yet when I do that, I see the statements come flying across my command
> window but there's nothing to indicate success or failure

After running the script, can you select from the tables created?  There
should be nothing in them, of course, but you should be able to execute a
"select * from ;" without generating an error.

IME, the SQLITE3.EXE program reports errors when it can't create the tables,
or encounters problems, so no message should mean success.

> and the database file I specified stays at zero length. So obviously
> that doesn't work.

Not so obvious to me.  Are you looking at the file size while the
SQLITE?.exe program still has the file open, or *after* exiting the SQLITE
command line back to your shell?

> Can anyone please tell me if there is any way to perform the batch
> processing of the SQL statements in my file?

Unless I'm misunderstanding what you've done, what you've done works for me.
It's how I check the validity of my creation, and other, scripts.

Brad

[sqlite] New to Sqlite

[Michael Keilhofer]

Hello,
I'm considering using Sqlite instead of Mysql on an embedded product. Since 
I only need straight forward INSERT, UPDATE, SELECT, and DELETE commands 
this seems like a reasonable alternative.

Since this would be a new product, I thought I'd try to use Sqlite version 3.
To evaluate the possibility, I need to create the database, merge it into 
our application, and get it working with our Apache/php web administration 
module.

My initial question is this: I have a set of SQL statements in a file that 
builds my desired database. In reading the command line options for sqlite3 
it appeared the ".read" command would read this file and execute the 
statements in the file specified.

Yet when I do that, I see the statements come flying across my command 
window but there's nothing to indicate success or failure and the database 
file I specified stays at zero length. So obviously that doesn't work.

Can anyone please tell me if there is any way to perform the batch 
processing of the SQL statements in my file?

Thanks for any help.
Michael

Re: [sqlite] New to SQLite, couple of questions

[Roger Binns]

"Andrew Piskorski" <[EMAIL PROTECTED]> wrote:
On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote:
Why do you need SQLite if you want everything in memory?  All you gain is
an SQL Parser to operate on the data structures instead of just doing it
directly yourself.
All?  You gain the relational model, which in some cases could be a
huge win.  I have considered using in-memory SQLite (haven't actually
done it yet) rather than lots of ugly hash tables for exactly that
reason.
That would be true for smaller amounts of data.  The OP was concerned
about the 2GB address space limit.  Bypassing SQLite in that case 
means your code can know very specifically what all data types are, 
can have perfect hash functions and can make memory vs cpu tradeoffs
as appropriate.  It can also do interning if there are frequent 
common values.  And it can do things like allocate all the memory at 
program startup rather than throughout execution in order to be
resilient to when the address space does fill up.

Other than some circumstances such as transient data, the in memory 
database doesn't buy you much.  You can always tell SQLite how much 
memory to use to get desired performance, and having a disk based database
makes it easy to have checkpointing.

Roger

Re: [sqlite] New to SQLite, couple of questions

[Andrew Piskorski]

On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote:

> Why do you need SQLite if you want everything in memory?  All you gain is
> an SQL Parser to operate on the data structures instead of just doing it
> directly yourself.

All?  You gain the relational model, which in some cases could be a
huge win.  I have considered using in-memory SQLite (haven't actually
done it yet) rather than lots of ugly hash tables for exactly that
reason.

-- 
Andrew Piskorski <[EMAIL PROTECTED]>
http://www.piskorski.com/

Re: [sqlite] New to SQLite, couple of questions

[Roger Binns]

What are some of the limitations of using memory tables (operations, counts,
etc)? Looking at Linux 32bit intel implementation (RH) and want to do some
larger tables all in memory. How large you ask ... as large as I can fit in
the typical 2gig workspace.
Why do you need SQLite if you want everything in memory?  All you gain is
an SQL Parser to operate on the data structures instead of just doing it
directly yourself.
On the other hand if you use on disk databases you can tell SQLite how
much memory to use as a page cache.  The default is 2MB.
Roger

[sqlite] New to SQLite, couple of questions

[Sandy Ganz]

What are some of the limitations of using memory tables (operations, counts,
etc)? Looking at Linux 32bit intel implementation (RH) and want to do some
larger tables all in memory. How large you ask ... as large as I can fit in
the typical 2gig workspace.

Also does/can SQLite support 64 Bit O/S native so I could easily get past
the some of the memory limits.

I just started looking at SQLite and it looks awsome, as well as for other
projects kicking around I found some native Delph/C++Builder components as
well.

Thanks for the newbie help :-)

Sandy

Re: [sqlite] New DBD::SQLite*s

[Matt Sergeant]

On Fri, 10 Sep 2004, David Morel wrote:

> Le ven 10/09/2004 à 17:51, Matt Sergeant a écrit :
> > Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33
> > 
> > Changes for DBD::SQLite2:
> > 
> >0.33
> >  - Set HAVE_USLEEP appropriately. This massively improves
> >concurrent access to your SQLite DB.
> 
> Grand. Could you solve the ATTACH problem as well?

Have you filed a bug report? I don't see one. http://rt.cpan.org/


__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

Re: [sqlite] New DBD::SQLite*s

[David Morel]

Le ven 10/09/2004 à 17:51, Matt Sergeant a écrit :
> Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33
> 
> Changes for DBD::SQLite2:
> 
>0.33
>  - Set HAVE_USLEEP appropriately. This massively improves
>concurrent access to your SQLite DB.

Grand. Could you solve the ATTACH problem as well?

-- 
***
[EMAIL PROTECTED]
OpenPGP public key: http://www.amakuru.net/dmorel.asc



signature.asc
Description: Ceci est une partie de message	=?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e=2E?=

Re: [sqlite] New DBD::SQLite*s

[Matt Sergeant]

On Fri, 10 Sep 2004, Darren Duncan wrote:

> With this round, I will start using the new stuff like named host parameters.

Sadly named host params are still broken in sqlite 3.0.6. When I parse 
this SQL:

  SELECT user_id, fname, lname FROM users
  WHERE lname like :1
  UNION
  SELECT user_id, fname, lname FROM users
  WHERE fname like :1

the sqlite library still thinks I have 2 bind parameters, which breaks 
trying to execute that with one parameter under the DBI. I suspect this 
could be just a bug in sqlite3_bind_parameter_count, or the way sqlite 
internals count the number of parameters.

Plus I have yet to implement code for named parameters to work.

Matt.


__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

Re: [sqlite] New DBD::SQLite*s

[Darren Duncan]

At 4:51 PM +0100 9/10/04, Matt Sergeant wrote:
Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33
Changes for DBD::SQLite2:
  0.33
- Set HAVE_USLEEP appropriately. This massively improves
  concurrent access to your SQLite DB.
Changes for DBD::SQLite:
  1.05
- Enabled HAVE_USLEEP where available which should massively
  improve concurrent usage of DBD::SQLite
- Update to sqlite 3.0.6
Hey, just in time!
As it stands, I had myself last night just made another round of CPAN 
uploads.  As preparation for the next round, that I am starting to 
work on today, I would be updating all my dependencies to the newest 
versions, so I can include yours.

With this round, I will start using the new stuff like named host parameters.
-- Darren Duncan

[sqlite] New DBD::SQLite*s

[Matt Sergeant]

Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33
Changes for DBD::SQLite2:
  0.33
- Set HAVE_USLEEP appropriately. This massively improves
  concurrent access to your SQLite DB.
Changes for DBD::SQLite:
  1.05
- Enabled HAVE_USLEEP where available which should massively
  improve concurrent usage of DBD::SQLite
- Update to sqlite 3.0.6
__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

[sqlite] new DBD::SQLite versions are available

[Darren Duncan]

I would like to announce that new versions of DBD::SQLite are 
available.  This includes 1.03, which embeds SQLite 3, and a renamed 
0.32, which embeds SQLite 2; it is now possible to use both SQLite 3 
and SQLite 2 databases from the same Perl program.  This is what 
*I've* been waiting for.

This message is posted by me instead of Matt Sergeant because Matt 
can't get through directly, because:
	"The sqlite list is preventing me posting due to ezmlm 
checking MAIL FROM rather than header From, and my MAIL FROM not 
being subscribed".

The details are posted here, and I also quote that link at the bottom 
of this email: http://use.perl.org/~Matts/journal/20319

-- Darren Duncan
-
Monday August 09, 2004
12:01 PM  

ANNOUNCE: DBD::SQLite-1.03 and DBD::SQLite2-0.32 [#20319 ]
OK, so these releases are a bit confusing, so let me explain:
DBD::SQLite is the active release of the driver, tracking the current 
release of sqlite (currently 3.0.4)

DBD::SQLite2 is the old release of the driver, tracking sqlite 2.x 
(currently 2.8.15), and I won't be updating it very much at all. 
Everything is renamed, including all the internal C functions, so 
that you can definitely load both DBD::SQLite and DBD::SQLite2 in the 
same program and not have conflicts. The only significant changes 
since 0.31 are the update to sqlite 2.8.15, and the addition of the 
busy_timeout API from DBD::SQLite-1.0.

And yes, before the bikeshed painter brigade comes out, I know the 
"2" on the end makes the second one look more up to date. There are 
multiple reasons I chose this scheme.

Available on CPAN as soon as local CPAN mirrors update.