Pabloz wrote:
Hi
Is it a good idea to keep for example blog posts in xml file rather than
mysql? Right now i am trying this kind of project and its going really
really slow, i dont have a model, i learn REXML, but still cant add
nothing to my xml from a form for example. Anyway…is this a good way?
or You would suggest database?
–
Posted via http://www.ruby-forum.com/.
Without knowing the business problem, the question is meaningless.
XML is good for cross-platform data transfer and serialization of
hierarchical data.
DOM can be considered an indexed tree structure, independent of its XML
roots, for some purposes. I have used JDOM as the core of a
high-performance ETL tool. In this case, the DOM is never rendered as
XML except for debugging. I build DOM from COBOL copybooks, VSAM
records, RDBMS rows, Excel spreadsheets, and (of course) XML documents.
I max out the I/Ochannels on mainframe database server with this
configuration.
RDBMS is good for data that can be organized as a set of related
tables. It has proven itself to be a flexible model for meeting most
problems efficiently.
Personally, I am not fond of MySQL. The business problems that I work
on tend to be transactional, and MySql does not honor the ACID
definition of a transaction. However, it does work well as a backing
store for for mostly static data (Wikipedia) and data that is not
audit sensitive (37signals). On the other hand, with their purchase of
Netfrastructure, I believe that MySql is positioned to become a
technology leader in the next generation of transactional RDBMS’ in the
next two years.
I do like Firebird RDBMS, and the ruby support for Firebird is quite
decent. You should probably also download and test the personal
versions of DB2, MS-SQL, and Oracle if you plan to distribute your
application.
Perhaps you could give us a better idea of the scope of the problem?