3 posts tagged with sql by iamkimiam.
Displaying 1 through 3 of 3.

Is there a way to visually organize database tables (and saved queries and views)?

I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
posted by iamkimiam on Feb 2, 2012 - 4 answers

[hɛlp mi si junikod ɪn maɪ deɪtəbeɪs, ɔr maɪ dætəbeɪs ivɛn]

I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols? [more inside]
posted by iamkimiam on Mar 8, 2011 - 2 answers

How do I collect dictionary definitions for ~350 words to put into a database?

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

Page: 1