[sqlite] Sqlite subqueries

2015-02-25 Thread russ lyttle
On 02/25/2015 10:31 AM, Rob Richardson wrote: > A Google search for "USS Yorktown" turned up the following: > > "On September 21, 1997, a division by zero error on board the USS Yorktown > (CG-48) Remote Data Base Manager brought down all the machines on the > network, causing the ship's

[sqlite] Sqlite subqueries

2015-02-25 Thread russ lyttle
On 02/25/2015 09:40 AM, Igor Tandetnik wrote: > On 2/25/2015 9:16 AM, russ lyttle wrote: >> To eliminate the need to reference a table would require combining 300 >> tables into one table. > > Yes. > >> A user editing entries for one space could crash >> th

[sqlite] Sqlite subqueries

2015-02-25 Thread russ lyttle
On 02/24/2015 08:53 PM, Igor Tandetnik wrote: > On 2/24/2015 8:42 PM, russ lyttle wrote: >> The 'a' table defines spaces to be controlled, the 'b' tables the >> control schedules and parameters. >> It would not be unreasonable to assume the 'a' table has >100 rows. >

[sqlite] Sqlite subqueries

2015-02-24 Thread russ lyttle
what you would like to do in a system/setup like this > will help - surely someone here have done some similar thing before and > they are always glad to assist. > > > On 2015-02-24 11:37 PM, russ lyttle wrote: >> I got the "Using SQLite" book and didn't find the answer there, or i

[sqlite] Sqlite subqueries

2015-02-24 Thread russ lyttle
I got the "Using SQLite" book and didn't find the answer there, or in a Google, DuckDuckGo, or Gigiblast search. I'm trying to create a field in a table to hold the name of a second table, then retrieve that name for use. The code below is the simplest of all the things I've tried. Can anyone say

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-22 Thread russ lyttle
On 02/22/2015 02:08 PM, Eduardo Morras wrote: > On Sun, 22 Feb 2015 13:10:25 -0500 > russ lyttle wrote: > >> Contiki-os sounds interesting, especially if it can be adapted to run >> sqlite3 on an Arduino UNO or MEGA (with attached SD card). Has anyone >

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-22 Thread russ lyttle
On 02/22/2015 02:06 PM, Roger Binns wrote: > On 02/22/2015 10:10 AM, russ lyttle wrote: >> The "natural" language for the Raspberry PI is Python. For Arduino >> it is C++. I've confirmed that both PERL and Python drop too many >> messages when using my naif DB with

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-22 Thread russ lyttle
On 02/22/2015 01:22 PM, Simon Slavin wrote: > > On 22 Feb 2015, at 6:10pm, russ lyttle wrote: > >> The "natural" language for the Raspberry PI is Python. For Arduino it is >> C++. > > Arduinos are programmed in 'Wiring' which is descended from 'Processing',

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-22 Thread russ lyttle
p too many messages when using my naif DB with sqlite3, R-PI model A, and Digi xbee s2 radios. On 02/22/2015 05:26 AM, Eduardo Morras wrote: > On Sat, 21 Feb 2015 23:04:53 -0500 > russ lyttle wrote: > >> Thanks. >> I doing building automation using Raspberry Pi, Arduino, a

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
]http://www.w3schools.com/sql/ > [2]https://www.sqlite.org/quickstart.html > > On Sat, Feb 21, 2015 at 7:33 PM, russ lyttle wrote: >> I'm new to sqlite and not that experienced with SQL in general. Are >> there any good sqlite tutorials or references better than the first few >

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
If so, check the website "sqlite in 5 minutes >> or less"[2]. >> >> [1]http://www.w3schools.com/sql/ >> [2]https://www.sqlite.org/quickstart.html >> >> On Sat, Feb 21, 2015 at 7:33 PM, russ lyttle wrote: >>> I'm new to sqlite and not that experien

[sqlite] Reference material for SQLITE3

2015-02-21 Thread russ lyttle
I'm new to sqlite and would like some intermediate to advanced tutorial and reference material. Google didn't return much useful beyond elementary level. -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473

[sqlite] sqlite tutorials and reference manuals?

2015-02-21 Thread russ lyttle
I'm new to sqlite. Can anyone recommend online or hardcopy tutorials and reference manuals for sqlite? Google search hasn't returned much useful. -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc:

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
I'm new to sqlite and not that experienced with SQL in general. Are there any good sqlite tutorials or references better than the first few pages returned by a google search? I have reference and tutorial books for MySql. -- next part -- A non-text attachment was