Hi,
Given this kind of sensors (Internet-of-Things) log and monitoring scenario:
* There are 3 production machines monitored every few seconds for
forthcoming (~2) years.
* Machine m1 is emitting 20 boolean and 20 float4 captured in sensors
(m1s1..m1s40).
* Machine m2 has same attributes as m1 pl
) inherits (m);
--create table m1 ( ... ) inherits (m);
/* end */
2017-12-09 23:01 GMT+01:00 Steven Lembark :
> On Sat, 9 Dec 2017 20:22:02 +0100
> Stefan Keller wrote:
>
>> create table m1 (
>> id bigint,
>> created timestamp,
>> b20 bi
Hi,
2017-12-10 2:53 GMT+01:00 John R Pierce :
> I believe I would use boolean, not bit.
Agreed.
2017-12-10 10:01 GMT+01:00 Thomas Kellerer :
> Did you try to use a (single) hstore or jsonb column instead where the
> attribute name is the key?
Thought about that and I'm using hstore extensively
Hi Paul
Paul Förster wrote:
> Also, I like the idea of global container/cluster-wide views such as
> CDB_TABLES, etc.,
> a thing which I definitely and seriously miss about PostgreSQL.
Can you specify little more: What's the use case for this (assuming
you know dblink and postgres_fdw)?
:Stefa
Hi,
I'd like to write a function like this:
create function foo(_host text, _port text, _dbname text)
returns void as $$
create server _server
foreign data wrapper postgres_fdw
options (host _host, port _port, dbname _dbname);
-- ERROR: syntax error at or near "_host"
$$ language sq
me %L)', _server, _host, _port, _dbname);
end;
$$ language plpgsql;
select link_server('other_db_server', '111.11.11.11', '5432', 'other_db');
But I actually hoped being able avoid "execute"...
:Stefan
Am Di., 29. Jan. 2019 um 16:21 Uhr schrieb
Hi,
Anyone aware and following this standardization activities?
Forthcoming SQL:2020 seems to contain "Property Graph Query Extensions".
See:
* GQL: a standard for property graph querying
https://www.gqlstandards.org/
* Property Graph Query Language (PGQL), an SQL-like query language for
graphs, i
Dear all
What about following „Rapid App Development Tools"?
* OpenXava (Java): https://www.openxava.org/ate/visual-studio-lightswitch
* Radzen (.NET): https://www.radzen.com/visual-studio-lightswitch-alternative/
* Other: https://aurelia.io/ (JS) or CUBA https://www.cuba-platform.com/ (Java)
:St
