I’m reviewing database storage in my little app after several years of dealing with M$’s calculated disregard for older technology (DAO in this case).<\/p>\n
DAO used to be a fully-respected local database storage API for any ODBC or Jet data source, complete with wizard support for easy updating of code as the database schema changed. I’ve been hand-coding updates for years now that the wizards have been killed. The fact that I now need to get the user to install special DAO library support when installing my app means Marketsoft wins, I officially give up on DAO. I may be the last to do so, but there still isn’t a good reason for it, except from M$’s point of view – Marketsoft has to keep rotating its tech to keep its customers paying. They killed DAO and are now suggesting that everyone use ADO.net instead of ADO. Why WOULDN’T you want to make your little app dependent on the bloated .net framework that’s 100 times the size of your app? And you don’t need an industry-standard language, use M$’s proprietary one, you’ll love it Anyway, I’m game, I’ll keep up with the times, but Microsoft isn’t the only show in town. So let’s review our options.<\/p>\n
I’m just a little guy with a little app, and standard local database needs. I don’t want to have to license a mother-of-all-mother of database-servers. I want small and local. So Oracle and SQL Server are out. I thought for sure that MySQL would offer a nice solution, but if your app isn’t GPL, you’ll have to pay to bundle MySQL with your app. Maybe I should GPL my little baby, no one would care. Anyway, before I go that route, I have the following options for sane local managable database access…<\/p>\n
I would love to make the storage binary-compatible across Windows and linux, so it would dovetail with my “big plans” for a MythTV module (shhhh!). So… without GPL’ing all my stuff, it looks like the last two are the most appealing… stay tuned…<\/p>\n
As an aside, I have used ADO.net to connect to Oracle sources, and it looks like you can connect to MySQL sources too. You have to install third-party addons from Oracle<\/a> and MySQL<\/a> to get it to work. Originally .net included Oracle access tools but they have apparently been removed or reduced in scope – the docs suck.<\/p>\n","protected":false},"excerpt":{"rendered":" I’m reviewing database storage in my little app after several years of dealing with M$’s calculated disregard for older technology (DAO in this case).<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","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,"enabled":false},"version":2}},"categories":[7,5,12,4,8,10,6,2],"tags":[],"class_list":["post-151","post","type-post","status-publish","format-standard","hentry","category-hangthedj","category-linux-projects","category-mythtv","category-projects","category-sharethedj","category-tricks-tips-tools","category-windows-projects","category-chatter"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9M11L-2r","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":0,"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"wp:attachment":[{"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bitpost.com\/news\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}