On Fri, Nov 23, 2012 at 8:11 PM, Art Heimsoth <artst...@artheimsoth.com>wrote:
> For a newbie on SQL, is there a "getting started" book that you or someone
> would recommend?
>
Hi Art,
I don't have a good recommendation, maybe someone else will chime in.
I don't know SQL very well and have very little database experience. I
used "The Definitve Guide to SQLite" Second Edition bye Grant Allen and
Mike Owens. It is published by Apress.
It was enough to get me started. Depending on your financial status, it
may or many not seem a little pricey.
I thought it had good sections on the basics of SQL and SQLite itself. The
book tries to cover a lot of different areas so it has sections on areas
that probably won't be pertinent to what you want to do.
I don't have any other book to compare it to, so I can't say if it is
better or worse than others. I'm sure it would help you get started, but
there may be some other book that would do just as good a job for less
money, or some other book that would do a better job at the same price.
> I have looked at the ooSQLite and the SQLite documentation
> and the examples, but think I need something more basic on how to connect
> to
> the database,
>
In ooSQLite connecting to a database is as simple as instantiating a new
ooSQLiteConn object using the file name of the database.
> how to add/insert data into the database, etc. and what error codes
> can be returned and what they mean.
>
Adding and inserting data basically uses SQL statements. Probably any SQL
reference could help you just get started there.
ooSQLite comes with an executable that is a command line interface. It is
really just the sqlite3 command line interface built and distributed with
ooSQLite so that it is easy to access.
The book I mentioned above starts you out by doing some exercises using the
cli (command line interface) and that is sort of what opened up my eyes to
how things work. The book uses a database for the examples and I got
written permission from Apress to distribute that database with ooSQLite.
So, with an install of ooSQLite you would have what you need to work
through the exercises in the book.
There are a couple of other people that are using ooSQLite that read this
list. If you have specific questions, I'm sure you can get a little help
here.
--
Mark Miesfeld
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
