The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

Any Postgress & MySQL experts in the house?


  • Subject: Any Postgress & MySQL experts in the house?
  • From: Vargster <vargster@xxxxxxxxx>
  • Date: Tue, 1 Mar 2011 23:42:25 +0000

I've recently installed a solar PV system. The inverter in the system,
a SMA
SB 3800 is fitted with an RS485 interface to read data out of it.
So to my problem, the only sensible code I've found to read data uses
Postgress to store the data.
Not a major issue, but my main server is already underpowered enough and
already runs MySQL, so I don't really want to install/run Postgress on it.
This leaves me with having to convert a script to create the Postgress DB
to
MySQL, but my MySQL is poor and my Postgress is non-existent, as I've never
used it before.

Anybody out there care to look this over?

Cheers,
Lee

--
-- PostgreSQL database dump
--
SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres

--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;

SET SESSION AUTHORIZATION 'sma';
SET search_path = public, pg_catalog;

--
-- TOC entry 4 (OID 8562513)

-- Name: comments; Type: TABLE; Schema: public; Owner: sma
--
CREATE TABLE comments (
stamp timestamp without time zone DEFAULT
('now'::text)::timestamp(6) with time zone,
addr integer,
"comment" text

);

--
-- TOC entry 5 (OID 13542410)
-- Name: stats; Type: TABLE; Schema: public; Owner: sma
--
CREATE TABLE stats (
stamp timestamp without time zone DEFAULT
('now'::text)::timestamp(6) with time zone,

addr integer,
"E-Total" double precision,
"h-Total" double precision,
"Pac" double precision,
"Vac" double precision,
"Fac" double precision,

"Ipv" double precision,
"Vpv" double precision,
"Temperature" double precision
);

--
-- TOC entry 6 (OID 13565009)
-- Name: stats_oid; Type: INDEX; Schema: public; Owner: sma

--
CREATE INDEX stats_oid ON stats USING btree (oid);

--
-- TOC entry 7 (OID 13565011)
-- Name: stats_stamp; Type: INDEX; Schema: public; Owner: sma
--
CREATE INDEX stats_stamp ON stats USING btree (stamp);

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 2 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--
COMMENT ON SCHEMA public IS 'Standard public schema';


[Non-text portions of this message have been removed]



------------------------------------

<*> Join the Automated Home Forums
http://www.automatedhome.co.uk/vbulletin/


UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.