{"id":1349,"date":"2009-02-27T10:22:20","date_gmt":"2009-02-27T15:22:20","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1349"},"modified":"2009-02-27T10:22:20","modified_gmt":"2009-02-27T15:22:20","slug":"dictionary-data-for-mysql","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql","title":{"rendered":"Dictionary data for MySQL?"},"content":{"rendered":"<p>I&#8217;m told <a href=\"http:\/\/wordweb.info\/\">WordWeb<\/a>, a dictionary application for Windows, allows you to find words, quite unlike the MacOSX dictionary. I&#8217;ve never even found a usable dictionary when I use Linux, that doesn&#8217;t require me to go online.<\/p>\n<p>The whole idea is that if I search for the phrase <i>cure all<\/i>, I get back a thesaurus entry that suggests the word <i>panacea<\/i>. OK, that example alone wasn&#8217;t so great, because cure-all tends to be a word in these dictionaries. WordWeb Online allows me to have a &#8220;reverse dictionary&#8221; result, which I think is just fabulous (as long as I have access to an Internet connection).<\/p>\n<p>Does such a Mac app exist? Seems WordWeb exists for the iPhone, but their Java app, requires an Internet connection.<\/p>\n<p>What&#8217;s interesting is that they sell the dictionary data. They are powered by MySQL, and if you&#8217;re wanting to grab their <a href=\"http:\/\/wordweb.info\/developer\/SQL.html\">dictionary data<\/a> in either tab separated plain text files or a MySQL database, you fork out a mere USD$999.<\/p>\n<p>That&#8217;s a lot of money for a database file. I have no intention of spending that much money, considering the restrictive licensing on their site. So I searched, and found <a href=\"http:\/\/www.ibiblio.org\/webster\/\">GCIDE_XML<\/a> &#8211; described as &#8220;The GNU version of The Collaborative International Dictionary of English, presented in the Extensible Markup Language&#8221;. I tried to see if it had reverse dictionary search results, but it didn&#8217;t.<\/p>\n<p><b>So, does anyone know if there&#8217;s English dictionary data out there, for MySQL, that doesn&#8217;t cost a bomb and is comparable, to WordWeb? Of course, it also comes with sensible licensing, will be an added bonus.<\/b><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Dictionary%20data%20for%20MySQL%3F&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F27%2Fdictionary-data-for-mysql&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"4752736757\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1349\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1349\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1349\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;m told WordWeb, a dictionary application for Windows, allows you to find words, quite unlike the MacOSX dictionary. I&#8217;ve never even found a usable dictionary when I use Linux, that doesn&#8217;t require me to go online. The whole idea is that if I search for the phrase cure all, I get back a thesaurus entry [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Dictionary%20data%20for%20MySQL%3F&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F27%2Fdictionary-data-for-mysql&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"4752736757\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1349\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1349\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1349\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/27\/dictionary-data-for-mysql?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[44,23],"tags":[257,1775,769],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-lL","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2247,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/new-mysql-5-6-features-by-oli-sennhauser","url_meta":{"origin":1349,"position":0},"title":"New MySQL 5.6 Features by Oli Sennhauser","date":"5\/2\/2012","format":false,"excerpt":"First talk at FOSDEM MySQL Devroom by Oli Sennhauser, of FromDual. Quick notes\/liveblog of the talk, plus links from a quick search. New Release Model: starts with at least in beta quality, milestone releases are RC quality (every 3-6 months), between milestones new features are allowed, GA releases every 12-18\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":839,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/15\/define-camwhore","url_meta":{"origin":1349,"position":1},"title":"Define: camwhore","date":"15\/6\/2008","format":false,"excerpt":"Google needs this in their dictionary. Thank goodness, the Urban Dictionary offers several opinions on what it is to be a camwhore (thus, practising the art of camwhoring, or to camwhore). See: narcissism, media whore Synonymous with: attention whore Ref.: Wikipedia:Cam_whore, On whoring oneself N\/B: camwhoring has nothing to do\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":474,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/02\/21\/useful-oss-software-for-the-desktop","url_meta":{"origin":1349,"position":2},"title":"(Useful) OSS Software for the Desktop","date":"21\/2\/2007","format":false,"excerpt":"gnash I've not exactly seen much working with Gnash, which is what I have installed: gnash and gnash-plugin. A quick visit to Youtube, confirms that gnash is still not exactly usable, and the bug seems to be with ActionExtend and Super (AS inheritance) not being implemented yet. There is hope\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":440,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/11\/02\/core-data-and-mysql-as-a-data-store","url_meta":{"origin":1349,"position":3},"title":"Core Data and MySQL as a data store?","date":"2\/11\/2006","format":false,"excerpt":"I've been thinking a lot about Core Data recently. It supports SQLite out of the box, and its rather scalable and fast. Main reason being sqlite3 is included on every desktop and server of OS X that has shipped since 10.4 (Tiger). It got me thinking about using MySQL as\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":594,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/07\/26\/mysql-related-resources-that-you-will-enjoy-reading","url_meta":{"origin":1349,"position":4},"title":"MySQL-related resources that you will enjoy reading","date":"26\/7\/2007","format":false,"excerpt":"The great Internet is littered with some really useful MySQL-related articles, that I think you'll enjoy reading just as much as I did.I've not given Google Gears too much of a look yet, but its definitely interesting and the tutorials at O'Reilly's ONLamp site help one play with it: The\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":809,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/05\/03\/playing-with-mysqls-online-backup","url_meta":{"origin":1349,"position":5},"title":"Playing with MySQL&#8217;s Online Backup","date":"3\/5\/2008","format":false,"excerpt":"Something that has excited me for a long time with upcoming features in the MySQL Server, is online backup. Since seeing it first being demonstrated by Chuck Bell at the Heidelberg Developers Conference in 2007, I've been enthralled. Now you too, can try online backup. If you've not read the\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1349"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1349"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1349\/revisions"}],"predecessor-version":[{"id":1350,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1349\/revisions\/1350"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1349"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}