Re: [sqlite] installing sqlite

[Danny]

SQLite Manager for firefox has real problems.  I made it work for a while until 
I found a real GUI.  And does a pretty decent job.

SQLite Expro Personal is FREE.  Of course, there is also a paid version with 
some additional features.

http://www.sqliteexpert.com/

--- On Tue, 4/19/11, Kees Nuyt <k.n...@zonnet.nl> wrote:

From: Kees Nuyt <k.n...@zonnet.nl>
Subject: Re: [sqlite] installing sqlite
To: sqlite-users@sqlite.org
Date: Tuesday, April 19, 2011, 5:42 PM

On Tue, 19 Apr 2011 15:04:31 -0400, Carlos Contreras
<clubcientif...@gmail.com> wrote:

>sqlite offer a very eficient program but I dont understand how to install it
>in my Windows NT PC. I dont know how to compile a C program and then use it
>as a shell to run the sqlite commands.
>
>Can you help me?

Download the command line tool and/or the .dll for windows from
the download page http://www.sqlite.org/download.html 

Look for the heading "Precompiled Binaries For Windows"
There is nothing to install, just unzip the .zip archive(s) into a
folder of your choice.

Or, if you prefer a GUI tool:
Install the Firefox web browser from 
http://www.mozilla.com/en-US/firefox/new/

and add the SQLite manager add-on from 
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

I have no idea wether all that is compatible with Windows NT.
Windows XP and later are fine.
-- 
  (  Kees Nuyt
  )
c[_]
___
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] installing sqlite

[Kees Nuyt]

On Tue, 19 Apr 2011 15:04:31 -0400, Carlos Contreras
 wrote:

>sqlite offer a very eficient program but I dont understand how to install it
>in my Windows NT PC. I dont know how to compile a C program and then use it
>as a shell to run the sqlite commands.
>
>Can you help me?

Download the command line tool and/or the .dll for windows from
the download page http://www.sqlite.org/download.html 

Look for the heading "Precompiled Binaries For Windows"
There is nothing to install, just unzip the .zip archive(s) into a
folder of your choice.

Or, if you prefer a GUI tool:
Install the Firefox web browser from 
http://www.mozilla.com/en-US/firefox/new/

and add the SQLite manager add-on from 
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

I have no idea wether all that is compatible with Windows NT.
Windows XP and later are fine.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] installing sqlite

[Carlos Contreras]

sqlite offer a very eficient program but I dont understand how to install it
in my Windows NT PC. I dont know how to compile a C program and then use it
as a shell to run the sqlite commands.

Can you help me?

-- 
Carlos Contreras, presidente
Club Científico de Peñalolén, Santiago, CHILE
http://www.clubcientifico.cl
fonos:  562-769130709-2114827
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Rich Shepard]

On Fri, 24 Jul 2009, Simon Slavin wrote:

> SQLite has enough fans that people are happy to build binaries for
> major platforms.

   I have a SlackBuild script that I've used since sqlite-3.3.1 on June 15,
2006. It builds a Slackware package (*.tgz) on my standard system (currently
-12.2). In the past I've sent the SQLite-*.tgz package to folks who've asked
for it, and I'd be happy to provide a copy to the application's Web site if
that would help. It uses the amalgamation packages with standard options and
standard Slackware filesystem usage (e.g., the executable is in
/usr/bin/).

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Simon Slavin]

On 24 Jul 2009, at 2:51pm, Jay A. Kreibich wrote:

>  As an experienced user of SQLite, I guess I'd rather have the
>  developers working on great new database features, rather than build
>  scripts.

SQLite has enough fans that people are happy to build binaries for  
major platforms.  If the SQLite web site will host those binaries, or  
even just a page with URLs where you can find those binaries, that  
makes 99.9% of users happy.  That includes me: for what I do all I  
want is a '.h' header file and a '.a' library file.

It's the 1% that we're discussing here.  They want to customise their  
copies or build with unusual settings, so they can't use standard  
binaries.  Fortunately, half (?) the people who want to do this know  
how to do it themselves: use 'make', or create a project in their  
favourite IDE, or whatever.

So now we're down to one person in 2000 who needs a special build but  
doesn't know enough to write makefiles, or set all the settings for  
their favourite compiler, or whatever.  And they're really hard to  
cater for because they all have different platforms, compilers, and  
IDEs.  And popular as SQLite is it's not popular enough to have  
experts on each one of these things.

So I think this mailing list does pretty well in dealing with such  
people, considering that we have nobody paid to do it.  It's gonna  
have to be like that for a while.  SQLite is trendy right now: lots of  
cool new portable platforms need a tiny light SQL system.  People will  
get by.

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

Re: [sqlite] Installing SQLite

[Jay A. Kreibich]

On Fri, Jul 24, 2009 at 02:19:36AM +0700, Dan scratched on the wall:
> 
> On Jul 23, 2009, at 10:50 PM, Jay A. Kreibich wrote:
> 
> > On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on  
> > the wall:
> >
> >  The amalgimation works well enough if what you want is mostly
> >  defaults.  The issue is that, while you can change a few of the
> >  #defines for numric defaults, most of the more interesting build
> >  options won't work with the amalgimation.  Only that's it.  As the
> >  website clearly states, there is no other supported option.
> >  no suppored "by the file"
> 
> I think it's just the SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature and
> some of the SQLITE_OMIT_XXX symbols that won't work with the  
> amalgamation
> version. I haven't tried though, so could be wrong there.

  These days, that's true.  When the amalgamation first came out, it
  seemed like you needed to rebuild the amalgamation from the
  distribution sources for nearly any #define that wasn't a simple
  numeric default.  This is no longer true and the vast majority
  of the available build options do appear to work directly on the
  amalgamation.  That's great.

> The problem with the configure script in the full source tree
> distribution is that it is complex and nobody really seems to understand
> it. Hence "unsupported".
 
  As an experienced user of SQLite, I guess I'd rather have the
  developers working on great new database features, rather than build
  scripts.

  Still, I think the lack of a simple build system for the working
  sources presents a signification barrier of entry to anyone that
  can't use the amalgamation-- including those that need/want to
  make changes or patches to the development sources, as well as
  those that prefer a working debugger (many debuggers, including
  Visual Studio, can't deal with a source file as big as sqlite3.c).

   -j


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

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Gary_Gabriel]

Hi All;

I'm a newbie trying to get up to speed on SQL and SQLite and first- 
thanks for the product, and thanks for the group access and the chance 
to extensively learn. I agree with the following and would volunteer to 
document my learning experience. I used this thread as an opportunity to 
look around and found some interesting compilers to use for SQLite. I 
would take the opportunity to use collective experience and 
recommendations to choose and install the compiler under XP and build 
SQLite. Then to document it for Windows users. I would suggest 
submitting the docs for group comment, make any changes; and then making 
it available for use. I found some tutorials that look as if they make 
significant contributions.

If there is interest in working together to bundle the collective 
experience and document it, then there are general questions to discuss 
that would speed, and benefit the installation as well as supporting the 
documentation. This would start the work. I would follow with my 
questions and continue with any that the group complements.

Thanks again for so actively sharing experience to help-

Gary Gabriel

