Re: Simple relational database program to replace Access

Sally Thompson <sallynewsgroup@xxxxxxxxxxx> writes:
> On Tue, 31 Jan 2006 13:53:20 +0000, Doc O'Leary wrote

> > I didn't see anyone else mention it, but Tiger comes with SQLite. No
> > GUI to speak of, but an excellent no-fuss SQL database.
>
> I'll look at that. At present I'm reeling under the load of a steep
> learning curve on new software!

man sqlite3

Pretty good docs.

To clarify just a little bit, SQLite is a small C library
which implements the SQL database engine. You can link it
into your applications if you're writing software.

sqlite3 is a simple command line access program which lets you
use the sqlite library from your command line (or from a
script - ie. shell script, perl, probably even AppleScript,
though I don't know anything about the last).

There are also drivers/wrappers for SQLite which give one
access from higher level languages without having to pipe
commands in and out of sqlite3.

I don't think there's much in the way of point-and-click,
but given the simple command line interface, as well as,
say, the Perl or Python or PHP or Java wrappers, one
could crank data into a SQLite DB pretty quickly.



--
Plain Bread alone for e-mail, thanks. The rest gets trashed.
No HTML in E-Mail! -- http://www.expita.com/nomime.html
Are you posting responses that are easy for others to follow?
http://www.greenend.org.uk/rjk/2000/06/14/quoting
.

Relevant Pages

  • Re: SQLite and VB6 - Documentation?
    ... still very foggy as to where SQLite starts and the wrapper ends. ... SQLite command or wrapper command? ... which is only there for regfree instancing. ...
    (microsoft.public.vb.database)
  • Re: Browser History
    ... Anyway, in my browser history I inadvertently cleared some entries that I really needed, was some sites I had been looking for and didn't take the time to write down. ... If you look in your Firefox profile, you'll find a file like "places.sqlite". ... SQLite is a database. ... In a command prompt window, while you've changed directory to the folder ...
    (microsoft.public.windowsxp.general)
  • SQLite3__Python2.3-SQLite__Problem
    ... It seems that SQLite3 data bases created at the command line ... and those created using the sqlite module from within Python ... If I create an SQLite3 data base from the command line ...
    (comp.lang.python)
  • Re: Query in connecting thttpd and Sqlite3
    ... command line or stdin. ... SQLite, but ODBC instead, e.g. OpenOffice.org. ... I wrote a simple HTML page which asks for user ... CGI application for verifying user name and password i added in C ...
    (comp.os.linux.development.apps)
  • Re: Quotes and apostrophes assistance
    ... Since I never worked with an SQLite DB I am not sure how well this will work ... but you might want to have a look at the following command in the DBI: ... qq and a combination of both but can't get a quoting system ...
    (perl.beginners)