QUOTES Browser

Quotations Browser is a web app we built  in 2011 to browse our quote collections. I hope you enjoy exploring them. Enhanced in 2015.

There are two databases.

  • Alex’s Oracle”: 445+ quotes. These Quotes are personal collectibles from my own writing, or caught on TV, or favorites found elsewhere.
  • “Quotes Archive”: 5,430 quotes presently. I had a private quotes collection that started as an Apple HyperCard stack in about 1990. I collected more lists from other sources and loaded them all into Microsoft Access, around 1995, a solution I hated. With over 5400 quotes, that’s far too many quotes to type and edit by hand. I didn’t then have the technical savvy to ‘clean’ and convert the data and load it, by some automated means, into a MySQL database on my site server. I do now.

The two databases are independent. You can choose either one with the ‘Table Select’ pop-up.

  • You can browse just by clicking the Enter button. This gives you all quotes in the either quotes database. Or you can use the optional search filter controls to select matches more closely to what you may be looking for. For example, there are 6 quotes in Quotes Archive on keyword topic “abstinence.”
  • “Quotes Archive”, being bigger, can take a few seconds to load into a browser on a slow broadband connection.  If you find your connection loads slowly, try searching by keyword to limit selection, or by limiting fetch size (as below). My Internet connection takes about four seconds to load all 5,430 quotes from the server database. That’s delivery time by the ISP. Server time is 0.14 seconds.
  • You can limit the number of results to any size in a single search. A limit of 100 will always display the first 100.
  • You can search quotes or authors by name, word or phrase.The search/sort by choice you select from the popup(s) will determine the order in which quotes are listed. If you do set a limit on fetch size, choosing different sorts changes the quote order and therefore what you see at the top of the list.
  • Being able to search by author name is more of a plus than I originally knew. Most of the large online quotations databases limit this to first-letter a-z author categories.
  • By the time you read this (or or about January 4, 2015), enhanced Quotations version ’81’ will access up to four keywords database fields. The single “keyword” screen column has been replaced with a “keywords” column showing up to four keywords assigned to the quote.
  • Take the Al Capp quote “Good is better than evil, ’cause it’s nicer.” I had originally used up the one available keyword with “evil,” but what about “good?” Better yet, what about “morality?” Now, I’ve been able to add all three. Much easier to find!
  • By the time you read this, enhanced Quotations version ’81’ will offer two keyword popups with an optional AND/OR connector popup. If you search for “virtue” AND “criticism”, you’ll fetch one quote; if you search for “virtue” OR “criticism, you’ll come up with twenty-two. Use of just one keyword selector popup works as before, as the second one is entirely optional.
  • At first, the virtue of four keyword database fields seems over-rated if you are only allowed to use up to two of them in Browser. Searching for an entry with four keywords at once is a true fishing expedition, with very low probability of getting a bite. You’ll note that some quotes, like a Madison quotation, have four keywords: religion, pride, ignorance, bigotry. For many quotes, a single keyword still more than suffices.
  • Hover your mouse over the fields for balloon help.
  • Searching results by author is fast, and gives you just that author’s quotes.
  • Searching results by word or phrase is also fast, and gives you just the quotes containing the search word or phrase.

Please feel free to use any Write Us button (right-hand sidebar margin of all our posts and pages) to contact us with your reactions, questions or suggestions. Should you find errors, we are more than pleased to make corrections. Thanks!

1,576 total views, 1 views today

About Writing NOTES

Welcome to WordPress. This is our first post in Writing Notes. It all started when we dashed off a two-part review of a Wallace Stegner novel, All The Little Live Things. We wished we’d had a WordPress installation here in Writing, but we didn’t, so we posted it in My Notes.

That’s OK. Like My Notes, Writing Notes is intended as a place where we can jot down ideas as they occur to us. Not that we aren’t lazy, because we are, but writing and formatting a regular “old-fashioned” HTML page (like most of the rest of the 800 pages on this site) is a lot of work. For every hour spend composing and editing, DreamWeaver can double that time investment, easily. Knowing that upfront sometimes makes the difference between writing an article, and not writing it at all.

For major articles, a blog format just can’t equal the resource-richness of an HTML page composed, edited and uploaded in DreamWeaver. You’ll have noticed our attempts to replace regular department index pages with WordPress where possible (Commentary, and?Computers, to name two). We’ll be the first to admit that, for all the convenience to us, a lot of the features (such as our invaluable AutoList that lists all articles on a site) just don’t port to WordPress. At this writing, we’ve tried to embed AutoList in WordPress, and it doesn’t work yet.

So, the WRITING Index, one of our largest departments, won’t go away soon. The page design may be dated, but it’s predictable, and you can see at a glance C.Bear’s World, Guest Authors, Poems, Short Stories, and a listing of every single article in the department.

So, look here for new short notes. Writing Notes will have links on the WRITING main index page, on the Summitlake Home index page, and elsewhere throughout the site. To see if anything’s new in Writing Notes, you can go to the main home index and look at At A Glance for the last date of update. Of course, you can still go to our regular WRITING index and click the link there.

When, that is, we finish making all the links.

574 total views, no views today