Any Postgress & MySQL experts in the house?

[Vargster <vargster@xxxxxxxxx>]

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/