Re: [sqlite] I'm Starving for New User Information

[John Stanton]

km4hr wrote:

Is there a sqlite introduction for programmers wanting to use the sqlite C
API? The info on the web site is pretty sparse. There seems to be plenty of
info regarding the use of sqlite3 all over the web.  But not much on getting
set up to write programs that use sqlite. 


I have some specific questions below. I am a C programmer and I want use
sqlite in my programs.

First question is about installation. I went to the sqlite download page and
got a ".so" file. This is obviously a shared library but I can't find any
installation document that confirms this. What do I do with the ".so" file?
I guess I need to put it somewhere, but where? I'm using Fedora Core4 at the
moment but what if I also want to use sqlite on RedHat 4? I'd eventually
like to use sqlite on HPUX 11.0 but I'll be happy for the moment to get
myself oriented on Linux.

Are there any link instructions? How do I link a C program on Fedora Core4
Linux for example?
"gcc  myprog.c  -o myprog  sqlite.so"?  Do I need to set a library path
environment variable to point to where the ".so" file is located? Or what?

Is a C program that uses sqlite statically linked? That is, is the final
executable a self contained program that can be moved from one computer to
similar computer? Or does it require supporting sqlite files/libraries to be
installed on each computer where the program is run? Can I just copy a
program that uses the C API to a similar computer and run it? I assume I
would at least have to copy some sqlite data file as well. No?

Once I've created a C program that uses sqlite can I administer its database
with sqlite3 or do I have to write utility programs to create a database,
tables, view table contents, etc?

I'd really like to understand how sqlite works. Not internally, but things
like where is the data stored? What does it mean to "install" sqlite? If I
run a C program in separate directories where does the data get stored? In a
common file somewhere? Or does each program have its own sqlite data file?  


On the sqlite web site there's a brief 5 minute getting started explanation.
It explains how to get going using sqlite3.  But where do I go after that
for more detailed understanding? 


How do you backup sqlite data? Just copy a data file? Or do you use sqlite3
to dump a file of sql statements?

The architecture is unclear to me. I'm hungry to learn more. Is there a
summary document somewhere? I'm finding plenty of tutorials on how to use
sqlite3, the command line interface. But is there anything that explains the
basic architecture? Installation? administration?

The sqlite C API documentation seems pretty clear. I can even find helpful
documents on the web. I just can't find anything describing how to install
and administer sqlite or basically how it works.

thanks





Just load the source, run configure, make and make install

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

Re: [sqlite] I'm Starving for New User Information

[A.J.Millan]

Of course there are may questions in your's post, but believe me, I
understand You because some months ago, and steel now, I feel exactly as
You.  IMHO that is the matter pending in the SQLite proyect, although I
suppose that it is not a Hipp fault (who has done much more that enough for
all us), but for the lack of volunteers.

Actually there are NOT that information that You need, alt least together.
Although in the past I've write against it, now I can suggest the less bad
alternative:  a book of Michael Owens, "The Definitive Guide to SQLite"
Apress.  I feel that in your's case it worth its price.

A.J.Millan
ZATOR Systems.


- Original Message - 
From: "km4hr" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 07, 2007 2:59 AM
Subject: [sqlite] I'm Starving for New User Information


>
> Is there a sqlite introduction for programmers wanting to use the sqlite C
> API? The info on the web site is pretty sparse. There seems to be plenty
of
> info regarding the use of sqlite3 all over the web.  But not much on
getting
> set up to write programs that use sqlite.
>
> I have some specific questions below. I am a C programmer and I want use
> sqlite in my programs.


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

Re: [sqlite] I'm Starving for New User Information

[C.Peachment]

You ask too many questions in one go. I will be surprised if anyone
is willing to provide that much assistance all at once.

It appears that you need some more fundamental knowledge about
programming on GNU/Linux and maybe even about programming in C.

Some of your questions are contradictory and suggest you have not
done your own homework before asking others to do it for you.

e.g.
got a ".so" file. This is obviously a shared library ...

and

Is a C program that uses sqlite statically linked?

You ask:
>Once I've created a C program that uses sqlite can I administer its database
>with sqlite3 or do I have to write utility programs to create a database,
>tables, view table contents, etc?

Why not try it and see for yourself?

Others have done so and not all of them are smarter than you :-)





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