PS. As a short intro: I am not new to databases having developed, built 
and implemented a DOS relational database for sales and distribution 
management with DataPerfect that successfully drove a business for 20 
years. I am also not new to documentation. I applied the database above 
to Sales Cycle Management/ Internet Messaging and wrote a series of 
articles to develop the application:
Internet Messaging >>> 

  
Sales Cycle Management 


My goal is to replace DP with SQLite and more tightly integrate into 
Internet Messaging. I am in the process of re-desiging and testing using 
SQLite/ Perl. I am grateful for any helpful comments.

Vance E. Neff wrote:
> If there was a zip file that included an open source compiler and linker 
> and a well commented makefile along with SQLite's source code so that 
> anyone (at least under Windows) can generate the version SQLite dll and 
> command shell that they want without having to search for tools, I think 
> more people would be more likely to experiment with some of the non 
> standard features.
>
> Vance
>
> Jay A. Kreibich wrote:
>   
>>   Grrr I didn't meant to send this just yet.  But since I did, I
>>   guess I need to finish it.
>>
>> On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched on the 
>> wall:
>> 
>>> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the 
>>> wall:
>>>
>>>   
 I think the OP just has the wrong expectations.
 
>>>   Yes, and no.  While SQLite doesn't have a one-click-to-install
>>>   download, I have to agree that the current build and distribution
>>>   state of SQLite is... let's just say "less than ideal."  I've been
>>>   writing a lot of documentation on just this issue, and unless you
>>>   want a perfect vanilla install, there are definitely a lot of hoops
>>>   you have to jump through compared to most open-source projects of
>>>   similar design.
>>>   
>>>   A few versions ago we transitioned from a traditional UNIX style
>>>   project, complete with "configure" script, to having the amalgamation
>>>   be the "standard" distribution.  I've always felt like that
>>>   transition is incomplete, and we've never gotten back to where we
>>>   were before.
>>>
>>>   The amalgamation works well enough if what you want is mostly
>>>   defaults.  The issue is that, while you can change a few of the
>>>   #defines for numeric defaults, most of the more interesting build
>>>   options won't work with the amalgamation.  Only that's it.  As the
>>>   website clearly states, there is no other supported option.  
>>>   
>>   The "by the file" distribution is bad enough, but you're totally out
>>   of luck if you need to go to the tree for some of the really complex
>>   build options.  Of course, the "by the file" distribution is there
>>   and available for download because a lot of people still need it, but
>>   apparently not enough to justify keeping it updated.  That's a bit of 
>>   a contradiction... for a piece of software that prides itself on its
>>   testing systems, the end-users sees a whole lot of "there but not
>>   supported; it might work it might not; you're on your own" stuff.
>>   That's normally a big red flag in my book.  Stuff should be there, be
>>   supported, and be documented, or it shouldn't.  The current situation
>>   is only easily understandable if you've been following SQLite for a few
>>   years.
>>
>>   And the OP is right... the build docs suck.  There are no build docs
>>   for most downloads, just a archive file with source.  No Makefiles, no
>>   nothing. 

Re: [sqlite] Installing SQLite

[Hamish Allan]

On Thu, Jul 23, 2009 at 9:03 PM, Rich Shepard wrote:

>   Er, Dan, ... without the build step there's nothing to install.

A well-formed Makefile should specify the default build target as a
dependency of the install target.

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

Re: [sqlite] Installing SQLite

[Rich Shepard]

On Fri, 24 Jul 2009, Dan wrote:

> There is an amalgamation package that includes a supported configure
> script. "./configure && make install" and you're away.

   Er, Dan, ... without the build step there's nothing to install. The usual
sequence is ./configure && make && make install. Or, you build a package for
your distribution.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Fred Williams]

That might be an option to consider.  But, I think there might be a rather
small number of potential SQLite users interested.  I would think the group
with the greatest benefit of that kind of package would be students and
serious rookies.

Most users I feel either pre possess the required expertise to work with the
current source package or, like me, prefer to leave the implementation
details to those supplying the pre packaged .DLL's.  I could work from
source, but why bother?  I guess I'm getting lazy or am too willing to
accept what is prepackaged.

My main purpose is to utilize a small tightly implemented database that I do
not have to deal with below the prepackaged level.  If that was not possible
with SQLite, I would still be looking I suppose.  I would suspect that the
majority of users are pretty much in my camp.  I'll go so far as to say
20/80, the golden rule of most everything in life.  With 20 being the Gurus
or wana'bes and 80 the rest of us.

BTW, I'll go further and say that fewer than 20 of the above 80 even know
about this mailing list ;-)

Dr. Hipp may be able to back this up with some general numbers if he wishes
to totally waste his time...

Fred

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Vance E. Neff
Sent: Thursday, July 23, 2009 1:06 PM
To: j...@kreibi.ch; General Discussion of SQLite Database
Subject: Re: [sqlite] Installing SQLite


If there was a zip file that included an open source compiler and linker
and a well commented makefile along with SQLite's source code so that
anyone (at least under Windows) can generate the version SQLite dll and
command shell that they want without having to search for tools, I think
more people would be more likely to experiment with some of the non
standard features.

Vance

Jay A. Kreibich wrote:
>   Grrr I didn't meant to send this just yet.  But since I did, I
>   guess I need to finish it.
>
> On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched on the
wall:
>> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the
wall:
>>
>>> I think the OP just has the wrong expectations.
>>   Yes, and no.  While SQLite doesn't have a one-click-to-install
>>   download, I have to agree that the current build and distribution
>>   state of SQLite is... let's just say "less than ideal."  I've been
>>   writing a lot of documentation on just this issue, and unless you
>>   want a perfect vanilla install, there are definitely a lot of hoops
>>   you have to jump through compared to most open-source projects of
>>   similar design.
>>
>>   A few versions ago we transitioned from a traditional UNIX style
>>   project, complete with "configure" script, to having the amalgamation
>>   be the "standard" distribution.  I've always felt like that
>>   transition is incomplete, and we've never gotten back to where we
>>   were before.
>>
>>   The amalgamation works well enough if what you want is mostly
>>   defaults.  The issue is that, while you can change a few of the
>>   #defines for numeric defaults, most of the more interesting build
>>   options won't work with the amalgamation.  Only that's it.  As the
>>   website clearly states, there is no other supported option.
>
>   The "by the file" distribution is bad enough, but you're totally out
>   of luck if you need to go to the tree for some of the really complex
>   build options.  Of course, the "by the file" distribution is there
>   and available for download because a lot of people still need it, but
>   apparently not enough to justify keeping it updated.  That's a bit of
>   a contradiction... for a piece of software that prides itself on its
>   testing systems, the end-users sees a whole lot of "there but not
>   supported; it might work it might not; you're on your own" stuff.
>   That's normally a big red flag in my book.  Stuff should be there, be
>   supported, and be documented, or it shouldn't.  The current situation
>   is only easily understandable if you've been following SQLite for a few
>   years.
>
>   And the OP is right... the build docs suck.  There are no build docs
>   for most downloads, just a archive file with source.  No Makefiles, no
>   nothing.  There is no "how to build" on the documentation page (just
>   docs on build options) and the Wiki pages on building and the
>   amalgamation are so out of date that they have negative value, doing
>   little more than confusing people.
>
>   I realize that you might take the argument that anyone smart enough
>   need to build the SQLite engine into an application should be able to
>   figure that out, and with enough time, maybe

Re: [sqlite] Installing SQLite

[Dan]

On Jul 23, 2009, at 10:50 PM, Jay A. Kreibich wrote:

> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on  
> the wall:
>
>> I think the OP just has the wrong expectations.
>
>  Yes, and no.  While SQLite doesn't have a one-click-to-install
>  download, I have to agree that the current build and distribution
>  state of SQLite is... let's just say "less than ideal."  I've been
>  writing a lot of documentation on just this issue, and unless you
>  want a perfect vanilla install, there are definitly a lot of hoops
>  you have to jump through compared to most open-source projects of
>  similar design.
>
>  A few versions ago we transitioned from a traditional UNIX style
>  project, complete with "configure" script, to having the amalgimation
>  be the "standard" distribution.  I've always felt like that
>  transition is imcomplete, and we've never gotten back to where we
>  were before.
>
>  The amalgimation works well enough if what you want is mostly
>  defaults.  The issue is that, while you can change a few of the
>  #defines for numric defaults, most of the more interesting build
>  options won't work with the amalgimation.  Only that's it.  As the
>  website clearly states, there is no other supported option.
>  no suppored "by the file"

I think it's just the SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature and
some of the SQLITE_OMIT_XXX symbols that won't work with the  
amalgamation
version. I haven't tried though, so could be wrong there.

There is an amalgamation package that includes a supported configure
script. "./configure && make install" and you're away. You can specify
compile time options via the CFLAGS environment variable.

The problem with the configure script in the full source tree
distribution is that it is complex and nobody really seems to understand
it. Hence "unsupported".
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Vance E. Neff]

If there was a zip file that included an open source compiler and linker 
and a well commented makefile along with SQLite's source code so that 
anyone (at least under Windows) can generate the version SQLite dll and 
command shell that they want without having to search for tools, I think 
more people would be more likely to experiment with some of the non 
standard features.

Vance

Jay A. Kreibich wrote:
>   Grrr I didn't meant to send this just yet.  But since I did, I
>   guess I need to finish it.
> 
> On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched on the 
> wall:
>> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the 
>> wall:
>>
>>> I think the OP just has the wrong expectations.
>>   Yes, and no.  While SQLite doesn't have a one-click-to-install
>>   download, I have to agree that the current build and distribution
>>   state of SQLite is... let's just say "less than ideal."  I've been
>>   writing a lot of documentation on just this issue, and unless you
>>   want a perfect vanilla install, there are definitely a lot of hoops
>>   you have to jump through compared to most open-source projects of
>>   similar design.
>>   
>>   A few versions ago we transitioned from a traditional UNIX style
>>   project, complete with "configure" script, to having the amalgamation
>>   be the "standard" distribution.  I've always felt like that
>>   transition is incomplete, and we've never gotten back to where we
>>   were before.
>>
>>   The amalgamation works well enough if what you want is mostly
>>   defaults.  The issue is that, while you can change a few of the
>>   #defines for numeric defaults, most of the more interesting build
>>   options won't work with the amalgamation.  Only that's it.  As the
>>   website clearly states, there is no other supported option.  
> 
>   The "by the file" distribution is bad enough, but you're totally out
>   of luck if you need to go to the tree for some of the really complex
>   build options.  Of course, the "by the file" distribution is there
>   and available for download because a lot of people still need it, but
>   apparently not enough to justify keeping it updated.  That's a bit of 
>   a contradiction... for a piece of software that prides itself on its
>   testing systems, the end-users sees a whole lot of "there but not
>   supported; it might work it might not; you're on your own" stuff.
>   That's normally a big red flag in my book.  Stuff should be there, be
>   supported, and be documented, or it shouldn't.  The current situation
>   is only easily understandable if you've been following SQLite for a few
>   years.
> 
>   And the OP is right... the build docs suck.  There are no build docs
>   for most downloads, just a archive file with source.  No Makefiles, no
>   nothing.  There is no "how to build" on the documentation page (just
>   docs on build options) and the Wiki pages on building and the
>   amalgamation are so out of date that they have negative value, doing
>   little more than confusing people.
> 
>   I realize that you might take the argument that anyone smart enough
>   need to build the SQLite engine into an application should be able to
>   figure that out, and with enough time, maybe that's right a fair
>   percentage of the time.  On the other hand, the whole point of moving
>   to the amalgamation was to simplify putting SQLite into an
>   application.  I think overall it does this, but only if you're
>   working from the default everything.  The amalgamation might be
>   easier or better (for some definition of those terms) if you
>   understand it, but it is radically different from nearly every other
>   open source project out there.  A bit of hand holding, even for
>   experienced developers, is not out of place.
> 
>   SQLite is a great product, but there is still a lot of room for
>   improvement on the packaging, distribution, and "productization"
>   of the code.
> 
> 
>   And even if his post was a bit negative, I'm a little disappointed at
>   the community response.  We're here to help, not criticize.  If that
>   was my introduction to the product and its users, you can be sure I
>   wouldn't be coming back.  If you're not going to try to add something
>   to the conversation, there is no obligation to hit reply.
> 
>-j
> 
> 

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

Re: [sqlite] Installing SQLite

[Jim Showalter]

Jay, your email below is superb. It's dispassionate, accurate, 
diplomatic, and informative.

I was also disappointed to see this email list go the way of so many 
others over the past day or so, but it's easy enough to fix it. Stop 
calling someone else a doofus for selecting a particular OS to work 
with, stop using the word "sucks" to describe a deficiency in the 
build system and instead offer constructive criticism and suggestions 
for improvement (as Jay does below), and stop calling people trolls 
even if their email is a bit of a flame.

In the short time I've subscribed to this list, I've been amazed at 
the technical acumen of the people who reply to questions. The replies 
I've gotten for my questions--even stupid ones--have been very 
helpful, and some of the in-depth discussions of particular features 
(like iterating over chunks of blobs) are fascinating.

- Original Message - 
From: "Jay A. Kreibich" <j...@kreibi.ch>
To: "Jay A. Kreibich" <j...@kreibi.ch>
Cc: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Thursday, July 23, 2009 9:07 AM
Subject: Re: [sqlite] Installing SQLite


