I think Xpath in postgresql is fast enough. I am dumping the raw xml file
into a table and then generating data from it. I want all the data to be
consistent thats why I am using a database.
I am planning to use triggers to generate content of
table1_master...table2_master, etc...
master -> table
On Saturday, January 28, 2017, Rita wrote:
> After xmltest has been populated, I can run xpath and unest to get my data
> into a row but I would like to store that result in another table, I am
> guessing I should look into triggers for something like that?
>
I suspect that using xpath in the da
I want to over write the data because I don't need to keep its history.
Yes, the 5-6 table will be the subset of the data. The subset of the data
will all come from xpath. I don't want to keep doing an xpath query when a
client requests the data.
On Sun, Jan 29, 2017 at 5:42 PM, Adrian Klaver
On 01/28/2017 05:57 PM, Rita wrote:
sorry for the late reply.
My table schema is very simple
DROP TABLE xmltest;
create table xmltest(
id serial,-- dont really need the serial
Maybe not a serial id, but a Primary Key of some sort would help with
what you say you want to do b
sorry for the late reply.
My table schema is very simple
DROP TABLE xmltest;
create table xmltest(
id serial,-- dont really need the serial
data xml
NOT null
);
INSERT INTO xmltest (data, id) VALUES (
On Thu, Jan 26, 2017 at 5:37 AM, Rita wrote:
> of course, sorry for being vague.
>
> I have an external process generating a XML file (every 30 secs) which is
> about 10MB. I would like to store the file as XML type for me to query
> using xpath. I plan to query it every few seconds by few hundre
On 01/26/2017 04:37 AM, Rita wrote:
of course, sorry for being vague.
I have an external process generating a XML file (every 30 secs) which
is about 10MB. I would like to store the file as XML type for me to
query using xpath. I plan to query it every few seconds by few hundred
clients. so, it
On 01/26/2017 04:37 AM, Rita wrote:
of course, sorry for being vague.
I have an external process generating a XML file (every 30 secs) which
is about 10MB. I would like to store the file as XML type for me to
Does this mean you are using this:
https://www.postgresql.org/docs/9.6/static/dataty
of course, sorry for being vague.
I have an external process generating a XML file (every 30 secs) which is
about 10MB. I would like to store the file as XML type for me to query
using xpath. I plan to query it every few seconds by few hundred clients.
so, it maybe easier for me create a separate
On 01/26/2017 09:08 AM, Rita wrote:
Is it possible to use hstore to store xml document?
I would like to have
"status" => "..."::xml
Keys/values in hstore are simply text strings, so you can store anything
you want formatted as a string.
Not sure if that's what you're looking for though, y
Is it possible to use hstore to store xml document?
I would like to have
"status" => "..."::xml
--
--- Get your facts first, then you can distort them as you please.--
11 matches
Mail list logo
