Pat Gunn (dachte) wrote,
Pat Gunn

SQL Menus

Dreamed that I figured out a way to have restaurant menus and catalogues be SQL-queriable/filterable, so when I look at a menu I could do "SELECT * FROM WHERE vegetarian=true AND cost < 12.00 AND type=(SELECT id FROM type WHERE description='entree');" and have a nice list to actually consider when I go out to eat somewhere. Somehow neither the magic floating-in-the-air screen nor the thought-based interface seemed the hard part of making it work - instead, it was parsing the source menus. I was showing it to the generic geeky people around me and told them it would sweep the world. My bubble was burst by three words -- "How many geeks?" ... Sigh.

SQL is like regular expressions or the Unix shell - once you learn the syntax, it's such a wonderfully powerful way to think about the kinds of problems suitable for it.. I'm sometimes still surprised when I run into Unixy folk who don't know these things intimately.. Still, fun dream. I've wanted the ability to do this kind of thing for awhile.

Likewise, this is why I think canned interfaces eventually suck for power users - it's difficult to make a GUI that can come close to the full power of a good CLI, and while simple-to-lightly-complex tasks can be done, going beyond that requires one to jump all the way into a programming language..

Vidocq was a pretty decent film given the genre. When all the pieces come together near the end, earlier parts of the film are called a bit into question, but that's not that unusual. The film is also very pretty - most scenes look like they have hidden in them an excellent poster. The biggest surprise to me is the difficult-to-understand-but-incredibly-strong charm of the character who dies near the start of the film (a strange "main character", as the film's frequent flashbacks paint him life as a substitute for the present). Surprised that mplayer needs to have its support for subtitle files turned on in its configfile, and also that there was a historical investigator Vidocq.

Expect one of those "thoughts on the year" posts sometime today or tomorrow.. I suspect I'll see a lot of other folk doing their own...

Tags: dreams, tech

  • Still alive

    Been feeling a bit nostalgic. Not about to return to LiveJournal - their new ownership is unfortunate, but I wanted to briefly note what's been up…

  • Unplugging LJ

    It's about time I pulled the plug on the LJ version of my blog: 1) I'm much more active on G+ than I am with general blogging. I post many times a…

  • Mutual Trust

    I don't know which should be considered more remarkable: That a cat should trust a member of a far larger and stronger species that it can't…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded