Re: [PLUG] Raspbian sqlite project...

2017-03-21 Thread Michael Christopher Robinson
> Why don't you make the (sensor,timestamp) combination the primary key > instead? > Makes sense, how do I set the combination (sensor,timestamp) as the primary key in C code? Note that I'm using sqlite3.h. ___ PLUG mailing list PLUG@lists.pdxlinux.org

Re: [PLUG] Raspbian sqlite project...

2017-03-21 Thread Russell Senior
> "Michael" == Michael Christopher Robinson > writes: Michael> I'm wondering how to count the number of rows in the database Michael> I'm creating from a C program. The database has a row number Michael> or Id that is the primary key. I need to know how many

Re: [PLUG] Multiple hard drive types in SAS raids.

2017-03-21 Thread Tom
Here is how I look at this... There are couple of potential issues with mixing different disks and speeds - 1. reliability 2. economy 1. Reliability - The level of risk depends mainly on whether you are using software or hardware RAID. There is no additional risk for software RAID as long as the

Re: [PLUG] Raspbian sqlite project...

2017-03-21 Thread Michael Christopher Robinson
On Tue, 2017-03-21 at 21:18 -0700, Jonas Augusto wrote: > Once you have the command line client running you can count the rows > from a > table with this query: > > SELECT Count(*) FROM tblName > > Please change the table name at the end (tblName) > > On 21 Mar 2017 21:14, "Jonas Augusto"

Re: [PLUG] Raspbian sqlite project...

2017-03-21 Thread Jonas Augusto
Once you have the command line client running you can count the rows from a table with this query: SELECT Count(*) FROM tblName Please change the table name at the end (tblName) On 21 Mar 2017 21:14, "Jonas Augusto" wrote: You can use the command line client for SQLite:

Re: [PLUG] Raspbian sqlite project...

2017-03-21 Thread Jonas Augusto
You can use the command line client for SQLite: https://www.sqlite.org/cli.html Once it is connected to your database it is simple to make a SQL query. If you don't know how the query​ language works I can help you. Jonas On 21 Mar 2017 21:03, "Michael Christopher Robinson" <

[PLUG] Raspbian sqlite project...

2017-03-21 Thread Michael Christopher Robinson
I'm wondering how to count the number of rows in the database I'm creating from a C program. The database has a row number or Id that is the primary key. I need to know how many rows there are to know the next row number so I can add more temperatures to the database. I'm developing on a

Re: [PLUG] Multiple hard drive types in SAS raids.

2017-03-21 Thread Russell Senior
> "Thomas" == Thomas Groman writes: Thomas> It has become quite expensive to maintain all the same vendor Thomas> and model 15K SAS drives in large raid arrays. Thomas> Would using different vendor SAS drives in the same array cause Thomas> any

[PLUG] Multiple hard drive types in SAS raids.

2017-03-21 Thread Thomas Groman
It has become quite expensive to maintain all the same vendor and model 15K SAS drives in large raid arrays. Would using different vendor SAS drives in the same array cause any problems/performance degradation/reliability/ differences? ___ PLUG mailing

Re: [PLUG] two post racks for free

2017-03-21 Thread Thomas Groman
i might be interested. do you got any photos so i know what i'm lookin at? On 03/20/2017 09:42 PM, Randall Gray wrote: > Joe, > Are these full-height racks? Have you got anything shorter like the 12U or > 24U desk-top models? > > Thanks! > > Randall Gray > > On Mon, Mar 20, 2017 at 3:39 PM, Joe

Re: [PLUG] PLUG Advanced Topics Volunteer?

2017-03-21 Thread Michael Dexter
On 3/20/17 10:41 AM, Brian P. Martin wrote: > I heartily second JJJ's sentiment regarding Michael! Seven years at this? That can't be right. Thank you Brian! Michael ___ PLUG mailing list PLUG@lists.pdxlinux.org