Storing HTML in Postgres

Luperci · Feb 1, 2008

Does any one know of a good way to store a html document in Postgres? It’s a simple page with two pictures. I’m trying to figure out if it’s worth it or just take a picture of the page and store that. Any thoughts?

Here’s the code to the page:
<html>
<head>
<title>BioCalculator Result</title>
</head>
<body>
<div align='center'>
C:\Documents and Settings\Victor\Desktop\HPV\HPV test #3-A-04
</div>
<div align='center'>
<img align='middle' src='HPV test #3-A-04.jpg' width='600' height='300'>
</div>
<div align='center'>
<img align='middle' src='HPV test #3-A-04Gel.jpg' width='600' height='50'>
</div> 
<table border='1' align='center'>
<tr>
<td>nr</td>
<td>name</td>
<td>time</td>
<td>reltime</td>
<td>start</td>
<td>stop</td>
<td>height</td>
<td>height%</td>
<td>na</td>
<td>na%</td>
<td>R</td>
<td>size (bp)</td>
<td>conc (ng/ul)</td>
</tr>
<tr>
<td>1</td>
<td></td>
<td>3.545</td>
<td>0.0000</td>
<td>3.512</td>
<td>3.569</td>
<td>0.9577</td>
<td>0.00</td>
<td>0.000E+000</td>
<td>0.00</td>
<td>0.000</td>
<td>0.0</td>
<td>0.00</td>
</tr>
<tr>
<td>2</td>
<td></td>
<td>3.807</td>
<td>0.0505</td>
<td>3.729</td>
<td>3.863</td>
<td>0.1484</td>
<td>11.81</td>
<td>1.385E-003</td>
<td>18.56</td>
<td>22.031</td>
<td>46.2</td>
<td>0.00</td>
</tr>
<tr>
<td>3</td>
<td></td>
<td>6.599</td>
<td>0.5896</td>
<td>6.529</td>
<td>6.708</td>
<td>1.1079</td>
<td>88.19</td>
<td>6.080E-003</td>
<td>81.44</td>
<td>14.932</td>
<td>409.9</td>
<td>0.00</td>
</tr>
<tr>
<td>4</td>
<td></td>
<td>8.724</td>
<td>1.0000</td>
<td>8.691</td>
<td>8.877</td>
<td>1.0446</td>
<td>0.00</td>
<td>0.000E+000</td>
<td>0.00</td>
<td>0.000</td>
<td>0.0</td>
<td>0.00</td>
</tr>
<tr>
<td>5</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>100.00</td>
<td>7.466E-003</td>
<td>100.00</td>
<td></td>
<td>456.1</td>
<td>0.00</td>
</tr>
</table>
</body>
</html>

Log in or Sign up to hide all adverts.

Stryder · Feb 1, 2008

This might not be of use to you but I'll mention it anyway.

Once upon a time I had a MySQL server rigged up on a server that I could directly access, you can pretty much rig up a server yourself with little problem either by installing it on a Linux server or just running a Binary on the machine you are working on.

I used OpenOffice to have a number of spreadsheets for dealing with some commodity trading in the EVE-Online game, to be able to identify the prices of things to my corporation at the time, I used the inbuilt method of OpenOffice to update the Tables that existed in the MySQL database.

Quite simply if you have a database available for use, you can actually populate and update (append) via the use of OpenOffice, which was very handy at the time. It would take some messing around for a person to get use to it and obviously some Web service providers don't allow direct access to databases making it impossible to use OpenOffice to update the database. (This is where webpages for parsing data have to be used)

For the most part if you are only dealing with limited amounts of data you don't need to even use a database but use something like a Comma seperated values (.cvs) However it's really down to the size of the data you are trying to store and the number of accesses you are looking at (and whether there administrative access for altering the data too).

Log in or Sign up to hide all adverts.

RubiksMaster · Feb 1, 2008

I don't know much about Postgres specifically, because I use MySQL. With that disclaimer...

In database systems, the data type you are looking for is called a CLOB (character large object). I've heard tell that Postgres doesn't have good (if any) CLOB support though. But, I'm sure you could just store the flat file in a BLOB (binary large object), because if I'm not mistaken, it does handle BLOBs decently.

Log in or Sign up to hide all adverts.

Luperci · Feb 4, 2008

Thanks, Rubiks I'll try that.

Quantic · Feb 6, 2008

Luperci, I agree with RubiksMaster. BLOBs are probably best; I've stored JPEG images that way and if you're using Perl, I can show you code that puts the data in the database and gets it out again.

Luperci · Feb 6, 2008

Using BLOBs was the way to go. And Quantic thanks for the offer on the Perl code. I've been looking for a good forum to discuss coding questions. Are there many programmers on this site, or is it mainly gammers?

Quantic · Feb 6, 2008

I don't know what the demographics of this site are. There seem to be a wide variety of people here that post messages. I would be lumped among the programmers and science enthusiasts...

RubiksMaster · Feb 7, 2008

Luperci said:

Are there many programmers on this site, or is it mainly gammers?
Click to expand...

There are a fair number of programmers here with ranging levels of experience. Maybe not as many as an actual programming forum, but there's several people I can think of off the top of my head that know a fair deal.

I like to think I'm decent. I do it for my job. If you want to discuss coding, feel free to make a thread. I actually wish there were more programming discussions on here.

Log in or Sign up

Storing HTML in Postgres

Luperci Registered Member

Google AdSense Guest Advertisement

Stryder Keeper of "good" ideas. Valued Senior Member

Google AdSense Guest Advertisement

RubiksMaster Real eyes realize real lies Registered Senior Member

Google AdSense Guest Advertisement

Luperci Registered Member

Quantic Registered Member

Luperci Registered Member

Quantic Registered Member

RubiksMaster Real eyes realize real lies Registered Senior Member

Share This Page

Log in or Sign up

Storing HTML in Postgres

Luperci Registered Member

Google AdSense Guest Advertisement

Stryder Keeper of "good" ideas. Valued Senior Member

Google AdSense Guest Advertisement

RubiksMaster Real eyes realize real lies Registered Senior Member

Google AdSense Guest Advertisement

Luperci Registered Member

Quantic Registered Member

Luperci Registered Member

Quantic Registered Member

RubiksMaster Real eyes realize real lies Registered Senior Member

Share This Page

Useful Searches