>
>  Grrr I didn't meant to send this just yet.  But since I did, I
>  guess I need to finish it.
>
> On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched 
> on the wall:
>> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched 
>> on the wall:
>>
>> > I think the OP just has the wrong expectations.
>>
>>   Yes, and no.  While SQLite doesn't have a one-click-to-install
>>   download, I have to agree that the current build and distribution
>>   state of SQLite is... let's just say "less than ideal."  I've 
>> been
>>   writing a lot of documentation on just this issue, and unless you
>>   want a perfect vanilla install, there are definitely a lot of 
>> hoops
>>   you have to jump through compared to most open-source projects of
>>   similar design.
>>
>>   A few versions ago we transitioned from a traditional UNIX style
>>   project, complete with "configure" script, to having the 
>> amalgamation
>>   be the "standard" distribution.  I've always felt like that
>>   transition is incomplete, and we've never gotten back to where we
>>   were before.
>>
>>   The amalgamation works well enough if what you want is mostly
>>   defaults.  The issue is that, while you can change a few of the
>>   #defines for numeric defaults, most of the more interesting build
>>   options won't work with the amalgamation.  Only that's it.  As 
>> the
>>   website clearly states, there is no other supported option.
>
>  The "by the file" distribution is bad enough, but you're totally 
> out
>  of luck if you need to go to the tree for some of the really 
> complex
>  build options.  Of course, the "by the file" distribution is there
>  and available for download because a lot of people still need it, 
> but
>  apparently not enough to justify keeping it updated.  That's a bit 
> of
>  a contradiction... for a piece of software that prides itself on 
> its
>  testing systems, the end-users sees a whole lot of "there but not
>  supported; it might work it might not; you're on your own" stuff.
>  That's normally a big red flag in my book.  Stuff should be there, 
> be
>  supported, and be documented, or it shouldn't.  The current 
> situation
>  is only easily understandable if you've been following SQLite for a 
> few
>  years.
>
>  And the OP is right... the build docs suck.  There are no build 
> docs
>  for most downloads, just a archive file with source.  No Makefiles, 
> no
>  nothing.  There is no "how to build" on the documentation page 
> (just
>  docs on build options) and the Wiki pages on building and the
>  amalgamation are so out of date that they have negative value, 
> doing
>  little more than confusing people.
>
>  I realize that you might take the argument that anyone smart enough
>  need to build the SQLite engine into an application should be able 
> to
>  figure that out, and with enough time, maybe that's right a fair
>  percentage of the time.  On the other hand, the whole point of 
> moving
>  to the amalgamation was to simplify putting SQLite into an
>  application.  I think overall it does this, but only if you're
>  working from the default everything.  The amalgamation might be
>  easier or better (for some definition of those terms) if you
>  understand it, but it is radically different from nearly every 
> other
>  open source project out there.  A bit of hand holding, even for
>  experienced de

Re: [sqlite] Installing SQLite

[Jay A. Kreibich]

  Grrr I didn't meant to send this just yet.  But since I did, I
  guess I need to finish it.

On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched on the wall:
> On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the wall:
> 
> > I think the OP just has the wrong expectations.
> 
>   Yes, and no.  While SQLite doesn't have a one-click-to-install
>   download, I have to agree that the current build and distribution
>   state of SQLite is... let's just say "less than ideal."  I've been
>   writing a lot of documentation on just this issue, and unless you
>   want a perfect vanilla install, there are definitely a lot of hoops
>   you have to jump through compared to most open-source projects of
>   similar design.
>   
>   A few versions ago we transitioned from a traditional UNIX style
>   project, complete with "configure" script, to having the amalgamation
>   be the "standard" distribution.  I've always felt like that
>   transition is incomplete, and we've never gotten back to where we
>   were before.
> 
>   The amalgamation works well enough if what you want is mostly
>   defaults.  The issue is that, while you can change a few of the
>   #defines for numeric defaults, most of the more interesting build
>   options won't work with the amalgamation.  Only that's it.  As the
>   website clearly states, there is no other supported option.  

  The "by the file" distribution is bad enough, but you're totally out
  of luck if you need to go to the tree for some of the really complex
  build options.  Of course, the "by the file" distribution is there
  and available for download because a lot of people still need it, but
  apparently not enough to justify keeping it updated.  That's a bit of 
  a contradiction... for a piece of software that prides itself on its
  testing systems, the end-users sees a whole lot of "there but not
  supported; it might work it might not; you're on your own" stuff.
  That's normally a big red flag in my book.  Stuff should be there, be
  supported, and be documented, or it shouldn't.  The current situation
  is only easily understandable if you've been following SQLite for a few
  years.

  And the OP is right... the build docs suck.  There are no build docs
  for most downloads, just a archive file with source.  No Makefiles, no
  nothing.  There is no "how to build" on the documentation page (just
  docs on build options) and the Wiki pages on building and the
  amalgamation are so out of date that they have negative value, doing
  little more than confusing people.

  I realize that you might take the argument that anyone smart enough
  need to build the SQLite engine into an application should be able to
  figure that out, and with enough time, maybe that's right a fair
  percentage of the time.  On the other hand, the whole point of moving
  to the amalgamation was to simplify putting SQLite into an
  application.  I think overall it does this, but only if you're
  working from the default everything.  The amalgamation might be
  easier or better (for some definition of those terms) if you
  understand it, but it is radically different from nearly every other
  open source project out there.  A bit of hand holding, even for
  experienced developers, is not out of place.

  SQLite is a great product, but there is still a lot of room for
  improvement on the packaging, distribution, and "productization"
  of the code.


  And even if his post was a bit negative, I'm a little disappointed at
  the community response.  We're here to help, not criticize.  If that
  was my introduction to the product and its users, you can be sure I
  wouldn't be coming back.  If you're not going to try to add something
  to the conversation, there is no obligation to hit reply.

   -j


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

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Jay A. Kreibich]

On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the wall:

> I think the OP just has the wrong expectations.

  Yes, and no.  While SQLite doesn't have a one-click-to-install
  download, I have to agree that the current build and distribution
  state of SQLite is... let's just say "less than ideal."  I've been
  writing a lot of documentation on just this issue, and unless you
  want a perfect vanilla install, there are definitly a lot of hoops
  you have to jump through compared to most open-source projects of
  similar design.
  
  A few versions ago we transitioned from a traditional UNIX style
  project, complete with "configure" script, to having the amalgimation
  be the "standard" distribution.  I've always felt like that
  transition is imcomplete, and we've never gotten back to where we
  were before.

  The amalgimation works well enough if what you want is mostly
  defaults.  The issue is that, while you can change a few of the
  #defines for numric defaults, most of the more interesting build
  options won't work with the amalgimation.  Only that's it.  As the
  website clearly states, there is no other supported option.  
  no suppored "by the file" 


> SQlite is not a
> windows application you install like MS Word or Firefox.  It is a
> code library that you embed into other code.  It is possible to
> use it in a 'stand alone' manner by using the command line
> utility, but I'm 99% sure this will not meet the OP's expectations
> either.



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

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Fred Williams]

I think you guys are most likely feeding a Troll, or the original poster
might ought to contact his IS support department, or enroll in some
introductory basic home computer continuing education courses in his local
area.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of John Machin
Sent: Thursday, July 23, 2009 10:02 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Installing SQLite


On 23/07/2009 6:48 AM, Rich Shepard wrote:
> On Wed, 22 Jul 2009, scabral wrote:
>
>> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:
>>
>> sqlite3   C File
>> sqlite3   H File
>> sqlite3ext H File
>
>> what am i supposed to do with those?
>
>  Well, based on what others wrote about your initial comments, I suggest
> that you replace XP with a linux distribution. Then you can compile that
> source code all by yourself.

No need. One can compile sqlite on Windows all by ones's own self using
a variety of $-free C/C++ compilers (gcc/mingw32 (FOSS), Borland, and
there's a command-line compiler somewhere inside the 100Mb VS2009
Express download from the dark tower of Redmond).

> On the other hand, if you insist on sticking
> with Microsoft, download one of the pre-built Winduhs .zip files as I
> indicated in my previous message.

The pre-built Windows .zip files are paralleled one-to-one by pre-built
linux .gz files ... someone must consider that inability to compile
one's way out of a wet paper bag is platform-independent :-)
___
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] Installing SQLite

