Can I store HTML as XML in a Sqlite3 database?

Question

Is it possible to do this? The HTML files in question all conform to:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

EDIT: How would you store a number of HTML pages with sequential IDs associated with them in a database? (Oh, I'm new to databases).

EDIT: Now I realise there is no "xml" datatype for SQlite. I had a wrong datasource open!

Your another question missed the point of all replies that you've got to your first one. SQLite does not have an "XML data field". It has text fields, and it's up to you to interpret text inside the way you want. If you treat it as XML, then that's fine. And of course you can do anything that you can do with XML "with SQLite". — Pavel Minaev
– Pavel Minaev, Commented Aug 20, 2009 at 20:49
This is what happens when you move from Microsoft SQL Server to Sqlite. — Callum Rogers
– Callum Rogers, Commented Aug 20, 2009 at 20:52

wierob · Accepted Answer · 2009-08-20 20:53:13Z

6

Use the TEXT datatype. Sqlite doesn't care if your data is HTML or XML.

To store several HTML pages with a sequential number use a table like:

 CREATE TABLE pages
        (ID integer  AUTO_INCREMENT PRIMARY KEY,
        html TEXT
        );

edited Aug 20, 2009 at 20:53

answered Aug 20, 2009 at 20:46

wierob

4,3691 gold badge28 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thom Smith · Accepted Answer · 2009-08-20 20:40:25Z

0

I don't see why not. If you store it in the database as a string, the database shouldn't care whether that string is plain text, XML, or SNOBOL.

answered Aug 20, 2009 at 20:40

Thom Smith

14.1k6 gold badges49 silver badges99 bronze badges

2 Comments

Mark Rushakoff Over a year ago

If I were a database, I'd draw the line at SNOBOL. Just saying.

pageman Over a year ago

+ for making me laugh hehehe :P

Dave Morgan · Accepted Answer · 2009-08-20 20:43:01Z

0

You should be able to, XHTML is a specialized subset of XML. However, if the XHTML is not compliant (it may work in a browser, but it may not really be XML), you may run into problems.

answered Aug 20, 2009 at 20:43

Dave Morgan

1,0751 gold badge13 silver badges19 bronze badges

Collectives™ on Stack Overflow

Can I store HTML as XML in a Sqlite3 database?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related