Initially I invested in "Using SQLite" by Jay A. Kreibich (O'Reilly) and it
got me started, but I must admit that I've probably only read a 3rd of the
book. Instead my daily SQL bible is http://www.sqlite.org/docs.html, which
is the official and ultimate information on SQLite as far as I'm aware. As
for ooSQLite the current documentation contains enough information to get
started with ooSQLite, no doubt. And where that has failed this user list
has proved invaluable with first class support from Mark and others.
Staffan
On Sat, Nov 24, 2012 at 5:59 AM, Mark Miesfeld <miesf...@gmail.com> wrote:
>
>
> 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
>
>
------------------------------------------------------------------------------
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