[John Machin]

On 23/07/2009 6:48 AM, Rich Shepard wrote:
> On Wed, 22 Jul 2009, scabral wrote:
> 
>> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:
>>
>> sqlite3   C File
>> sqlite3   H File
>> sqlite3ext H File
> 
>> what am i supposed to do with those?
> 
>  Well, based on what others wrote about your initial comments, I suggest
> that you replace XP with a linux distribution. Then you can compile that
> source code all by yourself.

No need. One can compile sqlite on Windows all by ones's own self using 
a variety of $-free C/C++ compilers (gcc/mingw32 (FOSS), Borland, and 
there's a command-line compiler somewhere inside the 100Mb VS2009 
Express download from the dark tower of Redmond).

> On the other hand, if you insist on sticking
> with Microsoft, download one of the pre-built Winduhs .zip files as I
> indicated in my previous message.

The pre-built Windows .zip files are paralleled one-to-one by pre-built 
linux .gz files ... someone must consider that inability to compile 
one's way out of a wet paper bag is platform-independent :-)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Wilson, Ron P]

> Well, based on what others wrote about your initial comments, I suggest
> that you replace XP with a linux distribution. Then you can compile that
> source code all by yourself. On the other hand, if you insist on sticking
> with Microsoft, download one of the pre-built Winduhs .zip files as I
> indicated in my previous message.

SQlite compiles just fine on windows XP.  You just need tools to do it, which 
unlike linux, don't automatically come with the OS.  So there is most likely a 
teaching opportunity here, though admittedly the OP does not appear to be in a 
teachable frame of mind.

I think the OP just has the wrong expectations.  SQlite is not a windows 
application you install like MS Word or Firefox.  It is a code library that you 
embed into other code.  It is possible to use it in a 'stand alone' manner by 
using the command line utility, but I'm 99% sure this will not meet the OP's 
expectations either.

Also, I for one would appreciate it if in the future you avoid making the 
sweeping generalization that "Winduhs" users are dummies or lemmings.  I'm sure 
others would agree.

RW

Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com

HARRIS CORPORATION   |   RF Communications Division assuredcommunicationsT
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Jim Dodgen]

This is not a simple tool. I is primarily designed to be embedded in
applications. Your opinion about the quality of the *install* instructions
leads people to believe that you may need a better understanding of the
skill level required to use Sqlite.

On Wed, Jul 22, 2009 at 1:43 PM, scabral  wrote:

>
> i don't get it...
>
>
>
> Nuno Magalhães-2 wrote:
> >
> > On Wed, Jul 22, 2009 at 21:30, scabral wrote:
> >
> > [...]
> >
> >> the instructions on the SQLite website are pretty crappy to say the
> >> least.
> >> When i download the zip file, all i get is 3 txt files???
> >
> > [...]
> >
> > Oh... a troll.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Installing-SQLite-tp24614036p24614214.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
>



-- 
Jim "Jed" Dodgen
j...@dodgen.us
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[scabral]

i don't get it...



Nuno Magalhães-2 wrote:
> 
> On Wed, Jul 22, 2009 at 21:30, scabral wrote:
> 
> [...]
> 
>> the instructions on the SQLite website are pretty crappy to say the
>> least.
>> When i download the zip file, all i get is 3 txt files???
> 
> [...]
> 
> Oh... a troll.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Installing-SQLite-tp24614036p24614214.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] Installing SQLite

[Rich Shepard]

On Wed, 22 Jul 2009, scabral wrote:

> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:
>
> sqlite3   C File
> sqlite3   H File
> sqlite3ext H File

> what am i supposed to do with those?

   Well, based on what others wrote about your initial comments, I suggest
that you replace XP with a linux distribution. Then you can compile that
source code all by yourself. On the other hand, if you insist on sticking
with Microsoft, download one of the pre-built Winduhs .zip files as I
indicated in my previous message.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Rich Shepard]

On Wed, 22 Jul 2009, scabral wrote:

> does someone have 'good' instructions on what i need and how i need to
> install SQLite on Windows XP?

Scott,

   I don't do Windows; haven't for more than a dozen years. However, it
doesn't look too hard.

> the instructions on the SQLite website are pretty crappy to say the least.
> When i download the zip file, all i get is 3 txt files???

   Well, those of us on non-Microsoft systems are used to installing new
applications either from distribution-specific packages or by building and
installing from the source code. There are probably generic installation
instructions for XP, too.

   If you go to the download section of the Web site you'll see this:

Precompiled Binaries For Windows
sqlite-3_6_16.zip
(246.32 KiB)A command-line program for accessing and
modifying SQLite databases. See the
documentation for additional information.

tclsqlite-3_6_16.zip
(314.99 KiB)Bindings for Tcl/Tk. You can import this
shared library into either tclsh or wish to
get SQLite database access from Tcl/Tk. See
the documentation for details.

sqlitedll-3_6_16.zip
(243.68 KiB)This is a DLL of the SQLite library without
the TCL bindings. The only external
dependency is MSVCRT.DLL.

sqlite3_analyzer-3.6.1.zip
(508.70 KiB)An analysis program for database files
compatible with SQLite version 3.6.1 and
later.

   So I presume that you downloaded both sqlite-3_6_16.zip and
sqlitedll-3_6_16.zip. Yes?

   Aren't there generic instructions for installing *.exe and *.dll files?

> I eventually want to create a desktop application to run on SQLite, but not
> sure what language i want to use yet (pythong, ruby, etc...)

   For stand-alone applications I suggest Python (without the 'g'); for
Web-based (or http server-based) applications I suggest Ruby on Rails.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Thomas Briggs]

   Not in the InstallShield/MSI format that I imagine you're looking
for no.  But that's the whole point, really.

   See the "Precompiled Binaries" section of the download page.
You'll find what you need (if not necessarily what you're looking for)
there.

   -T

On Wed, Jul 22, 2009 at 4:42 PM, scabral wrote:
>
> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:
>
> sqlite3   C File
> sqlite3   H File
> sqlite3ext H File
>
> what am i supposed to do with those?
>
> Is there no 'true' install?
>
> Scott
>
> P Kishor-3 wrote:
>>
>> On Wed, Jul 22, 2009 at 3:30 PM, scabral wrote:
>>>
>>> Hi,
>>>
>>> does someone have 'good' instructions on what i need and how i need to
>>> install SQLite on Windows XP?
>>>
>>> I eventually want to create a desktop application to run on SQLite, but
>>> not
>>> sure what language i want to use yet (pythong, ruby, etc...)
>>>
>>> the instructions on the SQLite website are pretty crappy to say the
>>> least.
>>
>> Well, declaring the sqlite website to be crappy is not going to win
>> you many friends here. Remember, it is all free, so if you think it
>> lacks in some way, offer some constructive criticism instead. Of
>> course, in reality, the sqlite website actually is quite the opposite
>> of crappy. I just downloaded the "zip file" (there are several of
>> them), and I got exactly what was stated on the tin -- the sqlite3.exe
>> executable.
>>
>> You have to decide what you want -- the executable is a command line
>> program. There is also a dll and other such paraphernalia that Windows
>> folks require... I am sure they will help you out, but please don't
>> put them off by calling the site crappy.
>>
>>
>>> When i download the zip file, all i get is 3 txt files???
>>>
>>> thanks
>>> Scott
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Installing-SQLite-tp24614036p24614036.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
>>>
>>
>>
>>
>> --
>> Puneet Kishor http://www.punkish.org
>> Carbon Model http://carbonmodel.org
>> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
>> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
>> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
>> ---
>> Assertions are politics; backing up assertions with evidence is science
>> ===
>> Sent from Madison, WI, United States
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context: 
> http://www.nabble.com/Installing-SQLite-tp24614036p24614205.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Reid Thompson]

