Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Why won't sharks eat lawyers? Professional courtesy.

devel / comp.databases.ingres / Store XML file

SubjectAuthor
* Store XML filenikosv
`* Re: Store XML fileRoy Hann
 `* Re: Store XML filenikosv
  `* Re: Store XML fileRoy Hann
   `- Re: Store XML filenksvg

1
Store XML file

<15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=232&group=comp.databases.ingres#232

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:ae9:ef55:0:b0:69e:7116:8644 with SMTP id d82-20020ae9ef55000000b0069e71168644mr779021qkg.293.1650574165164;
Thu, 21 Apr 2022 13:49:25 -0700 (PDT)
X-Received: by 2002:a05:6870:d58c:b0:de:6900:6222 with SMTP id
u12-20020a056870d58c00b000de69006222mr4650981oao.179.1650574164805; Thu, 21
Apr 2022 13:49:24 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Thu, 21 Apr 2022 13:49:24 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2a02:214a:8335:3200:d9b8:f239:dcb2:ec55;
posting-account=HVjXiwoAAABbMuZJSsy6aGtjsYOerfGt
NNTP-Posting-Host: 2a02:214a:8335:3200:d9b8:f239:dcb2:ec55
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com>
Subject: Store XML file
From: nikos.va...@gmail.com (nikosv)
Injection-Date: Thu, 21 Apr 2022 20:49:25 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 0
 by: nikosv - Thu, 21 Apr 2022 20:49 UTC

I have an XML file and want to store it in a table.Which data type should I choose?

Re: Store XML file

<t3tq48$5c6$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=233&group=comp.databases.ingres#233

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: Store XML file
Date: Fri, 22 Apr 2022 08:48:08 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <t3tq48$5c6$1@gioia.aioe.org>
References: <15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="5510"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Fri, 22 Apr 2022 08:48 UTC

nikosv wrote:

> I have an XML file and want to store it in a table.Which data type
> should I choose?

Depending on the potential size of the file I'd choose VARCHAR if I
could be confident I could declare it big enough. A VARCHAR can be up to
32kb if your page size is sufficient. I'd modify the table WITH
COMPRESSION=(DATA).

If my files might be too big for an ordinary VARCHAR then I'd go for
LONG VARCHAR which has a 2Gb limit. They are not so convenient to use
though. You may end up having to deal with data handler routines and
they are harder to use in WHERE clauses.

Roy

Re: Store XML file

<922aa735-c4e5-4d83-ad1b-616de8c3f4efn@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=234&group=comp.databases.ingres#234

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:6214:dcc:b0:446:4e6e:e919 with SMTP id 12-20020a0562140dcc00b004464e6ee919mr3155358qvt.24.1650630167496;
Fri, 22 Apr 2022 05:22:47 -0700 (PDT)
X-Received: by 2002:a05:6870:55aa:b0:e1:f826:c241 with SMTP id
n42-20020a05687055aa00b000e1f826c241mr5986683oao.84.1650630167212; Fri, 22
Apr 2022 05:22:47 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Fri, 22 Apr 2022 05:22:46 -0700 (PDT)
In-Reply-To: <t3tq48$5c6$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=2a02:214a:8335:3200:c12b:5ee9:c650:a0d6;
posting-account=HVjXiwoAAABbMuZJSsy6aGtjsYOerfGt
NNTP-Posting-Host: 2a02:214a:8335:3200:c12b:5ee9:c650:a0d6
References: <15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com> <t3tq48$5c6$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <922aa735-c4e5-4d83-ad1b-616de8c3f4efn@googlegroups.com>
Subject: Re: Store XML file
From: nikos.va...@gmail.com (nikosv)
Injection-Date: Fri, 22 Apr 2022 12:22:47 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 1
 by: nikosv - Fri, 22 Apr 2022 12:22 UTC

thanks Roy.the file is less than 32K so varchar would be fine.
As a side note,why doesn't Ingres support the native XML type?

Re: Store XML file

<t3ug2v$min$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=235&group=comp.databases.ingres#235

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: Store XML file
Date: Fri, 22 Apr 2022 15:02:55 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <t3ug2v$min$1@gioia.aioe.org>
References: <15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com> <t3tq48$5c6$1@gioia.aioe.org> <922aa735-c4e5-4d83-ad1b-616de8c3f4efn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="23127"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Fri, 22 Apr 2022 15:02 UTC

nikosv wrote:

> thanks Roy.the file is less than 32K so varchar would be fine.
> As a side note,why doesn't Ingres support the native XML type?

Could you use JSON instead? Ingres has fairly extensive support for
JSON.

https://docs.actian.com/actianx/11.2/index.html#page/SQLRef/Working_with_JSON_Data.htm#

Roy

Re: Store XML file

<487595d6-8f3c-42af-aabc-4d8a9221b969n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=236&group=comp.databases.ingres#236

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a37:9ad5:0:b0:69e:8c03:7e0 with SMTP id c204-20020a379ad5000000b0069e8c0307e0mr3704416qke.747.1650658102950;
Fri, 22 Apr 2022 13:08:22 -0700 (PDT)
X-Received: by 2002:a05:6870:a70a:b0:de:15e5:b938 with SMTP id
g10-20020a056870a70a00b000de15e5b938mr2784400oam.166.1650658102669; Fri, 22
Apr 2022 13:08:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Fri, 22 Apr 2022 13:08:22 -0700 (PDT)
In-Reply-To: <t3ug2v$min$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=2a02:214a:831b:e500:60c7:5180:4aa1:f96a;
posting-account=ZlDTmgoAAACMmgI_Psevgo4eFGLKaUXR
NNTP-Posting-Host: 2a02:214a:831b:e500:60c7:5180:4aa1:f96a
References: <15c58516-3266-4522-ad69-0565674722d7n@googlegroups.com>
<t3tq48$5c6$1@gioia.aioe.org> <922aa735-c4e5-4d83-ad1b-616de8c3f4efn@googlegroups.com>
<t3ug2v$min$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <487595d6-8f3c-42af-aabc-4d8a9221b969n@googlegroups.com>
Subject: Re: Store XML file
From: nks...@gmail.com (nksvg)
Injection-Date: Fri, 22 Apr 2022 20:08:22 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 1
 by: nksvg - Fri, 22 Apr 2022 20:08 UTC

that would be ideal but the file is coming from a SOAP based web service
so I'm stuck with XML

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor