{"id":555,"date":"2006-01-16T16:23:37","date_gmt":"2006-01-16T06:23:37","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2006\/01\/16\/xml-storage-engine\/"},"modified":"2013-12-18T08:43:20","modified_gmt":"2013-12-17T22:43:20","slug":"xml-storage-engine","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2006\/01\/16\/xml-storage-engine\/","title":{"rendered":"XML Storage Engine?"},"content":{"rendered":"

Every so often you come across people desiring intense XML and RDBMS interaction. Recently, here: Technical Notes and Articles of Interest \u00c2\u00bb MySQL 5.1 is gaining some momentum<\/a>.<\/p>\n

In MySQL<\/a> land, this usually means “An XML Storage Engine would be great”. hrmm… a storage engine is a way to store a table. A table is a relational thingy. Surely what’s wanted is a good way to query an XML document and search for a specific XML document.<\/p>\n

So, is what’s really wanted good XML indexers and the ability to extract parts (or the whole) of a document? Maybe there’s some extension to fulltext (along with some funky functions) that could bring an immense amount of power with dealing with XML?<\/p>\n

What is there now? What do people do now? What do they want to do?<\/p>\n

All interesting stuff<\/p>\n","protected":false},"excerpt":{"rendered":"

Every so often you come across people desiring intense XML and RDBMS interaction. Recently, here: Technical Notes and Articles of Interest \u00c2\u00bb MySQL 5.1 is gaining some momentum. In MySQL land, this usually means “An XML Storage Engine would be … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[],"class_list":["post-555","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-8X","jetpack-related-posts":[{"id":355,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/02\/10\/over-use-of-xml-when-xml-is-not-what-you-want\/","url_meta":{"origin":555,"position":0},"title":"over use of XML when XML is not what you want","author":"Stewart Smith","date":"2005-02-10","format":false,"excerpt":"sometimes XML is great. Sometimes, it's not. If GnuCash used a database (e.g. embedded mysql) - we'd be in great shape. I could easily extract stuff out of it into my own reports and stuff and it'd rock. Instead, I can't and have to learn some other way. annoying. Accounts.gnucash\u2026","rel":"","context":"In "GNOME"","block_context":{"text":"GNOME","link":"https:\/\/www.flamingspork.com\/blog\/category\/gnome\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":322,"url":"https:\/\/www.flamingspork.com\/blog\/2004\/12\/20\/wish-for-a-useful-tool\/","url_meta":{"origin":555,"position":1},"title":"wish for a useful tool","author":"Stewart Smith","date":"2004-12-20","format":false,"excerpt":"I've started to draw up (by hand) some UML diagrams of parts of the cluster code - I figure this way I can better learn (and remember) what belongs to what and what has what. This really useful where the question comes up of \"I need a NdbMgmHandle.. now where\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":349,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/01\/31\/gnomeabout-stuff\/","url_meta":{"origin":555,"position":2},"title":"GnomeAbout stuff","author":"Stewart Smith","date":"2005-01-31","format":false,"excerpt":"As far as I can work out, this is a good handler to make sure that an About box is shown every time you select Help->About from the menu (i should really look at some other project's code). void on_about1_activate(GtkWidget *w) { GtkWidget *about; GladeXML *xml = glade_xml_new (PACKAGE_SOURCE_DIR\"\/Finance.glade\", \"about\",\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":472,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/09\/14\/tomboy\/","url_meta":{"origin":555,"position":3},"title":"tomboy","author":"Stewart Smith","date":"2005-09-14","format":false,"excerpt":"Since I've just upgraded to Ubuntu Breezy (the next release of Ubuntu, currently a preview release) I've installed tomboy. It's like a Wiki for your desktop. Awesome. Seems to be pretty useful. Even more useful than the stickynotes applet. In fact, i think I'll remove sticky notes. The storage format\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":773,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/12\/19\/book-writing-tools\/","url_meta":{"origin":555,"position":4},"title":"book writing tools","author":"Stewart Smith","date":"2006-12-19","format":false,"excerpt":"I'm involved in the authoring of two books at the moment - both using different tools, neither of which would be my choice if it was up to me. One is using DocBook, writing raw incredibly verbose XML... which honestly, isn't that much fun. The other is in Microsoft Word\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3347,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/05\/24\/an-old-note-on-the-storage-engine-api\/","url_meta":{"origin":555,"position":5},"title":"An old note on the Storage Engine API","author":"Stewart Smith","date":"2013-05-24","format":false,"excerpt":"Whenever I stick my head into the MySQL storage engine API, I'm reminded of a MySQL User Conference from several years ago now. Specifically, I'm reminded of a slide from an early talk at the MySQL User Conference by\u00c2\u00a0Paul McCullagh describing developing PBXT. For \"How to write a Storage Engine\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=555"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/555\/revisions"}],"predecessor-version":[{"id":3557,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/555\/revisions\/3557"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}