On Wed, Jul 22, 2009 at 01:30:58PM -0700, scabral wrote:
>
> Hi,
>
> does someone have 'good' instructions on what i need and how i need to
> install SQLite on Windows XP?
>
> I eventually want to create a desktop application to run on SQLite, but not
> sure what language i want to use yet (pythong, ruby, etc...)
>
> the instructions on the SQLite website are pretty crappy to say the least.
> When i download the zip file, all i get is 3 txt files???
>

you did something wrong.  This file

http://sqlite.org/sqlite-3_6_16.zip

from  http://sqlite.org/download.html
contains the precompiled windows binary
and this page, referenced from where the above link is
http://sqlite.org/sqlite.html
tells you how to get started

utilizing sqlite from a language requires this file
http://sqlite.org/sqlitedll-3_6_16.zip
and you have to install the appropriate bindings for your lang of choice
or configure your compilation to utilize the dll
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[P Kishor]

On Wed, Jul 22, 2009 at 3:42 PM, scabral wrote:
>
> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:
>
> sqlite3   C File
> sqlite3   H File
> sqlite3ext H File
>
> what am i supposed to do with those?
>
> Is there no 'true' install?

Read that entire page carefully before clicking on the first available
link.. you will find what you need. This kind of trigger-happy
clicking will get your computer infected with some nasty virus.


>
> Scott
>
> P Kishor-3 wrote:
>>
>> On Wed, Jul 22, 2009 at 3:30 PM, scabral wrote:
>>>
>>> Hi,
>>>
>>> does someone have 'good' instructions on what i need and how i need to
>>> install SQLite on Windows XP?
>>>
>>> I eventually want to create a desktop application to run on SQLite, but
>>> not
>>> sure what language i want to use yet (pythong, ruby, etc...)
>>>
>>> the instructions on the SQLite website are pretty crappy to say the
>>> least.
>>
>> Well, declaring the sqlite website to be crappy is not going to win
>> you many friends here. Remember, it is all free, so if you think it
>> lacks in some way, offer some constructive criticism instead. Of
>> course, in reality, the sqlite website actually is quite the opposite
>> of crappy. I just downloaded the "zip file" (there are several of
>> them), and I got exactly what was stated on the tin -- the sqlite3.exe
>> executable.
>>
>> You have to decide what you want -- the executable is a command line
>> program. There is also a dll and other such paraphernalia that Windows
>> folks require... I am sure they will help you out, but please don't
>> put them off by calling the site crappy.
>>
>>
>>> When i download the zip file, all i get is 3 txt files???
>>>
>>> thanks
>>> Scott
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Installing-SQLite-tp24614036p24614036.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
>>>
>>
>>
>>
>> --
>> Puneet Kishor http://www.punkish.org
>> Carbon Model http://carbonmodel.org
>> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
>> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
>> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
>> ---
>> Assertions are politics; backing up assertions with evidence is science
>> ===
>> Sent from Madison, WI, United States
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context: 
> http://www.nabble.com/Installing-SQLite-tp24614036p24614205.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
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[scabral]

When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files:

sqlite3   C File
sqlite3   H File
sqlite3ext H File

what am i supposed to do with those?

Is there no 'true' install?

Scott

P Kishor-3 wrote:
> 
> On Wed, Jul 22, 2009 at 3:30 PM, scabral wrote:
>>
>> Hi,
>>
>> does someone have 'good' instructions on what i need and how i need to
>> install SQLite on Windows XP?
>>
>> I eventually want to create a desktop application to run on SQLite, but
>> not
>> sure what language i want to use yet (pythong, ruby, etc...)
>>
>> the instructions on the SQLite website are pretty crappy to say the
>> least.
> 
> Well, declaring the sqlite website to be crappy is not going to win
> you many friends here. Remember, it is all free, so if you think it
> lacks in some way, offer some constructive criticism instead. Of
> course, in reality, the sqlite website actually is quite the opposite
> of crappy. I just downloaded the "zip file" (there are several of
> them), and I got exactly what was stated on the tin -- the sqlite3.exe
> executable.
> 
> You have to decide what you want -- the executable is a command line
> program. There is also a dll and other such paraphernalia that Windows
> folks require... I am sure they will help you out, but please don't
> put them off by calling the site crappy.
> 
> 
>> When i download the zip file, all i get is 3 txt files???
>>
>> thanks
>> Scott
>> --
>> View this message in context:
>> http://www.nabble.com/Installing-SQLite-tp24614036p24614036.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
>>
> 
> 
> 
> -- 
> Puneet Kishor http://www.punkish.org
> Carbon Model http://carbonmodel.org
> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
> ---
> Assertions are politics; backing up assertions with evidence is science
> ===
> Sent from Madison, WI, United States
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Installing-SQLite-tp24614036p24614205.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] Installing SQLite

[P Kishor]

On Wed, Jul 22, 2009 at 3:30 PM, scabral wrote:
>
> Hi,
>
> does someone have 'good' instructions on what i need and how i need to
> install SQLite on Windows XP?
>
> I eventually want to create a desktop application to run on SQLite, but not
> sure what language i want to use yet (pythong, ruby, etc...)
>
> the instructions on the SQLite website are pretty crappy to say the least.

Well, declaring the sqlite website to be crappy is not going to win
you many friends here. Remember, it is all free, so if you think it
lacks in some way, offer some constructive criticism instead. Of
course, in reality, the sqlite website actually is quite the opposite
of crappy. I just downloaded the "zip file" (there are several of
them), and I got exactly what was stated on the tin -- the sqlite3.exe
executable.

You have to decide what you want -- the executable is a command line
program. There is also a dll and other such paraphernalia that Windows
folks require... I am sure they will help you out, but please don't
put them off by calling the site crappy.


> When i download the zip file, all i get is 3 txt files???
>
> thanks
> Scott
> --
> View this message in context: 
> http://www.nabble.com/Installing-SQLite-tp24614036p24614036.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
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Nuno Magalhães]

On Wed, Jul 22, 2009 at 21:30, scabral wrote:

[...]

> the instructions on the SQLite website are pretty crappy to say the least.
> When i download the zip file, all i get is 3 txt files???

[...]

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

[sqlite] Installing SQLite

[scabral]

Hi,

does someone have 'good' instructions on what i need and how i need to
install SQLite on Windows XP?  

I eventually want to create a desktop application to run on SQLite, but not
sure what language i want to use yet (pythong, ruby, etc...)

the instructions on the SQLite website are pretty crappy to say the least. 
When i download the zip file, all i get is 3 txt files???

thanks
Scott
-- 
View this message in context: 
http://www.nabble.com/Installing-SQLite-tp24614036p24614036.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] Installing SQLite

[William Kyngesburye]

On Mar 3, 2009, at 4:18 PM, D. Richard Hipp wrote:

