The "virtual table playground gadget" was our primary reason for selecting
SQLite in the first place, because none of our production data sources are
native SQLite tables. Instead, we have about 20 virtual table modules that
implement about 1000 virtual table instances.
-Ursprüngliche
>What about if I want 1 hour granity? (to plot a graph of daily consumption for
>example)
For a (meaningful, as opposed to "all interpolated values") granularity of 1
hour, information theory states that you need a sample every 30 minutes or less.
The desire to charge consumers more for "peak
Hello,
I can't figure out why PHP isn't happy with the following query:
==
prepare('INSERT INTO mytable (date, home_id, mode_id) VALUES
(?, ?, ?)');
$query->execute(array($today,$home, $mode));
//CREATE TABLE mode (mode_id INTEGER, mode_txt TEXT);
//SELECT OK
//$query =
Zakrzewski, Jakub wrote
> It's because `execute()` returns a boolean (as stated in the manual
> https://www.php.net/manual/en/pdostatement.execute.php ). `fetch()` must
> be called on `$query`
Thanks much!
=
$query = $dbh->prepare("SELECT mode_txt FROM mode WHERE mode_id=? LIMIT 1");
On Monday, 21 October, 2019 00:49, Hick Gunter wrote:
>The desire to charge consumers more for "peak power" (just like utilities
>have to pay more for "peak power" and less for "base load") is the
>driving force behind the installation of "smart meters".
This is the propaganda behind "smart
It's because `execute()` returns a boolean (as stated in the manual
https://www.php.net/manual/en/pdostatement.execute.php ).
`fetch()` must be called on `$query`
From: sqlite-users on behalf of
Winfried
Sent: 21 October 2019 11:47
To:
>
> For a (meaningful, as opposed to "all interpolated values") granularity of
> 1 hour, information theory states that you need a sample every 30 minutes
> or less.
>
> The desire to charge consumers more for "peak power" (just like utilities
> have to pay more for "peak power" and less for "base
Hello,
Before I dive into https://www.sqlitetutorial.net, I'd like to check with
experienced users whether SQLite is up to the task, or I should maybe run
multiple queries possibly with some help from PHP.
Using the following tables, I need to find how employees from each city come
to work.
> Not a clue. I didn't write the schema.
I know, I asked the OP.
RBS
On Mon, Oct 21, 2019 at 4:16 PM Keith Medcalf wrote:
>
> On Monday, 21 October, 2019 08:47, Bart Smissaert <
> bart.smissa...@gmail.com> wrote:
>
> >Shouldn't there be field MODE_ID in the Employee table?
>
> Not a clue. I
On 10/21/19, Jonathan Brandmeyer wrote:
> Or, how many times is each page written by SQLite for an insert-heavy
> test? The answer appears to be "4", but I can only account for two of
> those four.
Are you measuring writes at the OS-interface layer, or writes at the
hardware layer? SQLite
Hello,
compiling the latest stable version 3300100 using VS2019 on Windows and ICC
2019 Update 5 gives this warning:
1>-- Rebuild All started: Project: SQLite DLL, Configuration: Release x64
--
1>sqlite3.c
1>C:\Dropbox\Boo\Shares\Code\SQLite\SQLite DLL\sqlite3.c(154619): message #111:
Or, how many times is each page written by SQLite for an insert-heavy
test? The answer appears to be "4", but I can only account for two of
those four.
I'm working on an embedded system that uses a log-structured
filesystem on raw NAND flash. This is not your typical workstation's
managed flash
Shouldn't there be field MODE_ID in the Employee table?
RBS
On Mon, Oct 21, 2019 at 3:44 PM Keith Medcalf wrote:
>
> On Monday, 21 October, 2019 08:31, Winfried wrote:
>
> >Using the following tables, I need to find how employees from each city
> >come to work.
>
> >== Employees table:
>
On Monday, 21 October, 2019 08:47, Bart Smissaert
wrote:
>Shouldn't there be field MODE_ID in the Employee table?
Not a clue. I didn't write the schema. Perhaps there is another table called
MODATES that has a link to the employee (EMPLOYEE_ID) and a link to the mode
(MODE_ID) together
On Monday, 21 October, 2019 08:31, Winfried wrote:
>Using the following tables, I need to find how employees from each city
>come to work.
>== Employees table:
>EMPLOYEE_ID | CITY_ID
>Cities table:
>CITY_ID | CITY_TXT
>Mode table:
>MODE_ID | MODE_TXT
>
>This is the type of output I need to
> Shouldn't there be field MODE_ID in the Employee table?
>
It looks like a high school homework to me :D
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hello,
I would appreciate any help in finding why I get an error when saving back
to a database.
I am using vb.net in VS-2019 with sqlite.
The error is: "Concurrency violation: the UpdateCommand affected 0 of the
expected 1 records."
I have worked out that the error only occurs
On 10/20/19 11:03 PM, Rowan Worth wrote:
> On Sun, 20 Oct 2019 at 17:04, Simon Slavin wrote:
>
>> Another common request is full support for Unicode (searching, sorting,
>> length()). But even just the tables required to identify character
>> boundaries are huge.
>>
> Nitpick: there are no
On 10/21/19, Jonathan Brandmeyer wrote:
>
> No significant change. The target filesystem only caches non-aligned
> writes, so there usually isn't anything for it to do on fsync anyway.
>
OK. I don't have any more ideas at the moment, and without access to
your code, and your platform, I can't
On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
>
> On 10/21/19, Jonathan Brandmeyer wrote:
> > Or, how many times is each page written by SQLite for an insert-heavy
> > test? The answer appears to be "4", but I can only account for two of
> > those four.
>
> Are you measuring writes at
On 10/21/19, Jonathan Brandmeyer wrote:
> On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
>>
>> On 10/21/19, Jonathan Brandmeyer wrote:
>> > Or, how many times is each page written by SQLite for an insert-heavy
>> > test? The answer appears to be "4", but I can only account for two of
>>
On Mon, Oct 21, 2019 at 5:00 PM Richard Hipp wrote:
>
> On 10/21/19, Jonathan Brandmeyer wrote:
> > On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
> >>
> >> On 10/21/19, Jonathan Brandmeyer wrote:
> >> > Or, how many times is each page written by SQLite for an insert-heavy
> >> > test?
22 matches
Mail list logo