{"id":355,"date":"2005-02-10T16:06:55","date_gmt":"2005-02-10T06:06:55","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=355"},"modified":"2005-02-10T16:06:55","modified_gmt":"2005-02-10T06:06:55","slug":"over-use-of-xml-when-xml-is-not-what-you-want","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/02\/10\/over-use-of-xml-when-xml-is-not-what-you-want\/","title":{"rendered":"over use of XML when XML is not what you want"},"content":{"rendered":"<p>sometimes XML is great. Sometimes, it&#8217;s not. If GnuCash used a database (e.g. embedded mysql) &#8211; we&#8217;d be in great shape. I could easily extract stuff out of it into my own reports and stuff and it&#8217;d rock. Instead, I can&#8217;t and have to learn some other way. annoying. Accounts.gnucash is now about 700kb. That&#8217;s less than a year. Going to be <b>lots<\/b> of fun in a few years&#8230; hrrmm.<\/p>\n<p>All this finance data is in tables. You know what that means? A relational database is <b>ideal<\/b>.<\/p>\n<p>same with Gnome Time Tracker. cool app. Won&#8217;t scale at some point no doubt. Currently, i have a greater than 300kb gnotime-data.xml file. <strong>why?<\/strong> I ask. Surely there is a better way. How is it going to run when i&#8217;ve been using it every day for year?<\/p>\n<p>On the other hand &#8211; using XML for documents in OOo and stuff is like the <b>best<\/b> thing ever (it makes <b>sense<\/b>). For RPC it still seems like a huge amount of overkill.<\/p>\n<p>it&#8217;s another rant on &#8216;the right tools for the right job&#8217;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sometimes XML is great. Sometimes, it&#8217;s not. If GnuCash used a database (e.g. embedded mysql) &#8211; we&#8217;d be in great shape. I could easily extract stuff out of it into my own reports and stuff and it&#8217;d rock. Instead, I &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2005\/02\/10\/over-use-of-xml-when-xml-is-not-what-you-want\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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},"jetpack_post_was_ever_published":false},"categories":[10,14],"tags":[],"class_list":["post-355","post","type-post","status-publish","format-standard","hentry","category-gnome","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-5J","jetpack-related-posts":[{"id":555,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/01\/16\/xml-storage-engine\/","url_meta":{"origin":355,"position":0},"title":"XML Storage Engine?","author":"Stewart Smith","date":"2006-01-16","format":false,"excerpt":"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 great\". hrmm... a storage engine is a way to store\u2026","rel":"","context":"In &quot;mysql&quot;","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":355,"position":1},"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 &quot;General&quot;","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":355,"position":2},"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 &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":565,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/02\/02\/comments-on-online-documentation\/","url_meta":{"origin":355,"position":3},"title":"comments on online documentation","author":"Stewart Smith","date":"2006-02-02","format":false,"excerpt":"Something that makes me always just go to dev.mysql.com or php.net for documentation is the user comments. sometimes you just find some real jems that are really worth reading. It would be great if this somehow could get integrated into the (offline) help system in GNOME could somehow have this\u2026","rel":"","context":"In &quot;GNOME&quot;","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":355,"position":4},"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 &quot;mysql&quot;","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":720,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/06\/30\/mysql-bug-deskbar-plugin\/","url_meta":{"origin":355,"position":5},"title":"MySQL Bug Deskbar plugin","author":"Stewart Smith","date":"2006-06-30","format":false,"excerpt":"Over at my junkcode section, I have mysqlbug.py which is a plugin for the GNOME deskbar panel applet. If you've used Quicksilver on MacOSX, then you know the kind of app that Deskbar Applet is. This one lets you type \"bug 1234\" and be given the action of \"open mysql\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"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\/355","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=355"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/355\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}