> Another issue, that I only discovered two days ago, is that binaries
> compiled for Leopard (OS 10.5) will only run on Leopard and not older
> OS X systems.  And the precompiled shell found on the website is
> compiled on Leopard (which is all I have at hand.)  So downloading and
> running the pre-compiled shell will not work unless you have the
> latest Mac OS.  I don't know how to fix this problem.  Probably in the
> next release we will just label the binaries as "Leopard or later  
> only".
>
> D. Richard Hipp
> d...@hwaci.com


The default deployment target on Leopard is Leopard.  On earlier  
systems it's 10.3 (or 10.2?).  To get a Tiger-compatible Sqlite built  
on Leopard:

export MACOSX_DEPLOYMENT_TARGET=10.4
export CFLAGS="-Os -arch ppc -arch i386 -isysroot /Developer/SDKs/ 
MacOSX10.4u.sdk"

then configure as you normally would.

If you have the 10.3 SDK installed, you could go as far back as 10.3  
deployment+SDK.

-
William Kyngesburye 
http://www.kyngchaos.com/

"Those people who most want to rule people are, ipso-facto, those  
least suited to do it."

- A rule of the universe, from the HitchHiker's Guide to the Galaxy


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

Re: [sqlite] Installing SQLite

[D. Richard Hipp]

On Mar 3, 2009, at 5:04 PM, BareFeet wrote:
>
> In answer to your question about the .bin pre-compiled SQLite command
> line tool download from the SQLite web site, you need to:
>
> 1. Download it.
> 2. Rename it to "sqlite3" (no .bin extension, which I think shouldn't
> be there since it's confused with being a MacBinary file).

I did not know that.   I'll make a note to adjust the name in the next  
release.

>
> 3. Move it to a location where you want to run it. Somewhere like / 
> usr/
> local/bin/sqlite3. Do NOT replace the sqlite3 that is installed in the
> system /usr/bin/sqlite3.

Another issue, that I only discovered two days ago, is that binaries  
compiled for Leopard (OS 10.5) will only run on Leopard and not older  
OS X systems.  And the precompiled shell found on the website is  
compiled on Leopard (which is all I have at hand.)  So downloading and  
running the pre-compiled shell will not work unless you have the  
latest Mac OS.  I don't know how to fix this problem.  Probably in the  
next release we will just label the binaries as "Leopard or later only".

D. Richard Hipp
d...@hwaci.com



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

Re: [sqlite] Installing SQLite

[BareFeet]

Hi Dan,

> I am an experienced Windows user and application developer.  I am  
> now attempting to actually use a Mac!!  God forbid!!
>
> I have an SQLite database and I'm trying to figure out how to  
> install SQLite so I can view it and update it.  I downloaded the bin  
> files but I'm obviously missing something.

As others have mentioned, SQLite 3.40 is already installed as part of  
Mac OS X and drives half of the applications on the platform.

As other have pointed out, you can install the Mac OS X developer  
tools and compile/make the SQLite source code.

In answer to your question about the .bin pre-compiled SQLite command  
line tool download from the SQLite web site, you need to:

1. Download it.
2. Rename it to "sqlite3" (no .bin extension, which I think shouldn't  
be there since it's confused with being a MacBinary file).
3. Move it to a location where you want to run it. Somewhere like /usr/ 
local/bin/sqlite3. Do NOT replace the sqlite3 that is installed in the  
system /usr/bin/sqlite3.

I have a list of SQLite GUI apps for Mac OS X here:
http://www.tandb.com.au/sqlite/compare/?ml

Tom
BareFeet


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

Re: [sqlite] Installing SQLite

[William Kyngesburye]

Nothing wrong with Macs ;)

As others have pointed out, OSX includes Sqlite, though a bit old.   
Also note that extension loading is disabled in this version.

If you don't want to mess with installing Xcode, and want an up to  
date and feature-packed Sqlite installer, try my Sqlite framework.  It  
includes most extra features available in the source, plus the  
Spatialite extension.  Though it's made for building other  
applications with Sqlite support, the sqlite program is included (for  
use in Terminal.app).

On Mar 3, 2009, at 9:48 AM, Dan M. Wall wrote:

>
> I am an experienced Windows user and application developer.  I am  
> now attempting to actually use a Mac!!  God forbid!!
>
> I have an SQLite database and I'm trying to figure out how to  
> install SQLite so I can view it and update it.  I downloaded the bin  
> files but I'm obviously missing something.
>
> Please forgive my Mac OSX ignorance!  Any help you can provide would  
> be greatly appreciated!
>
> Dan
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-
William Kyngesburye 
http://www.kyngchaos.com/

"I ache, therefore I am.  Or in my case - I am, therefore I ache."

- Marvin


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

Re: [sqlite] Installing SQLite

[Nikolas Stevenson-Molnar]

Mac OS X also comes with SQLite; just open up the Terminal app and  
perform: sqlite3 

_Nik

On Mar 3, 2009, at 7:50 AM, P Kishor wrote:

> On Tue, Mar 3, 2009 at 9:48 AM, Dan M. Wall   
> wrote:
>>
>> I am an experienced Windows user and application developer.  I am  
>> now attempting to actually use a Mac!!  God forbid!!
>
> Welcome to sanity. Don't worry, you will get used to it.
>
>>
>> I have an SQLite database and I'm trying to figure out how to  
>> install SQLite so I can view it and update it.  I downloaded the  
>> bin files but I'm obviously missing something.
>
> step 1. Download the source.
> step 2. type /.configure followed by make && make install
> step 3. there is no step 3.
>
>
>>
>> Please forgive my Mac OSX ignorance!  Any help you can provide  
>> would be greatly appreciated!
>>
>> Dan
>>
>
>
>
>
> -- 
> Puneet Kishor http://www.punkish.org/
> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
> Carbon Model http://carbonmodel.org/
> Open Source Geospatial Foundation http://www.osgeo.org/
> Sent from: Madison WI United States.
> ___
> 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] Installing SQLite

[Jay A. Kreibich]

On Tue, Mar 03, 2009 at 07:48:02AM -0800, Dan M. Wall scratched on the wall:
> 
> I am an experienced Windows user and application developer.  I am now
> attempting to actually use a Mac!!  God forbid!!
> 
> I have an SQLite database and I'm trying to figure out how to install
> SQLite so I can view it and update it.  I downloaded the bin files
> but I'm obviously missing something.  

  Mac OS X 10.5 already has SQLite 3.4.0 installed.  That's not exactly
  new, but if all you need to do is open a vanilla file and poke
  around, you could do OK.

  I assume you've already found /Applications/Utilities/Terminal.app,
  and are working in the command line.

  You should be able to use the installed "/usr/bin/sqlite3" shell by just
  issuing the command:

  $ sqlite3 



  If you need to install a newer version, make sure you've got the full
  Development tools installed.  You don't need the IDE for SQLite, but
  you need the compilers.

  If you download and unpack the amalgamation source, you can just
  issue the command:

  $ cc -o sqlite3 sqlite3.c shell.c

  And that will build the sqlite3 binary.  And any defines (-D), like
  SQLITE_ENABLE_FTS, that you might require:

  $ cc -DSQLITE_ENABLE_FTS -DSQLITE_ENABLE_RTREE -o sqlite3 sqlite3.c shell.c

