> 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
> "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
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
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"
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:
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" <
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
> "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
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
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
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
11 matches
Mail list logo