> Please forgive my Mac OSX ignorance!  Any help you can provide would be
> greatly appreciated!

  Unless you're doing desktop stuff with XCode, developing for Mac OS X
  is really about developing for UNIX.  OS X has a more BSD flavor than
  Linux, but knowledge is generally somewhat cross-compatible.

   -j

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

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[Peter ZhaoKai]

http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
For compile on windows, Cygwin could be used, see cygwin section.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing SQLite

[P Kishor]

On Tue, Mar 3, 2009 at 9:48 AM, Dan M. Wall  wrote:
>
> I am an experienced Windows user and application developer.  I am now 
> attempting to actually use a Mac!!  God forbid!!

Welcome to sanity. Don't worry, you will get used to it.

>
> I have an SQLite database and I'm trying to figure out how to install SQLite 
> so I can view it and update it.  I downloaded the bin files but I'm obviously 
> missing something.

step 1. Download the source.
step 2. type /.configure followed by make && make install
step 3. there is no step 3.


>
> Please forgive my Mac OSX ignorance!  Any help you can provide would be 
> greatly appreciated!
>
> Dan
>




-- 
Puneet Kishor http://www.punkish.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Carbon Model http://carbonmodel.org/
Open Source Geospatial Foundation http://www.osgeo.org/
Sent from: Madison WI United States.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Installing SQLite

[Dan M. Wall]

I am an experienced Windows user and application developer.  I am now 
attempting to actually use a Mac!!  God forbid!!

I have an SQLite database and I'm trying to figure out how to install SQLite so 
I can view it and update it.  I downloaded the bin files but I'm obviously 
missing something.  

Please forgive my Mac OSX ignorance!  Any help you can provide would be greatly 
appreciated!

Dan

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

[sqlite] installing sqlite

[dime]

hi, 
I am using Eclipse 3.2.0 and  I am intrested in how to install sqlite
drivers for my eclipse. I am new at
this, so every advice would be very helpful to me.
-- 
View this message in context: 
http://www.nabble.com/installing-sqlite-tf2918531.html#a8156277
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Installing SQLite on a Shared Platform

[jpadie]

you are absolutely right on the debian version numbering, of course.

the GNU lib is 2.2.5

and brilliant idea aabout the live cd.  i'll get a copy of knoppix (debian
based i recall) and get the lib from there. 

thanks so much!
Justin

--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3659555
Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Installing SQLite on a Shared Platform

[Markus Kolb]

jpadie wrote:

> 2.  the linux servers are debian 2.4.28 (so they say).  i read that 2.4 was
> not a stable release so i am assuming they mean 2.2.x  in any event 

With Debian 2.4.28 I think of a Debian release with kernel version
2.4.28. This means it is a Debian distribution with a self-compiled
kernel. No information about Debian release.

You might get some information about Debian release with
cat /etc/debian_version
or
cat /etc/issue
but the content need not to be the truth.

> from this i would guess it would also use glibc2.2 and not 2.3 as you
> point out the debian woody (3) uses the earlier library.

The command
ldd --version
tells you the GNU libc version.

If I remember correct, phpinfo() has a line with libc version, too.

>so next thing to try is to find sqlite.so compiled with glibc.so.  i have
> no way of compiling things on my systems and googling does not reveal
> anything.   Do any of you know a source of precompiled .so files?  

Why you don't use one of those Linux Live CDs? You get libraries, you
can decompress binary packages, pick the right files and you can compile.

Re: [sqlite] Installing SQLite on a Shared Platform

[jpadie]

Thanks for the reply.  

I should have included this in my original post:

1.  1&1 won't turn on sqlite.  they say it's a security issue (which is, of
course, nonsense). I suspect it is a pricing issue as it might cause people
who would otherwise upgrade to a multiple mysql package to remain at the
cheaper level and use sqlite dbs.  

2.  the linux servers are debian 2.4.28 (so they say).  i read that 2.4 was
not a stable release so i am assuming they mean 2.2.x  in any event 

from this i would guess it would also use glibc2.2 and not 2.3 as you
point out the debian woody (3) uses the earlier library.

   so next thing to try is to find sqlite.so compiled with glibc.so.  i have
no way of compiling things on my systems and googling does not reveal
anything.   Do any of you know a source of precompiled .so files?  

Many thanks for your assistance
Justin

--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3654138
Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Installing SQLite on a Shared Platform

[Christian Smith]

On Wed, 29 Mar 2006, jpadie wrote:

>
>Hi there
>
>my host (1 and 1) have compiled php5 without sqlite.  but I have a couple of
>php applications that would benefit from SQLite (for portability).


You could raise a ticket with 1 and 1 to install sqlite.


>
>The server is a linux box and I do not have root, SSH or telnet access
>(although i have found using php i can eval and exec commands (eg. apt-get)
>outside of the document root: opens up possibilities...)


What version and distro of Linux? Do you know?


>
>I do not operate any linux boxes elsewhere so have no way of compiling and
>uploading source code.
>
>Now the issue:
>
>I am trying to find a way to "install" and use SQLite even though it is not
>compiled in to php5.  PDO and PDO_SQLite are installed.
>
>i can dl() extensions (.so) but when I try to do this with the SQLite
>extension 2.8.17 or later i get the message:
>--
>Warning: dl() [function.dl]: Unable to load dynamic library
>'/homepages/6/OCCLUDED/htdocs/pear/extensions/sqlite-2.8.17.so' -
>/lib/libc.so.6: version `GLIBC_2.3' not found


This means that sqlite-2.8.17.so is compiled against glibc 2.3, which is
included with most modern distros. Debian Woody uses glibc 2.2, as does RH
7.x and derived products (RH AS 1.x) RH 8.x was the first glibc 2.3 based
RH distribution, I believe. Not sure about the Suse distros.

It could be that:
- The Linux box it is installed on is using glibc < 2.3, in which case
  you'll have to get hold of library binaries compiled on an old distro
  with suitable glibc.
- PHP is running in a chroot environment, such that the system glibc is
  not available. The fact you can run external binaries makes this
  unlikely.


Christian


-- 
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \

[sqlite] Installing SQLite on a Shared Platform

[jpadie]

Hi there

my host (1 and 1) have compiled php5 without sqlite.  but I have a couple of
php applications that would benefit from SQLite (for portability).  

The server is a linux box and I do not have root, SSH or telnet access
(although i have found using php i can eval and exec commands (eg. apt-get)
outside of the document root: opens up possibilities...)

I do not operate any linux boxes elsewhere so have no way of compiling and
uploading source code.

Now the issue: 

I am trying to find a way to "install" and use SQLite even though it is not
compiled in to php5.  PDO and PDO_SQLite are installed.

i can dl() extensions (.so) but when I try to do this with the SQLite
extension 2.8.17 or later i get the message:
--
Warning: dl() [function.dl]: Unable to load dynamic library
'/homepages/6/OCCLUDED/htdocs/pear/extensions/sqlite-2.8.17.so' -
/lib/libc.so.6: version `GLIBC_2.3' not found
--

I have googled for this error but not come up with anything helpful.  

If anyone has any workarounds or suggestions i'd be very grateful
thanks
Justin


--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3651203
Sent from the SQLite forum at Nabble.com.